Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Autofilter Autoupdate
I have a spreadsheet that needs to gather information from one worksheet
based on certain criteria and feeds it to another. I have tried setting it up so that if one row of data has an X in the end column then that row of information is copied over to the new worksheet. I run into empty blocks when I do this, however. I next tried to have all the information duplicated by cell reference over to the new sheet and apply a filter so that only the X rows shows. While this works, I want to be able to hide the column that's being filtered from the user. Also, as more rows are added to the source worksheet, they are not be automatically updated to the applied filter. If this is something Excel can do, what solution makes sense? Can I create perhaps a command button and entitle it "Update" for the users to press which will refilter for new results? -- Lori |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Frozen panes in Excel should stay put when using autofilter. | Excel Discussion (Misc queries) | |||
Copy/Paste in Autofilter | Excel Discussion (Misc queries) | |||
Autofilter not working correctly... | Excel Discussion (Misc queries) | |||
Using AutoFilter with worksheet protection in 2000 vs. 2003 | Excel Discussion (Misc queries) | |||
Strange Results with Autofilter | Excel Discussion (Misc queries) |