I need a Macros to use 3 filters based on cell value and activated by buttons

[ferndiazabarca]

Please see the example in the excel file, it is very similar to what you see below

write below write below
Filter Category colum E a Reset filters
Filter Topic Colum G d and/or t
Filter Comment colum I e

column E column G column I
category Topic Comments

a d t e
a t e
a t e
a d t e
a d e
a d e
a d
a d
a d
a d
a d

I need a Macros to use 3 filters based on cell value and activated by buttons
I need 3 different filters that works independently and also in combination
one of the filters , the one that looks in colum H must be a conditional filter, so thesearch could be based on one or two parameters
the filters must be activated by buttons, so I can control the filters
based on the values that I have in cells C3, C4, E4 and C5 (red in the example)
some times I need to activate the 3 filters together and
some other times I only need 1 filter
and when I need only 1 filter, or two the other filters must be inactive
(this is only an example, the real columns can be located somewhere else, aswell as the starting row, also, the number of rows can be very long)
so If I can set the values for the columns and the rows in the macro , it will be genial
I am not sure, but maybe I will nedd a button to reset all the filters aswell
I know that it is possible to do the same process using the filter function in excel
but this sheet will be used for people not familiar with excel, so the buttons are intended to facilitate the use of the spreadsheet
I will appreciate any help
Thank you very much

Fernando

[sktneer]

Thread posted in Commercial Services.

[ferndiazabarca]

Sktneer please can you erase this post and don't know how
thnaks

[sktneer]

Only Administrator or Moderators can close a thread. Don't worry, I will PM one of them to close it.

[Fotis1991]

Thread closed per OP request as he posted in Commercial Services SUB FORUM