A
ashleyfox
I am preparing a financial forecast and want to have the ability to mov
rows of revenue data to an earlier or later start date. For example,
have a contract beginning Dec 05 with monthly revenues running unti
Nov 07. I want to be able to change the start date and have the sam
numbers move to the right or left in the spreadsheet depending on th
new input date. A what if concept.
The at if function is too complex and each cell requires huge formulas
I have tried named ranges and I can cut and paste the whole range easil
but then the links don't work. If Dec 05 is linked in my base workshee
to say Dec 05 in the P&L, if the data is moved to start Jan 06, th
link stays in Dec05.
I dont know if this is a macro/VBA issue or whether there is some othe
way. If someone could just tell me the excel functionality to explor
that in itself would be helpful.
I am sure this is a standard need but all the books and the posts
have read never seem to deal with it. Wouls appreciate some guidance
rows of revenue data to an earlier or later start date. For example,
have a contract beginning Dec 05 with monthly revenues running unti
Nov 07. I want to be able to change the start date and have the sam
numbers move to the right or left in the spreadsheet depending on th
new input date. A what if concept.
The at if function is too complex and each cell requires huge formulas
I have tried named ranges and I can cut and paste the whole range easil
but then the links don't work. If Dec 05 is linked in my base workshee
to say Dec 05 in the P&L, if the data is moved to start Jan 06, th
link stays in Dec05.
I dont know if this is a macro/VBA issue or whether there is some othe
way. If someone could just tell me the excel functionality to explor
that in itself would be helpful.
I am sure this is a standard need but all the books and the posts
have read never seem to deal with it. Wouls appreciate some guidance