View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
khaled shaheen khaled shaheen is offline
external usenet poster
 
Posts: 14
Default Filtering sheet data in another sheet

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