Previous Topic Next Topic

Copy/paste values on the specific column

Solved/Closed
tinissane - Mar 6, 2010 at 10:57 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Mar 7, 2010 at 03:54 AM
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 response

Answer 1 / 1
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Mar 7, 2010 at 03:54 AM
you can define your paste range as

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

Similar discussions

Can no longer paste text into insta
6hypnone -
Gordon -

7 responses
help me to add particular cells
mathewmunna -
mathew munna -

2 responses
Clear cell contents based on value of another cell range using VBA
Tbonekiller -
Tbonekiller -

6 responses
How can I make my name text invisible in Discord
imbenmark -
imbenmark -

4 responses
Fill adjacent cell with number from text answer
MitchP -
vcoolio -

20 responses