displaying filtered data on another sheet (Excel2000)

C

Chris Bruno

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
 
J

Jim Rech

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.
 
T

Tom Ogilvy

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
 
Top