Excel Macro Check

[edinburgh]

Hi,

Can someone help me to figure out how to macro for the following case:

SOURCE TARGET WEIGHTING FACTOR

Cell001 Cell002 100
Cell001 Cell003 99
Cell001 Cell015 90
Cell001 Cell022 88
Cell001 Cell033 66
Cell001 Cell044 33
Cell001 Cell055 22
Cell002
Cell003
...
...
...
etc


How Can I Prioritize for SOURCE to TARGET with 3 highest WEIGHTING FACTOR?

Thanks.

Best regards,
Edin