I have a list of sheet names and a drop down list of those sheet names in a cell. I then want a macro that will take whatever sheet name is selected from the drop down list and select that sheet and create a new copy of it in the current workbook.
Probably super simple but I can't seem to figure out how to reference the sheet name as a value in a cell:
' copyandpastesheet Macro
'
'
Sheets("THIS IS WHERE I WANT TO REFERENCE A CELL THAT HOLDS A SHEET NAME").Select
Cells.Select
Selection.Copy
Sheets.Add After:=Sheets(Sheets.Count)
Cells.Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Selection.PasteSpecial Paste:=xlPasteFormats, Operation:=xlNone, _
SkipBlanks:=False, Transpose:=False
Range("A1").Select
End Sub
Please let me know if you think you have a solution for my novice nature, thanks.
Probably super simple but I can't seem to figure out how to reference the sheet name as a value in a cell:
' copyandpastesheet Macro
'
'
Sheets("THIS IS WHERE I WANT TO REFERENCE A CELL THAT HOLDS A SHEET NAME").Select
Cells.Select
Selection.Copy
Sheets.Add After:=Sheets(Sheets.Count)
Cells.Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Selection.PasteSpecial Paste:=xlPasteFormats, Operation:=xlNone, _
SkipBlanks:=False, Transpose:=False
Range("A1").Select
End Sub
Please let me know if you think you have a solution for my novice nature, thanks.