I have a current issue trying to automize a scorecard on financial data.
I use Microsoft Query to read data into a Pivottable. My ambition is to make a VB dropdown box linked to the dropdown boxes in the pivot tables.
This would create a very user friendly and quick updating of the relevant reports.
I am not sure if it is possible, but I would appreciate constructive feedback.
I started out with a more ambitous plan of doing most of this without pivot tables, using VBA all the way, but due to time constraints and holes in skillbase this seems like a mouthful.
Thanks for your help,
Regards,
Atle M Brevik
I use Microsoft Query to read data into a Pivottable. My ambition is to make a VB dropdown box linked to the dropdown boxes in the pivot tables.
This would create a very user friendly and quick updating of the relevant reports.
I am not sure if it is possible, but I would appreciate constructive feedback.
I started out with a more ambitous plan of doing most of this without pivot tables, using VBA all the way, but due to time constraints and holes in skillbase this seems like a mouthful.
Thanks for your help,
Regards,
Atle M Brevik