Moving ranges by start date
 

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 to other parts of the workbook don't work. If Dec 0
is linked in my base worksheet to say Dec 05 in the P&L, if the data i
moved to start Jan 06, the 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

--
ashleyfo
-----------------------------------------------------------------------
ashleyfox's Profile: http://www.excelforum.com/member.php...fo&userid=2649
View this thread: http://www.excelforum.com/showthread.php?threadid=39796