Im trying to create a macro that carry's figures forward to a new
workbook but ignores any with zero in the end column.

I have a workbook which shows amounts owing and as they get paid off
week by week it deducts it from a grand total at the end of the column.
Dont know if it makes any difference the column's go horizontally.

As said if any get paid right off and have zero I dont want to carry
them figures forward at the end of the month.

Can anyone help?


--
tweacle