Filter Question?

H

hce

Dear All

Is it possible to "fix" a criteria to a filter? For eg, I have a colum
which contains different countries... I want to filter the data b
this column... I only want "Australia" data to appear hence filterin
out the rest... However, this file would be given to other users whic
would tamper with the filter to get the data they want... but I don'
want the "Australia" filter to be resetted by them... so is ther
anything i can do to fix the filter n yet at the same time allow th
users to change the other filter settings?

cheer
 
D

Debra Dalgleish

Create a new workbook, and include only the data for Australia.

I don't know of any way to allow users to filter a list, but not view
data for all the countries.
 
Top