Dear watersev,

i know your post is quite old, but if you are out there, I am using your VB code (which is excellent btw, thank you). However, sometimes not all columns exist in my original data, so I get an error which stops the sub. Is there a way to keep it running and searching only for the column headers available in the original data?

thank you