Hello,
I am very new to VBA, I was wondering if anyone can help me with this issue I have.
I want to copy a range (A2:A6) from sheet1 and paste it to a sheet in which the name of it is the same as A1 or sheet1. I want the macro to come back to sheet 1 and repeats on to the next column until it hits a blank cell in row1.
Thanks in advance,
Evelyn
I am very new to VBA, I was wondering if anyone can help me with this issue I have.
I want to copy a range (A2:A6) from sheet1 and paste it to a sheet in which the name of it is the same as A1 or sheet1. I want the macro to come back to sheet 1 and repeats on to the next column until it hits a blank cell in row1.
Thanks in advance,
Evelyn