View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Chris Bruno[_3_] Chris Bruno[_3_] is offline
external usenet poster
 
Posts: 1
Default 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