Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Active / Dynamic Filtered List (changes w/ change in cell value)
I'd like to be able to have a filtered list change AUTOMATICALLY based
on a criteria value (entered in a cell outside the filtered data range). What is the simplest way to do this? Autofilter is close, but it will not update the results dynamically. |
#2
|
|||
|
|||
You can use programming to update the filter if a cell on the worksheet
is changed. There are examples he http://www.contextures.com/excelfiles.html Under Filters, look for 'Product List by Week Number' and 'Filter Rows for Text String' wrote: I'd like to be able to have a filtered list change AUTOMATICALLY based on a criteria value (entered in a cell outside the filtered data range). What is the simplest way to do this? Autofilter is close, but it will not update the results dynamically. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
#3
|
|||
|
|||
I have little experience with VB, so I'll state my problem (which is similar
to tripp's regarding the dynamic autofilter) to see if I can receive any specific suggestions. I have a 7-sheet workbook. the 'master' sheet contains data automatically imported from a CSV file (approx. 101 col by 800 rows). The remaining 6 sheets filter off of a single column in the master but use different filter conditions. The autofilter almost works, until the master sheet is updated upon opening the file. I have looked at both of the files Debra suggested, but I do not speak that language. If all else fails, is there a way to update the filter of each sheet using a macro? Thanks in advance for the help. "Debra Dalgleish" wrote: You can use programming to update the filter if a cell on the worksheet is changed. There are examples he http://www.contextures.com/excelfiles.html Under Filters, look for 'Product List by Week Number' and 'Filter Rows for Text String' wrote: I'd like to be able to have a filtered list change AUTOMATICALLY based on a criteria value (entered in a cell outside the filtered data range). What is the simplest way to do this? Autofilter is close, but it will not update the results dynamically. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
#4
|
|||
|
|||
well, sorry to answer my own question, but I recorded a macro to update the
each sheet's filter when I press a keyboard command (ctrl+shift+u). New question . . . is using the 'view code' for each sheet like running a macro continuously? To make the update dynamic, would it be as simple as copying the macro code for each sheet into its 'view code' area? Thanks. "flaterp" wrote: I have little experience with VB, so I'll state my problem (which is similar to tripp's regarding the dynamic autofilter) to see if I can receive any specific suggestions. I have a 7-sheet workbook. the 'master' sheet contains data automatically imported from a CSV file (approx. 101 col by 800 rows). The remaining 6 sheets filter off of a single column in the master but use different filter conditions. The autofilter almost works, until the master sheet is updated upon opening the file. I have looked at both of the files Debra suggested, but I do not speak that language. If all else fails, is there a way to update the filter of each sheet using a macro? Thanks in advance for the help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating a dynamic list | Excel Worksheet Functions | |||
How do I paste data into filtered list in Excel? | Excel Discussion (Misc queries) | |||
automatic color change in cells using a drop down list | Excel Worksheet Functions | |||
How to change fonts in drop down list | Excel Discussion (Misc queries) | |||
Creating a dynamic list | Excel Worksheet Functions |