Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a very lengthy, horizontal list of names and addresses in Word that
need to become a sorted Excel spreadsheet ready for a mail merge. I'm looking for shortcuts that won't involve many hours of drag and drop or cut and paste. In other words, instead of Contact Name Title Company Address City, State Zip all one on top of the other, I need to have Column A be a list of the names, Column B will be all the titles, etc. So I need a macro that not only cuts and pastes, but puts the next one I select on the next line of the list. Sort of "Move to F4+1, Move to F4+2, Move to F4+3" or something like that. I hope this is clear. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
help with macro to read and sort data from multiple text files | Excel Programming | |||
help with macro to read and sort data from multiple text files | Excel Programming | |||
help with macro to read and sort data from multiple text files | Excel Programming | |||
count text in non consecutive cells in column | Excel Discussion (Misc queries) | |||
Data Sort Macro for specific cells | Excel Programming |