Hi, thanks a lot for your help. But instead of giving "x" a fixed value
can we have a condition that once every first day of a new year it wil
automatically create a new worksheet. e.g. today is 01/01/06 then a ne
worksheet named 2007 is created, then once it is 01/01/07 a workshee
for 2008 will be added. Is that possible

--
ReD-DevI
-----------------------------------------------------------------------
ReD-DevIL's Profile: http://www.excelforum.com/member.php...fo&userid=3262
View this thread: http://www.excelforum.com/showthread.php?threadid=52560