I have a column of IDs stored in excel sheet to generate report on a daily basis:
My ReportCreatingBot runs daily to make sure our web app is stable, and reports get generated successfully.
If code 001 is used today, it can not be used tomorrow. I’m wondering how should I get a new fresh ID daily and make sure no duplicates? I was thinking to get first used row value, and delete row after the bot runs. I’m not very good at VB methods to get the first used row… can anyone help?