Moving data from one worksheet to another and back.

Well yes, thank you Ali. Have to say that's surprised me, I actually thought I could probably do it but it would have ben long winded. Much obliged.

Yeah, youre right of course. As soon as you change the name all the other bits would disappear.

Thank you for that. I tried to copy over the code to the original workbook but it gave me a error 9 message, however I can use the downloaded book.

As for column C on the enter sheet, I guess I could copy over the formula to show the points until I change the name.

Do I press upgrade after each players scores are entered?

Thanks John, I can use the download as an original, which I guess will save me setting the named ranges. This will really improve my event day experience, the Masters page was quite delicate.

I create a new workbook for each event so its not a problem.

One further question if I might ask. Is it possible for Column B to clear once you select another name? Otherwise you're putting one number on top of another and I'd imagine that could easily lead to a mistake.

I'm typing in off a scorecard, usually 3 numbers at a time and its easy to lose track of where you are, especially as I am often interrupted mid flow, people bringing in more cards, questions, etc. .

I think I've just found and solved another problem. Sometimes you get a score queried, players cards can disagree with each other or scores are challenged. Obviously if I select a name for a second time then all the scores would disappear, however I can get round that by changing an individual score on one hole on the Master Sheet. That seems to work okay.

Yes, its definitely not working correctly John.

If you open the workbook and put a 4 in each cell for Brian Adams, then click on Jeff Batterbee, the 4's all appear under Batterbee.

Then if you enter a series of 5 under Batterbee, click on Bennett, all the 5's go to Bennett.

Sadly maybe this is a step too far, I don't like to think you keep wasting your valuable time on me. Also I've realised if something did go wrong on the day of the event, I'd have no idea how to put it right, when I can often work out what's gone wrong when using a formula a formula.

I think you've nailed it John. I actually prefer the update button, gives me a chance to check the score against what the player is claiming. I'll keep this copy as my Master now.

Thanks so much, I am full of admiration for people like yourself. I have managed to add some VBA to workbooks but it is all very simple stuff like sorting.

Have a good nights rest. I'll test it extensively tomorrow but I think we've got it.