Oops, I forgot to mention the following:

What I need is a macro or code to do the following after the user has
selected both an Operation and a Group:

I need it to lookup column X for all the cells that contain the text:
"VACANT" from the worksheet named: Data.

Then copy the entire row or rows (that contain the selected Operation,
Group and column X contains the text: "VACANT") to a new workbook named:
OMD Report.xls to worksheet: named: Report. The new workbook is on C:\
drive.

Cheers,

Chris.




*** Sent via Developersdex http://www.developersdex.com ***