Complex Data Analysis Project

Hi everyone,

I'm working on a project that is a bit over my head. I'm looking for advice, ideas, & suggestions you might have. (Anything helps at this point!)

In a nutshell, I am trying to create a workbook that will have two sheets in it. One sheet will contain a database with about 12 columns of entry inputs (date, producer, part #, etc.) and 1000's of rows (it is being continually updated) of the inputs themselves.

The other sheet contains a single chart (a scatter plot to be exact) and two drop down menus.

What I need is for these two drop down menus to link the graph to the database. So, for example, when I select process #1 (from the 1st drop down menu) and cycle #1 (from the second drop down menu), Excel will grab all of the data from the database pertaining to process 1 & cycle 1 and display it on the scatter plot. If I select process #3 and cycle #4, it will display the relevant information for that process/cycle on the plot. (There are about 50 combinations of process/cycle's contained in the database(processes 1 through 7 and cycles 1-8)).

There is no rhyme or reason to the database other than the date. Processes & cycles are scattered basically random throughout the list (the dates are in sequential order(newest are at the top)).

So to sum up, I'm trying to create a macro that will sort through both the process #'s and cycle #'s of the data points and show the desired results on a scatter plot. Each entry in the database gives the Process #, Cycle # and several "hardness readings." The chart will show the average 'hardness reading' for each process.

I know this is confusing, feel free to ask any more questions about details. Happy to provide more info.

I have been trying to create VBA macros to do this, but my VBA skills are beginner at best.

Any ideas? It all helps!

Best.

Hmmm... I am going to try that right now. Can you expand on that idea? What do you mean "use the combos to place the selection for both on the sheet"?

This seems like just what I'm looking for. Much appreciated!