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 it progressively wrote to scoresheets any help appreciated ( i think i already posted this but site says i haven' hmmm
- 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 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.
GiGi
- Thank you Georgia and all who looked at problem have finally found where i hid original formula so all good but thanks for your interest
cheers tony
