Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
sorting 2 colums of numbers and incremening them down | Excel Discussion (Misc queries) | |||
Inputting data to one worksheet for it effect another | Excel Discussion (Misc queries) | |||
Combining data from cells from several excel sheets to a new sheet | Excel Discussion (Misc queries) | |||
Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
pull data from sheet two, then fill in the data to sheet one (part | Excel Worksheet Functions |