How do I combine many worsheets into one worksheet??

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
 
G

Guest

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
 
R

Ron de Bruin

Hi Teri

Have you copy the macro in a standard module and also the function Lastrow ?
 
G

Guest

I copied it in a standard module using your last row sample but changed it to
your line to copy all cells with data on the sheet. That gave me the error so
I deleted the macro and started over but did not change your macro and came
up with the same error.
 

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

Top