Help with a macroo


Attached is a table that highlights the highest value as red that I want to be able to automate.

Basically if the red highlight is as shown (Yellow axis) I want M13 to show "1" and (Blue Axis) N13 to display "1". Can anyone please help with this?  Kind regards Dave

4 Replies

@harwood66  Try this:




M13 is fine mate, N13 is picking Cell A15 instead of the L15 value. Please can you help? Kind regards Dave


my bad


@mtarler  Thanks ever so much for your time and trouble. I am so grateful, amazing. This will save me hour ever week. Kind regards Dave