Hey, I havent quite hammered out the code Im going to use yet but just wanted to see if anyone had any ideas. Im looking for a way to store values that meet a certain criteria in order to use them later as a variable in another part of my macro. The data is being pulled from a SQL server in the first part of the macro.

Sample Data:
Source Number
JE 1234
AR 5236
AR 5236
AR 5478

I would be looking to store the numbers 5236 and 5478 based on the criteria Source= "AR". As shown in the sample data there will be duplicate numbers and I only want to store one instance of it. Later in the macro I will be using each number as a condition for calculation/lookup.

Im not looking for exact code, instead maybe any ideas people want to contribute. Thanks in advance!