Hi all,
Need your kind help here. I have a several sheets containing actual, budget and forecast numbers and all in the same format. What I want is to display (sumif) the data based on the month choosen in the drop down list. e.g if I choose March 12, then all the numbers in actual, budget and forecast will display the sumif from the respective sheet.
Also is it possible to display the year to date amount?
Thanks for your kind help, attached is the sample data
Bookmarks