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:
Thanks to rizvisa1
for this tip on the forum.
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