Hi all,
I have a worksheet which contains a Summary table and a data table. In the data table, I have some cells which has a drop down menu (created with Data Validation). I would like the summary table to update the sum depending on which item is selected from the drop down list.
Please have a look at the attached file. The summary table has categories which are already listed in the drop down list. If a user selects, say "Fairs" from the drop down list, I want that change to reflect in the summary sheet. ie: Sum of Fairs being updated. If later the item in the list is changed to "Sales Tools" in the drop down list, then the Summary table will update "Sales Tools" instead and re-adjust the "Fairs" total.
In other words, I am looking for a dynamic update in the sum of the items of the Summary Table, depending on any changes made in the items being selected from the drop down list.
Any ideas on how to do this?
LIST_SAMPLE.xlsx
Bookmarks