I was hoping you would reply. I found your macro, I did a copy and paste but
when I go to run the macro I get a compile error. Now I am new to macros so I
am probably doing something wrong.

Teri

"Ron de Bruin" wrote:

See this page Teri
http://www.rondebruin.nl/copy2.htm

Copy the macro in a normal module

See how on this page
http://www.rondebruin.nl/code.htm


--

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