First you want to defined a dynamic named range (if possible) for the
column that contains the product list. Then you want a macro to loop
through the range and check if there is an existing worksheet with
that name. If not, create the worksheet and name it with the product
name, copy over the information from the master worksheet, and copy
the name of the worksheet into cell B1.

Do you have any code written at all?

--JP

On Oct 20, 8:44*am, Eduardo wrote:
I have excel 2007, I have a list of products in *column A rows 5 to 19 ( with
possible new additions) and I need a macro to insert tabs and name its with
the product names. Everytime the macro is run it will identify the new
prroducts and will create a tav for it. Each tab will be a copy or the master
tab (where I have the formulas and calculations) and will copy the name of
the tab in Cell B1. I appreciate any help. thanks