Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Create Worksheet From Values in Existing Cells Using Existing Worksheet as Template.
Hello All:
I have been trying to do the following and haven't been successful. I have a workbook(Excel file) that has two worksheet one is called Roster and the other is called template(a pre-formated worksheet). In the Roster I have the names of the students. In one Colum A starting from cell A2. I have created a button that will hopefully do the following. 1) Reads the values in Colum A (starting from A2). 2) Create worksheets using Template worksheet and naming it the values stored in previous step. Please know that I am not a programmer but do my best to peace mill What I find. I have found, Private Sub CommandButton1_Click() Dim LastCell As Range, Rng As Range, cell As Range Dim WS As Worksheet Set WS = ActiveSheet Set LastCell = WS.Cells(Rows.Count, "A").End(xlUp) Set Rng = WS.Range("A2", LastCell) For Each cell In Rng If Not IsEmpty(cell) Then Sheets.Add.Name = cell.Value End If Next End Sub This makes the worksheets with the name of the values, but I can't quite get it to use the template for copying. Any help on this is greatly appreciated. Ardy |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I apply a template to one worksheet in existing workbook? | Excel Discussion (Misc queries) | |||
is it possible to apply template to a existing worksheet | Excel Worksheet Functions | |||
'Template' within a worksheet - change existing worksheets | Excel Programming | |||
apply a template to existing worksheet | Excel Discussion (Misc queries) | |||
How do I conditionally build worksheet from existing worksheet? | Excel Discussion (Misc queries) |