Best way to Link Workbooks

[HunterN]

Hi All You Excel People,

Here is an example of my Master Workbook:
Most is column headings, the two numbers go under Project Number, I can have many projects. (It doesnt look good when I submit it!)

FY 2002 CUMULATIVE COST ANALYSIS
MONTH BRANCH BRANCH PROJECT PROJECT
NUMBER CHIEF NAME NUMBER
--------------------------------------------- 7501 0251
"

I can go in and enter the Project Number in each row using another worksheet that holds the project numbers. There is also seperate workbooks for each Project that contains the other information that I need (plus more).
I need a way to move down the worksheet thru the Project Number column and use this
Project Number to open its appropriate workbook and retrieve the values from the Wkb
and enter them in the cells then move down to the next Project.


Has anyone done anything similar to this?

Your help would be appreciated. Thanks
This message was edited by HunterN on 2002-04-23 07:21

 

[HunterN]

I don't have a problem having to open each workbook as I go down to a new row!
What I really want is to dynamically change the formula as I go.

Throughout the masterworkbook, currently it contains the formula:
='C:My Project

 

[Legacy 98055]

Hi
Don't really understand, but I took a shot...

Sub InsertFormula()
Dim newProj As String
newProj = "='C:My ProjectFilename.xls'!project_name"
Range("C1") = newProj
End Sub

Tom

 

[HunterN]

newProj already represents

C:My Project