Hello,
I have put together a spreadsheet for my fishing club. The results of each persons catch (on their own tab) gets populated to the start tab and lists them in no particular order.
I would like the persons catch weight to be ranked highest to lowest automatically positioning it in the correct slot in the table. The name, weight in pounds, ounces and No of fish must all move as one.
Any ideas how this can be done?
Thank you in advance.
Neil.