I have an excel spreadsheet that at the top I would like to have a search box and you type a specific word and it searches the spreadsheet and returns data if there is any. There are a total of 7 columns and about 120 rows. The rows can grow or shrink at any time. I would like to have a search box at the top with the 7 columns below and when you type something into the search box and click search it will search for the data you have entered and return data below. TIA!
You can click Ctrl + F to find something...
or
You can use AutoFilter tool to find something...
Last edited by HerryMarkowitz; 04-20-2015 at 11:23 AM.
Sub DontForgetThese() If Your thread includes any code Then Please use code tags... If Your thread has been solved Then Please mark as solved... If Anybody has helped to you Then Please add reputation... End Sub
Thanks, but I would really like to have it where they can search and it returns the data.
Select the column and click Ctrl + F...
That is not how I would like to set up the spreadsheet. I am trying to make it easy on individuals that are not always familiar with excel. Thank you for your response.
As I said before you can search everything using Filter tool...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks