Hi, I've taken plenty of advise from this forum, so much so that I've only needed to register now, so thank you all.
I get data from external sources in the form of a table that has every month of a year. I'm looking for a way to automate the transfer of a specific month's sum to another spreadsheet, and then again with certain filters on. The table might increase in number of rows every month I receive it eg.
<tbody>
</tbody>Is this even possible with VBA and a macro? Would I need to clean the table somehow?
Thanks.
I get data from external sources in the form of a table that has every month of a year. I'm looking for a way to automate the transfer of a specific month's sum to another spreadsheet, and then again with certain filters on. The table might increase in number of rows every month I receive it eg.
Name | Filter 1 | Filter 2 | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec |
1 | a | x | 5 | 5 | ||||||||||
2 | a | y | 2 | |||||||||||
3 | a | z | 3 | 2 | 3 | |||||||||
4 | a | z | 1 | 2 | ||||||||||
5 | b | z | 5 | 4 | 5 | |||||||||
6 | b | y | 2 | 2 | 2 | 2 | ||||||||
7 | b | x | 4 | 1 | ||||||||||
8 | a | x | 4 | 5 | ||||||||||
Total | 17 | 12 | 18 | 12 |
<tbody>
</tbody>
Thanks.