List to card

P

Prixton

Hi,
I have a list vith names and now I´d like to get the names in a form, a time
sheet, for every name in the list. Is there a simple way to do this?

Thanks in advance.
 
C

Cesar Zapata

Hi,

You mean you want to create a sheet for every name in a list? then you
need a little macro like the one below.


Lets say the the list is in Sheet1! A1 to a20


Sub createsheetfromlist()
Dim cell As Range

For Each cell In Sheets(1).Range("a1:a20")
Sheets.Add after:=Sheets(1)
Sheets(2).Name = cell.Value
Next cell

End Sub


make sure names are not duplicating
 
P

Prixton

No, I mean that I want a form, say a Time Sheet for every namn so I can
print it with names, addresses etc filled in. The form can be created in the
same workbook.

Is there a way ?
 
Top