I want to migrated information on one spread sheet with column headers into
another with different column headers. For example sheet 1 has a column
labled Customer Address, Sheet 2 has a column labeled Primary Address. The
information on sheet 1 under Customer Address has to go into sheet 2 under
Primary address. Each row on sheet 1 contains all the information for a
particular customer and all the other information on that row will have to go
through the same transfer. Is there a way to do this with a function or some
type of macro? The spreadsheet has hundreds of rows and roughly 45 columns of
information.

Thank You,
Richard

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

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