RE: Autofilter Issue can't use macros

[xcentrik]

RE: Autofilter Issue can't use macros

Due to the company disabling macros and not everyone in the company clued on to how to set a trusted location I need to autofilter based on a cell reference in a worksheet of the same book.

i.e. when someone selects Dave, Michael, Sam etc from the dropdown list in Sheet1 I need the autofilter to just show Dave, Michael or Sam in column A in Sheet2.

I have searched the net and all appear to be vba code...please someone help

Many Thanks!!

 

[Jon von der Heyden]

Re: Autofilter Issue can't use macros

Yes that will involve VBA I'm afraid.