I have two columns of data, say column A and B. I would like to have a macro that copies the data on Cell B1 down the column where there is data in column A.


Col A Col B
343 ABC
46
335
312
345

Thanks for your helps....