Excel Drop Down Lists...can they self-adjust?
I'm working on a spreadsheet where I schedule posts to various social networking sites.
Right now I'm posting to three sites and I have chosen five different times during the day that I intend to post for each site.
Thus, one site will only get posts from me at 8:45 AM, 11:45 AM, 2:45 PM, 4:45 PM or 8:45 PM. Another will only get posts at five other times and likewise for the third. Don't ask me why, it just seems like a good idea.
Right now, when I'm scheduling to post to say, LinkedIn, I need to look at my list for LinkedIn times. What I'd like to do is click a drop down list in one column where I select the platform (LinkedIn, Facebook, etc.) and then when I get to the column for time, I can click a drop down list that will only show me the times available for that platform.
This one's over my head.
I've attached a sheet that shows the platforms and times I'm working with. Below is what the data looks like.
Drop-Down-Sample.xlsx
Right now I'm posting to three sites and I have chosen five different times during the day that I intend to post for each site.
Thus, one site will only get posts from me at 8:45 AM, 11:45 AM, 2:45 PM, 4:45 PM or 8:45 PM. Another will only get posts at five other times and likewise for the third. Don't ask me why, it just seems like a good idea.
Right now, when I'm scheduling to post to say, LinkedIn, I need to look at my list for LinkedIn times. What I'd like to do is click a drop down list in one column where I select the platform (LinkedIn, Facebook, etc.) and then when I get to the column for time, I can click a drop down list that will only show me the times available for that platform.
This one's over my head.
I've attached a sheet that shows the platforms and times I'm working with. Below is what the data looks like.
Drop-Down-Sample.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I see how that works. Wow, that is cool.
Thanks.
Jim
Thanks.
Jim
ASKER
Elegant.
ASKER
ITJockey
Sorry, I didn't see your comment. It came in while the screen was open and I was implementing the other solution. I think I figured a way to cover you from before. I will look at your suggestion here in a bit.
Jim
Sorry, I didn't see your comment. It came in while the screen was open and I was implementing the other solution. I think I figured a way to cover you from before. I will look at your suggestion here in a bit.
Jim
Picture is more than words i guess.
Thanks & one thing i had noticed in Sheet 2 - Step 8 - change to =INDIRECT($A$2) as provided wB that is = INDIRECT(A2).
Thanks & one thing i had noticed in Sheet 2 - Step 8 - change to =INDIRECT($A$2) as provided wB that is = INDIRECT(A2).
oooppps even i seen question is solved only after i had posted. i was preparing screen shots for better under standing.
:) :)
Thanks
:) :)
Thanks
Thanks
Drop-Down-Sample.xlsx