displaying filtered data on another sheet (Excel2000)

  • Thread starter Thread starter Chris Bruno
  • Start date Start date
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
 
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.
 
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
 
Back
Top