Forum Discussion

satda's avatar
satda
Copper Contributor
Aug 10, 2024

Cell reference

Hi need help have a darts scoring program i created some years ago and cannot find how i got o enter data into single cell and each entry appeared consecutively in a column so as i entered each score...
Formulas and Functions
satda's avatar
satda
Copper Contributor
Aug 11, 2024
i put it into normal language so most could understand it however it is simple i enter data into 1 cell on a sheet A Say C4 each entry goes to another sheet B B4 and each entry appears in a consecutive order from B4 to B50 n as in a scoresheet
GeorgieAnne's avatar
GeorgieAnne
Iron Contributor
Aug 12, 2024

Hello satda
Put this formula in Sheet B in Cell B4: ='Sheet A'!C4 and fill down (or copy it) to B50
Hope this helps, if not come back with why and how its not working.

GiGi

  • satda's avatar
    satda
    Copper Contributor
    Aug 12, 2024

    GeorgieAnne  below is part Data entry layout

        
      HOMEAWAY
    Doubles 1Leg 1

    6

     

    		 
    Leg 2 2 
    Leg 3   

    part of score sheet page

    HomeAway
    1st leg1st Leg
    78 
    85 
    5 
    4 
    8 
    1 
    5 
      
      
      
      

    thanks Georgia close to what is needed attached are part of how it is done and your formula is close except it refers to all cell in C and absolute reference only shows current entry it is supposed to be  continually entered in to bottom bit and show progressive entries in bottom bit which of of course are two different sheets somehow i made cells to refer to next entry in c4 that's the bit i cant remember not a spring chicken anymore lol but thanks cheers from OZ 

Resources