Compare data on two spreadsheets.
 

I am attempting to create a spreadsheet that can be used to show if an order
is complete. Some orders contain only one line and a simple IF statement
tells me wheter or not a each line is complete, =IF(QTY ORDERED=QTY
WRAPPED,"READY","NOT READY") but I am stumped in trying to compare multiple
lines on one order.

For example:

Order 123456 Line 1 QTY ORDERED 5 QTY WRAPPED 5 STATUS READY
Order 123456 Line 2 QTY ORDERED 4 QTY WRAPPED 3 STATUS NOT READY
Order 654321 Line 1 QTY ORDERED 2 QTY WRAPPED 2 STATUS READY
Order 654321 Line 2 QTY ORDERED 6 QTY WRAPPED 6 STATUS READY

In the above example, I would like to return the information in Order 654321
to another spreadsheet indicating that all lines on the the order are
complete and can be shipped.

Hopefully this makes sense and someone can help me out.

Thanks,

DC James

You've got a response to try out in your later re-post in
..worksheet.functions
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"dcjames" wrote in message
...
I am attempting to create a spreadsheet that can be used to show if an
order
is complete. Some orders contain only one line and a simple IF statement
tells me wheter or not a each line is complete, =IF(QTY ORDERED=QTY
WRAPPED,"READY","NOT READY") but I am stumped in trying to compare
multiple
lines on one order.

For example:

Order 123456 Line 1 QTY ORDERED 5 QTY WRAPPED 5 STATUS READY
Order 123456 Line 2 QTY ORDERED 4 QTY WRAPPED 3 STATUS NOT READY
Order 654321 Line 1 QTY ORDERED 2 QTY WRAPPED 2 STATUS READY
Order 654321 Line 2 QTY ORDERED 6 QTY WRAPPED 6 STATUS READY

In the above example, I would like to return the information in Order
654321
to another spreadsheet indicating that all lines on the the order are
complete and can be shipped.

Hopefully this makes sense and someone can help me out.

Thanks,

DC James

Thanks Max.

I really appreciate the assistance. Your solution seems to be working well.

Thanks again,

dcjames

"Max" wrote:

You've got a response to try out in your later re-post in
..worksheet.functions
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"dcjames" wrote in message
...
I am attempting to create a spreadsheet that can be used to show if an
order
is complete. Some orders contain only one line and a simple IF statement
tells me wheter or not a each line is complete, =IF(QTY ORDERED=QTY
WRAPPED,"READY","NOT READY") but I am stumped in trying to compare
multiple
lines on one order.

For example:

Order 123456 Line 1 QTY ORDERED 5 QTY WRAPPED 5 STATUS READY
Order 123456 Line 2 QTY ORDERED 4 QTY WRAPPED 3 STATUS NOT READY
Order 654321 Line 1 QTY ORDERED 2 QTY WRAPPED 2 STATUS READY
Order 654321 Line 2 QTY ORDERED 6 QTY WRAPPED 6 STATUS READY

In the above example, I would like to return the information in Order
654321
to another spreadsheet indicating that all lines on the the order are
complete and can be shipped.

Hopefully this makes sense and someone can help me out.

Thanks,

DC James

Great to hear that !
Thanks for the feedback ..
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"dcjames" wrote in message
...
Thanks Max.

I really appreciate the assistance. Your solution seems to be working
well.

Thanks again,

dcjames