Thanks for this except i think i may need some more instructions on ho
to incorporate the code.

When I create the User form - what do you suggest? Is this meant t
work with check boxes and drop downs?

I am imagining a user form which goes to the source sheet and allow
you to select one of the columns, and then allows you to select th
paste column from the destination.

thank

--
Message posted from http://www.ExcelForum.com