How can I link data from two sheets in Excel and show in another sheet?

I

imported_Hati B

New member
Dear Friend

I badly need to have below solution.

Suppose, sheet1 has below fields & data under that and I do insert data daily.

CLIENTADDRESS JOB STATUS
A 12/1 ABCD PENDING
B 3, XYZ DONE
A 12/1 ABCD PENDING
C 234, MNOP DONE
A 12/1 ABCD DONE

Now, i want to create below fields in sheet2 for CLIENT A.

CLIENT JOB COMPLETED DATE
A PENDING
A PENDING
A 01.12.2011

Now, i want to display fields & data for CLIENT A in sheet3 as below and that will be my report.
CLIENTADDRESS JOB STATUS JOB COMPLETED DATE
A 12/1 ABCD DONE 01.12.2011

Please help me by providing guideline.


Regards
Pervez
 
Back
Top