Copy cell contents to another table without Duplications
I have a pool that I administrate and I have been manually inputting a lot of the data. I would like to find a way to "automate" the following functions. I apologize in advance if the answers are somewhere within the forum but I have been unable to locate them.
Question #1:
I want to fill all the names from the Player columns in Table 1 into Table 2 but not duplicate the entries. Would I use some form of the LOOKUP function?
Question #2:
I would like the amounts I fill in next to the Players in Table 2 Winnings column to copy to the corresponding Players Winnings column in Table 1.
Question #3:
I have 25 Weeks and 20 Participants in my sheets. I am using a dropdown list for choosing the Players in Table 1. I know that Numbers 09 cannot populate that dropdown list from another dynamic list so I could update them in just one place. I know this is possible in Excel but can it be done in the new version of Numbers?
Here is an example of what the sheets would look like:
TABLE 1 TABLE 2
Numbers 09-OTHER