View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Cynthia Cynthia is offline
external usenet poster
 
Posts: 86
Default Automatic separate row is added when value is more than $0

I have a separte that is 2000 lines.

When there is a charge of more than $0 I need a separate row to be added
automatically with the other information AND not the $0

Is there way I can do this automacially instead of me having to put in a
row manually when I create this spreadsheet in the future?

Currently the spreadsheet is created. Is there a formula i can put in and
another row is added to the row above with the other information instread of
the charge like basic information like name and date.

EX
Charge Dog
50