$$Excel-Macros$$ How to check a field and change highlight color if the cell value changes

row). The sheet is sorted on field 2. I normally do this manually but the Excel they just sent me has over 1,000 rows and most of the field 2s are non repeating. Thank you, Bob Engler -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join

$$Excel-Macros$$ How to append row from 1 sheet to end of row of second sheet based on cell value

If columnA in sheet2 matches columnB in sheet1, append the data from the row in sheet2 to the end of the row in sheet1. Sheet1 may have multiple rows with the same column data and the data from sheet2 needs to be added to all sheet1 matching rows. ie: Sheet1: hr abc ddd rrt hr dew ggg wqq hr