Copy data from one sheet to another depending on date

prasantahazra

New Member
Joined
Nov 18, 2008
Messages
43
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...
 

Some videos you may like

Excel Facts

What is the fastest way to copy a formula?
If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.

RalphA

Well-known Member
Joined
May 14, 2003
Messages
3,829
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,095,920
Messages
5,447,287
Members
405,446
Latest member
morsecode

This Week's Hot Topics

Top