Posts by André Machado • 63 points
4 posts
-
1
votes1
answer377
viewsA: Filter dynamic table (Power Pivot) by Listbox
I resolved it this way: A formula named to find the last completed row of a column.. and then ... create a dynamic named range with the previously made "last" formula...as shown below. I use a…
-
1
votes1
answer377
viewsQ: Filter dynamic table (Power Pivot) by Listbox
This code: /a/309087/116347 Make the selection in Listabox ... and Filter activated by a button.. as described in the link... But if the Dynamic Table is created by Power Pivot .. This code does not…
-
2
votes1
answer1378
viewsQ: Filter dynamic table by Listbox
Private Sub Preencher().. From this publication here Filter dynamic table by word in a cell ... It is very efficient in searching column A .... I would like to take the values that are in Listbox…
-
2
votes1
answer4929
viewsQ: Filter dynamic table by word in a cell
This other one just below the same post of the link above .. has difference in running ? ... https://stackoverflow.com/a/43139189/9948374 There is a way to speed up the execution of some of these…