Hi vba experts
in my file, there are 2 sheets Sheet1 & Sheet2
Sheet1 has data in column a (the original names with the data already sorted in certain way)
Sheet2 has the same names but shuffled with some other data in multiple columns (A1:P200)

I wanted to sort the data in Sheet2 by the data in column a in sheet1

e.g
sheet1
^^^^
aa
bb
cc
dd
11
22
33
44
ee
ff

Sheet2
^^^^
11 ...... any .......... any .........any
cc ...... any .......... any .........any
ee ...... any .......... any .........any
44 ...... any .......... any .........any
aa ...... any .......... any .........any
33 ...... any .......... any .........any
dd ...... any .......... any .........any
22 ...... any .......... any .........any
ff ...... any .......... any .........any
bb ...... any .......... any .........any