|
If ? maybe.....
I have a hard one for you.
if Sheet1 A1 is = Sheet2 A1 and if Sheet1 OFFSET from S1 down 2 left 1 is equal to Sheet2 OFFSET from A1 down 2 left 1 return nothing otherwise IF different return what is now in that cell of Sheet2. Then continue down until the customers orders are all compared. 300+ Multiple customer with multiple order. Clear as mud, right Sheet 1 Sheet 2 A B A B 1 ABC Comp ABC Comp 2 3 Pickels 49 Pickels 9 4 Peaches 10 Peaches 15 TIA -- Pete |
If ? maybe.....
Hi!
IF different return what is now in that cell of Sheet2. If which is different? Sheet1A1 and Sheet2A1 or the offsets? What if all 4 are different? Biff "Pete" wrote in message ... I have a hard one for you. if Sheet1 A1 is = Sheet2 A1 and if Sheet1 OFFSET from S1 down 2 left 1 is equal to Sheet2 OFFSET from A1 down 2 left 1 return nothing otherwise IF different return what is now in that cell of Sheet2. Then continue down until the customers orders are all compared. 300+ Multiple customer with multiple order. Clear as mud, right Sheet 1 Sheet 2 A B A B 1 ABC Comp ABC Comp 2 3 Pickels 49 Pickels 9 4 Peaches 10 Peaches 15 TIA -- Pete |
If ? maybe.....
Sheet 1 is the active oders and Sheet 2 is the shipped order.
If the customer match and the orders match then do nothing. If the customers in Sheet 2 do not match the customers in Sheet 1 then we need to return customer name in sheet 1 and the offset cells within that range. If the customers match from Sheet to Sheet, but the order qtys do not then return what is different from Sheet 2 from Sheet 1. Still clear as Mud? -- Pete "Biff" wrote: Hi! IF different return what is now in that cell of Sheet2. If which is different? Sheet1A1 and Sheet2A1 or the offsets? What if all 4 are different? Biff "Pete" wrote in message ... I have a hard one for you. if Sheet1 A1 is = Sheet2 A1 and if Sheet1 OFFSET from S1 down 2 left 1 is equal to Sheet2 OFFSET from A1 down 2 left 1 return nothing otherwise IF different return what is now in that cell of Sheet2. Then continue down until the customers orders are all compared. 300+ Multiple customer with multiple order. Clear as mud, right Sheet 1 Sheet 2 A B A B 1 ABC Comp ABC Comp 2 3 Pickels 49 Pickels 9 4 Peaches 10 Peaches 15 TIA -- Pete |
If ? maybe.....
Hi!
Still clear as Mud? Well, there are some things that just can't be visualized no matter how good the explanation. I think this is one of those things. This is something I would need to see to figure out. Biff "Pete" wrote in message ... Sheet 1 is the active oders and Sheet 2 is the shipped order. If the customer match and the orders match then do nothing. If the customers in Sheet 2 do not match the customers in Sheet 1 then we need to return customer name in sheet 1 and the offset cells within that range. If the customers match from Sheet to Sheet, but the order qtys do not then return what is different from Sheet 2 from Sheet 1. Still clear as Mud? -- Pete "Biff" wrote: Hi! IF different return what is now in that cell of Sheet2. If which is different? Sheet1A1 and Sheet2A1 or the offsets? What if all 4 are different? Biff "Pete" wrote in message ... I have a hard one for you. if Sheet1 A1 is = Sheet2 A1 and if Sheet1 OFFSET from S1 down 2 left 1 is equal to Sheet2 OFFSET from A1 down 2 left 1 return nothing otherwise IF different return what is now in that cell of Sheet2. Then continue down until the customers orders are all compared. 300+ Multiple customer with multiple order. Clear as mud, right Sheet 1 Sheet 2 A B A B 1 ABC Comp ABC Comp 2 3 Pickels 49 Pickels 9 4 Peaches 10 Peaches 15 TIA -- Pete |
If ? maybe.....
|
If ? maybe.....
|
| All times are GMT +1. The time now is 06:58 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com