Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Active Cell to be used as filter...
Hi guys, think its a tough one...
I need to run a macro that filters data based on the contents of the active cell. Eg within my "info" sheet, I have: a1 = cat b1 = dog c1 = Mouse In another sheet (master) there are columns, one of which is "type of animal" If user is on cell a1 in the "info" sheet and activates the macro, I need the Macro to filter the column "type of animal" in the "master" sheet. (I also need to apply a second filter to another column in the master sheet, but that is not dependent on the users choice so I have been able to do using .AutoFilter Field:=13, Criteria1:="Y") Appreciate any thoughts,suggestions and solutions for this novice VBA user!!! :) Thanks Regards D *** Sent via Developersdex http://www.developersdex.com *** |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Row select mode to highlight active row of active cell | Excel Discussion (Misc queries) | |||
Hide Raws even the Auto Filter is active | Excel Worksheet Functions | |||
Open excel with a filter active an a certain value | Excel Discussion (Misc queries) | |||
Active Cell in Auto Filter | Excel Discussion (Misc queries) | |||
Filter range of only active cells??? | Excel Worksheet Functions |