You are THE man Jerry, full qudos to you my friend. I'm glad the solution wasn't as simple as I thought it would be. I have learned a lot from your code example. It works, perfectly. I will still need to lookup the autofilter and other functions I am not familiar withm but that's my homework. Sleep well tonight your mission is accomplished.
Again, a big thankyou.
NG
ps. how do I mark this as solved?
Bookmarks