Data entry from one sheet to another

[WES7]

Hi All,

I am new to excel and want to start a spreedsheet to record scores for my sons pinball machine scores. What i would like t know is how/if i can type in a score on sheet one say cell B2 and then it records this value on sheet 2 cell C2 but then the next time I enter a score on sheet one cell B2 it records this next score on sheet 2 cell C3 then C4, C5 and so on, so all the time I just have to enter the scores on sheet one cell B2?

Appreciate any help
Thank you

Wes7

[MarvinP]

Hi Wes7,

See the attached with some VBA behind the sheet1 and in a Module. I think this is what you wanted..

Dart Score Entry VBA.xlsm

[xladept]

You can put this code in the Sheet1 module:

Please Login or Register  to view this content.

Directions for running the routine(s) just supplied

If you haven't used macros before you'll need to go to:
File- options - trust center -trust center settings - macro settings ,
the second option down (disable all macros with notification)

Then - Copy the code to the clipboard

Open your Workbook

Press ALT + F11 to open the Visual Basic Editor.

Click on Sheet1 and paste the code in the white space

and that's it for this event code

*Be sure to save the book with the code as Macro-Enabled

[WES7]

Thanks Martin,

This is exactly what I wanted. Just one more thing if you have time? How do I copy this macro to another cell, so I can use different columns for different games?

[xladept]

You're welcome and thanks for the rep!

What are you contemplating for different games?

[WES7]

Just the different pinball machines that we have at home. It's so we can try and come up with a handicap system for when friends come over to even up the playing field.

[xladept]

You can list the machine names in Column A on sheet 1 and in Row 1 of sheet 2 and a routine can match the Sheet 1 row entries with the Sheet 2 column entries

[WES7]

Yes xladept, that's what i want to do. If you look at the spreed sheet that Martin sent me, I just need to know if I can copy the macro in cell B2 to cell D2 and it will automatically put the values in sheet 2 cell E2
or do i have to write a new macro for cell D2

[xladept]

I'm suggesting that A2 names a machine, A3 another machine and so forth then by machine you enter the score for A2 machine in B2, for A3 machine in B3 and on and on - how many machines do you have??

(Or you can organize it horizontally.)

[WES7]

Have 5 machines, but the code is only in cell B2, I can't figure out how to put the code into cell B3 so that it will send the score to sheet 2 cell D2

[MarvinP]

Hi Wes7,

See the attached that should take care of multiple machines and/or players. Also - thanks for the Rep as I always work on Rep answers first.


Dart Score Entry VBA Better.xlsm

[xladept]

I made a sample too

[WES7]

Thanks Martin, this should do the job excellently. Appreciate all your help and your time that you have given me. Thanks mate

[WES7]

Thanks xladept, this also should do the job. Appreciate the help and time you have given to a complete stranger.

[xladept]

You're welcome Wes and thanks for the reps!