J
Jim
I have a list of names, addresses, etc that I'm setting up for a mail merge.
I already have a macro that converts the names from a format like this:
Col A
Name
Address
City, state, zip
Col A Col B Col C
To this: Name Address City, State, Zip
I need to be able to take the normalized data and paste it into another
workbook that has the finished list in it. I need it to paste the new row
into the first blank row in the list and then keep moving down. Anyone know
how to do this? I'm using Excel 2003. Thanks for any help.
Jim
I already have a macro that converts the names from a format like this:
Col A
Name
Address
City, state, zip
Col A Col B Col C
To this: Name Address City, State, Zip
I need to be able to take the normalized data and paste it into another
workbook that has the finished list in it. I need it to paste the new row
into the first blank row in the list and then keep moving down. Anyone know
how to do this? I'm using Excel 2003. Thanks for any help.
Jim