Ignore empty cells

[ERcoder]

Hi All,

I have a spreadsheet that has 30+ columns on the first sheet. On the second sheet I am using the = to copy cells from the first sheet so that I can print only columns that need to be printed.

So on the second sheet the formula in A1 is =Sheet1!A1 and I dragged it all the way down. But where the cells on the first sheet that are blank the second sheet shows a 0 (zero). How can I make the 0 not happen? If it is blank on the 1st sheet I need it blank on the second sheet also.

Thanks.

TT

[TMS]

Maybe

Please Login or Register  to view this content.

Or, if the content of the column is alpha-numeric, just

Please Login or Register  to view this content.

Regards, TMS