hello I have a spreadsheet created by someone else that has a lot of codes etc . It is an invoice tracker that team members are INSERTING A NEW ROW when imputing a new invoice. This is done so that the new entry will have formulas applied like the other entries.
A- I need to create a onetime code that will add 2 additional columns to the list existing formula range.
B- I need a code to create unique I’d for the exiting entries.
Then
C- a code that will allow automatic INSERTION of a new row & automatically create a new unique Id for that new row.
The Unique ids. Created should never change once created. And or even when deleted, that old unique id should never be reused
A- I need to create a onetime code that will add 2 additional columns to the list existing formula range.
B- I need a code to create unique I’d for the exiting entries.
Then
C- a code that will allow automatic INSERTION of a new row & automatically create a new unique Id for that new row.
The Unique ids. Created should never change once created. And or even when deleted, that old unique id should never be reused
