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.

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.


---
Regards,
Norman


"Nikki" wrote in message
...
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.

Oh yeah. Didn't think of that.

Thanks.

"Norman Jones" wrote:

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.


---
Regards,
Norman


"Nikki" wrote in message
...
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.