Cell reference

[satda]

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

[#2]

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

[#3]

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

[#4]

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

[#5]

@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 

[#6]

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