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: 14
Default Macro to combine data in a column

If I select a block of contiguous cells in the same column, is it possible to
create a macro that will combine all the data, in the order of top selected
cell to the bottom selected cell and place it in proper order into a single
cell (the top cell of the selected block)--I don't want to merge the cells, I
just want all the data from a block of selected cells to be placed into one
cell.

Thanks.
 
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
how to combine number data from one column into another column newbie Excel Discussion (Misc queries) 1 September 2nd 08 02:18 AM
combine column data Mitchell_Collen via OfficeKB.com Excel Discussion (Misc queries) 3 February 5th 08 08:03 PM
how to combine data from Column A & B CORaccounting Excel Discussion (Misc queries) 3 December 1st 07 03:59 PM
How to combine data from two columns into one column? dcnguyen Excel Worksheet Functions 3 January 8th 06 11:40 PM
Macro to Combine 2 columns to make one column without merging JRM Excel Discussion (Misc queries) 1 December 31st 05 08:27 PM


All times are GMT +1. The time now is 10:21 AM.

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"