Delete row if item is not equal to sku

[djfscouse]

Hi,

I have a list of Items equal to a sku id shown below:

Item = Sku
RPC0094 = 17343D
RPC0097 = 17263D
RPC0068 = 17232B

For my project VBA is required so I have been trying to remove the rows where the Item is not equal to sku in the list above.

In the attached excel file I have displayed what is needed in the AfterVBA sheet.

Any help is appreciated.

Thanks,

David

[JEC.]

How about

Please Login or Register  to view this content.

[djfscouse]

Thanks JEC, it works good my list may have over 100 items so I will try create new lines.

[JEC.]

In that case, it is better to have a list of items and their Sku stored in a tab.
Refer to that list in VBA instead of hard coding them all.

[djfscouse]

Thanks JEC for your help and advice, unfortunately it must be hard coded as the VBA will be applied to an excel document that has been exported from a database.

Again I appreciate your help,

David

[JEC.]

Here an example. There should be a way to refer to a list. Maybe from a different workbook.

Please Login or Register  to view this content.

[djfscouse]

Your code gave me an idea and the below works perfect, thanks JEC for all your help.

Please Login or Register  to view this content.

[JEC.]

You're welcome!