Hi, could someone please help me with the following?

I have the following:

1. Worksheet named: Report has a dropdown list in cell B2 for a list of
Operations. These Operations are detailed

on Worksheet named: Operations. The defined name for these Operations =
Operations!$A$2:$A$12.

2. Worksheet named: Report has a dropdown list in cell B4 for a list of
Groups. These Groups are detailed on

Worksheet named: Groups. The defined name for these Groups =
Groups!$A$2:$A$29

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".

Then copy the entire rows (that contain the selected Operation, Group
and column X contains the text: "VACANT") and

copies the enire row or rows to a new workbook named: OMD Report.xls to
worksheet: named: Report.

If anyone could please help with this, it would be greatly appreciated.

Kind regards,

Chris.



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