I agree with Roger and Anne. If you can leave it on that sheet, by all
means. Often times in Excel, though, this is not the case. I am of the
perspective that data entry should be done on a seperate location/sheet as
opposed to cramming everything on one sheet (i.e. formatting, reporting,
data entry, etc). Depending on how your workbook structure was setup (this
is depending because I, myself, may take other courses of action dependent
upon what I had) this may or may not be the case.

You may want to think about just bringing over your data to another sheet
....

=A1
=A2
etc.

And then work on your data there as opposed to trying to fit it on one
sheet. BUT, this also may not be the best for you, maybe it's more work
than it's worth. That's a question only you can answer at this point.

HTH

--
Regards,
Zack Barresse, aka firefytr, (GT = TFS FF Zack)
To email, remove the NO SPAM. Please keep correspondence to the board, as
to benefit others.



"Duncare" wrote in message
...
I think you're on the right track. I have dates on one sheet and when they
go overdue I'd like them to go onto a seperate sheet in a block of cells
already set up for that particular inspection. I have multiple
inspections I
track and I'd like them to go in the correct inspection section. Any
thoughts?

"Zack Barresse" wrote:

Hi there,

I think maybe you are looking for something like this ...

Assuming numeric:
=IF(Sheet1!A140,"Overdue","Ok")

Assuming date:
=IF(Sheet1!A1DATE(2005,10,30),"Overdue,"Ok")

Assuming date 1 week from specified:
=IF(Sheet1!A1DATE(2005,10,30)+7,"Overdue,"Ok")

HTH

--
Regards,
Zack Barresse, aka firefytr, (GT = TFS FF Zack)
To email, remove the NO SPAM. Please keep correspondence to the board,
as
to benefit others.


"Duncare" wrote in message
...
I am trying to set up an inspection database I need the values from
other
pages to appear when they go overdue in a specific cell. Please
help!!!