Hi
I have created a drop-down menu using a custom text field and wish to enter a date into Baseline Finish based on the users selection. For example; if the user selects J350 from the drop-down, it enters 1/20/07 in the Baseline Finish. There are roughly 20 possibilities the user could select so it would be nice if I could centrally store a simple matrix or look-up table that Project could pull from.
As a side note, the drop-down selections represent the assembly cost center and the Baseline Finish is the assembly load date. The reason the load date is the Baseline Finish is because I’m scheduling from the Project end date backward to schedule all events necessary to design and fabricate parts for assembly. The load dates change periodically and I need a way to ensure consistency and accuracy across schedules.
VB, Macro, Formula….????????
Bookmarks