Match cells from one tab to another tab and delete

shawn2209

New Member
Joined
Jul 15, 2017
Messages
18
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?
 

Excel Facts

Highlight Duplicates
Home, Conditional Formatting, Highlight Cells, Duplicate records, OK to add pink formatting to any duplicates in selected range.

Forum statistics

Threads
1,223,896
Messages
6,175,265
Members
452,627
Latest member
KitkatToby

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top