Hi @atcodedog05 ,
I have two excel files
1)File1: 2021m07
2)File2: Final_report_07_2021
File1 is empty and File2 has a data.
Requirement:
File2 has columns with the month names.
I have to Sum these columns amount in a way that it adds up from Jan to present month.
For Example: These files are for month July , so it should add (Jan to Jul)/1000
For the next month it should add from (Jan to August)/1000
Desired_Output:
Result
381
My approach : i thought to take the month name from File name and map it with the column month name.
Can you help to solve this in better way or with my approach?
Regards
Areeba
Solved! Go to Solution.
Happy to help : ) @areeba
Cheers and have a nice day!