I would like to be able to enter weekly earnings in the first worksheet and then have that data auto-populate into the rest of the worksheets.
For example:
If Robert Allenby earns 100,000 in week one, I would like to enter that value into the "Player Earnings" worksheet in cell B6. I would like that data to then appear in cell C20, C33, and C46 on "The Masters" worksheet and in other cells if another participant adds Robert Allenby to his team. I would like the week 2 amount (C6 from the "Player Earnings" sheet) to populate into all the correct places on the "RBC Heritage" worksheet and so forth for 19 weeks.
I would appreciate if anyone could offer adcive on how to accomplish this task. Each participant will have 10 golfers on their team, and many will be duplicates. I would like to enter the earnings for each golfer only once per week if possible.
Thanks!
Bookmarks