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.