I have a range of data I want to:
+ find all the blanks cells in specific column
+ Select the row data for each blank cell respectively
+ then
+ Select another set of data in another columns based on that specific column (plz see the pic)
Untitled.jpg

this is my code. I'm asking for improvements 
Please Login or Register  to view this content.

I want to past it like this
Untitled.jpg

thank you