displaying filtered data on another sheet (Excel2000)
 

Is there a way, besides macros, to get data from a sheet
[Master] and display it in a separate sheet? For
instance, I want to automatically display all records
(rows) that have the value "Central" in the [region]
column of 'Master' in a separate sheet. Same
for "Western", etc. while only having to
update 'Master'. They are in the same workbook.

Thanks,
Chris

displaying filtered data on another sheet (Excel2000)
 

If you do not want a macro then "automatic" is out unless Excel has a
built-in feature to filter rows with "Central" in a field named "[region]".
Sadly the designers overlooked this feature<g.

So manually (but still better than copy/pasting each record), select a cell
in your table and do a Data, Filter, AutoFilter. Click the dropdown for the
[region] column and select Central. Then only rows with that item will be
visible. You can then copy them to the other sheet.

--
Jim Rech
Excel MVP

displaying filtered data on another sheet (Excel2000)
 

Or you can copy them to another sheet directly using
Data=Filter=Autofilter, but you need a criteria range and a destination
(copy the column headings to the destination. )

To start the process, start in the destination cells (select the copied
column headings).

Ignore warning about not being able to find you data

--
Regards,
Tom Ogilvy

"Jim Rech" wrote in message
...
If you do not want a macro then "automatic" is out unless Excel has a
built-in feature to filter rows with "Central" in a field named
"[region]".
Sadly the designers overlooked this feature<g.

So manually (but still better than copy/pasting each record), select a
cell
in your table and do a Data, Filter, AutoFilter. Click the dropdown for
the
[region] column and select Central. Then only rows with that item will be
visible. You can then copy them to the other sheet.

--
Jim Rech
Excel MVP