VBA copy & Paste loop from collum (B to G) to the last row of collum A

I need your help in create a VBA for copy loop. Here is the problem: I want to copy a range of data in column B to last row of A column and then copy next column C to the last row of column A. Can anyone help me with this. Appreciate your help! enter image description here enter image description here

https://stackoverflow.com/questions/66702231/vba-copy-paste-loop-from-collum-b-to-g-to-the-last-row-of-collum-a March 19, 2021 at 11:42AM