Summarizing data into single table from different sheets

  • Thread starter Thread starter pyzikchr
  • Start date Start date
P

pyzikchr

I am trying to put together a summary sheet for hours worked fro
timecard sheets from different employees. The timecard sheets can hav
multiple job numbers worked on for the week. There are also differen
tasks within each job so the same job number may be on the sheet mor
than once, but for different tasks.

I want the summary sheet to include the employee's name, the job numbe
worked on and the number of hours they spent on that particular jo
number.

I realize that pulling this amount of data into one final chart i
probably really hard, so I have decided to break the data into anothe
table before putting the data into a final table. I will be able t
get the data from my intermediate table to the final one, but gettin
the data into the first summary table is my problem.

If there is the same job number on the timecard more than once, I nee
to know how to combine those two into one row. I know how to do thi
with pull down menus, but not by just typing in the numbers.

Once the job numbers have been grouped together, the hours column i
the summary table will add up the total hours worked on that particula
job.

I hope someone understands what I'm trying to do, not sure if th
explaination was very clear or not
 
I hope I understand your question correctly. You need to
get a unique list of the job numbers on each timecard?

You can use an Advanced Filter for this. Select the cells
with the job numbers. Go to the Data menu, Filter,
Advanced Filter. Check the list range it displays to see
if it matches what you want. Then choose Copy To Another
Location and choose a cell for Copy To: Then check the
box Unique Records Only. This will give you a list of all
the job numbers used but each will be listed only once.

Hope this was helpful

Erin Kotch
 
Back
Top