J
Joanne
Hello
I am trying to creat a template that a user can adapt each time and make it
as user friendly as possible. Each worksheet is one product and this template
will be used once a month for a different number of products.
There is worksheet A which contains summaries of the data from the other
worksheets. Worksheets B and C contain set formulas which are linked to the
summaries in worksheet A. How would I approach creating a macro for when a
new product/worksheet needs to be inserted that is a replica of B and C but
is linked to the same equations in A.
So for example one equation in A is a COUNTIF, for colunm B in each
worksheet. If a new tab was inserted with the same format as the others,
could it be addes to the equations in A.
Hope that makes sense and is not too long winded.
Thanks in advance
Joanne
I am trying to creat a template that a user can adapt each time and make it
as user friendly as possible. Each worksheet is one product and this template
will be used once a month for a different number of products.
There is worksheet A which contains summaries of the data from the other
worksheets. Worksheets B and C contain set formulas which are linked to the
summaries in worksheet A. How would I approach creating a macro for when a
new product/worksheet needs to be inserted that is a replica of B and C but
is linked to the same equations in A.
So for example one equation in A is a COUNTIF, for colunm B in each
worksheet. If a new tab was inserted with the same format as the others,
could it be addes to the equations in A.
Hope that makes sense and is not too long winded.
Thanks in advance
Joanne