[SOLVED ]Excel Help, Merging Worksheets

Corvus

Alright, I feel like an idiot as I'm sure I should know how to do this, but I have some excel workbooks with multiple worksheets where I just need to do a simple merge of all the sheets into one. So, help please. I need to copy everything, including column and row headings.

Thanks.

Edit: Solved!

-Phil-

1 - Open both workbooks.

2 - highlight all of the sheets (using ctrl or shift button) that you wish to transfer.

3 - Right click one of the sheets and select Move or Copy option

4 - Select the new book on top. Press OK. (You can also select to just send a copy)

5 - ???

6 - Profit

Corvus

Am I missing something? That just seems to copy the worksheets. I might not have been clear, I actually need to merge all the worksheets into one sheet, and I have multiple workbooks I need to do this in, but I won't be merging the workbooks.

-Phil-

No, I interpreted what you were asking for incorrectly.

The only way I know of this is maybe copying the rows by highlighting them one the left then pasting them into the new worksheet below the current information you have (Highlight columns if your putting the new information to the right of the current information).

DJ-99

Yeah, what do you mean by "merge"? Do you have 10 columns in each, and you want to make it 20 columns? Or do you have 50 rows in each, and you want to make it 100 rows, or what?

I don't understand why you can't just use a simple copy/paste function.

Corvus

DJ-99 wrote: »

Yeah, what do you mean by "merge"? Do you have 10 columns in each, and you want to make it 20 columns? Or do you have 50 rows in each, and you want to make it 100 rows, or what?

I don't understand why you can't just use a simple copy/paste function.

Basically, I want all the data from 20+ worksheets within a workbook merged into one worksheet. And I have multiple files I need to do this in, so copy and pasting is going to be both tedious.

Anyhow, I think this macro I found basically does what I need to do:

http://www.mrexcel.com/archive/VBA/17846.html

Arikado

Is vlookup out of the question?

Corvus

Arikado wrote: »

Is vlookup out of the question?

This begs the question, what's vlookup? :P

I should mark this as solved though, the macro I posted the link to did what I needed.