I have a requirement to inspect each cell in an excel sheet.
If any cell is empty, a GUID should be inserted.
The column contains >60,000 cells and takes forever to execute (I don’t actually know how long it takes as I’ve never let it complete).
Please could someone help me with a faster / more efficient way of doing this?
I’ll attach the automation and a sample spreadsheet.
Many thanks in advance.