doriannjeshi
Active Member
- Joined
- Apr 5, 2015
- Messages
- 338
- Office Version
- 365
- Platform
- Windows
Hi,
I need a macro to filter and copy items to a new sheet. The filtered items and the new sheet name to be established in the macro.
I need a macro to filter and copy items to a new sheet. The filtered items and the new sheet name to be established in the macro.
| Book2 | ||||||||
|---|---|---|---|---|---|---|---|---|
| A | B | C | D | E | F | |||
| 1 | A | B | C | D | E | F | ||
| 2 | june | 3 | -3 | 1 | ||||
| 3 | june | 3 | 1 | 1 | 1 | 1 | ||
| 4 | april | 3 | 1 | 1 | 1 | |||
| 5 | may | 3 | 1 | 1 | 1 | 1 | ||
| 6 | february | 3 | 1 | 1 | ||||
| 7 | october | 3 | 1 | 1 | ||||
| 8 | october | 3 | 1 | 1 | ||||
| 9 | november | 3 | 1 | 1 | ||||
| 10 | december | 3 | 1 | 1 | ||||
| 11 | ||||||||
| 12 | ||||||||
| 13 | result | |||||||
| 14 | A | B | C | D | E | F | ||
| 15 | june | 3 | -3 | 1 | ||||
| 16 | june | 3 | 1 | 1 | 1 | 1 | ||
| 17 | may | 3 | 1 | 1 | 1 | 1 | ||
| 18 | october | 3 | 1 | 1 | ||||
| 19 | october | 3 | 1 | 1 | ||||
| 20 | sheet name"months" | |||||||
sheet1 | ||||||||
Last edited:
