Reference 3 spreadsheets and automatically insert formula

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

MODIFIED POST: Ok, I was able to figure this out some on my own. I have now put the due dates in the sheet named master template.

I need to find a statement that can match Cell B5 from the criteria sheet, to pull in the correct cell (H if = 60, K if = 90, and N if = 120) into the column E on the internal project plan tab.

There is a macro that pulls in the data from the master template to the internal plan, but I do not know how to change it. It is below:

I appreciate any assistance you can provide. Thanks

Please Login or Register  to view this content.

I have several other posts on this site about this project but on different issues. The links are below:

http://www.excelforum.com/showthread.php?t=649053

http://www.excelforum.com/showthread.php?t=649209

I have no open posts on any other site.

Hi guys, I am new to VB, I start classes on Wednesday but I have this project that is due before then, is there anyone that can assist?

I have not gotten a response on this one so have posted on another forum. The link is below.

http://www.mrexcel.com/forum/showthr...66#post1623366

We ended up using a select case code for this, below is the code:

Please Login or Register  to view this content.