How do I combine worksheets

G

Guest

Hello,

I have many worksheets that I need to combine into a master sheet. The data
in each sheet is different and the number of rows and columns are different
in each sheet and there are no headers or anything like that, just numbers is
each sheet.
I saw there was a macro on here and tried to copy and paste it but it gave
me a compile error so I am stuck. Can anyone tell me how to get all these
numbers from multiple worksheets into one worksheet. Thanks.

Teri
 
S

Stephen

Teric506 said:
Hello,

I have many worksheets that I need to combine into a master sheet. The
data
in each sheet is different and the number of rows and columns are
different
in each sheet and there are no headers or anything like that, just numbers
is
each sheet.
I saw there was a macro on here and tried to copy and paste it but it gave
me a compile error so I am stuck. Can anyone tell me how to get all these
numbers from multiple worksheets into one worksheet. Thanks.

Teri
Click to expand...

Well, you will have to say how you want to combine the data. What do the
columns or rows represent?
 

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

How do I combine many worsheets into one worksheet?? 6
How do I combine multiple worksheets into one worksheet? 1
How do I combine Exel workbooks? 2
Combine Worksheets 2
How do I combine worksheets w/o enough rows to combine? 3
Combine several spreadsheets with multiple worksheets into 1 file 5
How to I combine excel worksheets? 6
Combine 2 sheets into 1 that will update w/new data 2

Top