Hi

I think Anne has given you very good advice regarding filtering data on your
current sheet, with or without Conditional Formatting to highlight certain
things.

If you insist on moving the data to another sheet, then set up a second
sheet with your criteria for selection, and use Advanced Filter to pull this
data across.

For help on setting up and using Advanced Filter, take a look at
http://www.contextures.com/xladvfilter02.html

Regards

Roger Govier


Duncare wrote:
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!!!