Inserting a new worksheet that is linked to a previous one

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top