id="info"

Question

Locked

Excel auto populate given a start date

By jamieangel06 ·
Hi I need some help,

I have a spreadsheet with a list of projects down column A then the forecast revenue in each row b:z a2:z2 has the month's names in them.

what i need is a formula/solution to push the revenue out a few months for each row given a start date on a new sheet (sheet2), if the project was forecasted to start recieving revenue in march for example but now is forecast to start in May i need a solution that will check the new start date then copy the figures from sheet1 column "march" to sheet2 cloumn "May" and so on for the other few months.

Thanks in advance

J

This conversation is currently closed to new comments.

2 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Answers

Back to Software Forum
2 total posts (Page 1 of 1)  

Software Forums