hello,
I have table, and on one column I have names.
I would like to create macro, that will autofilter the rows by each possible value in a loop.
For example, if the names are John, Ruth and Hana, the macro will filter once all John rows, then all Ruth's and finally all Hana's (in the loop I'm printing each time the visible rows).
My problem is that the list of name is changing every day, and I don't know how many name will be each time. also the number of rows in the table - is unknown.
I would also like to store each time in the loop the currant filtered value, in order to use this value in formula.
Is it possible to do that?
Help will be most appreciated,
Best Regards,
Yael
I have table, and on one column I have names.
I would like to create macro, that will autofilter the rows by each possible value in a loop.
For example, if the names are John, Ruth and Hana, the macro will filter once all John rows, then all Ruth's and finally all Hana's (in the loop I'm printing each time the visible rows).
My problem is that the list of name is changing every day, and I don't know how many name will be each time. also the number of rows in the table - is unknown.
I would also like to store each time in the loop the currant filtered value, in order to use this value in formula.
Is it possible to do that?
Help will be most appreciated,
Best Regards,
Yael