Hi All,
Forgive me I've gotten into VBA recently and I'm fairly novice.
I am trying to create a Pivot chart to show the number of projects against a specific team from a datatable but I am having no luck with my attempts at modifying the recorded Macro to work correctly VBA.
What I am trying to accomplish:
There are 2 sheets, one for source data (Called "Calcs) containing all the data and another sheet for the output desitination (Called "NOC).
I am trying to basically grab all the data from the 'Calcs' sheet, filter the 'Team' column so I can see how many projects are against a specifc team and output that to a piechart.
Any help is appreciated, I can't seem to find anything on Google which has been helpful.
Thanking you kindly.
Forgive me I've gotten into VBA recently and I'm fairly novice.
I am trying to create a Pivot chart to show the number of projects against a specific team from a datatable but I am having no luck with my attempts at modifying the recorded Macro to work correctly VBA.
What I am trying to accomplish:
There are 2 sheets, one for source data (Called "Calcs) containing all the data and another sheet for the output desitination (Called "NOC).
I am trying to basically grab all the data from the 'Calcs' sheet, filter the 'Team' column so I can see how many projects are against a specifc team and output that to a piechart.
Any help is appreciated, I can't seem to find anything on Google which has been helpful.
Thanking you kindly.
