Macro to copy rows based on a critera and copy the name of the column

Hey Guys,

I need help with a macro to copy part of a certain rows based on criteria, then add the name of the column and the value.
The macro compares any of the values in Range E3:M1300 whether they are bigger than the value in O1.
If a match is found (for example cell F3 is bigger than O1), to copy A3:C3 on a new row in Sheet Results , on column D to copy the name of the section, and on column E to copy the actual Value.

I have included a test file with data.testexamplev2.xlsx

Thank you very much in advance!

Maybe:

Please Login or Register  to view this content.

Well, John...it took me more time to write my post, than you to solve it!

Works great! Thank you so much!

You're welcome. Glad to help out and thanks for the feedback and the rep.

I just thought that I would throw this in. The only difference is that if any changes are made to the data and you want to refresh the "Results" sheet, I think that John's macro would simply add the changes to the existing data. The following macro would avoid that issue. I'm not sure if this helps.

Please Login or Register  to view this content.

Mumps, that's actually an awesome suggestion! This way if they press the macro button twice, it won't double the data.

Thank you very much for your addition! Now the macro is perfect!

My pleasure.

Try:

Please Login or Register  to view this content.

Works great, thank you again Mumps!

Glad it worked out.