realtime list sorting/data exraction

[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

 

[Bernd P]

Hello Richard,

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

Regards,
Bernd

 

[Richard Edwards]

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]

Hello Richard,

Can you give an input and output example?

Regards,
Bernd

 

[Richard Edwards]

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