I've got a spread sheet with one tab called "reject codes" full of reject codes, station numbers and descriptions. I have another tab called "defect detail" where I enter the month, date, shift, reject code number, station and description. What I'd like to do is when I enter the reject code in column F in tabe "defect detail" to auto fill in column G (station), column H (description) based on the info from tab "reject codes". I started doing this using a very long nested IF(OR)) statement but the problem is it would get very long and have to copy it down to every cell so I want the macro to do it for every new row in column G & H. Any help would be greatly appreciated!Reject Log.xlsx