How do I combine different workbooks into one?

G

Guest

Hi,

I need to combine different workbooks with the same columns into 1 mega
workbook. How do I combine? I can't use "Compare & Merge" because it would
delete some of the data. I need to combine the info from file 1 to file n
into another xls file. Thanks!
 
P

Pete_UK

Can't you just <copy> the data from the second worksheet/book and
<paste> below the data in the first worksheet/book?

Hope this helps.

Pete
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

combine sheets from several workbooks into one 1
Combine two workbooks into one 2
COMBINING WORKBOOKS 1
Open multiple workbook then combine into single workbook butdifferent sheets 10
Combine two spreadsheets into one 3
Excel Excel VBA Macro to combine multiple workbooks into one 0
How to Combine Columns of Text - sounds easy 9
Combining sheets with variable layout 4

Top