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