Home

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
Lpworkman
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?

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
21 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies