I need an Excel template with a macro that will work in Excel for Mac (ie cannot use ActiveX as that is not compatible with Macs)
Macro should allow user to enter a number from 1 to 100,000 to indicate the number of unique values to generate and then click "Go" to let Excel do its thing.
Specifically, we want the system to generate GUIDS and display results in a couple of ways:
1. Column A: Label # (This is just the count of label 1, 2, 3, 4, 5, etc)
2. Column B: URL with GUID appended (https://www.2ndealer.com/inventory/item/GUID)
3. Column C: Displays just the final 12 digits of GUID
See sample attached
The project is now completed