Dear all

I have a sheet which looks as follows

Sheet 1

COl A l COl B l COl C l COl D
Name l Tax l Tax Recpt No l Date of deduction

John l 22 l 3 l 21.12.08
Raj l 36 l 8 l 03.01.08
Sam l 35 l 6 l 01.01.08
Vas l 89 l 7 l 16.05.08
John l 92 l 5 l 12.04.08
Raj l112 l 9 l 31.06.08
Jane l121 l 12 l 13.08.08
Mader l 92 l 13 l 23.09.08
Varun l181 l 15 l 26.11.08
Jane l145 l 19 l 24.07.08
Raj l213 l 26 l 29.03.08


In Sheet 2 I need to get all the values in the three fields against names which lookl ike this

COl B COl C COl D
Name Tax Tax Recpt No Date of deduction

Jane
Raj
John
Vas
Jane
Raj
Varun
Raj
Mader
John
Sam


Pls help me

Adi