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(Contract Award/NTP Date) and the "Execution/Monitoring in Construction" is selected from the drop down list in column D(Project Lifecycle Phase),|
|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!
Here is sheet 1 named "PLRAM Tool" :
Here is sheet 2 named "CMI_PMT_Project in Progress":
So I need the information from the entire A row of sheet 1 to automatically populate in sheet 2. Hopefully I explained well enough!