Excel - Copy and paste values from specific columns

Ask a question


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.


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.

Excel - Delete certain cells of active row
Excel: Sample Macro to Insert Multiple Rows