Hi, I'm trying to merge two workbooks to one, but it's a bit more complicated than I'm used to
Using Excel 2011 on Mac
I want Column A and B from sheet 1 and Column A and B from sheet 2 to become A,B,C and D in sheet 3.
I would also like to have two blank columns after the first four ones, and then start again.
It should look something like this:
X=Blank
1,2=sheet number
A1 B1 A2 B2 X X C2 D2 C2 D2 X X E1 F1 E2 F2 X X............
Last edited by kahler; 01-31-2012 at 05:25 PM.
So you're merging two worksheets in the same workbook into a third worksheet?
_________________
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!)
Yes! Sorry I got them a bit confused, it's two sheets with information that I need to arrange in a third one.
Give this a try:
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks