Hello,

I'm using Excel 2003 for payroll deductions. I have one workbook with two worksheets. One worksheet (information sheet) is were I enter all of the information. The other (payroll sheet) calculates the information from the first. I want to use an indirect formula so if a co-worker goes into the information sheet and cuts and pastes something, it won't change the formula on the payroll deduction sheet. Is there a way to auto-fill down the indirect formula so I won't have to type it in thousands of times?

To clarify, this is the formula
=INDIRECT("'Monthly Deductions-Elections '!$M$11")*12/26

If I copy and paste, or auto-fill with the mouse, to a different cell the exact same formula is pasted there.

I want to be able to paste it and have the references change automatically. Example
=INDIRECT("'Monthly Deductions-Elections '!$M$11")*12/26
=INDIRECT("'Monthly Deductions-Elections '!$M$12")*12/26
=INDIRECT("'Monthly Deductions-Elections '!$M$13")*12/26