If it's that big, I would still use datafilterautofilterfilter on the
daycopy/paste. Incorporate in a loop for each day.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Maurolava" wrote in message
...
Two reasons. One the sheet is really big, and two I need to create a
scatter
chart that will contain a series for Monday, Tuesday, Wednesday, etc.
which
need to be in a continous column.

"Don Guillett" wrote:

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