Hi,

May I know is there anyone out there care to help regarding the problem i'm
facing.

Suppose my worksheet Sheet1 is having the following data.

A B
R1 Tom 20
R2 Sam 15
R3 Sally 11
R4 Tom 5

How and what approach can I go about to display the data in worksheet Sheet2,
taking the data from Sheet1.

A B
R1 Tom 20
R2 Tom 5

It seem like filter function within a single sheet but I just can't do it in
multiple sheet. Is there any formula/function that I can fulfill this problem?


Please help.

Thanks and appreciate lots with the kind reply.

Regards,

--
Message posted via http://www.officekb.com