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

"Teric506" wrote in message
...
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

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

See your other thread

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Teric506" wrote in message ...
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