Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
HansM
 
Posts: n/a
Default column mapping from on sheet to the next

What is the fastest/easiest way to take data from one Excel sheet in columns A, B, C, ...etc. and load it in another sheet in order I, J, A, C, K, G etc (with some columns being left unused as they don't exist in the source sheet). I have ten of those workbooks in order of A, B, C ...etc. and need to bring them (after some column manipulation) into a single new workbook.

I am now thinking to copy and paste all ten of those workbooks into one, do the data manipulation (i.e. separating last name and first name etc) and then just cut and paste columns in the needed order. But I was hoping for an import that let me select where to map the columns.

Thanks,

HansM
  #2   Report Post  
Dave Peterson
 
Posts: n/a
Default

I think I'd approach it the same way as you--merge all the worksheets, then
rearrange.

If it's something you have to do lots of times, you may want to record a macro
when you rearrange the columns.

Then you could just run that macro when you had to do the rearrangement.

(I don't think there's a generic solution for what you're asking.)

HansM wrote:

What is the fastest/easiest way to take data from one Excel sheet in columns A, B, C, ...etc. and load it in another sheet in order I, J, A, C, K, G etc (with some columns being left unused as they don't exist in the source sheet). I have ten of those workbooks in order of A, B, C ...etc. and need to bring them (after some column manipulation) into a single new workbook.

I am now thinking to copy and paste all ten of those workbooks into one, do the data manipulation (i.e. separating last name and first name etc) and then just cut and paste columns in the needed order. But I was hoping for an import that let me select where to map the columns.

Thanks,

HansM


--

Dave Peterson
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
MACRO - copy rows based on value in column to another sheet Michael A Excel Discussion (Misc queries) 1 March 5th 05 03:15 AM
how do i print a column containing 150 names on 1 sheet of paper . stormey Excel Discussion (Misc queries) 3 February 10th 05 06:01 AM
My Excel Sheet has opened as a mirror image - Column A is on the . Philip Setting up and Configuration of Excel 2 December 29th 04 08:28 PM
getting data from 2 different exc sheet pinar Excel Worksheet Functions 1 November 9th 04 03:58 PM
Naming & renaming a sheet tab Cgbilliar Excel Worksheet Functions 1 November 7th 04 06:57 PM


All times are GMT +1. The time now is 10:34 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"