Try Data Filter Autofilter........select zero from the dropdown arrow in
column B.......then copy and paste the visible rows over to the Filtered
sheet.............note, this can all be done by macro if it's something yo
do frequently........

Vaya con Dios,
Chuck, CABGx3



"khaled shaheen" wrote in message
...
Dears,

here is my problem:

Source sheet Filtered
sheet
A B A
B
Ticker Balance Ticker
Balance

HRHO 1000 ...... ......
ACGC 500 ......
......
ESRS 0
ORHD 500
ELEC 0

I want to filter the data in the "Source sheet" to another sheet to only
display those Tickers " A" that have Balance " B" Zero


regards,

Khaled