Gotcha. I like keeping the entire account #, and the will be deleted, I modified your first code with your second .

Ok so not sure if this is another wrench, but we could have different account #'s, same price class, same address... we would need a few columns like "normal pricing 1, 2, 3" etc. it doesn't happen often, but it could.

I suggested the ALT+Enter method, so you would have 5 account #'s in 1 cell, but that does not work for sorting (useful part of a database).

Ideas?


I seriously appreciate your help with this!