realtime list sorting/data exraction

  • Thread starter Thread starter Richard Edwards
  • Start date Start date
R

Richard Edwards

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
 
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
 
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
 
Back
Top