Split data to worksheets

C

Compass Rose

I have created a monthly time sheet for my employees to fill out. Since they
can work on different jobs during the days of the month, the spreadsheet, as
an example, looks like this:

M A R C H

1 2 3 4 .... 30 31
Job A 2.5 1.5 1.0 1.5
Job B 3.0 4.5 3.5 3.5 4.5
Job C 1.5 2.5 6.0 3.5
Job D 3.0 2.5 1.5
etc.

What I would like to see is the worksheets that follow the master
spreadsheet to be populated as follows:

Job A
1 2.5
3 1.5
4 1.0
.......
30 1.5


Job B
1 3.0
2 4.5
4 3.5
.......
30 3.5
31 4.5


Job C
1 1.5
3 2.5
4 6.0
.......
31 3.5


Job D
2 3.0
4 2.5
.......
31 1.5

etc. for the number of jobs on the master spreadsheet, with each job
on a separate worksheet.

What coding would be required to transfer the data from the master time
sheet to the individual worksheets?

TIA
David
 
G

gimme_this_gimme_that

No coding is required. Experiment with creating a pivot table. you'll
get it.
 

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