search column "A" for every occurrence of the current part number cont.

Ok, I guess I need more help than I thought.

This is what I have molded the previous code (http://www.excelforum.com/showthread.php?t=622975) into:

Please Login or Register  to view this content.

Basically, I have changed it so that I can choose what columns I want to
compare to, grab data from, and where to dump the data. The reason I
need to tell it where to get the info, is because the sheets that I deal
with are not all the same. The example provided is a "Very Clean"
version of what I have to deal with.

What I would really like this to do is automatically run through the
whole list. Once it spits out the data on "C2" for example, it moves
onto C3.. C4 until it hits the last "selected" cell.

Again, Thank you for all of your help!

Zombie, stick to the original post until the question is resolved!

Looking at your code, using a loop is less efficient than using the .Find method & .FindNext ( see: http://www.excelforum.com/showthread.php?t=623830.

I also can't see why you are declaring variables as Variants when they are Strings or Longs, Variants are slower.