WOW!! ...amazing how your mind works...never thought of implementing autofilter..

mardyl :: Thanks a ton for the quick reply...saved me hours of research time (..though i wasted a lot of time on it already..)

Anyways...addition to it, can we keep the original color, font, alignment to the copied data in delivery sheet?