Macro for Filtering

[Guest]

Hi,

Is there a code that can create a macro that does the following:

To update this sheet with any changes to prices or employees per team follow
the steps below:
Data > Filter > Advanced List
Action: Filter the list, in-place
List Range: $A$4:$D$36
Criteria Range: $F$1:$F$2

Basically the above is the instructions given but I want to be able to
create a button that does it for them.

 

[Norman Jones]

Hi Nikki,

Try turning on the macro recorder while you perform
the required steps manually.

The resultant code may be edited to render it of more
generic application. If you experience any problems with
such editing, post back with specific details.

 

[Guest]

Oh yeah. Didn't think of that.

Thanks.

Hi Nikki,

Try turning on the macro recorder while you perform
the required steps manually.

The resultant code may be edited to render it of more
generic application. If you experience any problems with
such editing, post back with specific details.