Afternoon all,

I have a list of order id's in column A (that are updated in realtime) and a
list of their instructions (if any) in column B.

One user deals with orders without instructions and one only deals with
orders with instructions.

i have tried using the auto-filter function and pivotable to only show the
right orders for each person but they do not update in realtime and i don't
want the user to have to press a button or run a macro in the background to
monitor for changes.

i suppose what i am after is to be able to name column A and B as a
"database" and then be able to run a " select * from A where B <'"blank' "
(or something similar!)

thanks in advance.

richard

Hello Richard,

Sorting with WS functions only is possible:
http://www.sulprobil.com/html/sorting.html

Regards,
Bernd

thanks vm but it doesn't allow me to extract just what a particular user
needs.

i should have explained a little further that whilst the order is not
important the ability to JUST be able to show EITHER orders with
instructions OR orders without instructions is the priority.

thanks

richard

"Bernd P" wrote in message
...
Hello Richard,

Sorting with WS functions only is possible:
http://www.sulprobil.com/html/sorting.html

Regards,
Bernd

Hello Richard,

Can you give an input and output example?

Regards,
Bernd

i have the solution now...

i ended up amending the api that pulls in the data rather than solving it
within excel.

thanks for your help

richard

"Bernd P" wrote in message
...
Hello Richard,

Can you give an input and output example?

Regards,
Bernd