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
I am sorry to tell you that your message is VERY hard to understand what you are asking. Remember you work on this frequently and we do not. It is up to you to make us understand what is going on so that we can help.
OK let me try and see if I can understand what you need:
You say "darts scoring program i created some years ago and cannot find how i got o enter data into single cell" OK to enter data into a cell you select the cell and use the keyboard.
Then you say "enter data into single cell and each entry appeared consecutively in a column" Huh!!! You lost me here. So if you have an entry into cell A1 and you want it to appear in a column say Column K then in Column K you would have a formula =A1 and anything you type in A1 will appear in cell K1.
What do you mean by "consecutively in a column"? It it Cell 1, Cell 2, Cell 3, Cell 4 consecutively, or value of Cell 1, then value of Cell 2, then value of Cell 3, then value of Cell 4 in Cell K1. That is VERY hard to do without any automation using VBA.
Then you say "as i entered each score it progressively wrote to scoresheets " You can do the same thing with =A1 in Cell K1 but you can also specify what worksheet cell A1 is in for example:
If you have a worksheet named "Data Sheet" and a worksheet named "scoresheets" placing this formula in cell A1 on scoresheets='Data Sheet'!A1 will get the value of Cell A1 on the Data Sheet.
Please take a minute, gather your thoughts, and describe each step in some details. It does help to use the right MS-Excel nomenclatures so that we are all on the same page. Look at this webpage for reference: https://www.exceldemy.com/learn-excel/parts/
Let us help you to the MAX!
GiGi
I am sorry to tell you that your message is VERY hard to understand what you are asking. Remember you work on this frequently and we do not. It is up to you to make us understand what is going on so that we can help.
OK let me try and see if I can understand what you need:
You say "darts scoring program i created some years ago and cannot find how i got o enter data into single cell" OK to enter data into a cell you select the cell and use the keyboard.
Then you say "enter data into single cell and each entry appeared consecutively in a column" Huh!!! You lost me here. So if you have an entry into cell A1 and you want it to appear in a column say Column K then in Column K you would have a formula =A1 and anything you type in A1 will appear in cell K1.
What do you mean by "consecutively in a column"? It it Cell 1, Cell 2, Cell 3, Cell 4 consecutively, or value of Cell 1, then value of Cell 2, then value of Cell 3, then value of Cell 4 in Cell K1. That is VERY hard to do without any automation using VBA.
Then you say "as i entered each score it progressively wrote to scoresheets " You can do the same thing with =A1 in Cell K1 but you can also specify what worksheet cell A1 is in for example:
If you have a worksheet named "Data Sheet" and a worksheet named "scoresheets" placing this formula in cell A1 on scoresheets='Data Sheet'!A1 will get the value of Cell A1 on the Data Sheet.
Please take a minute, gather your thoughts, and describe each step in some details. It does help to use the right MS-Excel nomenclatures so that we are all on the same page. Look at this webpage for reference: https://www.exceldemy.com/learn-excel/parts/
Let us help you to the MAX!
GiGi
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
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.
GiGiGeorgieAnne 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
