I have an excel workbook with two worksheets "Master" and "Template"
I want to copy "template" once a cell, from range
A2:A20, in worksheet "Master" is filled out and name a new worksheet with
I would like to copy value from Master sheet of two cells, into newly created worksheet (from master cells
A2:B2 to new sheet (with a name
A2) to cells
I want to do that for each cells
A2:A20 that are filled out, so that it would not create a new worksheet for cells from
A2:A20 that are empty.
So if I would have
A5 filled out I would get 3 new worksheet, like template worksheet, with names from
A5. In first new sheet
A2:B2 from master, would be copied to
D1:D2. In second new sheet
A4:B4, would be copied to
D1:D2 and on the third new worksheet
A5:B5 would be copied to
I would like to have this done, once excel is open, and if once done, not to repeat it
is this possible?
much appreciate any help
Sub CreateAndNameWorksheets() Dim c As Range Application.ScreenUpdating = False For Each c In Sheets("Master").Range("A2:A20") Sheets("Template").Copy After:=Sheets(Sheets.Count) With c ActiveSheet.Name = .Value .Parent.Hyperlinks.Add Anchor:=c, Address:="", SubAddress:= _ "'" & .Text & "'!A1", TextToDisplay:=.Text End With Next c Application.ScreenUpdating = True End Sub