realtime list sorting/data exraction
 

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

realtime list sorting/data exraction
 

Hello Richard,

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

Regards,
Bernd

realtime list sorting/data exraction
 

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

realtime list sorting/data exraction
 

Hello Richard,

Can you give an input and output example?

Regards,
Bernd

realtime list sorting/data exraction
 

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