Hi all,

I'm just starting to learn VBA and hope that you can serve as resources for what I need to do now and in the future.

I've attached a sample file to talk through this problem.

I have some user inputs of "NAME," various "SIZES" and "PRICES". For 1 NAME, there are many corresponding sizes/prices. The idea is that the user would type all of this in by him/herself. Then, press a button and have a new table created, as shown in the example. The table is sorted by Sizes.

To make the new table, I wanted to first grab all of the possible values in the size column, sort, then get rid of duplicates. After that, make a lookup table of some sort. I'm just not sure how to go about doing this.

Thanks!

example.xlsx