Hello my friends.
I hope you can help me here.
I have an excel with a matrix like the following
Abrantes Amiais Benavente Chamusca Constância
Abrantes 58 98 40 14
Alcanede 66 12 67 54 50
Alcanena 46 10 72 32 36
Almeirim 66 38 34 24 60
In this matrix you have the "origin city" as rows on the left, the "destination city" as columns , and the values.
What I need to do is, given a origin city and a destination city, the macro must read the value.
Anyone can help me how to achieve this ?
Thank you in advance,
Bleeding_me
Bookmarks