link spreadsheets together to summarize

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Have 12 different spreadsheets with filters. Filters separate employees and
their production for each individual month. Need to put all these together
into one with employees/their totals...summarizing.
 
Assuming the 12 spreadsheets have the same structure, copy each of them into
one giant spreadsheet, and use the functionality available from Data >
Subtotals.
 
You must log in or register to reply here.

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

Similar Threads

formula assistance needed 5
Summarize employee attendance data on a weekly basis 1
how to ignore hidden cells with a countif 1
LIST OF PERSON'S NAMES 1
Adding from several columns if ... 1
Multiple variables-SOS 3
Hide/lock worksheets 4
How to extract the month in a Pivot Table 2

Back
Top