Sequential numbering

[Jock]

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,stayed!D,withdrawn!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.

 

[Jacob Skaria]

I am unable to recreate the issue you were mentioning..Try with the below
formula.

=IF(INDIRECT("F6")="","",MAX(INDIRECT("D45"),INDIRECT("complete!G:G"),INDIRECT("'struck out'!D"),INDIRECT("stayed!D"),INDIRECT("withdrawn!D"))+1)

If this post helps click Yes

 

[Jock]

Hi jacob,
This gives the same result for me.
I don't think a formula is the answer in this case. I have abandoned the
idea of automatic numbering in this instance.

Thanks though