How To Create And Populate New Worksheets With Data From Columns In Worksheet 1

HI guys i'm new to macro world need help.
my work requires to create n of copies of sheet 2 based up on the no of names present in first column of sheet 1,also name each sheet with the names from sheet 1 and place the name in D2 cell of the respective sheet.
ex:-
sheet 1 contains names ravi
sundar
hari........
sheet to contains there common certificates
need to create certificate for every one in individual sheet with there names in it,name the sheet with there name

Hi Ravi Varma,



Dear


As you are new to Vba Macro world

i suggest you to be aware about the Worksheet,workbook & Range object .

these are the 3 main object which comprise 60% of Vba codeing.

create a procedure
declare a range object and assign a range that contains a range having a list of names.

then use this range in "for loop statement" or "for each statement"

and use the add method of sheet object to add a new sheet
then pass new name to the worksheet that has been newly added.



please rate if u are satisfied with this post.