In one of my formula's i have

'2005'!B5

This is pointed at tab sheet 2005, what i'd like to know is if it is
possible to have this in there instead:

'Current Year'!B5

and basicly translate the current year to tab sheet name so that the
refferenced tab sheet will change from year to year without anyone
having to change it?


--
alymcmorland
------------------------------------------------------------------------
alymcmorland's Profile: http://www.excelforum.com/member.php...o&userid=27652
View this thread: http://www.excelforum.com/showthread...hreadid=482757