Hello, I'm trying to create a database of step by step instructions on how to complete different tasks. This looks like individual, separate outlines. I'm open to other ideas of formatting.
I will need a way to search for specific words and have excel bring the related task to the front of the screen, while still having the search bar available, or a very easy way to jump back to it.
EX Google search bar that only pulls the one related result.
I'm thinking a VBA/Macro that would jump to the title's name would be easiest. But I'm not sure if I should go that route or if there's a simpler way I haven't thought of yet. Aside from simple scrolling.
Again, I'm open to any alternative ideas you may have! Just need to get the correct information in front of the people who need it, in an easy to use way. Preferably in a way that won't require a lot of explanation for people who don't regularly touch Excel.
Thanks in advance!
I will need a way to search for specific words and have excel bring the related task to the front of the screen, while still having the search bar available, or a very easy way to jump back to it.
EX Google search bar that only pulls the one related result.
I'm thinking a VBA/Macro that would jump to the title's name would be easiest. But I'm not sure if I should go that route or if there's a simpler way I haven't thought of yet. Aside from simple scrolling.
Again, I'm open to any alternative ideas you may have! Just need to get the correct information in front of the people who need it, in an easy to use way. Preferably in a way that won't require a lot of explanation for people who don't regularly touch Excel.
Thanks in advance!