What would be the best method to add the next sequential number to column D
when a date is entered in F on the same row? This number must never change
Problems arise when whole rows are removed and the data pasted on another
sheet (historical data) when using something like this:
=IF($F6="","",(MAX($D$4:$D5,complete!G:G,'struck
out'!D:D,stayed!D:D,withdrawn!D:D)+1))
This formula checks the active page and four other sheets for the highest
number and works fine until a row is removed to another sheet.
Is there a code method which will add sequential numbers and not be affected
by removing whole rows of data?
Thank you.
--
Traa Dy Liooar

Jock