View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
AllenRubinstein AllenRubinstein is offline
external usenet poster
 
Posts: 1
Default Need to sort text data to consecutive cells (w/ Macro?)

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.