Hello
I have 5 columns with 35 rows. I use this to book in parcels I receive from residents.. When a row is filled in I also send this data to another page. When the parcel is collected, the details on the "next page" are saved to file as proof of collection. I have coded that when the parcel is collected, the row with the data has its contents cleared, so that the row can be used again.
Currently I manually add a number to the parcel along with apt number and name. I would like to add a column with heading of number and the rows to follow sequentially each time a row becomes blank.
So if row 1 has the number 1
row 2 has the number 2
row 3 has the number 3
Then if row 1 contents are cleared then the next number for this row would become 4
I would like to do this up to 999 and restart the count .
Is it possible to do this?