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