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