Hi,
I'm not an expert in VBA and macros but I created a system that automatically fills a sheet starting from a form.
Now that I have the complete set of data in "data", I need a macro that acts as a filter in column B, called "ACCOUNT", to help me in finding the right account (I will always have 6 rows as a result).
After it, the macro should copy this data and should be pasted in a new sheet ("pivot") to be the base of a pivot chart that should update itself every time that I change account.
So, in conclusion, I need a macro that automatically updates the chart, starting from a database.
Thank you very much for your help!
Jack.
I'm not an expert in VBA and macros but I created a system that automatically fills a sheet starting from a form.
Now that I have the complete set of data in "data", I need a macro that acts as a filter in column B, called "ACCOUNT", to help me in finding the right account (I will always have 6 rows as a result).
After it, the macro should copy this data and should be pasted in a new sheet ("pivot") to be the base of a pivot chart that should update itself every time that I change account.
So, in conclusion, I need a macro that automatically updates the chart, starting from a database.
Thank you very much for your help!
Jack.
