LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 32
Default rearrange Columns according to predefined order

I have a file lets name it file One Xl Sheet that has 10 Colums and Another
file two one that has 50
I would liketo rearrange the file one colums in such an order to match the
order in file B. So for example input
File One
A B C D
SSn Name last name Age
File Two
A B C D E F
record num Age Name City Last Name SSn


File One Should be converted
A B C D E
F
record num (blank) Age Name City(blank) Last Name SSn


I need to compare the 2 files and unless they get the same order this is not
possible.
 
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
rearrange cells in random order Amy B Excel Discussion (Misc queries) 1 April 20th 09 02:08 AM
Rearrange numbers from a column in a different order in a second c Gaetan58 Excel Discussion (Misc queries) 14 November 21st 06 07:43 AM
can i rearrange names in alphabetic order naughtyboy[_6_] Excel Programming 1 August 7th 06 12:31 PM
can i rearrange the following names in alphabetic order.. naughtyboy[_5_] Excel Programming 1 August 7th 06 11:01 AM
rearrange an array in a different order clui[_12_] Excel Programming 3 December 10th 03 01:16 AM


All times are GMT +1. The time now is 03:01 AM.

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

About Us

"It's about Microsoft Excel"