Ok what I have this time is about 200 NBA games November 2006. Each play by play is on a seperate sheet with a title in a format ROADTEAM@HOMETEAMDATE for example ATL@PHI11-01-2006. So far so good.
Then on the first sheet I have a database that I am compiling.
Date Team Opp H/A 1Tass 2Tass 3Tass 4Tass
11/1/06 PHI ATL H 3 4 8 4
This is a small sample but gives an idea of the format.
Date being A1 etc.
Currently the first few lines of data have been copied and pasted from their respective sheets manually. This will be very time consuming since my project is to do the last 8 years of NBA stats.
In E2 which is First Quarter Team Assists the number 3 has been copied and looks like this ='ATL@PHI11-01-2006'!$F$2. Now, all the info to call up the sheet, is in columns A B and C in my database. So my question is, in the function to call for the sheet ATL@PHI11-01-2006 can I somehow put cell numbers in place example A2@A3A1? I hope that I am explaining this well enough. I tried to guess and came up with ='"&A2&"@"&A3&"'!$F$2 but as I have only used excel for 2 weeks and have no training I am quite clueless.....I was just taking a stab at it.
Any help is appreciated thanks in advance.
I also have one more question. Once I have all the stats in the database, how can I make it so that the numbers in the database for example E2 is ='ATL@PHI11-01-2006'!$F$2 but I want to change it so the function is gone and just leaves the number 3. Thanks again in advance.
Bookmarks