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.
