Hi all.
I have an Excel worksheet which will have several columns with drop-down feature lists. My question is this; is it possible having selected a drop down filter, to freeze those results, select another filter and have the results of applying the second filter appended to the first set? I've tried messing about with VBA but had no joy - wondering if it would be possible to make a function, or if there is actually a way of coding it in VBA.
Any help appreciated please!
I have an Excel worksheet which will have several columns with drop-down feature lists. My question is this; is it possible having selected a drop down filter, to freeze those results, select another filter and have the results of applying the second filter appended to the first set? I've tried messing about with VBA but had no joy - wondering if it would be possible to make a function, or if there is actually a way of coding it in VBA.
Any help appreciated please!
