Deleting a row when a value match is found in another worksheet

[MattEvansC3]

Hi,

I'm blanking on this and it feels so simple I should know. I'm working on a reporting tool for an asset log that creates upload files, one for deploying assets and one for returning assets. This part of the tool tells us if the person we are deploying an asset to also has additional assets to them. In my macro I've used the following code to populate tab "Multiple Devices" with records from another workbook which works fine.

Please Login or Register  to view this content.

Now the next step is to check the results in the Multiple Devices worksheet against the assets in the return list (same workbook, worksheet is called In Inventory) and if a match is found delete the entire row in the Multiple Devices worksheet. I know I can use a reverse loop with a boolean condition for deleting the entire row but I cannot remember how to generate that boolean answer;

Please Login or Register  to view this content.

For purposes of this code I am using a unique asset tag to match the records. On the Multiple Devices worksheet that's in column B, in the In Inventory worksheet that's column E


Sorry I can't post an example of the spreadsheets as they contain sensitive information. The full code for thsi workbook is;

Please Login or Register  to view this content.

[MattEvansC3]

I figured it out

Please Login or Register  to view this content.