I have a worksheet with data for hundreds of employes across the columns and they all have a unique identifier in column A. There is a VLOOKUP in cell A6 that all the employee data is tied to, which populates the sheet I would like to make a copy of. Instead of going through, creating a copy, and manually entering the unique identifier in A6, is there a macro that could do that for me and name the new sheet whatever is in column A from the data set?
I'm a newbie to VBA but looking to improve!
Thanks!
I'm a newbie to VBA but looking to improve!
Thanks!