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

z060081 wrote:
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 ?

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200903/1