formula question

[stew]

in A2 in Financials worksheet I have the following formula

=INDIRECT("'Merchandise'!"&ADDRESS(70,(COLUMN()))). THIS DIRECTS ME TO
$A$470 on The merchandise worksheet

IN A18,
A34,
A50 REPEATING in Financials worksheet I need to have a formula that
takes me to
$A$150
$A$230
$A$310

CAN I MODIFY THE ABOVE FORMULA TO INCREASE IN AMOUNTS OF 80 OR DO i START
AGAIN

Help and thanks for your time

Stew

 

[Lars-Åke Aspelin]

in A2 in Financials worksheet I have the following formula

=INDIRECT("'Merchandise'!"&ADDRESS(70,(COLUMN()))). THIS DIRECTS ME TO
$A$470 on The merchandise worksheet

IN A18,
A34,
A50 REPEATING in Financials worksheet I need to have a formula that
takes me to
$A$150
$A$230
$A$310

CAN I MODIFY THE ABOVE FORMULA TO INCREASE IN AMOUNTS OF 80 OR DO i START
AGAIN

Help and thanks for your time

Stew

Assuming the $A$470 is just a mistype for $A$70.
Replace the 70 in your formula with 60+5*ROW()
Then, when you copy the formula to the mentioned rows, the references
will be as stated above.

Hope this helps / Lars-Åke

 

[stew]

Yes it was a MisType and yes it works

Thank you for your time

Stewart