mapping? columns from one excel workbook to another
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 |
mapping? columns from one excel workbook to another
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 On Fri, 11 Dec 2009 12:10:47 -0800, Jadooi wrote: 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 |
All times are GMT +1. The time now is 02:05 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com