I have a column full of text values. I need to create a list of variables based on the uniqueness of the column. The column is filled with "core, services, btr, admin, and payments" currently but it may have more or less values based on an extraction (hence why i need the variable list to redim each time this runs). I want to set the column range as an array and then create a list of variables that is unique based on the column (Column B if it's relevant).

I then want to take the values from the variables that were extracted from the array and then set them to cells in sequential order (i.e. - cells 56, 57, 58, 59, etc)

Thoughts?

Thank you!