It would probably be best if you rearranged your formulas so that the carry
over formula would be beside the current year formula, in column B, instead
of below it. That way, you could fill down all you like, and the formulas
would update incrementally.
--
Anne Murray


"Dave" wrote:

I have the following formula in cells A33 and A34:

=+A3&" Current Year" A33
=+A3&" Carry Over" A34

Is there a way to copy/paste both of the formulas at the same time to cells
A35 and A36 and have the forumla reference update to A4 in both formulas?
When I copy/paste the formulas to A35 and A36, the reference in the formulas
go to cell A5:

=+A5&" Current Year"
=+A5&" Carry Over"

Thanks
Dave