Referencing
Results 1 to 1 of 1

Thread: Referencing
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Moderator mole999's Avatar
    Join Date
    Oct 2004
    Location
    UK
    Posts
    9,817
    Post Thanks / Like
    Mentioned
    16 Post(s)
    Tagged
    2 Thread(s)

    Default Referencing

    I have a table were I have a couple of static references, and I need to be able to copy paste across the sheet maintaining the same reference points. The Monday (and other days) value is derived from the week ending value (Sunday) in relation to the top percentage per day, what ever I try one or other reference moves every time and I need to do this cleanly for a year to start with


    FPG

     DEFGHIJK
    1314.31%14.27%14.26%14.31%14.44%14.31%14.09% 
    14        
    15      55211 
    16      41929 
    17      10482 
    18      2800 
    19        
    20MonTueWedThuFriSatSunMon
    2108/04/1909/04/1910/04/1911/04/1912/04/1913/04/1914/04/1915/04/19
    2279017878787378997975790377827901

    Formeln der Tabelle
    ZelleFormel
    D13='Global Key'!AE39
    E13='Global Key'!AE40
    F13='Global Key'!AE41
    G13='Global Key'!AE42
    H13='Global Key'!AE43
    I13='Global Key'!AE44
    J13='Global Key'!AE45
    J16=(J15-J18)*0.8
    J17=(J15-J18)*0.2
    D20=TEXT(D21,"ddd")
    E20=TEXT(E21,"ddd")
    F20=TEXT(F21,"ddd")
    G20=TEXT(G21,"ddd")
    H20=TEXT(H21,"ddd")
    I20=TEXT(I21,"ddd")
    J20=TEXT(J21,"ddd")
    K20=TEXT(K21,"ddd")
    D22=$J$15*D$13
    E22=$J$15*E$13
    F22=$J$15*F$13
    G22=$J$15*G$13
    H22=$J$15*H$13
    I22=$J$15*I$13
    J22=$J$15*J$13
    K22=$J$15*D$13


    Excel Tabellen im Web darstellen >> http://www.excel-jeanie-html.de" target="_blank"> Excel Jeanie HTML 4.8
    Last edited by mole999; Jul 10th, 2019 at 05:11 AM. Reason: I'll have to see if I can install HTML Genie to repair this
    • Yes I know there are better ways to do it. I just wish I knew them. - 97, 2003, 2007, 2010, 2013, 2016 & 2019
    • I wear my ignorance openly, excel is not my chosen career, its a means to an ends
    • Posting Guidelines Want to post well laid out questions and answers Translate Excel Versions
      Code:
      [CODE ]Put Your Code[/ CODE]
    • Settings > General Settings (on the left) scroll to the bottom, > Miscellaneous Options > Use ENHANCED
    • X-Posting Guidelines Rule 13 > CHART STUFF

Some videos you may like

User Tag List

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
  •