Finding similar tabs compared to data

Look up the LIKE command. It will let you match a number of wildcard combinations.

My apologies for being late to respond. I'm catching up from "snow days."

It would help a lot if you can include a workbook to go along with the code. Also I notice that you are using activecell and select a lot in your code. There are better ways of doing this. If you don't mind, I'll rewrite it with lots of comments explaining why I'm doing things.

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

Here is what I think you want.

A couple of comments on the code. Whenever possible, avoid using active anything such as active sheet or active cell. Quite often your idea of what’s active and Excel’s idea of what is active may be two different things. It is always best to tell Excel where you want it to be.

Also, there generally is not a good reason to select anything. Selecting something only slows the code down. When the macro recorder comes up with

Please Login or Register  to view this content.

You can usually replace it with

Please Login or Register  to view this content.

Having said all this, there are cases such as when working with charts, where you have to select the item and then work with the active item such as ActiveChart. These are exceptions.

There are several different ways to reference sheets in the code. You can use the sheet name Sheets(“SheetName”) or its position Sheets(2). Another way is to declare a variable as type worksheet and set it to “point” at the sheet: Set shD = Sheets(“Master Sheet”).

One advantage of the pointer method is that it saves typing. Instead of using Sheets(“Master Sheet”) everywhere, you can just use shD.

There is also a subtle difference between the pointer and explicit versions. The pointer method knows which workbook the sheet is in. This comes in handy when you start working with multiple workbooks. So it’s a good habit to get into.

We are only working with one workbook here so the pointer method really isn’t necessary, but I like the shortcut instead of doing all the typing.

Also I try to use a naming convention whenever I can. In this code, anything ending in S has to do with the source sheet, and anything ending in D has to do with the destination sheet.

I make use of an external function to get the matching sheet name. I could have embedded the code into the main subroutine, but I try to make my code as modular as possible. You’ll notice a small subroutine called test. By separating the GetSheet Function into its own self-contained piece, I was able to test it out without running the full code.

Also, in the future, if you ever have to do a partial match of a string to a sheet name, you can lift this piece of code in its entirety.

The GetSheet Function is an example of a user defined function. UDFs usually take arguments and return a value. This function makes use of the LIKE operator to see if the Part is a match for a sheet name. the sh.Name & “*” will match anything that begins with the sheet name and has anything or nothing following it. For more information on LIKE, see https://msdn.microsoft.com/en-us/library/swf8kaxw.aspx.

I hope I put enough comments in the code so it’s understandable. If not, ask!

I removed all the data on sheets 1 and 2 and saved the RAND() measurements as fixed values. I did this for the purposes of QA.

I don't know where you are getting

Please Login or Register  to view this content.

That's not even part of my code.

As for the macros are not enabled: just because a file *can* have macros doesn't mean that they are enabled. Whether macros get enabled depends on your Trust Center Settings.

Also there a no pivot tables in the worksheet. I just downloaded the workbook and looked at it. Your comments led me to believe that I must have uploaded the wrong workbook.

My apologies, I think I ran a code that was similarly named to yours and that was the problem. I still am having problems with getting parts with similar names to the sheet name, like "1A", I know you said using the like command but I do not see that anywhere. I also tried to add part numbers to the original worksheet and the code did not pull these changes. Sorry for all the questions but I really do appreciate you helping me.

Sorry again, so I ran the code again and it pulls the copies like I wanted, thank you again, but if it runs to a part that doesn't have a sheet with a similar name it stops completely. Is there any workarounds for this because I don't know exactly what numbers are there and what are not.

This is the code you should be running.

Please Login or Register  to view this content.

Here is the code with the modification of the msgbox function. It now looks for an answer, and either exits or jumps to the next row to be processed depending on your answer.

Please Login or Register  to view this content.

You are welcome. It helps a lot that you were able to define the requirement rather clearly.