Need formula for populating info to corresponding columns in separate sheet

[kAR87]

I'm not even sure where to begin with this but here is what I was asked to do:

"When a date is entered in column F and the "Execution/Monitoring in Construction" is selected from the drop down list in column D,
the Column information for that row is populated to the corresponding column headings in the "CMI_PMT_Project In Progress" tab:
Customer Name, Project #, Project Name, Project Lifecycle Phase, Contract Award / NTP Date, Substantial Completion Date, Project Revenue, Date Last Updated/Reviewed." I've been researching and all that I've been able to find is info on VLOOKUP and array formulas. If either of these are correct I don't know how to apply them to my situation. I can provide additional information if needed! Thank you!

<colgroup><col span="2"><col><col><col><col><col><col></colgroup><tbody>
</tbody>

 

[mumps]

Try:

Private Sub Worksheet_Change(ByVal Target As Range)
    If Intersect(Target, Range("D:D,F:F")) Is Nothing Then Exit Sub
    Application.ScreenUpdating = False
    If Target.Column = 6 And Target.Offset(0, -2) = "Execution/Monitoring - In Construction" Then
        Range("A" & Target.Row & ":D" & Target.Row).Copy Sheets("PMT_Project In Progress").Cells(Rows.Count, "A").End(xlUp).Offset(1, 0)
        Sheets("CMI_PMT_Project In Progress").Cells(Rows.Count, "N").End(xlUp).Offset(1, 0) = Target
        Sheets("CMI_PMT_Project In Progress").Cells(Rows.Count, "P").End(xlUp).Offset(1, 0) = Target.Offset(0, 2)
        Sheets("CMI_PMT_Project In Progress").Cells(Rows.Count, "R").End(xlUp).Offset(1, 0) = Target.Offset(0, 3)
        Sheets("CMI_PMT_Project In Progress").Cells(Rows.Count, "F").End(xlUp).Offset(1, 0) = Target.Offset(0, 5)
    ElseIf Target.Column = 4 And Target = "Unsuccessful Bids" Then
        Range("K" & Target.Row & ":K" & Target.Row + 6).ClearContents
    End If
    Application.ScreenUpdating = True
End Sub

 

[kAR87]

I entered the code but for some reason I cannot access the drop down menu. For some reason when I try to click on the drop down menu I can't select the "Unsuccessful Bids" option. Could this be a cell validation issue?

 

[mumps]

I had the same problem. When I checked your data validation, there was a '#REF' error which means that the source for your data validation list could not be found. You may have to re-enter that information.