Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Inserting a new worksheet that is linked to a previous one
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy two linked sheets, and update the link isn't to the previous | Excel Discussion (Misc queries) | |||
Inserting new row and pasting formulas from previous row | Excel Discussion (Misc queries) | |||
Inserting rows, updating linked worksheet | Excel Worksheet Functions | |||
inserting row into linked cells | Excel Worksheet Functions | |||
Can I retain functions from a previous cell when inserting a new r | Excel Discussion (Misc queries) |