Auto Update Formula Rows
 

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

--
Message posted via http://www.officekb.com

Auto Update Formula Rows
 

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" <u15639@uwe wrote in message
news:74607e218d598@uwe...
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

--
Message posted via http://www.officekb.com

Auto Update Formula Rows
 

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.

Trevor Shuttleworth wrote:
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

--
Message posted via http://www.officekb.com