HELLO
I NEED AN EXCEL MACRO TO COPY DATA FROM MULTIPLE SHEETS TO ONE MASTER SHEET
PLEASE NOTE THERE ARE MORE THAN 100 SHEETS WITH MORE THAN 100 COLUMNS
I WANT TO MERGE ALL THE SHEETS BY NEW SHEET DATA ADDED TO THE ADJACENT COLUMNS WHENEVER I RUN MACRO
IF THIS IS SOMEONE CAN ASSIST ME AT ASAP.
tHANKS
Add a new sheet named master as your first sheet, and try this
VBA copies every column of every sheet into "Master" beginning with second sheet.
Please Login or Register to view this content.
Last edited by kev_; 12-31-2016 at 11:52 AM.
Thanks for the reply
it is giving only few columns of the first 3 sheets and all columns from the last sheet?
I spotted a typo and immediately amended the code.(apologies if you used what I posted first)
I spotted that:
was on the wrong line and moved it.Please Login or Register to view this content.
Check that your code looks like this - it should work
If it is still giving issues (perhaps your data is a different shape to mine) I will amend how it decides where to copies toPlease Login or Register to view this content.
Last edited by kev_; 12-31-2016 at 02:01 PM.
This uses a different method to work out where to paste the data and (unlike previous method) does not use row 1 to determine the last used column in sheet "Master"
Happy New Year
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks