Hello,
First of all, I have a table that looks like this:
Head1 Head2 Head3 ...
1 1 2 ...
2 1 2 ...
1 1 1 ...
... ... ..... etc.
Since I am using this kind of table every single day, I thought that I could buy myself (and others) a little bit more time by having one vba button for each header that would sort the corresponding column by just one click.
To be more specific:
Click1 on the Head1 will sort the column and show only the entry "1"
click2 on the same button will show only values of "2"
Third click shall reset the column, bringing it to the initial state.
And for each column, I shall have one button. It's a large table and it a real pain to check only one value or another ...
Thank you so much for your trouble !
We are here to learn, to teach and to exchange ...
First of all, I have a table that looks like this:
Head1 Head2 Head3 ...
1 1 2 ...
2 1 2 ...
1 1 1 ...
... ... ..... etc.
Since I am using this kind of table every single day, I thought that I could buy myself (and others) a little bit more time by having one vba button for each header that would sort the corresponding column by just one click.
To be more specific:
Click1 on the Head1 will sort the column and show only the entry "1"
click2 on the same button will show only values of "2"
Third click shall reset the column, bringing it to the initial state.
And for each column, I shall have one button. It's a large table and it a real pain to check only one value or another ...
Thank you so much for your trouble !
We are here to learn, to teach and to exchange ...