View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
LennieLou LennieLou is offline
external usenet poster
 
Posts: 2
Default Hide rows with zero balances

Hi, I have created a report by linking the worksheet with the balances to a
new worksheet as such: Account Name, Account Number, Dr & Cr. The Dr and Cr
columns contain the value of the calculation performed on the previous
worksheet. eg C8=CALCULATIONS!O10. I am looking for a function/formula that
will hide a row when the Dr(C8) and Cr(D8) balances are zero?

Any help would be appreciated.