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
If cell contains specific text then return value in another cell ✓ - Excel Forum
Auto serial number in excel based on another column ✓ - Excel Forum
Vba find column by name ✓ - Excel Forum
Excel copy column from one sheet to another automatically - Guide
Compare two worksheets and paste differences to another sheet - excel vba free download ✓ - Excel Forum

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

help me to add particular cells

Can no longer paste text into insta

Deleted Message icon

How to use conditional format based on text?

Highlight cell if another cell contains specific text

Similar discussions

Subscribe To Our Newsletter!