Here are 2 ways to do this:
Easiest:
1)Sort the list. (all the "Item #:" will goup together)
2)Select the "Item #:" rows and delete them
Done (but you lose the original order)
OR
DataFilterAutoFilter
Product ID dropdown, select "Item #:"
Then
select the displayed "Item #:" rows (all at once)
EditGoTo[Special...] Visible Cells Only
EditDeleteEntire Row
DataFilterShow All
Done
Does that help?
Ron
--
Ron Coderre
------------------------------------------------------------------------
Ron Coderre's Profile:
http://www.excelforum.com/member.php...o&userid=21419
View this thread:
http://www.excelforum.com/showthread...hreadid=385676