Dynamically Pulling Unique Values

[starbwoy]

Hi Guys- I need some help pulling unique records from a list dynamically. Tax Min will be pasted in the sheet every day and will have different values each day. I need to know every unique value within the list.

In the attachment, I need column C to have a sorted list of each value in col A. I need these values to change as the values in col A change daily.

Thanks for any help you can provide.

[martindwilson]

that can be achieved using advanced autofilter
using the copy and unique records options then sorting
or record macro or use macro like below to do it and assign to button

Please Login or Register  to view this content.

[starbwoy]

But the advanced autofilter is not dynamic to changing data. Isnt that correct?

Thanks

[Portuga]

You can create a pivot table from that column and everytime you add new values they will be automatically be displayed in the pivot (Once refreshed)

[martindwilson]

correct its not dynamic..yet
working on macro that will run after paste
vba noob has given me a snippet thet may do the trick

[martindwilson]

perhaps this will work for you just past into a1 including title,
on attached try it out select column h and paste into a1 then try column j and paste into a1
code is

Please Login or Register  to view this content.

it goes in a worksheet module for sheet you require sorting

[starbwoy]

This works Perfect..........THANKS!