software

What I am trying to do is add rows to an existing worksheet with multiple
formulas. The problem is after I add all of the rows and drag the formulas
to the end of the added rows, then I have to manually change each formula.
The formulas are from another workseet in the same workbook, and they look
like =Page1!L206, when I drag I get =Page1!L207, but what I need is
=Page1!L216. Any help would be greatly appreciated.

Do a search in excel for absolute references. This information will be
helpful to you.

To answer your qestion specifically, change the formula to =page1!$L$206.

quot;J.D. Websterquot; wrote:

gt; What I am trying to do is add rows to an existing worksheet with multiple
gt; formulas. The problem is after I add all of the rows and drag the formulas
gt; to the end of the added rows, then I have to manually change each formula.
gt; The formulas are from another workseet in the same workbook, and they look
gt; like =Page1!L206, when I drag I get =Page1!L207, but what I need is
gt; =Page1!L216. Any help would be greatly appreciated.