=IF(ISERROR(CELL("address",INDIRECT("'"&TEXT(B2,"y yyy.mm.dd")&"'!a1"))),
"Not there yet",INDIRECT("'"&TEXT(B2,"yyyy.mm.dd")&"'!$Z$2") )





Dave Peterson wrote:

You can use =indirect() to check to see if that sheet is the

=IF(ISERROR(CELL("address",INDIRECT("'2006.02.01'! a1"))),
"Not there yet",INDIRECT("'2006.02.01'!$Z$2"))

(all one cell)

bsspewer wrote:

Here's my dilemma. I want to create one sheet as a summary sheet that
pulls data from specific cells that are in other pages. The problem is
that some of these pages aren't created yet because I create one new
page each day. It's alot of work to go back to that first page and
type in the exact same info as the day before, just changing the name
of the sheet to the next day.

Example: "='2006.02.01'!$Z$2" is for feb 1st, and the cell following
states "='2006.02.02'!$Z$2" for feb 2nd. Right now, I have to retype
it each day, because if I try calling for a page before the page is
made, excel gets confused. If anyone follows please help out.

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

--

Dave Peterson

--

Dave Peterson