LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
help with macro to read and sort data from multiple text files [email protected] Excel Programming 1 March 23rd 07 05:44 AM
help with macro to read and sort data from multiple text files [email protected] Excel Programming 3 March 22nd 07 07:25 PM
help with macro to read and sort data from multiple text files [email protected] Excel Programming 0 March 15th 07 11:02 PM
count text in non consecutive cells in column pinmaster Excel Discussion (Misc queries) 0 January 19th 07 08:12 PM
Data Sort Macro for specific cells slundrigan via OfficeKB.com Excel Programming 1 December 21st 06 06:20 AM


All times are GMT +1. The time now is 07:18 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"