chrissyrw
New Member
- Joined
- Jun 9, 2015
- Messages
- 7
Hello Team,
I have a workbook that has multiple worksheets tracking individuals' monthly usage of an online learning system (number of chapters passed, number of logins, etc). Each worksheet is a separate month. Also, individuals are associated with a particular group (Group A, Group B, etc.).
A separate worksheet is dedicated to provide a summary based on the input criteria such as the particular group and month, or all groups. The summary worksheet sums the total number of logins, chapters passed, failed, and so on of the selected group and month.
Two drop down menus are shown to select the desired group and month. For Example, Group A and May. I've been successful at displaying information for just one particular group or all groups using the SUMIF formula, but only for one month. I need assistance with Excel checking every worksheet for the specified month (located in Cell B1), so if we want a summary of April's usage data for a particular group, that data only will be shown.
I've been researching different formulas and macros, but haven't found anything that quite answered my concern. What would be the best way to accomplish this?
Let me know if I can clarify further. Thanks for your assistance!
I have a workbook that has multiple worksheets tracking individuals' monthly usage of an online learning system (number of chapters passed, number of logins, etc). Each worksheet is a separate month. Also, individuals are associated with a particular group (Group A, Group B, etc.).
A separate worksheet is dedicated to provide a summary based on the input criteria such as the particular group and month, or all groups. The summary worksheet sums the total number of logins, chapters passed, failed, and so on of the selected group and month.
Two drop down menus are shown to select the desired group and month. For Example, Group A and May. I've been successful at displaying information for just one particular group or all groups using the SUMIF formula, but only for one month. I need assistance with Excel checking every worksheet for the specified month (located in Cell B1), so if we want a summary of April's usage data for a particular group, that data only will be shown.
I've been researching different formulas and macros, but haven't found anything that quite answered my concern. What would be the best way to accomplish this?
Let me know if I can clarify further. Thanks for your assistance!