Output has to create FY based on source data

[trprasad78]

Hi All,

Thank you so much for Chandoo.org this forum

I have month wise revenue and cost , from that i need to pull out data from financial year April to March .

Months will increase based on project.

out has to check how many years are thier based on that out column has to added the financial year.like FY17,FY18,FY19,FY20,FY21,FY22... So.. on.

EX:-
FY17 = Apr16 - Mar17
FY18 = Apr17 - Mar18

I need VBA code to add the FY Column in out put based on the year available in the sheet1 (source ), it has to sum the value based on Financial year.

please refer the file i attached.

Thank you all for your support

 

[trprasad78]

I guess my question is not clear...
Please ask your question

 

[Monty]

Hey trprasad78

Welcome back!!!

You meen to say when ever you add new year in the sheet1...it should also add in sheet 2 as format mentioned...correct me if am wrong...

 

[trprasad78]

Hey trprasad78

Welcome back!!!

You meen to say when ever you add new year in the sheet1...it should also add in sheet 2 as format mentioned...correct me if am wrong...

Exactly I have four Financial year will be their in out put.
First one always be a current financial year
2nd one following next financial year
3rd following next
4th following next.

When ever current date change the out also change.
If current date is 05-Feb-17 then sum FY17= Apr16 to mar17
Rest of the column should be following next 3 frequent year..FY18,FY19&FY20.

We need to maintain next 3 years.

If current date is 20-Dec-2017 then sum FY18 = Apr17to Mar18.

Hope I am clear.