Thanks Dave that works,I've been trying INDIRECT all afternoon trying to get
the syntax right, that / 6 is neat logic

Thanks

"Dave R." wrote in message
...
One way, you can try replacing B9 with in that formula (in AA9) with

INDIRECT("B"&9+(ROW()-9)/6)

then copy it down. If you copy it to cells other than A15, A21, A27
(adding
6) it will return #REF.



"John" wrote in message
...
Hi Frank



=INDEX(Master!$A$16:$C$43,MATCH(B9,Master!$A$16:$A $43,),MATCH("Subacc",Maste
r!$A$16:$C$16,))

This formula resides in AA9 and I wish to copy it exactly to AA15,
except
I
need B9 above to change to B10

I think in actual fact I got this formula from you about a year ago for
another spreadsheet

Rgds



"Frank Kabel" wrote in message
...
Hi
in what other cells do you want to copy it and how should the ell
reference change.
Also always better to post the actual formula!

--
Regards
Frank Kabel
Frankfurt, Germany

"John" schrieb im Newsbeitrag
...
I would appreciate any heply in solving what seems a simple problem.

I wish to copy down a formula in Cell AA1, that contains a reference
to B1
down to AA6, but instead of it showing B6 I want it to show B7.

I have an extended formula in AA1 but only the reference to B1 is
the
critical part as I just want to simplify my post. I scanned the
Groups for
an answer and I'm getting more confused. I've to copy this formula
400 times
so that why I don't want to do it manually!


Thanks