Skip sheets and check for txt in a cell.

[Scoobster_doo]

Hi All,

I have a doc which for example purposes has Sheets 1-4. I want to 'skip' sheets 1-3 and then do a check for txt in sheet 4. If there IS txt then I'd like to call a sub which copies a column, if not then stop working.
Also, If there is the specified txt and I call the sub to copy the column, I would then like to continue the loop to check for this txt on the next sheet etc.

The reason being is I have a template where sheets 1-3 are always named the same. Whereas the 4th onwards will have different names in each document however will hold the same data.

I have the following:

Please Login or Register  to view this content.

I'm struggling a bit so any guidance would be great!

[davesexcel]

Would it not be
next ws

Here is my take on this,

Please Login or Register  to view this content.

[Scoobster_doo]

Hi Dave,

Firstly, love the way you arrow your code....makes it look very neat.

In regards to the next ws, yeah I've put 'next sheet?' as an indicator to query if this is where the next WS bit goes. Your code seems to do the job in regards to searching, finding and then my sub captures the data. I now just need to state If Not InStr Then end sub etc

Thanks for your help

[davesexcel]

There are lots of different options what are you trying to do?

For example: This will change the msgbox it the word "Potato" is not found.

Please Login or Register  to view this content.

[Scoobster_doo]

Hi Dave,

Sorry for the late reply.

The end goal is to search for a title (As this does) then if found copy everything under it into and array.

Again thanks for your help.