Sage 100

How to Hide Zero Rows in Sage Intelligence (see attached pdf). Not sure if this is the best place to post but wanted it out here in case people are searching. Also, if you have many sheets to hide, be aware that you have to set up a separate statement for each sheet. I would recommend modifying the Add-In statement manually - basically you can copy and paste one statement and just change the sheet name. Much faster than running through the setup process 10 or 20 (or 50) times.

@EricAnderson thanks for the update. I'm now using a macro to update the filters on each worksheet. I have approximately 70 worksheets. I taught the client how to modify the macro if they add a worksheet. Modified template to save to xltm so macro saves. At this point I don' see any advantage to changing to this add-in. It would be different if you could identify a range of sheets though. thanks again!

@RonGouveia are there sheets where you wouldn't want to update the filters?

That's a good question @RobertWood . There are the designer and references sheet that don't need the update but all the rest of the sheets do.

@RonGouveia off the top of my head if the designer and references are the first two sheets, wouldn't something like this work?: Dim Sht As Worksheet For Each Sht In ThisWorkbook.Sheets If Sht.Index > 2 Then 'your code goes here End If Next

@RobertWood sounds good. I will try that! thanks.