Correlating/Combinig data from two worksheets

G

Gunjani

Where do I start... What I have is two worksheets one consists of ALL 99
employee names and there respective 'Duty Nos' for each day for the
whole year.
The first worksheet is laid out as follows:

Name Day1 Day2 Day3 Day4 Day5 Day6 Day7
Tom 22 22 56 55 R R 33
Dick 44 R R 15 15 15 15
Harry R R 76 65 65 65 65
Joe 07 07 R R 88 88 88

The second worksheet is the data related to the to the duty nos e.g
start time, end time, lunchtime, total daily hours, paid time etc...
These are all column headings.

I like to do combine the two worksheets to do several things...

1.I like to establish what hours each employee does for a specific week
/month /year.

2.Create worksheet or just a printout of a specific employee's duty no
and it's respective data for a specific week.

Where do I start?

--
Many Thanks

Gunjani
"A person starts to live when he can live outside himself."
-- Albert Einstein
 

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