Hello,
I am attempting to create a macro which filters a column by each unique value within the column then prints a sheet off for the resulting data.
So for example if I had a table of data like such..
I could hit the macro button and it would print me off individual sheets with the data for each value 20/40/50.
How could I go about this?
Thank you in advance for any help!
I am attempting to create a macro which filters a column by each unique value within the column then prints a sheet off for the resulting data.
So for example if I had a table of data like such..
Values | Data |
20 | A |
20 | B |
40 | A |
40 | B |
50 | A |
I could hit the macro button and it would print me off individual sheets with the data for each value 20/40/50.
How could I go about this?
Thank you in advance for any help!