Hello,
I am in need of help of making an accurate inventory sheet. So far I am needing a way to delete rows from one tab of the work sheet when it matches another tab. I have a running list of inventory that is assigned to tote, for example:
[TABLE="width: 444"]
<tbody>[TR]
[TD]7/26/17
[/TD]
[TD]UPC
[/TD]
[TD][/TD]
[TD]Tote
[/TD]
[TD]Tote Location
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]67876234123
[/TD]
[TD][/TD]
[TD]T987234
[/TD]
[TD]VAS
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]876123874619
[/TD]
[TD][/TD]
[TD]T987234
[/TD]
[TD]VAS
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]98798723412
[/TD]
[TD][/TD]
[TD]T987234
[/TD]
[TD]VAS
[/TD]
[/TR]
</tbody>[/TABLE]
On the other tab I have a VLOOKUP to find the information of that item. I have it to where I can scan the UPC and it tells me what tote and the location of that tote. The issue I have is once I find that UPC in that tote, I want to be able to delete that information of that UPC, Tote, and Tote location of that ROW. Here is an example of my VLOOKUP layout.
UPC Tote Tote Location Found Item?
67876234123 T982734 VAS
On the Found Item? Column, I have a check box and I wanted to assign the macro of the match and delete to it when someone checks the box. But in other words, if I were to go to this tote in VAS and find UPC 67876234123, I would then take it out to fulfill an order. So that being said, I want that information to delete because that UPC would not be located to that tote anymore. Can someone help me with this?
I am in need of help of making an accurate inventory sheet. So far I am needing a way to delete rows from one tab of the work sheet when it matches another tab. I have a running list of inventory that is assigned to tote, for example:
[TABLE="width: 444"]
<tbody>[TR]
[TD]7/26/17
[/TD]
[TD]UPC
[/TD]
[TD][/TD]
[TD]Tote
[/TD]
[TD]Tote Location
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]67876234123
[/TD]
[TD][/TD]
[TD]T987234
[/TD]
[TD]VAS
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]876123874619
[/TD]
[TD][/TD]
[TD]T987234
[/TD]
[TD]VAS
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]98798723412
[/TD]
[TD][/TD]
[TD]T987234
[/TD]
[TD]VAS
[/TD]
[/TR]
</tbody>[/TABLE]
On the other tab I have a VLOOKUP to find the information of that item. I have it to where I can scan the UPC and it tells me what tote and the location of that tote. The issue I have is once I find that UPC in that tote, I want to be able to delete that information of that UPC, Tote, and Tote location of that ROW. Here is an example of my VLOOKUP layout.
UPC Tote Tote Location Found Item?
67876234123 T982734 VAS
On the Found Item? Column, I have a check box and I wanted to assign the macro of the match and delete to it when someone checks the box. But in other words, if I were to go to this tote in VAS and find UPC 67876234123, I would then take it out to fulfill an order. So that being said, I want that information to delete because that UPC would not be located to that tote anymore. Can someone help me with this?