You can use Data - Autofilter to perform these operations manually or with a
macro. The two drop downlists should be on a different worksheet from the
DATA so the drop down boxes don't get filter by the autofiler.

Select the entire worksheet DATA. Then go to menu Data - Filter -
autofilter. You can then copy the visible cells using the menu

Edit - Goto - Special - visible Cells Only.

Then copy the cells to a new workbook.

If you record the macro while performing these operations I can easily make
a macro that will use the selections in drop down boxes. Let me know wherre
the new drop down boxes are located. the macro can go down each item of the
drop down box and create a new workbook for each selection.

"Chris" wrote:

Hi, could someone please help me with the following?

I have done the following:

1. Worksheet named: Report has a dropdown list in cell B2 for a list of
Operations. The Operations are populated on worksheet named: Data in
column B.
I made a list of these operations on worksheet named: Operations and
gave this list a defined name = Operations!$A$2:$A$12. This was done so
that I could let the user click on drop-down lists in column B (on
worksheet
named: Data) to select an appropriate Operation.

2. Worksheet named: Report has a dropdown list in cell B4 for a list of
Groups. These Groups are populated on worksheet named: Data in column C.
I made a list of these groups on worksheet named: Groups and gave this
list a
defined name = Groups!$A$2:$A$29. This was done so that I could let the
user click on drop-down lists in column C (on worksheet named: Data) to
select an appropriate Group.

The following is an example of what I need:

For example: when the user clicks on the Report tab and then clicks on
cell B2 (drop-down list) to select an Operation (The Operations are
populated on worksheet
named: Data in column B), and then clicks on cell B4 (drop-down list) to
select a Group (The Groups are populated on worksheet named: Data in
column C),
I need some code or macro that will automatically lookup column X (on
the worksheet named: Data) and select all the cells in column X that
contain the text: "VACANT".

If there are any matching records (a record being one row of data on
worksheet named: Data) for these three criteria (Operation, Group and
cells in column X that contain the text: "VACANT"), then I need the code
or macro to copy the record (entire record from the worksheet named:
Data)
to a new workbook named: OMD Report.xls and paste it onto worksheet
named: Report (paste on cell A2). This new workbook is located on c:\
drive.

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

Kind regards,

Chris.



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