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: 40
Default merging column values and transferring them to another worksheet

hello! help please. how do i merge the values of 2 columns then paste them
into 1 column of another worksheet? i also need to transfer rows from 1
worksheet to another with an interval of 3 then 2 then 2? after this i need
to copy F10 to J10 to E4:I4 of sheet2?
ex.
copy D10 = alex & E10 = david then paste it in B4 of sheet2
D13 = male then paste it in C4 of sheet2
D15= single then paste it in D4 of sheet2

D17= ben & E10 = cruz then paste it in B5 of sheet2

 
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
Transferring/Merging Data Between Worksheets Gman Excel Discussion (Misc queries) 1 July 10th 09 03:58 PM
Merging files with nearly identical values in one column Allen Excel Discussion (Misc queries) 3 March 4th 09 05:09 PM
Optimizing transferring values Geoff Excel Programming 4 October 11th 07 08:43 PM
Optimizing transferring values Geoff Excel Programming 0 October 11th 07 03:24 AM
Replace all values in a column with values using a mapping from another worksheet [email protected] Excel Programming 6 August 18th 06 03:12 PM


All times are GMT +1. The time now is 02:12 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"