+ Reply to Thread
Results 1 to 3 of 3

VLOOKUP to loop over every 2nd worksheet

  1. #1
    Registered User
    Join Date
    04-08-2009
    Location
    ireland
    MS-Off Ver
    Excel 2003
    Posts
    4

    VLOOKUP to loop over every 2nd worksheet

    Hello,

    I have attached a worksheet that I need some help on. I have created a master sheet and in this I want to pull certain data of every player from the 'OnBall' sheets - I can get this working for one 'OnBall' sheet using a VLOOKUP but is there a way to add the values required from all the 'OnBall' sheets and can the addition be automatic if a new sheet is added?

    also, the real names on the 'OnBall' may change position or be completely different.

    many thanks,

    sergio
    Attached Files Attached Files
    Last edited by sergio12; 04-24-2009 at 09:42 AM. Reason: solved

  2. #2
    Registered User
    Join Date
    04-08-2009
    Location
    ireland
    MS-Off Ver
    Excel 2003
    Posts
    4

    Re: VLOOKUP to loop over every 2nd worksheet

    hello,

    I have had a bit of luck in my VLOOKUP and got some of it working, so maybe someone will understand a little better what I'm tryingto do.

    basically, I have a new spreadsheet attached with a master sheet that pulls the data from the Game1OnBall sheet into the master sheet - my problem is that I want to pull the data from the Game2OnBall sheet and add the values, in an automatic way, so that if I add another sheet, called Game3OnBall, the master sheet will pick these up automatically - is this possible?

    also, I've hid the players' real names and just called them player1 to player17, but the order of these may change depending on the game and new names could also be entered - would this be a problem?


    Thanks,

    Sergio
    Attached Files Attached Files

  3. #3
    Forum Expert
    Join Date
    06-18-2004
    Location
    Canada
    MS-Off Ver
    Office 2016
    Posts
    1,474

    Re: VLOOKUP to loop over every 2nd worksheet

    Post deleted...
    Last edited by Domenic; 04-17-2009 at 05:38 PM.

+ 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