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.
[TABLE="width: 397"]
<colgroup><col><col><col><col></colgroup><tbody>[TR]
[TD]Item Count[/TD]
[TD]Scanned SKU's[/TD]
[TD]Item #[/TD]
[TD]Bin Location[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]010838120078[/TD]
[TD]ALE12007[/TD]
[TD]b8-15-04-08[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]047497330005[/TD]
[TD]AML3300001[/TD]
[TD]g9-04-02-04[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]047497330012[/TD]
[TD]AML3300101[/TD]
[TD]h1-14-01-02[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
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.
[TABLE="width: 397"]
<colgroup><col><col><col><col></colgroup><tbody>[TR]
[TD]Item Count[/TD]
[TD]Scanned SKU's[/TD]
[TD]Item #[/TD]
[TD]Bin Location[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]010838120078[/TD]
[TD]ALE12007[/TD]
[TD]b8-15-04-08[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]047497330005[/TD]
[TD]AML3300001[/TD]
[TD]g9-04-02-04[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]047497330012[/TD]
[TD]AML3300101[/TD]
[TD]h1-14-01-02[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
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.