How to delete discontinued items

**MercXoxo** · 09-14-2008, 07:54 PM

Hi everyone! This is my first post so please bear with me.
I'm a online business owner and am trying to figure out how to delete
whole CSV files which contain discontinued items.
I was told by yahoo store customer service to take my store inventory and uploaded it to excel (lets call that excel A). Now, I received a email containing a CSV file from my wholesaler with discontinued items which I saved to excel ( lets call that excel B). I would like to know if there is a way to take "excel B" and import it to "excel A" so that I can delete all 148 items at once.
I've been deleting them one by one and that takes way too long. Especially since I am constantly receiving emails of discontinued items, I just can't keep up.

Thanks to everyone for taking the time to read this.

**rylo** · 09-14-2008, 08:16 PM

Hi

A couple of ways I can think of.

1) Use the advanced filter. If you set up a criteria range that has all the item keys that you want to remove, then you could filter out the items you want to keep. Bit tricky to set up, but you could use this approach.

2) Use code to cycle through the delete items, and remove the lines from the original.

If either of these are acceptable, then advise your preference, and some structure details so we can assist you with a solution.

rylo

**MercXoxo** · 09-15-2008, 03:43 PM

Thank you for your quick reply. Unfortunately I am not experienced in Excel. Could you explain what you mean by "code".

**rylo** · 09-15-2008, 06:31 PM

Hi

By "code", I mean create a macro that will process the items.

rylo

How to delete discontinued items

LinkBack

Thread Tools

Rate This Thread

Display

How to delete discontinued items

Thread Information

Users Browsing this Thread

Similar Threads

How to delete rows in a protected worksheet

delete menu items

How to delete all items A:A from B:B

Delete Data with code

Auto delete row in this specific pattern

Bookmarks

Bookmarks

Posting Permissions