Archives
When creating a new Syteline financial Statement, it is much easier to work on a copy of existing statement report, instead of starting from scratchy. You can certainly use the Excel export/import to do the copying, but one part of the financial statement line, the total tab, would not get copied over that way. Syteline […]
How to get a 2nd drop down box to update the range (Not just use C6:C7)based on selection in 1st drop down box. Example: If Fat, Use range from C6:C7 If Skinny, Use range from D6:D7 You can direct put the IF statement in 2nd drop down validation, like =IF(Sheet1!$A$1="Fat", Sheet1!$C$6:$C$7, Sheet1!$D$6:$D$7)
Excel provides conditional formatting which allows you to change the color and other attributes of a cell based on the content of the cell. There is no way, unfortunately, to easily hide rows based on the value of a particular cell in a row. You can, however, achieve the same effect by using a macro […]