Thanks for the reply,

THat is a little more simple than what im trying to do, I need the green hilighted numbers to stay the same and the code in the blue hilighted cells to change. Basically i need to refrence the value in c11 and find it in f12, m12 and p12, then replace it with the value in c12. This also needs to be done with row 13 (finding the c11 value and replacing it with whats in c13 for f13, m13 and p13. I hope my explanation is clear enough. Is this clear?