Find and copy to other worksheet if not find something else.

[jnh0]

Hello guys,

What I need to do is to find CP1 in a determined column, if it does, copy the cell and paste it into other file (Dabase.xlsm), if not it should look for CP2 until CP4. If doent find any of them, Delete the sheet.

But until know, I havent find the way to pass the error if it doesnt find anything. This is what I have:

Thanks in advance for the help!!

Please Login or Register  to view this content.

[ragulduy]

Maybe:

Please Login or Register  to view this content.

[jnh0]

It works perfect thanks!!

Is there a way to avoid the msg that excel send when the macro try to delete the sheet?

[ragulduy]

Please Login or Register  to view this content.

[jnh0]

Works perfect!! Thanks you!!

[jnh0]

Hello,

If I want to run the same macro for all sheets what can I do?

thanks again!!