Hello,

I have a worksheet which has a column with codes that are duplicated.

I want to extract unique codes and put them into an array.

I then want to re-loop through the worksheet and look at a different column.

For each item in the array I want to check if this row has that item and then assign the number value to the 2nd dimension of the array.

I am going to use this 2d array to compare to another worksheet.

In the other worksheet I will compare the codes in the first dimension of the array (ie say it finds it in row 12), compare the number value in the corresponding second dimension to the value in another cell of row 12 and deduct the value from the second dimension of the array (i.e. it will be a reducing balance.

I hope this doesnt sound too complicated and will appreciate help

Sorry if this sounds rushed but I am in an internet cafe and the guy next to me really smells so I need to get out of here!!!!