Please Help with VBA...

[NPA1984]

I really need some help with VBA On my sheet Row 2 is where I will enter in the values that I want moved into the table below, based on the EE# I have put into A2. I have a table with raw data below this, each row has a number assigned to it called EE# I would like to have VBA do the following when I press the button: Copy the data I entered into row 2 and paste it into the row with the same EE# IF Cell A2 = A10 then copy data from D2 into D10 and F2 into F10 if A2 does not equal A10, check if A2 = A11 if so copy D2 paste in D11, copy F2 paste in F11, and continue until the end of the table. If no match then msg box "Error - No EE# in table" Right now my table is sorted largest EE# on top and smallest on the Bottom

 

[bill0145]

try this:

Sub test()
EEnum = Cells(2, 1)
lr_table = Cells(Rows.Count, 1).End(xlUp).Row
x = 1
For i = 10 To lr_table
    If Cells(i, 1) = EEnum Then
        Cells(i, "D") = Cells(2, "D")
        Cells(i, "F") = Cells(2, "F")
        x = x + 1
    End If
Next i
If x = 1 Then
    MsgBox "Error - No EE# in table"
End If
End Sub
<

 

[NPA1984]

OH!!!! - THANK YOU! THANK YOU! THANK YOU! Worked Awesome!