It is difficult to understand your question. I think you want to have a
formula in the new sheet that refers to the data on another sheet.

Instead of just "=sheet1!A1", which will give you 0s where the cells on
sheet1 are blank, you can use something like this, which writes "" (nothing)
if the cell A1 on sheet1 is blank:

=IF(sheet1!A1=0,"",sheet1!A1)

--
Reply to post if not correct
Allllen


"areezm" wrote:

I am trying to copy one column from one sheet to another sheet without
getting all the zeros at the end, This is for a template that will have
varying range sizes.

Any suggestions???