Filter or Query Between Worksheet

[z060081 via OfficeKB.com]

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,

 

[z060081 via OfficeKB.com]

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,

Sorry, forgot to mention that the problem seem like Microsoft Access Query
function. But Microsoft Excel doesn't not have Query function itself right ?