scotthannaford1973
Board Regular
- Joined
- Sep 27, 2017
- Messages
- 112
- Office Version
- 2010
- Platform
- Windows
Hi
I have a sheet "Folders" which has a huge table of data; I then have another sheet "Search" with a cell K11 into which I'd like colleagues to type a search term and for that to effectively be copied and pasted into a filter for "Folders" column C, so that whatever they type in Search!K11 and click onto a button, automatically takes them to "Folders" and shows the filtered results.
Hope that makes sense!
TIA
I have a sheet "Folders" which has a huge table of data; I then have another sheet "Search" with a cell K11 into which I'd like colleagues to type a search term and for that to effectively be copied and pasted into a filter for "Folders" column C, so that whatever they type in Search!K11 and click onto a button, automatically takes them to "Folders" and shows the filtered results.
Hope that makes sense!
TIA