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: ua-cam.com/video/HUnFkZPB2iQ/v-deo.html
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. ua-cam.com/video/HUnFkZPB2iQ/v-deo.htmlsi=X6OlpdbX4xpjH7Iy
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.
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
For more complex search functions, see my other video. ua-cam.com/video/HUnFkZPB2iQ/v-deo.html
What if you have multiple tabs? (Example: Data1, Data2, Data3) How can you search in all tabs? Thank you.
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: ua-cam.com/video/HUnFkZPB2iQ/v-deo.html
I am trying this with clients' name in a row. But, it's not working. Please suggest something.
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. ua-cam.com/video/HUnFkZPB2iQ/v-deo.htmlsi=X6OlpdbX4xpjH7Iy
@@ParkerLearnsStuff Yes, it is working. Actually, I was trying something similar, later realize it was not correct. Thank you.
How do you switch between sheets to select the columns?
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.
Gracias❤❤❤
Thanks
gracias