formula question

S

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
 
L

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
Click to expand...


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
 
Top