Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Moving data in financial forecast
I am preparing a financial forecast and want to have the ability to move rows of revenue data to an earlier or later start date. For example, I have a contract beginning Dec 05 with monthly revenues running until Nov 07. I want to be able to change the start date and have the same numbers move to the right or left in the spreadsheet depending on the 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 easily but then the links don't work. If Dec 05 is linked in my base worksheet to say Dec 05 in the P&L, if the data is 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 other way. If someone could just tell me the excel functionality to explore that in itself would be helpful. I am sure this is a standard need but all the books and the posts I have read never seem to deal with it. Wouls appreciate some guidance. -- ashleyfox ------------------------------------------------------------------------ ashleyfox's Profile: http://www.excelforum.com/member.php...o&userid=26493 View this thread: http://www.excelforum.com/showthread...hreadid=397600 |
#2
|
|||
|
|||
Got your solution?
I wish to try please. "ashleyfox" wrote: I am preparing a financial forecast and want to have the ability to move rows of revenue data to an earlier or later start date. For example, I have a contract beginning Dec 05 with monthly revenues running until Nov 07. I want to be able to change the start date and have the same numbers move to the right or left in the spreadsheet depending on the 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 easily but then the links don't work. If Dec 05 is linked in my base worksheet to say Dec 05 in the P&L, if the data is 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 other way. If someone could just tell me the excel functionality to explore that in itself would be helpful. I am sure this is a standard need but all the books and the posts I have read never seem to deal with it. Wouls appreciate some guidance. -- ashleyfox ------------------------------------------------------------------------ ashleyfox's Profile: http://www.excelforum.com/member.php...o&userid=26493 View this thread: http://www.excelforum.com/showthread...hreadid=397600 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I compare 2 sets of data and highlight differences? | Excel Worksheet Functions | |||
Sort pages? | Excel Discussion (Misc queries) | |||
Adding more source data to existing scatter plot | Charts and Charting in Excel | |||
Running Data Table using an input that triggers DDE linked data | Excel Discussion (Misc queries) | |||
Data Table - does it work with DDE links and Stock Tickers? | Excel Worksheet Functions |