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...
"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...