Macro for Find All

[VARGEESH]

Hi,


I need a macro code for the below.


I have a workbook with more than 30 sheets.


When i find something, it should find all and should export to a new workbook.


And the workbook name should be the searched criteria.


For instance: -


My query is:


"COM"


The Process should be:


1. It should find all(Entire workbook)


2. Then Export to a new workbook.


3. The workbook name shoud be "COM"(This was my query)


Regards,

Vargeesh

 

[SirJB7]

Hi, VARGEESH!

Despite of feasibility, which I'm still wondering about, ... What do you mean by "Export"? You're talking about whole sheet, cell contents, cell formulas? And what about source reference?

Regards!