Here's the scenario:
I have an excel sheet that contains a number of fields ranging from customer shipping information to sales. Each time a customer places an order, I import most of the information to populate the cells, and then finish up by doing a little data entry afterwards. The rest, such as unit cost, tax rate, net sales, etc., are completed automatically. This sheet works perfectly, but I want to be able to take this information and make it meaningful on a separate sheet(tab).
On the second sheet, I have two drop-down date boxes. In addition, I plan to include a third drop-down box that will allow the user to select the report that needs to be shown based on the dates.
For example, if the user selects "March 1, 2012" as the first date, then "June 1, 2012" as the second date, and then selects "Shipping" as the report type, then that should pull only all of the shipping information between those two dates from the first sheet and display them in the second.
I've read through a lot of forums and still haven't found a way to do this. Essentially, all I need is the formula on how to make this work. Once I have that then I can work back through it to figure out how it works. I've seen some answers that show this to a degree, but so far I've been at a loss on everything.
My skill level with Excel is average. Usually, I can figure out how to do things if I play with it long enough, but this one has really baffled me. As far as scripts and such, I've never delved into that much.
Any help anyone can provide would be much appreciated!
Bookmarks