Hello All, I think this is not as easy as I thought. What I have is a set of values in column A, lets say from A1:A10. Then I have one value in B1 and I want to copy that B1 value down as long as there is a value in A. Column A could be different lengths as in A1:A10 or A1:A1000, it is...