9
9burnsdr
I am building a workbook that is intended to capture information on new
feature requests for a system. The workbook will then consolidate
information from each new feature request and perform different kinds
of analysis to facilitate portfolio management (ranking views of each
feature to make a determination as to which features will be funded for
the next release). Analysis (and input for each feature) will include
things like value to the customer, value to the company, development
cost, marketing risk, development risk, deployment/support risk,
company strategy supported, etc.
I think I would like to use 3-D references to copy the individual
worksheets into the workbook that are created by the person requesting
the feature. The format of these will be standardized so that
everything used by the rest of the workbook is in the same relative
location.
I am looking for ways that once the information (feature worksheet) is
copied into the workbook that I can:
1) automatically populate a separate summary worksheet that shows a row
for each feature request and columns that have the required data items
from the new feature sheet. Ideally, all someone has to do is add
the new feature worksheet in the 3D range and the rest of the workbook
adjusts. I don’t know how to establish the formulas for getting this
data from a variable amount of worksheets that may be changing. I do
know how to calculate three D from the sheets that are added, but I
need a sheet that has all of the feature requests, to perform other
analysis and sorting.
2) Once I have the summary sheet built that will have a variable amount
of rows, is there a way (or would it be the same as request 1) that I
can build formulas in other sheets that reference row 2 through x?
where x depends on how many sheets have been added in the 3D range?
Any suggestions will be appreciated?
feature requests for a system. The workbook will then consolidate
information from each new feature request and perform different kinds
of analysis to facilitate portfolio management (ranking views of each
feature to make a determination as to which features will be funded for
the next release). Analysis (and input for each feature) will include
things like value to the customer, value to the company, development
cost, marketing risk, development risk, deployment/support risk,
company strategy supported, etc.
I think I would like to use 3-D references to copy the individual
worksheets into the workbook that are created by the person requesting
the feature. The format of these will be standardized so that
everything used by the rest of the workbook is in the same relative
location.
I am looking for ways that once the information (feature worksheet) is
copied into the workbook that I can:
1) automatically populate a separate summary worksheet that shows a row
for each feature request and columns that have the required data items
from the new feature sheet. Ideally, all someone has to do is add
the new feature worksheet in the 3D range and the rest of the workbook
adjusts. I don’t know how to establish the formulas for getting this
data from a variable amount of worksheets that may be changing. I do
know how to calculate three D from the sheets that are added, but I
need a sheet that has all of the feature requests, to perform other
analysis and sorting.
2) Once I have the summary sheet built that will have a variable amount
of rows, is there a way (or would it be the same as request 1) that I
can build formulas in other sheets that reference row 2 through x?
where x depends on how many sheets have been added in the 3D range?
Any suggestions will be appreciated?