I have a workbook which is structured as:
Assumptions page (allows me to change interest rates etc)
Results summary
Detailed calculations for each item
Source data.
The detailed calculations pages are named after and include the value in
each row of column A of the source data page.
The detailed calculations pages then use that value to perform some lookups
on other workbooks (controlled by other people) and some other calculations.
The format if each detailed calculation page is the same - if I'm doing this
manually, I copy one of them and "re-point" it to the newest addition to the
data sheet.
What I would like to do is be able to add a new item to the list in the data
sheet and have that automatically copy a detailed calculation page and change
the references to the row of the new item.
I am relatively new to programming and have trolled through these pages but
can't find an example that seems to match this one.
I am ok with the other bits of code that I want to use (changing the sheet
name and updating the summary page) but I'm stuck on using only the new data
items to create new worksheets.
|
Similar Threads
