Macro to auto fill in cells based on value on different cells

[juskojj]

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

[stnkynts]

Macro isn't needed. Put this in G2 of Defect Detail Sheet

Please Login or Register  to view this content.

This in H2 of Defect Detail Sheet

Please Login or Register  to view this content.

Just copy down as far as you want within column G and H of Defect Detail Sheet

*Note: Column A of Reject Codes Sheet will need to have a vaule in each row for it to reference.

[juskojj]

thanks! but I don't want to copy down the code. I'm going to be giving this to someone else to input data and don't want to worry about copying down code since I"ll also be locking those columns so they can't change it.

[stnkynts]

I am not understanding the problem. Copy down the code yourself all the way to the bottom then lock the columns. It will still reference properly when they change the reject code in column F

[juskojj]

the problem is i don't want to copy the code all the way down to row 10485476 which is the bottom of a excel 2010 spreadsheet.

[mike7952]

Place this in the Defect detail worksheet mod

Please Login or Register  to view this content.

[mike7952]

small modification to clearcontents

Please Login or Register  to view this content.

[juskojj]

Thanks Mike!!!!!!!
It works perfectly!