Find & Move Sheets

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Pretty new to the VBA gig, so thanks in advance to anyone who offers up
help...

I'm needing to record a macro for the following scenario:

3 - 5 workbooks, Same name, using numeric ordering
I want to search for a specific work*** in each workbook, and if it
exists, move that *** to a new workbook

If the *** I'm searching for isn't contained, let's say in wkbk 4,
then just skip it and move on to wkbk 5.

I think I have the moving the *** part down ok, it's just the
searching for, moving if present, and just moving on if it's not
present.....

.

Quantcast