@AB33 - my error, everything works perfect. Thank you for your help! I learned at lot today.

Another small improvement, if I have few values in column A , how can I loop through column A, so the code
brings data to corresponding rows in column C in one run?