Select tab name with 8 digits and copy back with new name

[emina002]

Hi there to all expert, I need to consolidate tab and copied it back to the tool with modified name,I do have code selecting multiple workbook,list it down on a column, but I am having a hard time on how can I select tab name if the macro determine numeric value and 8 digits only.

On my example workbook, Copy Worksheet with 8 Digits.xlsm file has macro, if user press "Select files" button and select for example the report LE 440 report,the name of the file will appear on A2 and the content of LE 440 report file has 5 tabs(other tab on the report already fix), now my problem is I have to copied the tab name 15010012,12041003,18520007(which is not permanent every month) back to the tool with Company code(b2) on it ex: 440-15010012,440-12041003,440-18520007. I just need a code to consolidate all tab name when I press Consolidate button. I will be easy because I only give 1 example file to consolidate but what f I have to consolidate multiple files,I have to open it 1 by 1 using looping on macro and consolidate what I need is one of my problem.


Hope you can understand my problem very well, since I am from other country, I am not sure if I already elaborate my problem well. Thanks and hope you could help me with this

[haripopuri]

Please Login or Register  to view this content.

[emina002]

Hi there @haripopuri, it works but I need to rename the consolidate tab ex: 440-15010012 etc. If you see macro file on B2 it has 440 which indicate the company code of the report, it will be useful if I have to consolidate multiple tab name for example 15010012 it wont get error because it has unique company code. Thanks for your code

[haripopuri]

ah, apologies. I missed that part earlier. This one should work fine for you.

Please Login or Register  to view this content.

[emina002]

Hi There,thanks for your modified code. It really really works now