Hi, I am trying to create a handover logbook for my work with a search function. I have created a filtered table with a blank row above the table to add new log entries, it then has a macro button to insert a new line in the sheet and cut and paste it in the newly inserted row.
I would now like to add a search box that will automatically filter the table to only include rows that contain this text , I would prefer it to dynamically filter so that as each letter is typed it filters more rows i.e filter as i type not wait until i hit a search button.
Any help would be greatly Appreciated,
Cheers,
Chris
[TABLE="class: t1"]
<tbody>[TR]
[TD="class: td1"][/TD]
[TD="class: td1"][/TD]
[TD="class: td1"][/TD]
[TD="class: td1"][/TD]
[TD="class: td1"][/TD]
[/TR]
</tbody>[/TABLE]
I would now like to add a search box that will automatically filter the table to only include rows that contain this text , I would prefer it to dynamically filter so that as each letter is typed it filters more rows i.e filter as i type not wait until i hit a search button.
Any help would be greatly Appreciated,
Cheers,
Chris
[TABLE="class: t1"]
<tbody>[TR]
[TD="class: td1"][/TD]
[TD="class: td1"][/TD]
[TD="class: td1"][/TD]
[TD="class: td1"][/TD]
[TD="class: td1"][/TD]
[/TR]
</tbody>[/TABLE]