Reference 3 spreadsheets and automatically insert formula

[dodom75]

Hi guys,

In the attached example there are four spreadsheets in the workbook (Criteria, Workday Formula, Master Template and Internal Project plan).

What I need to do and can't figure out, is:

Fields:
1. On the Criteria Sheet the end user chooses a timeline (60/90/120) days and the launch date.
2. On the master templete there are three columns (Recommended Lead time 60, Recommended Lead time 90, and Recommended Lead time 120) that is based on regular days
3. On the Workday template I have done the comparison to figure out what the workday # of days vs a regular # of days is based on 60/90/120)

There is a macro built in here that pulls over the rows from the master template based on the criteria from the sheet "criteria" what I need is for the appropriate "reg days lead" on the internal project plan sheet to pull from the column on the master template and then match that to the workday formula sheet and "work days lead" to pull over based on whether the user chose 60/90/120.

Then I want to build in the "Due Date Column" on the internal project plan to make the workday formula =WORKDAY(Criteria!B3,-F7) copy all the way down where f7 changes to that actual row number to calculate the due dates and then hide the # of days fields.

There is probably a simpler way but I cannot find it.

I hope this isn't too confusing, if anyone help on this one the assistance is greatly appreciated. Thanks