mapping? columns from one excel workbook to another

[Jadooi]

I have data with headers in one excel spreadsheet

A1 Item Code, A2 Item Description, A3 Department

I want to map the column data from A1 to a new worksheet template into
column A4

I want to create a macro that will automatically arrange the column info
from Worksheet 1, Column A1 into the new workbook under Column A4 under the
new correct headers.

Any ideas how to begin this process?

Thank you

 

[Gord Dibben]

Columns are A B C D etc.

Rows are 1 2 3 4 etc.

A1 A2 A3 A4 are cell references.

There is no such thing as Column A1 or Column A4

Please re-describe your needs based on this information.

Post an example of your current layout and an example of your "what it
should look like" layout.


Gord Dibben MS Excel MVP