Migrating Information

[Richard]

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

[tony h]

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

[Richard]

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
>
>