notsoevilgenius
MIS
I have worksheets tabbed by month.
Column A - Subscribers (unique)
Column B - Agents (duplicates)
Columns E thru ?? Agents (unique)
I added a tab called Report
The user wants to be able to pick a single agent and get a yearly total. There can be different subscribers (A) and agents (E thru ??) each month. Column TOTALS are on different rows in each sheet. I want to run through the worksheets and make a list (without duplicates) of each agent and make a total. What would be cool is if I can put them in a pick list (in alphabetical order) and the user can click one and get the output in a particular cell. I'm using Excel 2016, but the user will be using Excel 2013. I'm pretty good with excel and formulas. I haven't used form controls or active x controls, but I have used VBA for some macros.
Thanks
Column A - Subscribers (unique)
Column B - Agents (duplicates)
Columns E thru ?? Agents (unique)
I added a tab called Report
The user wants to be able to pick a single agent and get a yearly total. There can be different subscribers (A) and agents (E thru ??) each month. Column TOTALS are on different rows in each sheet. I want to run through the worksheets and make a list (without duplicates) of each agent and make a total. What would be cool is if I can put them in a pick list (in alphabetical order) and the user can click one and get the output in a particular cell. I'm using Excel 2016, but the user will be using Excel 2013. I'm pretty good with excel and formulas. I haven't used form controls or active x controls, but I have used VBA for some macros.
Thanks