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 i
with a macro). As a matter of interest is it a one-off thing or
regular event?

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

regard

 

[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