Hi I have a drop down box in "A2" which is changed by month eg. (Apr- 16), in cells "A3:A8" this pulls through all sales data for that month.
I copy that data from cells "A3:A8" and paste values ONLY in the corresponding month in a table "C2: F8".
I need a macro that copies the figures in column "A" and pastes values only in table (C2:F8) for the corresponding month which is chosen in cell "A2"
I will then assign a macro button for this.
<tbody>
</tbody>
I copy that data from cells "A3:A8" and paste values ONLY in the corresponding month in a table "C2: F8".
I need a macro that copies the figures in column "A" and pastes values only in table (C2:F8) for the corresponding month which is chosen in cell "A2"
I will then assign a macro button for this.
Apr-16 | Jan-16 | Feb-16 | Mar-16 | Apr-16 | ||||||||||
2567 | 10 | 16 | 1544 | 2567 | ||||||||||
100 | 1 | 887 | 5 | 100 | ||||||||||
266 | 55 | 0 | 3 | 266 | ||||||||||
666 | 489 | 0 | 8 | 666 | ||||||||||
948 | 34 | 88 | 99 | 948 | ||||||||||
348 | 5 | 67 | 1 | 348 | ||||||||||
<tbody>
</tbody>