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
Bookmarks