Change cell reference for a linked formula

  • Thread starter Thread starter Samantha
  • Start date Start date
S

Samantha

I have 50 employees who all have their own worksheet.
These worksheets are linked to a monthly worksheet with
changes every month. Instead of manually changes the cell
reference how can i change this for the whoe sheet.Here is
an example:

=SUM('C:\Documents and Settings\shawn smith\My
Documents\carter industries w-2\[W2 WH c smith 03.xls]
Sheet1'!$D$29)
The number 29 is the number I need to change every month
on a different worksheet, but all other info will be
different for each individual employee.

Please help me :(
 
Back
Top