Alright dave, we're getting there now. I can now go ahead of the day
and type up all the cells having them refer to pages that are uncreated
yet. This lightens up the day to day work, but I still have to manually
change each sheet name in the arguments (2006.02.01 to 2006.02.02).

Is there a way I can have it call for the name of a sheet using a
cell?

Example: cell B2 says 2006.02.02 and in your formula I put something
like "'B2'"! thereby it uses what I've typed in cell B2 as the name of
the sheet it looks for. This prevents me from manually typing each page
name, and can refer to a cell much easier.


--
bsspewer
------------------------------------------------------------------------
bsspewer's Profile: http://www.excelforum.com/member.php...o&userid=32846
View this thread: http://www.excelforum.com/showthread...hreadid=526600