Forum Discussion
2 Sheets needing to compare and extract different data
I have 2 data sheets that have the data with one having more (Online Shop vs Physical Shop Stock)
- I want to write a formula that looks at both and using a unique cell value (stock code) that they both have then look to see if the other data matches exactly (Sales Price) if yes ignore, if no Copy the Row to a new worksheet. Also compare another Cell (Stock on hand) in both Sheets and make sure the Sheet (Physical Shop) is always greater by a minimum of 2, if not add to new worksheet as before.
The 'Physical Shop" has about 3000 rows but only 5 columns in each worksheet.
| Code | Description | Barcode | GSTPrice1 | OnHand |
| A1001 | 2 SLICE TOASTER BLACK WESTINGHOUSE | 9338620006562 | 89.95 | 0 |
| A1002 | 2 SLICE TOASTER RED CIRCULON TRADITIONAL | 51153566981 | 99.95 | 0 |
| A1003 | 2 SLICE TOASTER WHITE WESTINGHOUSE | 9338620006586 | 89.95 | 0 |
| A1004 | 4 SLICE TOASTER S/S WESTINGHOUSE | 9338620006616 | 99.95 | -1 |
End result should shown me where the errors are (Prices don't match) (Inventory to high online)
thanks
Kx
