Can someone help me out with this VBA. I would like to be able to run a macro that looks at cells C123:H123 on sheet 1 and compare it to column A in sheet 2. If it finds a match (there will always be a match) I want to go back to sheet 1 and get the value in the corresponding column in row 128 and paste that value on the corresponding row in column D in sheet 2. I've attached the file. So when I run this macro the cell C128 value will be entered in under the name from cell C123 in the sheet2 (in this case it's called Employees. Then when ran again it needs to write the same cell value just in the next cell available.
Mill Bonus 2.xlsm
Bookmarks