First step I do is find the column row with the max value through
Let's say it's A7 that has the max value.
Once I have that value, I would like some data from the rest of row 7 to be grabbed. For instance if A7 is the max value, I'd like to grab the values from B7, C7 and E7 automatically.
How do I do this? Take into account the row with max value is constantly changing.