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


This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Share your knowledge

Related Discussions

Related Forums