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???