Hi,

I am trying to set up a validation sourced to another worksheet.

Also, how do I set up a filter to sort only on select options?

Thanks,

Julie Harvell

Q1: On the sheet with the valid values: select the range of values and in
the Name box enter a name such as MYVALUES and now press enter. Double check
that this worked (Insert Names Define --- do you see the name and range you
selected?)
Go to sheet where validation is needed; select range; use Data | Validation;
specify LIST and in the box for the list range type =MYVALUES (or whatever
name you chose) ---- do remember the = sign !!!
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"Julie Harvell" <Julie wrote in message
...
Hi,

I am trying to set up a validation sourced to another worksheet.

Also, how do I set up a filter to sort only on select options?

Thanks,

Julie Harvell