Is there a way to auto-delete rows in my template that have no amount specified?

View comments to see user responses…

Subscribe to the FBS News E-mail ListSubscribe to the FBS News E-mail List

One Response to Is there a way to auto-delete rows in my template that have no amount specified?

  1. Jacob Hintze says:

    My preferred solution for this issue is to create an =IF() formula for the chartfield and description cells of a line to be blank if the debit and credit are also blank (or zero). This may make the excel worksheet look strange with blank lines between the actual lines, but once uploaded to the web format, the blank lines are removed.

    Example:

    =IF(OR(I17<>“”,J17<>“”),Sheet1!$A$12,””)

Comments are closed.