Hi

I need to copy a user input on sheet 1 on rows C3,C5,C7,C9,C11 then find the name on C3 match the name on sheet 2 then copy the values from C5 to C11 on sheet 1 to columns B, D, F,G on sheet 2 against that name

C3 = NAME
C5 = GP
C7 = UNIT
C9 = DEPT
C11 = MARKUP

I have a routine for the name but can't find how to get the row so it can be copied into sheet 2.

Any help would be most appreciated.