ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   link spreadsheets together to summarize (https://www.excelbanter.com/excel-worksheet-functions/56195-link-spreadsheets-together-summarize.html)

wag

link spreadsheets together to summarize
 
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.

Roland

link spreadsheets together to summarize
 
Assuming the 12 spreadsheets have the same structure, copy each of them into
one giant spreadsheet, and use the functionality available from Data
Subtotals.

"wag" wrote:

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.



All times are GMT +1. The time now is 05:48 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com