Doesn't seem to work.

When I try it, all I get is the customer name and the rest as #NA.

I've treid paste special and selecting values, but that does nto skip blanks. Even when I tick the "skip blanks" option it still pastes the zero.

Any ideas?