Auto Update Formula Rows

[FIRSTROUNDKO via OfficeKB.com]

Hi

Range A1 has the formula ='[apples.xls]Adjustment'!$H$44/1000

but evereyday i want to update the formula by the next H Cell

i.e tommorow I want the formula to read

='[apples.xls]Adjustment'!$H
$45/1000

and the next day

='[apples.xls]Adjustment'!$H
$46/1000

Thanks in advance

 

[Trevor Shuttleworth]

OK

why do you want to increment the row number ? Have you added another row of
data ? And you just want the last one ? If so, are there any gaps in
column H ?

Regards

Trevor

 

[FIRSTROUNDKO via OfficeKB.com]

Thanks trevor,

I missed out that i want the next formula to be in range A2, and the next in
A3 and so on

my purpose is to autodate a daily movement sheet, I have simplified the
problem down as much as I can as an example.

OK

why do you want to increment the row number ? Have you added another row of
data ? And you just want the last one ? If so, are there any gaps in
column H ?

Regards

Trevor

Hi

[quoted text clipped - 13 lines]

Thanks in advance