duplicating sheets based on cell content

[Peaky_Blinder]

HI

I currently use the below code to generate copies of sheets based on a list in sheet 1 - List. What I am wanting to do is populate a specific cell, say A1 on sheet 1 - List with the name of the sheet I want to copy ie P9 on the example below, how would I do this?

Please Login or Register  to view this content.

[maniacb]

If I'm understanding correctly, If the name of the sheet is always hardcoded as "P9" in the code, you could just add the following line in red:

Please Login or Register  to view this content.

[maniacb]

You can also make the sheet to copy a string value in the code so you don't have to update three lines but one:

Please Login or Register  to view this content.

[Croweater]

Just change "P9" to Range("A1").Value....

Please Login or Register  to view this content.

[Peaky_Blinder]

Hi no the sheet to copy (P9 in this instance) would not be hardcoded, it would change based on what is in cell A1 on sheet 1 - List

eg is "1 List" A1 if P13 then that would be the sheet that needs copying

[Peaky_Blinder]

Just change "P9" to Range("A1").Value....

Please Login or Register  to view this content.

His this worked a treat, if I was to want to do the same with another sheet but but that in B1 could I add this to the same code or would i need to add another?

[Peaky_Blinder]

Im sorted guys now, thanks for your help