Split up summary sheet

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
 
C

Compass Rose

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
 
M

Martin Fishlock

It is probably best to write a macro to make table and then use pivot tables.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top