Find all sheets if Met criteria copy rows to one sheet

[elsg]

I have multiples sheets (Destination, sht1, sht2, sht3, sht4 ....sht30)

I need find a string, inside column C, all sheets different tab (Destination), after copy rows contein criteria in column C (all sheets)

I want use a inputbox to user enter search value.


i tried adapt some cods, but not work.

Please Login or Register  to view this content.

[fredlo2010]

hi,

I believe this will help.

Please Login or Register  to view this content.

Obrigado

[elsg]

unbelievable
Perfect!!

thank you!!!!!!!!!!!!!

[fredlo2010]

I am glad I was able to help