Dear Smaritans,
I am trying to create a spreadsheet for a picking operation. It has three tabs (sheets). The first one got the Picking request (provided), the 2nd got the inventory (provided), the third one is the picking sheet which is to be created as per the other two sheets.
Sheet 1 (Picking request)
<tbody>
</tbody>
Sheet 2 (Inventory)
<tbody>
</tbody>
Sheet 3
Picking sheet
<tbody>
</tbody>
As you would see I want to create a picking sheet which choose to pick from the first location and if still there is some more quantity is required, then it should chose the 2nd location and 3rd if more qty is required.
Thanks.
Aarav
I am trying to create a spreadsheet for a picking operation. It has three tabs (sheets). The first one got the Picking request (provided), the 2nd got the inventory (provided), the third one is the picking sheet which is to be created as per the other two sheets.
Sheet 1 (Picking request)
part no. | required qty |
Part A | 10 |
Part B | 12 |
Part C | 30 |
<tbody>
</tbody>
Sheet 2 (Inventory)
part no. | location | available qty |
Part A | mezz A | 2 |
Part A | Mezz B | 5 |
Part A | Mezz C | 7 |
Part B | Mezz B | 9 |
Part B | Mezz C | 15 |
Part A | Mezz D | 5 |
Part B | Mezz E | 5 |
Part B | Mezz F | 6 |
Part C | Mezz C | 50 |
Part C | Mezz D | 12 |
Part C | Mezz E | 10 |
Part D | Mezz A | 5 |
<tbody>
</tbody>
Sheet 3
Picking sheet
Part No. | Location | qTY |
Part A | Mezz A | 2 |
Part A | Mezz B | 5 |
Part A | Mezz C | 1 |
Part B | Mezz B | 9 |
Part B | Mezz C | 3 |
Part C | Mezz C | 30 |
<tbody>
</tbody>
As you would see I want to create a picking sheet which choose to pick from the first location and if still there is some more quantity is required, then it should chose the 2nd location and 3rd if more qty is required.
Thanks.
Aarav