I am new to VBA, and was going back and forth between the available codes trying to create VBA to execute the following, but was not able to get a complete one that get through end to end:
In my workbook Inventory, I have 4 worksheets, and I would like to copy the results in Source tab to Target tab for that particular admin matching the 'Name' col in the List of Admins tab, and then save that excel file with the Admin Name on my desktop and then continue likewise until all the names under the List of Admins tab is done. The Col A has the list of unique names under the List of Admins tab.
Each of he final Excel file will be saved with only the 2 tabs Target and Instructions; the rest of the tabs must be deleted before saving.
I would like to do this since there is a huge volume of record lines for more than 1000s of admins throughout the year, and automating them was the only solution.
Please help.
Appreciate any suggestions to improve time and efficiency.
Thank you.
In my workbook Inventory, I have 4 worksheets, and I would like to copy the results in Source tab to Target tab for that particular admin matching the 'Name' col in the List of Admins tab, and then save that excel file with the Admin Name on my desktop and then continue likewise until all the names under the List of Admins tab is done. The Col A has the list of unique names under the List of Admins tab.
Each of he final Excel file will be saved with only the 2 tabs Target and Instructions; the rest of the tabs must be deleted before saving.
I would like to do this since there is a huge volume of record lines for more than 1000s of admins throughout the year, and automating them was the only solution.
Please help.
Appreciate any suggestions to improve time and efficiency.
Thank you.