I want to have a unique row ID created when every new row is created, so i can find and refer to same row with other people.
The row ID may never change after it has been created and should be +1 more than the highest row ID already existing. And an old deleted ID may never be used again.
I managed to fix this with some hacking in excel but i can't figure it out here.
I managed to automate when a new row was created, another row was created with the ID of +1. So i got a new row, and then another one, where the ID became 1 every time.
But how do read the highest row ID, increase by one, and ad it to the created row?