Hi

Use ODBC queries to get filtered data into partial sheets. You can set
queries to be refreshed on open and/or after some time interval, or you can
refresh them manually.

Another option is to create (some) report sheet(s). You determine there
filter conditions, and according data are read from master sheet using
formulas or ODBC query(es). The exact solution depends heavily on your data,
and what you want to get.


Arvi Laanemets


"Nlevans" wrote in message
...
Hello,

I have been using a master worksheet which stores all my data and been
using
a filter to show certain types of data and copy and paste into a new
worksheet. Is there a way to update the data in the master worksheet and
have that information trickle down into the other worksheets without
applying
the filters and copy/paste?
--
TS