Macro to obtain colored values from 3 columns

Hm yes I did delete some rows, edited my original post.

Hmm so yes that does bring all the desired ones to the top, but would you know how to then make it so it only copy/pastes the ones flagged into column M? In your picture I would just want the macro to copy from 38648 down to 443010 and place that into column M. I couldnt figure out how to get the macro to know which ones are red.

Also, the red is conditional formatting, so it could also work by flagging anything where the "Comparison" column is greater than 1. Not sure what is easier.

THanks!

I am not sure if this will help, but I used another conditional formatting on column A based on the following formula.
flag3.png

Please Login or Register  to view this content.

This formula accurately selects the items you require, but now I am also stuck. We need a way to convert that formula selection into a macro to pull those values in green.

I think Karmapala's code answers what I thought was the original requirement, but Clizzy will have to tell us. I was doing research on the coding on color fill and came across this site for information on the color process. https://www.extendoffice.com/documen...r-of-cell.html

Great job karmapala!

Hi maniacb,

Actually I also not quite sure on what Clizzy's expected result .
So yes, better wait for Clizzy to explain further about what he want.
Thanks, maniacb.

Originally Posted by Clizzy

OK so I am making a macro to filter/scrub through some data to be reviewed, using a template that will always be the same. I am stuck on figuring out a way to place all the "Row Labels" that are flagged with a red amount in either column I/J/K into column M.

Please Login or Register  to view this content.