Insert a few rows on top of the table,
in A1 put Ticker in B1 put Balance
leave A2 blank (you really don't need the values in A1 but if you want to
filter on values in A as well it could be handy)
in B2 put
0
now go to the sheet where you want the filtered table, select for instance
A1 in sheet3
do datafilteradvanced filter, click in the list range box and then click
the source sheet tab and select the table, could look like
Sheet1!$A$4:$B$100
click in the criteria range box and select Sheet1!$B$1:$B$2
now select copy to another location, go sheet3 and click in the cell where
you want the filtered table to start
click OK
That should do it
--
Regards,
Peo Sjoblom
Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
(Remove ^^ from email)
"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