Hi,

I have a sheet with an 'April' column of data referencing cells in an
'Apr06' sheet... Next to that column I have the 'May' one, which I want
to reference cells in 'May06' sheet. I have dragged the formula along
with $C$5 for example, so the cells are correct, but is there anyway I
can replace the Apr06 reference with May06 in one fail swoop??

Thanks


--
neilcarden
------------------------------------------------------------------------
neilcarden's Profile: http://www.excelforum.com/member.php...o&userid=35623
View this thread: http://www.excelforum.com/showthread...hreadid=554887