Per the below grid, I am looking to have VBA take the data for each Silo pull the entire row (client, Silo, Jan, Feb, etc) onto a new worksheet also including the header row and total the months. So for example, the Group 1 worksheet would have 2 lines for client "a" and "d" under the header (ideally alphabetically by client) and sum each month Column.
Thanks in advance to the Excel community!
<colgroup><col><col><col span="2"></colgroup><tbody>
</tbody>
Thanks in advance to the Excel community!
Client | SILO | January | February |
Client a | group 1 | $ 1,000.00 | $ 1,500.00 |
Client b | group 2 | $ 2,000.00 | $ 5,000.00 |
Client c | group 3 | $ 3,000.00 | $ 2,500.00 |
Client d | group 1 | $ 4,000.00 | $ 6,800.00 |
Client e | group 2 | $ 5,100.00 | $ 3,500.00 |
<colgroup><col><col><col span="2"></colgroup><tbody>
</tbody>