Paste formula with fixed cells

[joe_fisher]

Hi,
I've got some huge formulas to paste numerous times put I think all comes down to this:
I want to copy/paste cell A1 into cell A2 with this effect:

A1= B1 + AND(F1,F2)
A2= B2 + AND(F1,F2)
A3=..

Can I really do it or I need some kind of macro r something like that?
I have hundreds of them to copy!

Thanks

[ConneXionLost]

You need to adjust the references.

Like this:

Please Login or Register  to view this content.

Cheers,