dmkitz
09-19-2006, 01:22 PM
I created two financial forms, in Excel. Formulas in Form B take values that exist in Form A and populates cells in Form B.
This is code from Form B:
=IF('G:\FormA.xls'RE1Add1="","",'G:\FormA.xls'RE1Add1)
You notice that instead of using generic cell references, I named the cells. This is creating a problem now if the user needs to add rows to a particular section because they cannot just copy the formula down, because Excel copies the exact range names down.
So do I have a choice but to go back and unname those cells? Is there a way to substitute cell references for cell names in a formula? :think:
This is code from Form B:
=IF('G:\FormA.xls'RE1Add1="","",'G:\FormA.xls'RE1Add1)
You notice that instead of using generic cell references, I named the cells. This is creating a problem now if the user needs to add rows to a particular section because they cannot just copy the formula down, because Excel copies the exact range names down.
So do I have a choice but to go back and unname those cells? Is there a way to substitute cell references for cell names in a formula? :think: