MrExcel Publishing
Your One Stop for Excel Tips & Solutions

I want worksheet referenced cell to link to its own worksheet

Posted by Kevin C on May 10, 2001 5:57 PM

I am trying to set up a budget with several workbooks.

first workbook is budgeted months to date
if I only have january figures then formula reads


Budget is for 10 departments (workbooks).

I want to have a "constant" workbook where I can put in master formulas affecting all 10 other workbooks so cell reference for this workbook could be that formula (above), but it automatically refers to its own cells in constant workbook so all values are zero instead of refering back to department workbook monthly figures.

Anyway, I want to make formula changes in only one "master" workbook and have it affect numbers in 10 others


Posted by Kevin James on May 10, 2001 8:09 PM

global vs local

Hi Kevin

The following message from a few days ago may provide some insight.