Starlightjewel
New Member
- Joined
- Feb 15, 2004
- Messages
- 2
I am trying to copy and paste the following formula where the Formula Adjust E10 stays constant and the D23 changes for each row. =SUM(D23*'Formula Adjust'!$E$10*1.07)
I can't figure out how to keep the one constant - it keeps tring to change - on the next line it looks like this - =SUM(D24*'Formula Adjust'!E11)*1.07 - I want to keep the link to the same cell while the other changes going down.
I can't figure out how to keep the one constant - it keeps tring to change - on the next line it looks like this - =SUM(D24*'Formula Adjust'!E11)*1.07 - I want to keep the link to the same cell while the other changes going down.