Share via

HELP Creating a summary sheet from multiple worksheets which totals with two variables (which are existing data tables)

Anonymous
2021-03-11T12:55:42+00:00

Hi,

I am trying to create a summary top sheet for monthly worker timesheets. I want to create a summary per month (each worksheet=calendar month) which will either display the data in subtotals per two fields- Employment Type and Pay Type- or can be filtered by each of these fields (one of which currently exist in the sheets as drop-down from a data table- Employment Type)

I can easily pull the totals by Pay Type out onto the top sheet- but can't figure out how to add in the Employment Type field as either a linked variable or filter options. Screenshot of one of the monthly worksheets below. Highlighted in yellow the totals I am looking to pull out of each sheet. Column D= Employment Type Column N= Pay Type (which is at the moment just text)

I don't have in-depth knowledge, so I have tried to figure out with a Pivot Table, using consolidate and sumifs but I don't have enough knowledge to make these work. If someone can describe in plain terms I would be ever so grateful!!

TIA

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments
Answer accepted by question author
  1. Anonymous
    2021-03-16T23:16:10+00:00

    Hi

    You may find in the link below a copy of your file with the answer to your question

    https://we.tl/t-ANueXXLV3J

    Regards

    Jeovany

    1 person found this answer helpful.
    0 comments

12 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2021-03-11T14:34:24+00:00

    Could you please, clarify if you have a Source sheet with all the inputs for all the (weeks) year from where you feed the monthly tables (tabs)?

    i.e. Create a summary report for every month of the year from ONE SOURCE table

    If so please, upload the Source sheet (table) and share the link.

    Regards

    0 comments
  2. Anonymous
    2021-03-11T14:58:48+00:00

    Awaiting your answer in order to move further with your solution

    0 comments
  3. Anonymous
    2021-03-11T15:20:33+00:00

    Hi Jeovany,

    Thanks so much for your help on this. No, there is no source sheet, the monthly sheets are updated manually- with the employment type being available from a drop-down list and everything else being added straight into cells.

    Eilidh

    0 comments