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.