I have two data tables on a worksheet with Auto Numbering (1,2,3,…) in the first column.
I am using =Row() –<row#> to auto populate these numbers.
When I add a new row to the first table it throws the numbering sequence off in the second.
Is it possible to create a macro that will insert a new row in the first table and update the =Row-<row# +1> formula in the second table so both tables will be correct?
I am using =Row() –<row#> to auto populate these numbers.
When I add a new row to the first table it throws the numbering sequence off in the second.
Is it possible to create a macro that will insert a new row in the first table and update the =Row-<row# +1> formula in the second table so both tables will be correct?