Suppressing printing blank cells containing formulas.

Hi, I have a spreadsheet that is used solely for the purpose of printing out anonymised data as a pdf for distribution ot outside agencies. it references another spreadsheet containing the full data using the following formula:

=IF('[Other Spreadsheet.xls]Employees'!G2="","",'[Other Spreadsheet.xls]Employees'!G2)

so that blank cells do not return a '0' or 'error'.

There are two worksheets that reference two different worksheets in the original spreadsheet.

What I want to be able to do is to print out one document that includes both anonymised worksheets without having to set a print area each time I do and without printing out reams of sheets because I have formulas returning blank cells in perpetuity.

Thanks

Right, think I have achived this using filters which I have never used before and found following trial and error. Not perfect but it works conveniently enough.

Tanks