Is it possible create a table like in the dample image: dynamic filtering datatable searching and "filtering" rows in which occur the text highlighted?
Thanks
Fransis
Senza titolo-2.jpg
Is it possible create a table like in the dample image: dynamic filtering datatable searching and "filtering" rows in which occur the text highlighted?
Thanks
Fransis
Senza titolo-2.jpg
Last edited by fransis1976; 03-13-2014 at 09:43 AM.
Perhaps this is what you are looking for:
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
Not really
i would like something that search (and dynamically filer) in a data table any rows that contains the "search string" in any cell.
Senza titolo-3.jpg
look at this better example
You are looking at having a VBA solution to this if it can be done. The picture indicates to me that the picture is of a worksheet with macros triggered by the buttons.
May be any simple solution will be welcome.
the picture is from
http://datatables.net/release-datata...bootstrap.html
not from excel
thanks
Hi, go to cell F4 and enter a couple letters (eg. "al", "ha".. etc.), then press Enter. The rows will be advance filtered for any name in Column A that contains the string you entered.
This is the code in Sheet1:
![]()
Please Login or Register to view this content.
Here it is...
Hope should be useful... tell me if someone enhance this sample in some way...
Elenco.xls
Used Excel 2007 a short VBA code and conditional formatting take a look
![]()
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks