Need help with worksheet table and summary

[Guest]

I have a table I am using to get the total hours worked for a half month
period for employees. I need to have the information for each employee go
to a individual summary for that employee and I need to update it for each
new half month work period.

Pay Period November 16-30, 2006
Day Thu Fri Sat Sun
Date
Empl Name
Joe S.
Fred. M.
Sarah J.
Mike L.

The above is a sample of how the table is laid out.

I've made a summary for each employee with the following:

Employee Name November 16-31, 2006


Joe S. (formula is =A6)
Total hours worked 0 (formula is =SUM(B6:Q6))

Is there a way to copy the worksheet, then update the date information in
one individual's summary and then have it update in the other employee's
summaries?

I would also like to have the ability to make the first employee summary and
then have it auto fill the next empoyee's summary when I do a fill down
without it skipping employees. Right now I can do fill down after I copy one
or two employees but it skips from Joe S. to Mike L. for example....

I hope this is not too confusing. I am sure it is something simple but I
have not used excel for anything other than really simple things.

Thank you.

 

[Guest]

I saw this before and it wasn't really clear to me then. Let me ask some
questions to flesh out the requirements.

1 - Where is the daily data for each employee stored?
2 - How much data is stored? Annual and we need to pull out the pay period
or just the pay period data?
3 - I presume you want a worksheet for each employee? Are they already set
up, or will they need to be created from the list of daily data? (would
require VBA)

Sometimes it's easier to do it piece by piece.

 

[Guest]

The data is entered after each pay period is over. I made a table for that

example:
Pay Period November 16-30, 2006
The days are entered across the top, the employee names vertically down the
side (one in each row).

I will need a individual summary of the employees total hours for the pay
period, but have to enter the hours per each day.

I found that by doing a listing of employee names underneath the table and
then hiding the ones I don't want, I can pull the total hours for each
employee that way.

I then have to print a summary for each employee one at a time.

I was hoping to have an individual summary for each empoyee but could not
figure out a way to get the data to copy from the table to the individual
summary without alot of repetitive data entry. Since I have to work up this
table and summary after each pay period I was looking for a faster way to do
it once the initial set up was done. I think that copying and pasting it
will probably be the fastest way at this point.

Thank you.