Okay,


I want to be able to create a list based on an IF statement.
For example, i want to have a list validation for all clients, but if a cell is equal to a client code, then reduce the list to only that client...

does this make sense?

If so ... how (if possible avoiding vb).

Ta Kaite