LinkBack URL
About LinkBacks
I have auto filtered Column S. Cell S1 has the drop down list showing my criteria. I need to control S1 selection from A1 on the same sheet. How do I make this work?
I have auto filtered Column S. Cell S1 has the drop down list showing my criteria. I need to control S1 selection from A1 on the same sheet. How do I make this work?
Is A1 an entry or a formula?
Gary's Student
its an entry.
I have attached a sample based upon a macro solution. Load the file, enable macros, and then make an entry in cell A1. We can adapt this to your actual needs.
Perfect. I can place a list in A1 and it will control my filter. What are the steps to get this macro into my file. Copy Paste?
First here is the macro:
Please Login or Register to view this content.
Because it is worksheet code, it is very easy to install and automatic to use:
1. right-click the tab name near the bottom of the Excel window
2. select View Code - this brings up a VBE window
3. paste the stuff in and close the VBE window
If you have any concerns, first try it on a trial worksheet.
If you save the workbook, the macro will be saved with it.
To remove the macro:
1. bring up the VBE windows as above
2. clear the code out
3. close the VBE window
To learn more about macros in general, see:
http://www.mvps.org/dmcritchie/excel/getstarted.htm
To learn more about Event Macros (worksheet code), see:
http://www.mvps.org/dmcritchie/excel/event.htm
Macros must be enabled for this to work!
https://docs.google.com/open?id=0B8f...G9RdVlMOG5XQk0
Please see attached error. Thanks
Here is the missing macro:
This macro goes in a standard module:Please Login or Register to view this content.
Macros are very easy to install and use:
1. ALT-F11 brings up the VBE window
2. ALT-I
ALT-M opens a fresh module
3. paste the stuff in and close the VBE window
If you save the workbook, the macro will be saved with it.
To remove the macro:
1. bring up the VBE window as above
2. clear the code out
3. close the VBE window
This macro will be called from the first one that you have already installed.
To learn more about macros in general, see:
http://www.mvps.org/dmcritchie/excel/getstarted.htm
Macros must be enabled for this to work!
** FINALLY!, I figured it out, thanks for your help. Do you know of a code for a reset feature, that would clear all filters?
Last edited by SZBELL; 10-15-2012 at 11:21 PM.
tomorrow...................
If you empty A1, the filter will be "cleared" (that is all rows will be displayed)
How do I add additional cells like a1? Do i have to create another Macro?
Let me ask this a different way. I would like to add the same filtering ability but with a different column in a different cell. What do I have to add to do this, with out losing what we already have.
It would involve a modification to the existing macro. Of course, we need the details - which trigger cells and what filter functions.
filtering cell would be d3, with Y:9 - Y201 data.
I cant seem to filter both cells..
Please Login or Register to view this content.
Please Login or Register to view this content.
is this possible?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks