Hi,
I have an Excel where in Column B, I populate the an id like DG0001, DG0002...
First - I need to check for the existing records if the DG number is not assigned then the new DG number need to be assigned depending on the latest/maximum number
Now going forward, when an new row is added, the id needs to pick up the last DG number and increment it by 1 and assign an new id to that row. I am new to macros and would need the entire code. Please help.
Thanks!
Bookmarks