Input data in a worksheet so it will open and create a new worksheet tmeplate

[elliemae64]

Hello all,

I am trying to insert data in a cell in one worksheet with hopes on opening a new worksheet (and name the new worksheet with the data I input) in the same workbook.

example: If I type Ellen McKay in A5 in worksheet 1, I want it to create and open a worksheet 2 named Ellen McKay. But I want to worksheet 2 to be an invoice template that I created. Can this be done?

 

[ranman256]

I think templates apply to workBOOKS. Try...

   vName = range("A5")
    Workbooks.Add Template:="C:\Users\myName\AppData\Roaming\Microsoft\Templates\Jaxworks_GA_ExpBudget.xltx"
    ActiveSheet.Name =vName