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 ***

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 ***