Need help with this code. I need this code to only delete content of summary sheet (ConsolidatedData), then copy data from other sheets and paste it here. Reason I cant delete then and add new summary sheet is because I have links in other files to this ConsolidatedData.
Please Login or Register to view this content.
Please help. 'Im searching for this the whole week.
Hi noorie007,
Add this code where you have written 'Delete Content of the summary sheet.
Note:Please Login or Register to view this content.
1) Please rename Sheet1, Where Sheet1 will be your summary sheet.
2) Also alter the range to be selected as per your requiement.
Hope this code helps you.
Regards,
Paresh J
Click on "* Add Reputation" as a way to say thanks
Thank you Paresh,
When I do that the line that pastes value gets bugged!
Hi,
After this code CopyRng.Copy,
Always activate the workbook before doing copy paste operations, Hence activate the workbook which contains ConsolidatedData worksheet.
ActiveWorkBook.Activate
Can I somehow refrain the macro from changing the name of the new sheet? For example, when i run the macro although its calling it "ConsolidatedData" the sheet number keeps changing evertime i run the macro... Sheet23, Sheet24 etc etc
Hi noorie007,
Whether this is causing any issues while running the macro? I think it is not coz you are using names instead of indexs to call sheet.
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