Macro for creating 100 of the same sheet - then MACRO for copying values

[Likizaan]

Hi there,

I need some help, thought I would delve into this knowledge pool

I would like to create a macro that will copy a entire sheet and create 100 copies in the same workbook, this is for letter purposes.

Then I would like to use values in another sheet, a list of names, take the first name and copy it into the first sheet, then the second name into the second sheet, etc. You get the point. Any ideas?


Thanks

L

 

[NARAYANK991]

Hi ,


You need to have copies of the same worksheet , only if you need to store these for record purposes. Otherwise , just as you have Mail Merge in MSWord , you can have the macro do the printing using only one worksheet as a template , and filling in the required fields in the template from the database worksheet. Is this acceptable ?


Narayan