hi all
worksheet 1 range of values from a1 to a100.
corrseponding names in b1 to b100

worksheet 2 values from coluimn A worksheet 1 appear but in different order
in column G:need to have corresponding name from b column wksheet 1 appear in
d column worksheet 2

heklp pls

cheers anthony