Macro to insert formula result into range with zero values in cell

I have a column with possible Values A thru F for example. I need to insert
any of A thru F (whatever is there) into another range where there are cells
equal to zero in that range (column). There can only be one copy of A thru F
in the new range. Please help if you can, I am blocked on this project. I
appreciate any help given. If this is more appropriate in work***
functions, please advise. Posted only in programming.

Thanks
.

Quantcast