Hello everyone,
I would like to copy values from Sheet A to Sheet B.
Sheet A has a drop-down (data validation list) and items in that sheet change according to the item that is selected. E.g.: Items in the drop-down are Apples, Oranges, Bananas. Below the drop-down I have monthly counts that populate based on the filter; when I select Apples all 12 months in the year get populated with 5, Oranges 10, and Bananas 20.
Sheet B is my summary sheet. I have titles for Apples, Oranges, and Bananas, and would like to populate counts by quarter. For Apples and quarter 1 the count will then be 15, for Oranges 30 and for Bananas 60.
If I did not have a drop-down/list I could vlookup values from Sheet A to Sheet B, but my counts keep changing based on the filter. Any suggestions on how I could do this?
Thanks in advance for your help!
-Andrea
I would like to copy values from Sheet A to Sheet B.
Sheet A has a drop-down (data validation list) and items in that sheet change according to the item that is selected. E.g.: Items in the drop-down are Apples, Oranges, Bananas. Below the drop-down I have monthly counts that populate based on the filter; when I select Apples all 12 months in the year get populated with 5, Oranges 10, and Bananas 20.
Sheet B is my summary sheet. I have titles for Apples, Oranges, and Bananas, and would like to populate counts by quarter. For Apples and quarter 1 the count will then be 15, for Oranges 30 and for Bananas 60.
If I did not have a drop-down/list I could vlookup values from Sheet A to Sheet B, but my counts keep changing based on the filter. Any suggestions on how I could do this?
Thanks in advance for your help!
-Andrea