I'm not even sure where to begin with this but here is what I was asked to do:
<tbody>
</tbody>
"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" :
<tbody> </tbody> Here is sheet 2 named "CMI_PMT_Project in Progress":
<tbody> </tbody> So I need the information from the entire A row of sheet 1 to automatically populate in sheet 2. Hopefully I explained well enough! |
<tbody>
</tbody>