P
Pete Pete
Posted with an Unregistered Version of NewsHunter - The Newsgroup Utility for OS X.
Get your copy today at: http://www.parkersoftware.com/products/newshunter/
Situation:Sheet A has a simple database which gets updated frequently.In Sheet B, I just want to display the entire rows of the database which meet a certain criteria for 1 column.I tried setting up filters, which work fine, but when I change the database, I have to always update the filter to get the new updated result.This wouldn't be a big deal, except that I will eventually have not only Sheet B to update, but many more.I'd hate to have to go to each individual Sheet and update the filter every time the database changes.I suppose I could write a macro which updates all my filters, but what I'm trying to do seems much simpler than filtering and macro-ingdGET would be perfect, except that it only works with 1 record, not an entire row, or multiple rows.Help!- Pete
Get your copy today at: http://www.parkersoftware.com/products/newshunter/
Situation:Sheet A has a simple database which gets updated frequently.In Sheet B, I just want to display the entire rows of the database which meet a certain criteria for 1 column.I tried setting up filters, which work fine, but when I change the database, I have to always update the filter to get the new updated result.This wouldn't be a big deal, except that I will eventually have not only Sheet B to update, but many more.I'd hate to have to go to each individual Sheet and update the filter every time the database changes.I suppose I could write a macro which updates all my filters, but what I'm trying to do seems much simpler than filtering and macro-ingdGET would be perfect, except that it only works with 1 record, not an entire row, or multiple rows.Help!- Pete