I have 2workbooks - a source data workbook and a destination dat
modelling workbook. Every month I need to copy select columns from on
workbook to the other - the complication is that they are laid ou
differently eg column A (source) needs to be pasted over the older dat
of column J (destination).

Most of the time the copy and paste format doesn't change so i woul
like to have defaults set but have the option to change where to past
to, if the source changes as I have no control over that workbook.

I would also like to do this in one step if the default is true.

Can I have a user form which allows me to select the source columns an
paste into the destination columns through check boxes or drop dow
lists and if so, how would i do this

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