Hi, I have a list starting in Cell E7 going down to a user defined length (within column E). The list contains "Test_1" "Test_2" "Test_3" and so on. How would I renumber this list if there were to be one of the rows removed? The auto refill doesn't work, as if the first row (Test_1) is removed then the list starts at "Test_2" which is not what I am after (list should always start with "Test_1" even if "Test_1" is removed). It is only renumbering of column E that I am after and not re ordering the full table.
Any help with this would be greatly appreciated,
TIA
Any help with this would be greatly appreciated,
TIA