RoyalDoyle
New Member
- Joined
- Jun 28, 2013
- Messages
- 21
Hello MrExcel,
i am trying to get excel to print a selected cell after the "enter" event of another cell.
<colgroup><col><col><col><col></colgroup><tbody>
</tbody>The user will scan the SKU of a product(Column B). I then have an Index with an embedded match function retrieve the item# and bin location.
I would like to have a label automatically print out the item# and bin location after every scan. I would also like to NOT print a label
if the same label has already been printed(there will be more than 1 scan of the same item but i only need the label once).
Is this possible?
Thanks for your time.
i am trying to get excel to print a selected cell after the "enter" event of another cell.
Item Count | Scanned SKU's | Item # | Bin Location |
1 | 010838120078 | ALE12007 | b8-15-04-08 |
2 | 047497330005 | AML3300001 | g9-04-02-04 |
3 | 047497330012 | AML3300101 | h1-14-01-02 |
<colgroup><col><col><col><col></colgroup><tbody>
</tbody>
I would like to have a label automatically print out the item# and bin location after every scan. I would also like to NOT print a label
if the same label has already been printed(there will be more than 1 scan of the same item but i only need the label once).
Is this possible?
Thanks for your time.