View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Nikki Nikki is offline
external usenet poster
 
Posts: 184
Default Macro for Filtering

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.