$$Excel-Macros$$ Can the filter criteria come from the value of a cell?

2011-01-10 Thread John A. Smith
Is there a way to change a filtered view by changing the value of a cell rather than clicking the drop-down arrow and scrolling to the data you want to filter it to? Or more specific, see attached for a formula to look up all instances of a specific variable. Thank you. John --

Re: $$Excel-Macros$$ Can the filter criteria come from the value of a cell?

2011-01-10 Thread ashish koul
check the attachement see if it helps On Tue, Jan 11, 2011 at 12:44 AM, John A. Smith johnasmit...@gmail.comwrote: Is there a way to change a filtered view by changing the value of a cell rather than clicking the drop-down arrow and scrolling to the data you want to filter it to? Or more