Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro for Filtering
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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro for Filtering
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro, Scenario, Filtering - What should I do? | Excel Worksheet Functions | |||
Filtering with a macro | New Users to Excel | |||
Filtering in a macro | Excel Programming | |||
Combo Box Filtering Macro | Excel Discussion (Misc queries) | |||
filtering data with a macro | Excel Programming |