selecting a sheet that matches the name in a cell range

[Muckybox]

Hi,

I'm having trouble selecting a newly created sheet that matches a name from a range of names in a list. As a new name is entered, it already creates a new sheet for them but then I need it copy another sheet and paste it to the newly created sheet therefore it needs to be selected but as the names are not known, they need to be matched to select the new sheet.

I need the macro to match the name and select the appropriate sheet. I think I can do it based on a singular cell reference but the cell reference is a variable with every new sheet created.

Any help is much appreciated!

[Norie]

How are you creating the new sheet(s)?

Can you post your current code?

[Muckybox]

I've been playing around with this but I think I've taken out the other code that I've tried to try and solve my problem. This should be the whole code I'm using.

Please Login or Register  to view this content.

[jolivanes]

Re: therefore it needs to be selected

I don't understand your explanation of what you want to accomplish so I can't really offer anything but you don't need to select a sheet to copy from or paste into.
As an example, if you are in Sheet1 and you want to copy from Sheet2 into Sheet3, these 3 examples would do that.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[leelnich]

This is what Muckybox' post #3 code appears to do:

Please Login or Register  to view this content.

[Muckybox]

Re: therefore it needs to be selected

I don't understand your explanation of what you want to accomplish so I can't really offer anything but you don't need to select a sheet to copy from or paste into.
As an example, if you are in Sheet1 and you want to copy from Sheet2 into Sheet3, these 3 examples would do that.

I think i see your point but i cant define the destination as it changes every time.

I think theres probably an easier way to do this actually. I have a master sheet that all new sheets i want to add must start with so what im doing is creating a new sheet which sets its name based on a new entry to a database of names and then trying to copy/paste this master sheet to the new players own sheet.

Im also trying to teach myself all this so im no vba veteran, are these 3 codes doing exactly the same thing?

[Muckybox]

I've solved my issue by changing the way I create the new sheet.

Instead of creating the sheet, selecting another sheet to copy and then try to match the name to find and select the new page to be able to paste it, I've simply just copied the existing sheet and renamed it that way as part of the code I already had.

Please Login or Register  to view this content.

[jolivanes]

I would minimize selecting if possible at all.
This will do the same without the selecting or making visible.
Run it while in any sheet and see the result.

Please Login or Register  to view this content.

[Muckybox]

I tried this and it didn't work. It copied the hidden page, which remained hidden and just changed the name of the next page. I played with not having to make it visible and selecting to start with but was getting errors so decided to just stick with what I've got. Thanks though!

[jolivanes]

If you would have mentioned all the facts in Post #1, like hidden sheets, things might have been a lot easier.
Go with whatever works though.
Good luck

[Muckybox]

True, sorry for the miscommunication.
I do now have another problem which I believe is the same as my post. Matching a cell reference to a sheet name, is that possible do you know? I put that I though I knew how to do it but I've either forgotten or I was mistaken.