I have two tables in one excel workbook under each other. Each table contains the first column which is just a number, 1,2,3....
Problem: when a record is deleted, you need to renumber the rows.
Would like: is it possible that when you add or remove a row it automatically renumbers the rows?
I have done this by inserting a table in excel and using this formula =ROW()-3. However it only works with one table. the second table updates numbers wrongly because the row number changes.