Hi,
Will try to do this request in bullet point:
- Workbook will be adding a sheet each day with similar data
- Need to match certain data from previous day to current day
- Data will be taken off and added day to day; therefore rows will not be same (VLOOKUP - couldn't work).
- Columns are not side by side - multiple columns in worksheet. (example shows side by side) - Result column is about 8 columns over from the columns I need to match.
Can't figure out how to add attachment - here are the two worksheets.
Sheet One
| Customer requisition | Sales order | Serial Number |
| 1024-123912 | S000001410 | F0000237993 |
| B32254 | S000000012 | F039248709834 |
| R000000493 | S000002507 | F0000237993 |
| R000000493 | S000002522 | F0000238801 |
| R000000498 | S000002525 | F0000457326 |
| R000000498 | S000002530 | F0000458802 |
Sheet Two
| Customer requisition | Sales order | Serial Number |
| B32254 | S000000012 | |
| 1024-123912 | S000001410 | |
| R000000493 | S000002507 | |
| R000000498 | S000002525 | |
Hope this helps. Thank you.
