search in multiple sheets

[whitoulias]

Hello to all

I have an excel with 33 sheets

In the first sheet i have a drop down list with 4 values (word)

I need to search what user picks from that list, to all the other sheets in Range("A1:A4").

So what i'm actually looking for is Sheets("Sheet1").Range("A1") = All other sheets. Range ("A1:A4").

The ideal solution whould be if the value was found to copy+paste all the sheet to a new workbook.

Thank you in advance

[Mumps1]

What is the name of the sheet that contains the drop down list? I assume the drop down list would be in cell A1. Is this correct?

[whitoulias]

Correct

The drop down list is in A1

Sheets("select") is the name of the sheet with the drop down list

[Mumps1]

Copy and paste this macro into the worksheet code module. Do the following: right click the tab for the sheet "select" and click 'View Code'. Paste the macro into the empty code window that opens up. Close the code window to return to your sheet. At the moment, it assumes that the workbook with the drop down list is named "Master1" and the workbook to which the sheets will be copied is named "Master2". This macro will need some changes to make it suit your situation. I have included comment on some lines to indicate what you may need to change. The macro will search for the value in the drop down list in all the other sheets and if the value exists, it will copy the sheets to a newly-created workbook.

Please Login or Register  to view this content.

[Mumps1]

Sorry. The macro in my previous post will have to be modified. I'll get back to you as soon as I can.

[Mumps1]

Following the instructions in Post# 4, try this macro:

Please Login or Register  to view this content.

[whitoulias]

thx Mumps

I'm testing it now

[whitoulias]

Mumps

It works great

Thank you for your time and the solution

[Mumps1]

My pleasure.