software

Hi thereI am using Excel 2002.I have one worksheet tab named quot;Product 1quot; (which is the same data as I

typed in cell A1).I wanna make 20 copies of this worksheet and name them from quot;Product
2quot;, quot;Product 3quot;.... all the way till quot;Product 21quot;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 quot;Product 2quot;, Worksheet Product 3's
cell A1 is quot;Product 3quot; etc etc....How can I do that?Thanks.cheersHello,
Try my add sheet utility at
www.geocities.com/excelmarksway

There are two of them.
AddSheets.xls
or
InReMo.xls

The last one is a bit more advanced.

It gives you the option of creating as many sheets as you want. And naming
them to whatever ie Product1, Product2, etc also dates in any format ....

quot; wrote:

gt; Hi there
gt;
gt;
gt; I am using Excel 2002.
gt;
gt;
gt; I have one worksheet tab named quot;Product 1quot; (which is the same data as I
gt;
gt; typed in cell A1).
gt;
gt;
gt; I wanna make 20 copies of this worksheet and name them from quot;Product
gt; 2quot;, quot;Product 3quot;.... all the way till quot;Product 21quot;
gt;
gt;
gt; Questions:
gt;
gt;
gt; 1) is there a faster or easier way to copy/duplicate 20 copies of the
gt; worksheet?
gt;
gt;
gt; 2) I also want the worksheet name appears in cell A1 respectively i.e.
gt; Worksheet Product 2's cell A1 is quot;Product 2quot;, Worksheet Product 3's
gt; cell A1 is quot;Product 3quot; etc etc....
gt;
gt;
gt; How can I do that?
gt;
gt;
gt; Thanks.
gt;
gt;
gt; cheers
gt;
gt;