Formula returns null, hide entire row?

[Andrewgray123]

Not sure if this is possible. But i've got an excel workbook which has numerous sheets inside it. each sheet posts data to one final sheet.


This final sheet is populated based on simple formulas... =IF(C2=0,"",A2) etc.. This works perfect for the function i want it to perform (this is to paste into a sales program to generate a sales order) it does skip the null lines which is great)

However when it comes to printing all of these null lines are displayed. Is there a way to compress these null lines?

Or is there a way i can bring up a new sheet which will only show non null values?

Thanks

 

[Joe4]

How about using Filters to filter those records out?
Then those rows will be hidden, and your printing should work the way you want.