I have a table of data that is dynamic based on a drop down list, so when a different item is selected the data changes. I would like to have another sheet that summarizes the data in the table across all selections. Attached is a workbook that is not the exact data I am working on, but just to show what my problem is. In cell A2 of the "drop down" sheet I have the drop down list. On the "summary" tab is where I am having the issue. I would like to fill that table out, and cannot figure out what function to use to do so. Let me know if you need more clarification of the problem, thank you all for your help.
Bookmarks