G
Gary
Hi,
Help! Need help creating a macro for Excel 97 (I also have Excel 2000)
I have a large (aprox 100k rows) Excel spreadsheet made up of columns named
" names, street, city, state, zip, phone and company,"
In many of the cell the information is split between cells. Example
"Brown, James" is split between two cells with "Brown" and "James" in two
separate cells.
I need a macro that will cut "James" out of the cell on the right and add to
the cell to the left, then delete the cell "James" was in, moving the
remaining cells to the left.
Also Another problem is the opposite. Example: "James Brown 444 Main St."
is all in the same cell (instead of "James Brown" and "444 Main St." and I
need to cut the address out and put it into an inserted new cell directly to
the right of the original cell.
I can do these things manually but not with the Excel macro recorder.
I couldn't even make a macro that would cut the info in one cell and move
it the left and delete the now empty cell.
I have been able to do the macros with MS old universal macro recorder I
found on a old machine. The problem is it uses up so much memory that after
using the
macro just a 30 or 40 times the machine runs out of Ram (I have 256k on a
Win2000 machine) and the machine starts to slow and lock up and needs to be
restarted.
Thanks for any help,
Gary
(e-mail address removed)
Help! Need help creating a macro for Excel 97 (I also have Excel 2000)
I have a large (aprox 100k rows) Excel spreadsheet made up of columns named
" names, street, city, state, zip, phone and company,"
In many of the cell the information is split between cells. Example
"Brown, James" is split between two cells with "Brown" and "James" in two
separate cells.
I need a macro that will cut "James" out of the cell on the right and add to
the cell to the left, then delete the cell "James" was in, moving the
remaining cells to the left.
Also Another problem is the opposite. Example: "James Brown 444 Main St."
is all in the same cell (instead of "James Brown" and "444 Main St." and I
need to cut the address out and put it into an inserted new cell directly to
the right of the original cell.
I can do these things manually but not with the Excel macro recorder.
I couldn't even make a macro that would cut the info in one cell and move
it the left and delete the now empty cell.
I have been able to do the macros with MS old universal macro recorder I
found on a old machine. The problem is it uses up so much memory that after
using the
macro just a 30 or 40 times the machine runs out of Ram (I have 256k on a
Win2000 machine) and the machine starts to slow and lock up and needs to be
restarted.
Thanks for any help,
Gary
(e-mail address removed)