Hopefully this makes sense...
The first sheet we will call "Pick" and is formatted like this:
<tbody>
</tbody>
There is an empty row under every entry. The headers above are for display and the sake of clarity, the actual Pick sheet is a daily data dump with 9 extra rows before the first entry.
The second sheet is "Route" which will also change daily, formatted as:
<tbody>
</tbody>
What I'm trying to figure out is how to take each combo of Truck/Stop from the Route worksheet, find all instances of it in the Pick worksheet, and replace it with the corresponding Door/LS combo. The Pick example above would then become:
<tbody>
</tbody>
I don't know what the logic would be to accomplish this so unfortunately I don't have relevant sample code yet.
The first sheet we will call "Pick" and is formatted like this:
SKU | Description | Call Name | BC | QTY | B/O | Aisle | Row | Tier | Truck | Stop |
1234567 | Blah Blah | Blah | _____ | 1 | 301 | A | 1 | 1 | 1 | |
<tbody>
</tbody>
There is an empty row under every entry. The headers above are for display and the sake of clarity, the actual Pick sheet is a daily data dump with 9 extra rows before the first entry.
The second sheet is "Route" which will also change daily, formatted as:
Area | Truck | Stop | Door | LS |
Blah | 1 | 1 | 702 | 1 |
<tbody>
</tbody>
What I'm trying to figure out is how to take each combo of Truck/Stop from the Route worksheet, find all instances of it in the Pick worksheet, and replace it with the corresponding Door/LS combo. The Pick example above would then become:
SKU | Description | Call Name | BC | QTY | B/O | Aisle | Row | Tier | Truck | Stop |
1234567 | Blah Blah | Blah | _____ | 1 | 301 | A | 1 | 702 | 1 | |
<tbody>
</tbody>
I don't know what the logic would be to accomplish this so unfortunately I don't have relevant sample code yet.