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.
Published by aakai1056
Latest update on July 30, 2012 at 08:28 AM by aakai1056.