Questions

Excel auto populate given a start date

Tags:
+
0 Votes
Locked

Excel auto populate given a start date

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