I would appreciate some help with this task as I am really stuck trying to work this out. I will try my best to explain it. I have 2 worksheets in the excel file. The first worksheet is where all the data is sent from the 3rd party software. I have no control over how the data is displayed on the first worksheet. All the calculations are completed on the 2nd worksheet. Below is what I am trying to complete on the 2nd worksheet. The D,Z,A,P,W text is what is shown on B9,B10,B11,B12,B13 of sheet1. The problem is the data is continually changing positions. The data may change to Z,D,P,A,W 10 minutes after this example. What I want to do is on another section of the 2nd worksheet is create Alphabetical ranking. So the data is always shown as A,D,P,W,Z. Any help appreciated
='Sheet1'!B9 D
='Sheet1!B10 Z
='Sheet1!B11 A
='Sheet1!B12 P
='Sheet1!B13 W
='Sheet1'!B9 D
='Sheet1!B10 Z
='Sheet1!B11 A
='Sheet1!B12 P
='Sheet1!B13 W