"That works in a formula but I don't know how to use it in the macro unless you have two columns to the side of the data and then have the macro check both values. That would be pretty clean and simple........
You'd have to insert a code loop into the macro that tests all of the cells in the row to see if any are not zero. If it finds a value, either positive or negative, it exits the loop and resumes on the next row. I'm not a programmer…"
"Below is the macro I use. One (minor) downside is that it hides zero rows in hidden worksheets but that doesn't affect functionality. Another downside is that it hides rows which net to zero, ergo, if there is a debit in one column and a credit…"
You won't be able to modify standard Sage reporting in Intelligence, however, using the field list in the report might give you a head start on accessing the right tables and fields…"
"Here's a macro that may help.
1. It's not perfect. Someone with much better skills than I, should be able to fix it up.
2. You WILL have to modify it for your needs with the correct column to test and the correct number of rows…"
"The way I do this is to create an additional tab just after the Notes tab.
In that tab, I have a table starting in A1 called Periods_Table with the columns:
Period, Month, Descr, Date
Period are two characters so you have to…"
"That was the one I was thinking of.
Also, try turning off the Force Book Recalculation option. It's not generally recommended because it requires that you recalculate the spreadsheet after it has been created.
Be sure the…"
"I suspect that the range names are being created by SI after the formula column has been inserted into the spreadsheet.
For some reason, I think I've read where you can turn off the calculation for the spreadsheet until after all of the…"
"I'm having a similar issue.
We have created several templates, each with more than 100 tabs, one tab for each reporting unit on the tree. These templates all use the same tree. As large as the Excel templates become with so many tabs,…"