Mperrah, that was suggested by my co-worker too, I suppose we could do a unique ID, except that will only be useful when referring to this document, everything else is based on account #.

Snb - wow, that was a fail on my part!

I like it, however in the government pricing column, it would have to put the -xxx number, not the 5001 number.

so 012345-001 would put -001 in the government pricing column instead of 5001. The -xxx number can be different, but it will always be classified as a certain account based on its price class column.

If you can make that change then i'll take a look at your old code vs new and see if I can spot the differences. My real export data has maybe 30 columns, so I will have to adapt your code into that and make sure it copies over the entire thing.

baby steps..