View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
stratis stratis is offline
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.