Why not just leave on one sheet and use datafilterautofilter to work with
it.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Maurolava" wrote in message
...
I need help with a formula that will find an specific cell when it meet
specific criteria.

A B C
1 Monday 11/10/2008 1
2 Tuesday 11/11/2008 0
3 Wedy 11/12/2008 1
4 Thursday 11/13/2008 1
5 Friday 11/14/2008 3
6 Saturday 11/15/2008 2
7
8 Monday 11/17/2008 2
9 Tuesday 11/18/2008 2
10 Wedy 11/19/2008 1
11 Thursday 11/20/2008 2
12 Friday 11/21/2008 3
13 Saturday 11/22/2008 1
.
.
.

I want a formula that can find the number on column C after each Monday on
a
different sheet. Another for Tuesday, Wednesday and so on.

Is that possible?

Thank you in advance,

Maurolava