View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
davo1805 davo1805 is offline
external usenet poster
 
Posts: 1
Default Can I hide a row conditional upon a cell value?

I want to create a sheet which will serve as a Proforma Invoice displaying
data from a Bill of Materials sheet within the same file. For any line item
where the qty is 0, I would like that row to be hidden so that the Invoice
bears only the line items relevant to the proposed supply.