Quote Originally Posted by mperrah View Post
Not to throw a monkey wrench in this whole thread, but I re-read your first attached example.
This code will look for matching account numbers (first 6 numbers) then adds that number to the row above in the pricing column,
then removes the duplicate and moves to next, going from bottom up...
Sorry I didnt pursue this earlier.

Just saw this, will try, give me a sec!

That works, but can you put the exported data into Sheet 2 like snb did?

I am thinking, it deleted the price code so I can't see if it worked (it looks like it did, but I would like to compare).

hope that is not difficult. I like that code though, it's doing what I want.