Hi, guys! Any ideas how to write a Macro to achieve the following in EXCEL? _______________________ If Coulmn2="Rt" AND Column3="brake" (e.g. Row2 as highlighted), Then do the followings: -> write "brake" in Column4 (same as copying the content from Column3) AND, -> look for the NEXT HIGHER value in Column1, e.g. Row2 has value 1 in Column1, so the next higher value is 2 (=1+1), -> if found (i.e., if 2 is found in Column2 in this example), see if it has "brake" in Column3; if it has, then write "brake" in Column4 (or any new column), -> now look for still higher value in Column1 (that is 3) and see if it has "brake" entry in Column3; if it has, then write "brake" in Column4, and so on (a loop!) -> The loop ends when the next higher value does not have "brake in column3 or the next higher value is not found.