Hi -
New to Macros and trying to learn, but essentially what I'm trying to do is take a data dump fo information that includes first name, last name, and DOB and convert to unique ID. Now I have the formula for unique ID and test data in the attached document, but trying to create a marco that if I were to have say 1000 rows of data and need to find unique Ids for each one, I don't have to drag and copy down, I can just click button once I do the data dump and the cells generate the unique IDs.
Also - for further reference, the data dump was happen in new sheets within the workbook and not added to the same sheet if that helps.
Please advise.
Bookmarks