Expert: Jan Karel Pieterse - 11/9/2009

Question
QUESTION: I am having two excel sheets, W1 and W2. In W1 i have certain charecters and in W2 i have the 3 corresponding values for the charecters in W1

My Problem is that the text for the charecters are not the same in W1 and W2, but are more or less the similar. The second thing is that the values are not listed in the same order in W1 and W2.

I need to have a logic to arrange all the values for the charecters in Sheet W1. Manually this can be done, but since there are more than 5000 points it will take moe time and accuracy is less.

ANSWER: Hi Terrence,

I assume you need more than just sorting the data?
Can you show a part of the data?

---------- FOLLOW-UP ----------

QUESTION: Thanks for the immediate correspondence.I will illustrate this with an example.
In W1 the charaters are in
column   A          B          C   D   E
      AHU-7-  AUTOMATIC MANUAL OVERRIDE STATUS


In W2 the charecters are in

column   A          B          C   D  E
      AH07   Auto Manual Override Status  V1  v2 v3

i need to compare the charecters in the columns A and B in both the excels and have the values correspondingly from W2 to W1

I hope i have explained this better  

Answer
Hi Terrence,

It looks to me like this is something you do have to do manually. To aid a bit, you could have both tables show next to each other in Excel.

From the menu, select Window, New Window. Then select Window, Arrange. Choose one of the options you think are useful (I'd think vertical might be good) and check "WIndows from active workbook".