+ Reply to Thread
Results 1 to 2 of 2

locating cells using a variable

  1. #1
    Registered User
    Join Date
    03-15-2007
    Posts
    53

    locating cells using a variable

    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.

  2. #2
    Valued Forum Contributor
    Join Date
    07-11-2004
    Posts
    851
    for the first part it sounds like you need to use the INDIRECT function. for the second part, once the data is in you can always select a region and copy, paste special values.
    not a professional, just trying to assist.....

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1