I add new records to a worksheet every day, I use the Max(a1:ayyyy) to tell me the highest value in the range, which includes the new rows just added. I have a cell that tells me the last entry, I would like to use the value of that cell to insert into yyyy so I don't have to manually change the entry each day.
I know this is easy - I must have a mental block.
thanks in advance,
dan
I know this is easy - I must have a mental block.
thanks in advance,
dan