Microsoft Excel Creating Working with Multiple Worksheets

Creating dynamic links between workbooks using external reference formulas provides a number of advantages such as breaking a large, complex budget model into more manageable departmental models. Then link all the departmental workbooks to a master budget workbook. Basic worksheet and formula building is required.