Linking spreadsheets to calculate totals

Topic

New Reply

I have a monthly report system that includes a separate spreadsheet file for each employee. There are 12 separate sheets (tabs), one for each month. Each sheet is the same format and has places to list totals as well as place to list class names, dates and # attendees instructed. I would like to be able to have a master spreadsheet that pulls in all of the information from 5 different employees (separate files) to populate totals for each month. Can someone assist me with the process or formulas that I would use for this?

Reply | Quote

Replies

My suggestion is to have ONE file with 5 tabs with all dates on one tab where you can filter for the months. Then just use sumproduct on the master sheet.
Or, ONE file with ONE tab and all data and use filter with SUBTOTAL at the top for the filtered data

Attach your file(s) and I’ll show you.

Reply | Quote

OK, I have attached the 2 files. I will ultimately have 5 different Advisor files that will need to feed into the Master Advisor file.

My suggestion is to have ONE file with 5 tabs with all dates on one tab where you can filter for the months. Then just use sumproduct on the master sheet.
Or, ONE file with ONE tab and all data and use filter with SUBTOTAL at the top for the filtered data

Attach your file(s) and I’ll show you.

Reply | Quote

I am sick and can’t work on this but here is the basic idea then use autofilter

Month adavisor Military Member Military Spouse Civilian or Dependent Total

Reply | Quote

Don

Concentrate on getting well.
Get well soon.

zeddy

Reply | Quote