Please see the attached workbook. The first page "Summary Log" is intended to automatically summarize how many calls occur for each department. I would like for Excel to look at each "Call Sheet" (which can be an indefinite number of sheets), identify the value in the "Department" field, and create a count of how many times that department occurs. For instance, if there were 12 "Call Sheet"s, and the "Department" field in 6 of those sheets had "Merchant" selected, I would like for cell F12 on the "Summary Log" to provide a value of 6.
If anyone has tips or suggested readings on how to make this happen, I would greatly appreciate it. My grand idea is to have a macro written so that these summary counts would automatically populate every time a "Department" field is changed in any of the created "Call Sheets."
First time poster, so please be gentle.
Thank you in advance for your time!
Bookmarks