Results 1 to 5 of 5

Copy & pasting Formula with one constant cell and one mo

This is a discussion on Copy & pasting Formula with one constant cell and one mo within the Excel Questions forums, part of the Question Forums category; I am trying to copy and paste the following formula where the Formula Adjust E10 stays constant and the D23 ...

  1. #1
    New Member
    Join Date
    Feb 2004
    Location
    NC
    Posts
    2

    Default Copy & pasting Formula with one constant cell and one mo

    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.

  2. #2
    Board Regular
    Join Date
    May 2002
    Location
    The Netherlands
    Posts
    90

    Default Re: Copy & pasting Formula with one constant cell and on

    I am not quit sure what you mean, but try it with just one $.
    $E10 or E$10

    Hope this solve your problem

  3. #3
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    64,415

    Default Re: Copy & pasting Formula with one constant cell and on

    Quote Originally Posted by Starlightjewel
    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.
    You don't need the outer SUM and

    =D23*'Formula Adjust'!$E$10*1.07

    copied 1 row down, would become:

    =D24*'Formula Adjust'!$E$10*1.07

    because E10 is completely locked, while E$10 would also work as intended.

  4. #4
    Legend just_jon's Avatar
    Join Date
    Sep 2002
    Location
    Alabama/State of Disarray
    Posts
    10,473

    Default Re: Copy & pasting Formula with one constant cell and on

    Quote Originally Posted by Starlightjewel
    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.
    It looks like you are doing it correctly -- anchoring the row and column on the E10 reference. Are you using copy/paste?
    just_jon
    Book of the Month: I'm Not Really an MVP, I Just Play One on TV [j. jon, 2004]

  5. #5
    New Member
    Join Date
    Feb 2004
    Location
    NC
    Posts
    2

    Default Re: Copy & pasting Formula with one constant cell and on

    I'm not sure what I did differently, but I tried everything above and it's working now. I have 250 tabs to fix and really didn't want to do it manually. Thanks so Much!!!!

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


DMCA.com