Continuation from: http://www.excelforum.com/excel-prog...bobox-1-a.html
I am up against a rather difficult challenge but I would like to see if you can help me out.
Background:
** Example **
UserForm Interface:
ComboBox1 = Department #1
ComboBox2 = PumpA1
The tricky part is that each Pump (dependent on Department #) has a Data Table associated with it. The Dimensions of each table vary depending upon Failure Data history.
Goal: (Execute Command)
I need a code which will take the Values of ComboBox1 and ComboBox2, and run a Pump Search in the appropriate Department # "Failure History Data" sheet, and generate the Defined Table in a "Results" Sheet
I have a picture which shows a portion of the tables that are associated with each Pump.PumpFailure Data.jpg
Let me know if you understand what I am trying to do here, or if you need me to formalize this a bit more.
As always, thanks.
Bookmarks