Getting the data from picking a certain month

[maradykstra]

I have a list of products with amounts in a table. In another worksheet, I want to pick a month from a drop down list and then it would show me the totals for all my products from my table. How would I do this? Should I use a combo box to do my drop down or would it be okay to use a data validation list of months? Then I have to write a function that says if I pick that month then show totals for that month.


Any help would be great.


Thank you.

 

[Hui]

JaElle

You can use either Data Validation (require manual entry of a date) or a Drop Down (Will requiure a list of dates somewhere) for your Date selection.


You may also want to look at using a Date Picker which brings up a small calendar to let you choose dates: http://www.fontstuff.com/vba/vbatut07.htm


Once you have a date you will probably be summing numbers using a Sumproduct or SumIfs command


Sumproduct: http://chandoo.org/wp/2009/11/10/excel-sumproduct-formula/


SumIfs: http://chandoo.org/wp/2010/04/20/introduction-to-excel-sumifs-formula/

 

[maradykstra]

Thanks Hui. I actually thought of those two functions and I think the Index will work too.


Thanks for your reply.