Golf Skins Autopopulate

Hello everyone,

I am hosting a golf outing tournament & have decided to use excel to handle my scoring this year instead of the big sheets. I have come up with an idea but I don't know how to execute it. I'll try my best to explain it in detail as much as possible.


1. At the start of the tournament each golfer must register ($20.00 per person). They can also pay $10.00 a day to enter into the skins competition. The tournament is three days long. Now they can pay the $10.00 for all three days at the start of the tourney or they can pay $10.00 each day. Either way doesn't matter. But what does matter is that when they pay me I am going to record it on my registration page of my workbook.

This is where you guys come in....

When you look at my workbook on the registration tab, you will see the 1st golfer (Maldonado) has registered & paid for all three days of the skins competition. When I enter the $10.00 into cell E3, I want a $ to appear in cell C3 on the page titled A_ROOKERY. When I enter the $10.00 into cell F3, I want a $ to appear in cell C3 on the page titled A_BAYCLUB. And when I enter it into cell G3 I need the $ to appear in cell C3 on the A_RIVERRUN page.

This needs to happen for each golfer. As I said before I just don't know what formula to use to achieve this solution.

I have left the $ in just so you can see how I want it to look. but as I said, I want them to appear once I put the $10.00 in for each golfer.

Thanks in advance

Big Daddy J-Mos

Copy of Ocean_City_Scorebook-1.xlsm

see if this will work

updated with E F and G

Thanks ya all. This is a good "gross skins" worksheet. Are there any out there with Net Skins that take into account the difficulty (handicap) for each hole and compares to each players' index. a 10 index would get a stroke reduced from his actual score on the 10 toughest holes (handicap 1-10, 18 is easiest).