Split up summary sheet
 

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

Split up summary sheet
 

Sorry, this didn't format on this post the way it looked when it was being
composed. Hopefully, you get the idea of what I'm trying to accomplish.

David

"Compass Rose" wrote:

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

Split up summary sheet
 

It is probably best to write a macro to make table and then use pivot tables.
--
Hope this helps
Martin Fishlock, Bangkok, Thailand
Please do not forget to rate this reply.


"Compass Rose" wrote:

Sorry, this didn't format on this post the way it looked when it was being
composed. Hopefully, you get the idea of what I'm trying to accomplish.

David

"Compass Rose" wrote:

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