Forum Discussion
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...
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
GeorgieAnne below is part Data entry layout
| HOME | AWAY | ||
| Doubles 1 | Leg 1 | 6
| |
| Leg 2 | 2 | ||
| Leg 3 |
part of score sheet page
| Home | Away |
| 1st leg | 1st 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