+ Reply to Thread
Results 1 to 5 of 5

Picking datas from other sheets

  1. #1
    Registered User
    Join Date
    07-06-2023
    Location
    Venezia, Italy
    MS-Off Ver
    Google sheets
    Posts
    3

    Lightbulb Picking datas from other sheets

    Hello, I believe for most of you it is a simple question, but I miss some steps.

    In the same document I have 2 sheets:
    -SHEET 1: it is a competition schedule. Every day corresponds at a different match, and every Match have a different GameID;
    -SHEET 2: I have some strings that contain various infos, and one of the info is the GameID.

    The thing I'd like to do is:
    in SHEET 2 i'd like to have a cell with a menu with all the matches that I have in SHEET1 in oprder to choose the match I need. As soon as I choose one match from the menu, I'd like to have the correspondent GameID in the next cell.

    Thanks

  2. #2
    Forum Contributor
    Join Date
    12-17-2013
    Location
    ON, Canada
    MS-Off Ver
    MS 365
    Posts
    171

    Re: Picking datas from other sheets

    Hi manaberto,

    Have a look at sheet 2 in this LINK. It uses a dropdown in cell A2 and an xlookup in cell B2. Is this what you're looking for?

  3. #3
    Registered User
    Join Date
    07-06-2023
    Location
    Venezia, Italy
    MS-Off Ver
    Google sheets
    Posts
    3

    Re: Picking datas from other sheets

    Hi Flyboy65, I don't see the dropdown I just see a cell with Match "A" in sheet 2, A2. But yes the idea is that. Having a schedule similar to sheet 1, I'd like to have a dropdown in Sheet2 in which, selecting the match (A,B,C,D...) I'm able to have the correspondent Game ID in the next cell

  4. #4
    Forum Contributor
    Join Date
    12-17-2013
    Location
    ON, Canada
    MS-Off Ver
    MS 365
    Posts
    171

    Re: Picking datas from other sheets

    If you click on the downturned arrow in cell A2, you'll see a list of all the matches. Select one and you'll see the game ID in the next cell change.

  5. #5
    Registered User
    Join Date
    07-06-2023
    Location
    Venezia, Italy
    MS-Off Ver
    Google sheets
    Posts
    3

    Re: Picking datas from other sheets

    Super. Thanks a lot

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Sum datas by date across different sheets
    By ikimashu in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-03-2022, 12:06 PM
  2. [SOLVED] Code runs in small datas but not working perfectly in bigger datas
    By RAJESH SHAH in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-04-2021, 10:28 PM
  3. how to retrieve datas from sheets to combobox?
    By jeffersonss in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-18-2019, 02:29 AM
  4. VBA for loop and Compare od datas in two different sheets
    By sarajun_88 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-01-2014, 06:33 AM
  5. datas between sheets
    By mertserveren in forum Excel General
    Replies: 5
    Last Post: 02-28-2014, 08:31 AM
  6. how to get automatic updation of datas in all Sheets
    By relianceaaa in forum Excel General
    Replies: 0
    Last Post: 02-13-2014, 03:28 PM
  7. compare oracle table datas and excel datas
    By james94539 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-01-2013, 03:48 PM

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