auto increment on new line insertion

  • Thread starter Thread starter Becky
  • Start date Start date
B

Becky

In the following code, how can i get the numbers 54 to
automatically increment to 55when i insert a new line. For
some reason this does not happen, however, the number 63
does increase to 64.

=HLOOKUP('Project Summary'!B1,OFFSET('Associates Hours
(actuals)'!$S$5:$AD$63,0,0,COUNTA('Associates Hours
(actuals)'!$S$5:$AD$63)),54,TRUE)*30

Many thanks
Becky
 
Hi,

I'm just guessing, but what happens if you change
,54, to ,54:54, ?

This change seems to increment it for me..

jeff
 
Back
Top