Filter by Selection

[Yamezz]

Can anyone point me in the right direction to write a macro that filters my table by the values currently selected?

Currently, to filter my data I have to click the filter arrow on ColumnA, un-select the "select all" box, then scroll through the list to select the value I want to use in the filter. I then move on to do the same for ColumnB, ColumnC and ColumnD. Doing this all day gets tedious, so I want to be able to just use the mouse to highlight a selection in a single row and use the selection as the inputs for the filter.

i.e. highlight W,X,Y,Z in a single row, press a macro button and the VBA code filters my data for W in ColumnA, X in ColumnB, Y in ColumnC and Z in ColumnD.

Thanks.

 

[Yamezz]

This macro has been such a time saver every working day. So much so, I'd like a similar one, but writing the code myself has got me beat. I'd like to be able to use the selection in Sheet1 to filter the data in Sheet2. The selection in Sheet1 will always be columns D, E, F and G in a single row. The columns I need to filter in Sheet2 are I, J, K and L, with the headings in row 2 (subtotal formulas are in row 1). Any ideas?

 

[Yamezz]

Bump...

It would be much appreciated if anyone could point me in the right direction here. Thanks.