How do you automatically transfer data from one spreadsheet to another spreadsheet?

Hi,

I am trying to do some record keeping of nba stats. basically, what i would like to do in spreadsheet1 is have two columns where column one is "teams" and column two is "points". I would like to be able to transfer the data from column 2 into a second spreadsheet. However, the data from column two that is transferred to the second spreadsheet is dependent on what team i enter in column one. Ex. Every time that i enter "Minnesota" in column one, the corresponding point value in column two would be sent to a specific location in my second spreadsheet for my minnesota stats. then if i entered "miami" in column one, the corresponding points in the second column would be sent to the second spreadsheet where i want to record my miami stats. this would go on for all the teams in the nba. Note: there are 31 teams so whatever function that could do this would have to be able to recognize 31 team names. Hopefully i worded this in an understandable fashion

Thanks,

Dan

I think this is on the right path. However I was imagining something slightly different. I will try give a more specific example from a game last night and attach a template spreadsheet. Since I dont know how to do the code I will try explain where I see everything going in the template.

Example game: Min was the away team and Was was the home team. Min scored 93 and Was scored 72. So in the worksheets I would like to input this data into the master worksheet. Min goes into cell A2, 93 goes into cell B2, Was goes into cell C2, and 72 goes into cell D2. Now what I would like to automatically happen as I do this is: 93 will transfer to cell C3 in my "Min" worksheet and also cell B3 in my "Was" worksheet. 72 will be sent to cell D3 in "Min" worksheet and also in cell A3 in "Was" worksheet. The reason for this is its assigning the correct stats to the home/away and points for/points against to the designated columns for their respective teams. My goal is to be able to input data into one worksheet and all the stats will be correctly assigned to each teams respective stat columns. Obviously my template is small scale (only two teams), and I will have to scale up to 31 teams once I understand how to write a macro for this.

Thanks,

Dan

NBAstats.xlsx