Copy data from one sheet to another depending on date

[prasantahazra]

I am a new member of this forum..I need a help from you...

"Sheet1" of Book1.xls contains the daily efforts of each members in the team. The detail changes automatically everyday like:

Date Name Task1 Task2 Total
1/1/08 Mark Design-2 Analysis-2 4
1/1/08 James Design-3 Analysis-2 5
1/1/08 Paul Implement-4 4

On the very next day the details will be automatically changed as:

Date Name Task1 Task2 Total
1/2/08 Mark Design-2 Analysis-4 6
1/2/08 James Design-3 Analysis-2 5
1/2/08 Paul Analysis--8 8

i.e. "Sheet1" will contain only the records of current date.
I am able to managed the functionality of "Sheet1" .

Here, I want the details of each month in separate sheets. i.e. "Sheet2" will contain the total efforts of each member of January, "Sheet3" will contain the details of February and so on...

The details of "Sheet2" will be:

Date Name Task1 Task2 Total
1/1/08 Mark Design-2 Analysis-2 4
1/1/08 James Design-3 Analysis-2 5
1/1/08 Paul Implement-4 4
1/2/08 Mark Design-2 Analysis-4 6
1/2/08 James Design-3 Analysis-2 5
1/2/08 Paul Analysis--8 8
.......
......
1/31/08 Mark Design-2 Analysis-4 6
1/31/08 James Design-3 Analysis-2 5
1/31/08 Paul Analysis--8 8

The details of "Sheet3" will be:
Date Name Task1 Task2 Total
2/1/08 Mark Design-2 Analysis-2 4
2/1/08 James Design-3 Analysis-2 5
2/1/08 Paul Implement-4 4
2/2/08 Mark Design-2 Analysis-4 6
2/2/08 James Design-3 Analysis-2 5
2/2/08 Paul Analysis--8 8.......
......
2/29/08 Mark Design-2 Analysis-4 6
2/29/08 James Design-3 Analysis-2 5
2/29/08 Paul Analysis--8 8

and so son....

As soon the date changed of a row in "Sheet1" then it will be reflected automatically in "Sheet2" in the next blank row for the current month.

Can anyone please guide me to do this functionality...Thanks in advance for the help...

 

[RalphA]

This is one way, using formulas:
Assuming your data starts on Sheet1, cell A2:
On Shhet2, cell A2, enter: =IF(AND(Sheet1!$A2>0,TODAY()>=Sheet1!$A2),Sheet1!A2,"")
and copyto the range A2:E500, asuming your data end at row 500.
Tell us if this is the solution you needed.