Asking for help creating an intricate and dynamic dropdown list.

%3CLINGO-SUB%20id%3D%22lingo-sub-579279%22%20slang%3D%22en-US%22%3EAsking%20for%20help%20creating%20an%20intricate%20and%20dynamic%20dropdown%20list.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-579279%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20all%2C%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%20%26nbsp%3B%26nbsp%3B%20I%20am%20fairly%20new%20to%20Excel%20and%20am%20probably%20in%20over%20my%20head%20trying%20to%20use%20excel%20more%20dynamically%20than%20I%20should.%20I%20work%20for%20my%20city's%20park%20department%20and%20am%20trying%20to%20create%20a%20book%20that%20links%20daily%20data%20to%20sheets%20with%20weekly%2C%20monthly%2C%20and%20yearly%20data%20to%20show%20park%20statistics%20and%20trends.%20I've%20created%20formulas%20to%20auto%20populate%20the%20information%20on%20other%20sheets.%20All%20of%20this%20was%20fairly%20straight%20forward.%20Now%2C%20I%20am%20trying%20to%20make%20it%20look%20very%20professional%20and%20user%20friendly.%20I%20would%20rather%20create%20the%20weekly%2C%20monthly%2C%20and%20yearly%20data%20into%20a%20dropdown%20list%20where%20you%20pick%20the%20date%20and%20it%20only%20shows%20you%20the%20info%20and%20a%20graph%20for%20that%20dates%20specific%20data.%20I've%20used%20Linked%20In%20Learning%20to%20learn%20most%20of%20the%20information%20I%20have%20now.%20Does%20anyone%20have%20links%20or%20resources%20that%20could%20help%20me%20to%20do%20what%20I'm%20looking%20for%20or%20is%20it%20too%20dynamic%20or%20not%20possible%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-579279%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Visitor

Hi all, 

     I am fairly new to Excel and am probably in over my head trying to use excel more dynamically than I should. I work for my city's park department and am trying to create a book that links daily data to sheets with weekly, monthly, and yearly data to show park statistics and trends. I've created formulas to auto populate the information on other sheets. All of this was fairly straight forward. Now, I am trying to make it look very professional and user friendly. I would rather create the weekly, monthly, and yearly data into a dropdown list where you pick the date and it only shows you the info and a graph for that dates specific data. I've used Linked In Learning to learn most of the information I have now. Does anyone have links or resources that could help me to do what I'm looking for or is it too dynamic or not possible?

0 Replies