Hi there


I am using Excel 2002.


I have one worksheet tab named "Product 1" (which is the same data as I

typed in cell A1).


I wanna make 20 copies of this worksheet and name them from "Product
2", "Product 3".... all the way till "Product 21"


Questions:


1) is there a faster or easier way to copy/duplicate 20 copies of the
worksheet?


2) I also want the worksheet name appears in cell A1 respectively i.e.
Worksheet Product 2's cell A1 is "Product 2", Worksheet Product 3's
cell A1 is "Product 3" etc etc....


How can I do that?


Thanks.


cheers