Solved: Looping through Dynamic Array

[LeoLee]

Hi,

I have attached a quick demonstration of how my program requires.

Sheet 2 is the place where all the back-end stuff is happening.

1. In Column A, it is a record of Customer ID and I have create a Dynamic Array call CustomerDynamicArray using Offset.

2. In Column B, it is a number imported by Sheet 1. At all times, it will only contain 1 customer ID.

3. Column C and B is the results of using value in B2 to loop through CustomerDynamicArray to identify any duplication.

After countless hour of researching , the nearest of looping through a dynamic array is the code I attached above.

Please help me I really really appreciate your help!

A million thanks!