ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Automatic separate row is added when value is more than $0 (https://www.excelbanter.com/excel-discussion-misc-queries/169110-automatic-separate-row-added-when-value-more-than-%240.html)

Cynthia

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


All times are GMT +1. The time now is 08:50 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com