I need a macro to create n sheets from filtered data.
Context: I have a sheet with 3 columns (fixed), but a lot of row (and increasing the numbers of rows). Periodically, I need create a new sheet for each value of 3º row.
Example:
| A | B | C |
|---|---|---|
| 1489 | VAN GOGH | PAINTER |
| 6245 | MONET | PAINTER |
| 6548 | CROSBY | MUSICIAN |
| 3216 | WESLEY | MUSICIAN |
| 4598 | WATTS | MUSICIAN |
| 4953 | HAVERGAL | MUSICIAN |
| 4258 | CHRISTIE | WRITER |
| 1234 | LEWIS | WRITER |
| 1548 | TOLKIEN | WRITER |
Objective: At the end of macro, I need to have 3 new sheets, each one renamed after the column C value and with the correspondent data.
I would prefer this macro in embebbed LO python, but in VBA would help too.
I don’t know how to start. Please, help me.
Best regards.