VBA Excel from Table to Matrix

[jmpmolegraaf]

Hello all,

I really need your help with this one. Excel file can be downloaded from link below:
https://docs.google.com/file/d/0B3YkCIgMwSNMcXlCZWMyWkVULXM/edit?usp=sharing

It is a typical example: two sheets, one with a 2D data and the other should become a matrix.

I got it so far to get the unique ports vertically and the unique products horizontally. Now the values DISCOUNT need to be filled in from the first sheet ("Table").

For some reason I cannot get it right with For..Next (in three steps) and I would expect that an Array is needed to properly access this.

Please note that the number of ports and products varies each time. I only need assistance on the part of getting the right values in the right place in the matrix.

Thanks so much for your assistance!!!

Best regards,
Jan-Martin (Copenhagen)

 

[jmpmolegraaf]

Anybody?

I just cannot find any solution and it really shouldn't be too complicated I guess.

 

[jmpmolegraaf]

is there anybody who could assist in this matter.. Thanks so much in advance!!!