+ Reply to Thread
Results 1 to 4 of 4

Formula to copy formula in another cell but with a different reference in the formula

  1. #1
    Registered User
    Join Date
    03-24-2020
    Location
    London, England
    MS-Off Ver
    MS 2019
    Posts
    2

    Angry Formula to copy formula in another cell but with a different reference in the formula

    Hi All,

    Hopefully you can help.

    I currently have formula that are linked to other worksheets within my workbook and I want to be able to get some secondary information from that formula.

    So for example i currently have a formula which is linked to a specific cell in another sheet

    ='P01'$K$45

    This is in cell F57

    What I would like to do is have cell I45 reference the above formula but change the letter to $J$45.

    Is this possible?

    TIA

    Sam

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Excel 2007
    Posts
    19,798

    Re: Formula to copy formula in another cell but with a different reference in the formula

    Is there some relationship between the cells where the formulae would reside? It seems a bit random to have a formula in cells F57 and in cell I45. Are those the only two cells where you would want the formula?

    Pete

  3. #3
    Registered User
    Join Date
    03-24-2020
    Location
    London, England
    MS-Off Ver
    MS 2019
    Posts
    2

    Re: Formula to copy formula in another cell but with a different reference in the formula

    Hi Pete,

    Thanks for your response.

    That should be I57, sorry.

    I work for a building company and we have a bill of quantities that we link each item to a build up sheet which has a rate.

    What we would like to do is be able to have a hidden set of columns where the reference is linked to a the materials and labour if that makes sense.

    So we would have the following.

    Bill Item 1 - Roof Type 1 - Quantity, Rate (='P01'!$K$45), Total. Material Rate (='P01'!$K$24), Labour Rate (='P01'!$K$39)

    The bills can be very long so I need the Material Rate/Labour rate to be automatic based on the first formula. Note: The Material and labour rate are always the same reference whatever sheet they are on.

    Thanks.

  4. #4
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Excel 2007
    Posts
    19,798

    Re: Formula to copy formula in another cell but with a different reference in the formula

    It would help if you attached a sample Excel workbook.

    To do this, click on Go Advanced (below the Edit Window) while you are composing a reply, then scroll down to and click on Manage Attachments and the Upload window will open. Click on Browse and navigate to (and double-click) the file icon that you want to attach, then click on Upload and then on Close this Window to return to the Edit window. When you have finished composing your post, click on Submit Post.

    Do not try to use the Paperclip icon for attachments, as it does not work on this forum.

    Hope this helps.

    Pete

    P.S. the same instructions are also given in the yellow banner at the top of the screen.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. copy formula down entire column while changing formula cell reference
    By am_hawk in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-22-2013, 11:34 AM
  2. Copy Formula and Reference the Same Cell in the Next Sheet
    By Loanhighknight in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-04-2013, 02:15 PM
  3. [SOLVED] Copy Cell Reference formula to 3 rows down but increment formula by only 1 row
    By jwnickman in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-23-2013, 01:57 PM
  4. Can I copy a formula from one cell and reference the next worksheet
    By angela.fitt in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-21-2012, 11:09 AM
  5. Replies: 7
    Last Post: 11-12-2012, 02:46 PM
  6. Excel 2007 : copy formula and cell reference does not change
    By MaryKMathias in forum Excel General
    Replies: 2
    Last Post: 12-20-2011, 03:45 AM
  7. [SOLVED] Copy formula down a column does not use correct cell reference
    By brett in forum Excel General
    Replies: 1
    Last Post: 01-09-2006, 12:35 AM
  8. [SOLVED] HOW DO I COPY FORMULA WITHOUT CHANGING CELL REFERENCE
    By anantth in forum Excel General
    Replies: 4
    Last Post: 02-06-2005, 09:06 AM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1