C
Compass Rose
I have created a monthly time sheet for my employees to fill out. Since they
can work on different projects during the days of the month, the spreadsheet
looks like this:
M A R C
H
1 2 3 4 5 6
............ 30 31
Project A 2.5 1.5 1.0 3.5
1.5
Project B 3.0 4.5 3.5 2.0
3.5 4.5
Project C 1.5 2.5 6.0
2.5 3.5
Project D 3.0 2.5 1.5
1.0
......
What I would like to see is the worksheets that follow the master
spreadsheet to be populated as follows:
Project A
1 2.5
3 1.5
4 1.0
6 3.5
.......
30 1.5
Project B
1 3.0
2 4.5
4 3.5
6 2.0
.......
30 3.5
31 4.5
Project C
1 1.5
3 2.5
5 6.0
.......
30 2.5
31 3.5
Project D
2 3.0
4 2.5
6 1.5
.......
31 1.0
etc. for the number of projects on the master spreadsheet, and each project
on a separate worksheet.
Is this a VBA project, or can it be done using worksheet functions?
TIA
David
can work on different projects during the days of the month, the spreadsheet
looks like this:
M A R C
H
1 2 3 4 5 6
............ 30 31
Project A 2.5 1.5 1.0 3.5
1.5
Project B 3.0 4.5 3.5 2.0
3.5 4.5
Project C 1.5 2.5 6.0
2.5 3.5
Project D 3.0 2.5 1.5
1.0
......
What I would like to see is the worksheets that follow the master
spreadsheet to be populated as follows:
Project A
1 2.5
3 1.5
4 1.0
6 3.5
.......
30 1.5
Project B
1 3.0
2 4.5
4 3.5
6 2.0
.......
30 3.5
31 4.5
Project C
1 1.5
3 2.5
5 6.0
.......
30 2.5
31 3.5
Project D
2 3.0
4 2.5
6 1.5
.......
31 1.0
etc. for the number of projects on the master spreadsheet, and each project
on a separate worksheet.
Is this a VBA project, or can it be done using worksheet functions?
TIA
David