Copy/paste values on the specific column

Solved/Closed
Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
Hello,
I want to, copy/paste values on the specific column based on cell A2. i.e.
if cell A2= 1 then copy/paste values for the January column (range B2:B10), if
A2 = 2 then copy/paste values for column February range C2:C10, the report will
change every month. i.e. the range will change accordingly to the value on cell A2. if value on
A2 = 1 then B2:B10 , if A2 = 2 then the range is C2:C10.

I will really appreciate your thoughts.

1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
you can define your paste range as

Range(cells(2, (range("A2").value + 1)), cells(10, (range("A2").value + 1)))
1
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2821 users have said thank you to us this month