This question could be solved using acess, unfortunetly I need to use excel. And hope someone can help.
I have a spread sheet that has 5 columns and some 700 lines. Like the one bellow.
Dealer Type Country Trade L/S
C FX N. Zeland USD/RUB L
D FX S. Africa USD/ZAR L
A FX Sweden USD/SWK S
B Rate Korea K. swap S
A Rate Euro Pol swap L
What I want to do is create a sheet where I can select (or not) the criteria which I would like to filter (dealer, type, country), and then run a code which would return a report only with the lines that attend the chosen criteria.
Suppose, one time I only want to filter rates. The next only Euro FX... and so on. And that criteria would be established on predetermined fields.
Can someone help? Or at least suggest some other thread with this subject?
Thanks.
JOOM
I have a spread sheet that has 5 columns and some 700 lines. Like the one bellow.
Dealer Type Country Trade L/S
C FX N. Zeland USD/RUB L
D FX S. Africa USD/ZAR L
A FX Sweden USD/SWK S
B Rate Korea K. swap S
A Rate Euro Pol swap L
What I want to do is create a sheet where I can select (or not) the criteria which I would like to filter (dealer, type, country), and then run a code which would return a report only with the lines that attend the chosen criteria.
Suppose, one time I only want to filter rates. The next only Euro FX... and so on. And that criteria would be established on predetermined fields.
Can someone help? Or at least suggest some other thread with this subject?
Thanks.
JOOM