Seacrhing for specific text in multiple sheet and pasting in summary sheet

[Chandresh]

Hi All,

Need a help in macro which will search the specific text ineach sheet and copy all the entire row and paste it in summary sheet

Example :
1) I have more than 50 sheets
2) Macroshould search text “Notional” in column “A” form each sheet and copy 4cells toright (A+4cells) in summary sheet from row no3 once completed Macro should search text “Certified” in column“A” form each sheet copy 4cells to right (A+4cells)in summary sheet after the last row

This macro should loop through all the sheets available inthe workbook.

Thanks for your great help

 

[hiker95]

Chandresh,

So that we can get it right on the first try, can we see your actual raw data workbook/worksheets, and, can we see what the results in the summary worksheet, manually formatted by you, should look like.

You can post your workbook/worksheets to the following free site (sensitive data changed), mark the workbook for sharing, and, provide us with a link to your workbook:

https://dropbox.com