VBA Macro - Filter column by unique value and print column(s)

[Browneh89]

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..

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!

 

[ER_Neha]

Hello. I couldn't understand your requirement properly. Can you please provide a sample of your requirement.