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.

Copy/paste values on the specific column
How to find specific words on a page - Guide
Based on the values in cells b77 ✓ - Excel Forum
Excel conditional formatting if cell contains specific text - Excel Forum
Excel conditional formatting if another cell contains specific text ✓ - Excel Forum
Copy and paste fonts - Guide

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

help me to add particular cells

Fill adjacent cell with number from text answer

How can I make my name text invisible in Discord

Excel function question

Similar discussions

Subscribe To Our Newsletter!