Hi,
First, I don't what a one-off thing is. This is a one time event. Once the
information is tranferred there will not be another. You are correct in your
assumption of what I am trying to do and it will be going into a "new"
workbook. I hope this what you were looking for.

Richard

"tony h" wrote:


Just to confirm what you are trying to do (and of course you can do it
with a macro). As a matter of interest is it a one-off thing or a
regular event?

So you want to move columns of data (except for the header labels) into
a different mapping of columns on another spreadsheet. Is the "new" in a
new workbook (it might make life easier it was and this is a regular
event)

regards


--
tony h
------------------------------------------------------------------------
tony h's Profile: http://www.excelforum.com/member.php...o&userid=21074
View this thread: http://www.excelforum.com/showthread...hreadid=552070