trprasad78
Member
Hi experts
I am looking for vba to sum the value based on YTD, MTD ,YR16& YR17.
full year (financial year ) from 1st April 2016 31st March 2017
YTD = 1st April 2016 till last month
MTD = Current Month till date
YR16 = 1st April 2016 31st March 2017
Month start from "E17"
Start month and end month vary file to file. so i dont know how to handle that.
Result need/output = Sample1.xlsx [Report1 & Report2]
output Report1
Name = Folder name
Customer =AAR!B4
Project=AAR!B1
Costcenter=AAR!B2
Revenue = YTD
Total Cost=YTD
Revenue=MTD (for the month)
Total Cost=MTD (for the month)
Revenue=MONTHS - (LESS) YTD & MTD
OUTPUT Report2
Name = Folder name
Customer =AAR!B4
Project=AAR!B1
Costcenter=AAR!B2
Revenue&Total cost FY17 = 1st April 2016 31st March 2017
Revenue&Total cost FY18 = 1st April 2017 31st March 2018
Revenue&Total cost FY19 = 1st April 2018 31st March 2019
we have some 50 files like this all data sum and get in to report1 & report2
if you able to help me it will be great, please do the needful
I am looking for vba to sum the value based on YTD, MTD ,YR16& YR17.
full year (financial year ) from 1st April 2016 31st March 2017
YTD = 1st April 2016 till last month
MTD = Current Month till date
YR16 = 1st April 2016 31st March 2017
Month start from "E17"
Start month and end month vary file to file. so i dont know how to handle that.
Result need/output = Sample1.xlsx [Report1 & Report2]
output Report1
Name = Folder name
Customer =AAR!B4
Project=AAR!B1
Costcenter=AAR!B2
Revenue = YTD
Total Cost=YTD
Revenue=MTD (for the month)
Total Cost=MTD (for the month)
Revenue=MONTHS - (LESS) YTD & MTD
OUTPUT Report2
Name = Folder name
Customer =AAR!B4
Project=AAR!B1
Costcenter=AAR!B2
Revenue&Total cost FY17 = 1st April 2016 31st March 2017
Revenue&Total cost FY18 = 1st April 2017 31st March 2018
Revenue&Total cost FY19 = 1st April 2018 31st March 2019
we have some 50 files like this all data sum and get in to report1 & report2
if you able to help me it will be great, please do the needful