I am trying to use combo boxes to pull data from a raw data sheet with an intention of drawing a bar chart from it. The source data is 28000 rows so creating a chart from all of it is bogging my system down.
excel.png
When I select 2006 from the combo box it draws the first record it comes across. When I select values from the 2 other comboboxes I cannot get E3:Q3 to reflect this.
Is there any way of doing this easier?
Attach a sample workbook for better understanding
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
Sorry I probably didn't explain that very well at all.
Please see file attached.
What I am looking to do is have an interface of dropdown boxes to select a year, region and product code that will return a list of said data. It's just like the filter option but I do not want the user to see the raw data. I then went to create a macro to draw a bar chart based on the data returned, can all this be done?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks