HI Dear Friends,

I stumbled upon a file I was working on when I had to create a Drop Down list with additional set of functionalities. I have attached my sample work with what I need, any help would be greatly appreciated

I tried to strip down as much information as possible to upload on the website portal but not working hence posted it on a link

http://speedy.sh/4zQfm/UTILITIES-P-L-DEMO.xlsx

I have listed out what i would need in the spreadhseet

• Drop Down list in Cell AB 1- To show YTD Actuals, FY Actuals, Q1 Actuals,Monthly Actuals
YTD Actuals means to pull values from Jan to Dec, this is what the current formula is doing
FY Actuals means to pull values from Jul 14 to June 15
Q1 Actuals means to pull values from Jan-15 to Mar-15
Monthly actuals means to pull values for each month as shown in Cell AB2
The action o f all the above items should be seen in Column AB only
• How to make drop list button visible without clicking on the cell
• Any change in formula required as current formula slowing down sheet. This is a demo sheet and I have more similar categories to add like Water, electrcity etc
I have used name list and this still seems to slow down my data as I work on my original file