How to copy sheet1, sheet 2, sheet3 in Sheet4

Closed
Sam - Jan 23, 2011 at 06:01 PM
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jan 27, 2011 at 08:54 AM
Hello,

How to copy sheet1, sheet2, sheet3 and Sheet 4 in Sheet 5(same excel workbook) using macro?

I want to copy columns A-W

The rows will vary in sheet1, sheet2, sheet3 and sheet 4.

Thanks for the help in advanced.



1 reply

rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 768
Jan 27, 2011 at 08:54 AM
Copy the columns from first sheet
paste to the target
find out the last used cell and increment by one
copy the column from other sheet
paste it in the next available cell and so on
1