Hello,

I'm working on creating inventory lists exported from Quickbooks. I want to delete all the items I previously counted from the new list each time I need a new list to count from.

Right now I have a new full list exported to Excel, and a column with previously counted items. I would like to find a way to look up each item in the counted list, find it in the new list (next to it in the same worksheet), and delete the four cells in the row where the item is found.

Let me know if this makes sense and if you have any ideas.

Thanks,

Ken