Hi,
I have a macro that opens a list of files and copies sheet1 to a summary workbook. the code is below. now i'm trying to modify the code so that it can also rename the sheet tabs. Please see attached file as example and code below.
AR consol.xlsm
Please Login or Register to view this content.
Can you upload a file containing the data to be copied? I guess it needs to be in a particular format with "!". I tried replicating it but the macro is not working properly.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks