Let me see how well I can explain this:
On my report tab, cell 'B1' has a drop down list containing an 'Unique ID'. The report is created using vlookup for multiple sets of data relating to the 'Unique ID'. My 'RawData' tab has over 100 'Unique IDs', and I need to create a report tab for each one. In an effort to speed up the process, I am seeking help with a macro that is connected to a button on the 'Report' tab and would execute the following:
1. copy 'report' tab
2. rename tab to cell B1 ('Unique ID')
3. Repeat process automatically for each 'Unique ID'
Any help would be appreciated. If this makes no sense, please ask I will try to be more explicit.
Thank you!!
On my report tab, cell 'B1' has a drop down list containing an 'Unique ID'. The report is created using vlookup for multiple sets of data relating to the 'Unique ID'. My 'RawData' tab has over 100 'Unique IDs', and I need to create a report tab for each one. In an effort to speed up the process, I am seeking help with a macro that is connected to a button on the 'Report' tab and would execute the following:
1. copy 'report' tab
2. rename tab to cell B1 ('Unique ID')
3. Repeat process automatically for each 'Unique ID'
Any help would be appreciated. If this makes no sense, please ask I will try to be more explicit.
Thank you!!