Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Mapping XML to workbook | New Users to Excel | |||
XML Mapping in Excel 2007 | Excel Discussion (Misc queries) | |||
Excel 2003: Mapping rows (x-axis) vs multiple columns (y-axis) | Excel Discussion (Misc queries) | |||
mapping with excel | Excel Worksheet Functions | |||
Using Excel's XML mapping/export with data organized in columns | Excel Worksheet Functions |