Bulk deleting lines/rows of data.

Hi,

I have spreadsheet A which has a list of current product lines.

I have spreadsheet B which has a list of current product lines as above but also has items which have been discontinued/deleted and need to be removed from spreadsheet B as they do not appear in spreadsheet A.

I have identified the products which should not be in spreadsheet B see attached spreadsheet titled "Items to delete"

Is there a way I can bulk delete these identified product rows from spreadsheet B. (sample of spreadsheet B attached)

Thanks

Rich

Another option

Please Login or Register  to view this content.

Thank you very much for your help, it works a treat

Not sure which of us your talking to, but glad we could help & thanks for the feedback

Both of you for replying. I have used Alan's suggestion.