Hi, I wish to join few columns from two data sheets using Macro function.
Sample
Sheet 1:
A B C D E
1 Headline Msg1 Msg2 Msg3 Msg4
2 Car Post Join Help AAA
Sheet 2:
A B C D E
1 SumNo Msg1 Msg2 Msg3 Msg4
2 CM001 Join Help AAA BBB
Output;
A B C D E F
1 Headline SumNo Msg1 Msg2 Msg3 Msg4
2 Car Post Join Help AAA
3 CM001 Join Help AAA BBB
Hope any ones can help. Thanks a lot
Last edited by rylo; 01-07-2009 at 03:01 AM.
Straight copy?
Please Login or Register to view this content.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Thanks, however the output is not my desire output. I have many rows for each data sheet. My desire output is copy selected columns for sheet1 and paste it to sheet3, then copy selected columns for sheet2 and paste it at last row of data from sheet1.
Your code just select one row for each data sheet.
Hi
Hard to tell from your post just what goes where, but try this.
ryloPlease Login or Register to view this content.
Thanks Rylo, it works.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks