Dear Experts,
Please find here attached workbook, I do have very complicated situation for me and for the same i am looking your precious support. In Raw Forecast & Raw Actual tabs i do have data on daily basis with the column heading Budget Period. Now basis on the daily numbers in the Report tab i do require output in Cell D14 & F14 for Total Week, Cell L14 & N14 for Total Month, Cell T14 & V14 for Total Quarter and Cell Ab14 & AD14 for Total Year based on following criteria:
1) Criteria at Cell B11
2) Criteria at Cell B13
3) Criteria at Cell B14
4) Criteria at Cell Q3
5) Criteria at Bank Selection Control Form Box
And the with above i do need formula for Opening Balance for Forecast & Actuals for Total Week, Month, Quarter & Year. Dear Experts i have kept also the Form Control Button for Frequency, Please check whether is it beneficial to keep or not.
Request to you please do help me out.
Thank you for your precious phase and valuable support.
Regards,
Neilesh
Bookmarks