chicagojump
New Member
- Joined
- Oct 26, 2015
- Messages
- 1
I'm using Excel 2011 for Mac.
I'm posting because I haven't figured out how to search for what I'm asking.
I help out at a theater that uses an excel worksheet online for it's calendar.
https://onedrive.live.com/view.aspx...=file,xlsx&app=Excel&authkey=!ADkNNtAP5aypgZ0
I would like to be able to add a search box to the page, where performers can enter by the name of their group ("Torque," for example) and it will show them what dates their shows are going to be.
Ideally, it would search for the name of the group, and then pull the date from the column above it, then place that bit of info in some "results box."
BUT if that's wildly unrealistic, perhaps some way of dressing up the regular search function and it's highlighting of their shows --some box they enter the info into, some way to make the interface easier-- would help too.
And feel free to drop any pointers on how I could have searched for this... I mean, what terms I should have used, and how I could have figured this out on my own.
I've realized I'm out of my depth on this question, and greatly appreciate any advice you might have.
I'm posting because I haven't figured out how to search for what I'm asking.
I help out at a theater that uses an excel worksheet online for it's calendar.
https://onedrive.live.com/view.aspx...=file,xlsx&app=Excel&authkey=!ADkNNtAP5aypgZ0
I would like to be able to add a search box to the page, where performers can enter by the name of their group ("Torque," for example) and it will show them what dates their shows are going to be.
Ideally, it would search for the name of the group, and then pull the date from the column above it, then place that bit of info in some "results box."
BUT if that's wildly unrealistic, perhaps some way of dressing up the regular search function and it's highlighting of their shows --some box they enter the info into, some way to make the interface easier-- would help too.
And feel free to drop any pointers on how I could have searched for this... I mean, what terms I should have used, and how I could have figured this out on my own.
I've realized I'm out of my depth on this question, and greatly appreciate any advice you might have.