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

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

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