Ever wanted to have search bar in your google spreadsheet and make it easier to view information? Then this video is for you. You can find my new favorite way to search in this video: • Better Than a Search B...
Hi can you help me. I want to have a search bar to search for employee ID and search date from and date to at the same time. Once I click the search button, the data will then be displayed to a table like displaying my selected rows from the other tables. and the main problem is, there is a static data below the table and my problem is that what if I reach the number of rows I alloted to the searched data? and what will then be happen to the remaining data I need to display
You would have to repeat this process for each tab. This can become quite time consuming. This is why I created an app script that you just have to copy and past and instantly your entire sheet is searchable. You can find my video here: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-HUnFkZPB2iQ.html
As you are filling in the requirements for the filter function, you have to designate the data range. You can accomplish this by manually entering or highlighting. In this case, I clicked the other sheet, and the while holding down the control or command key selected the entire rows I wanted to highlight. This updates the data range. Hope that helps.
Likely not searching the correct word. If you for example have one column for first name, another column for last name, you can only look up via first or last not both. If you need a more universal look up, I suggest watching my other video. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-HUnFkZPB2iQ.htmlsi=X6OlpdbX4xpjH7Iy