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

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
>

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