Excel - Copy and paste values from specific columns

September 2017




Issue


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.

Solution


You can define your range as:
  • Range(cells(2, (range("A2").value + 1)), cells(10, (range("A2").value + 1)))

Note that


Thanks to rizvisa1 for this tip on the forum.

Related

Published by aakai1056. Latest update on July 30, 2012 at 08:28 AM by aakai1056.
This document, titled "Excel - Copy and paste values from specific columns," is available under the Creative Commons license. Any copy, reuse, or modification of the content should be sufficiently credited to CCM (ccm.net).