+ Reply to Thread
Results 1 to 8 of 8

How to tell excel to autofil from database to sheet specific names/results

  1. #1
    Registered User
    Join Date
    05-17-2017
    Location
    oslo
    MS-Off Ver
    2016
    Posts
    6

    How to tell excel to autofil from database to sheet specific names/results

    Hey

    How can i tell excel to autofil from database to sheet specific names

    Example:

    In Database I got results for my team

    and in Sheet1 i got results and names

    How can i tell excel to recognize result from database and sheet so it can autofil in sheet with correct names
    I hope you understood ,I know it's confusing :D

    Plz help me

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2405 Win 11 Home 64 Bit
    Posts
    23,873

    Re: How to tell excel to autofil from database to sheet specific names/results

    Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Registered User
    Join Date
    05-17-2017
    Location
    oslo
    MS-Off Ver
    2016
    Posts
    6

    Re: How to tell excel to autofil from database to sheet specific names/results

    Done, Uploaded

    Edit:

    i Want to fill names from database to sheet1 automatic but the names Is not in order something I should bring
    Attached Files Attached Files
    Last edited by supermann; 05-22-2017 at 03:04 PM.

  4. #4
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2405 Win 11 Home 64 Bit
    Posts
    23,873

    Re: How to tell excel to autofil from database to sheet specific names/results

    A little bit confused. Where do you want the names to appear. Is the criteria the name of the team only?

    Perhaps using the Vlookup function would be the answer. Here is a link to it.
    https://www.techonthenet.com/excel/formulas/vlookup.php

  5. #5
    Registered User
    Join Date
    05-17-2017
    Location
    oslo
    MS-Off Ver
    2016
    Posts
    6

    Re: How to tell excel to autofil from database to sheet specific names/results

    Yes.

    i want the names to be moved from database to sheet1 in the correct teams

    edit: I want to "tell excel to bring me the list of names to the correct teams, i will have the teams and names in database
    but only teams in sheet1, so when i add team " para " in my sheet1 so the excel can recognize the names with "team para" that i have in my database so it can fill out the teams with win or loss

    I will have many database with database1 win/loss, database2 $(money), database3 names
    so i want excel to understand when i have similar teams in database and sheet1 so it can fill out the rest like , results or money automatically in sheet1

    I know its a little bit confusing :D


    I will try Vlookup function

    Edit2: i looked for Vlookup function in youtube, and i think this is the correct tool i need, is it possilbe that i can choose source from database1 databse 2, databse3 etc to sheet1 ?

    Thanxx <3
    Last edited by supermann; 05-22-2017 at 04:32 PM.

  6. #6
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2405 Win 11 Home 64 Bit
    Posts
    23,873

    Re: How to tell excel to autofil from database to sheet specific names/results

    i want the names to be moved from database to sheet1 in the correct teams
    I understood this part. What cells do you want them in?


    I will have many database with database1 win/loss, database2 $(money), database3 names
    So each look up will have multiple criteria?

    database1 Win
    database1 Lose
    database2 Money

    Is this correct? I am having a hard time understanding your criteria for searching for the team members. Can you be more specific in describing your criteria.

  7. #7
    Registered User
    Join Date
    05-17-2017
    Location
    oslo
    MS-Off Ver
    2016
    Posts
    6

    Re: How to tell excel to autofil from database to sheet specific names/results

    Thats correct hehe

    Will the Vlookup function work with many database?

  8. #8
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2405 Win 11 Home 64 Bit
    Posts
    23,873

    Re: How to tell excel to autofil from database to sheet specific names/results

    It can but you will have to nest the Vlookups within IFError statements assuming that your databases are on separate worksheets. Give it a shot and if you run into issues, post back with what you have and what you want.

+ 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. copy specific columns from variable sheet names to specific sheet tab
    By JEAN1972 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-23-2017, 05:50 PM
  2. [SOLVED] A formula which results in a list of names based on specific criteria
    By Eftychia in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 08-18-2016, 12:15 PM
  3. [SOLVED] Copying only specific file names from a directory based on Excel Sheet
    By pynergee in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-20-2016, 12:21 PM
  4. Linking a names database in one sheet to another sheet
    By Hazard6175 in forum Excel General
    Replies: 1
    Last Post: 09-05-2014, 01:36 AM
  5. Replies: 11
    Last Post: 10-21-2012, 01:40 AM
  6. Execute multiple SQL queries on a specific oracle database and log results in excel
    By harsh2209 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-08-2012, 01:38 PM
  7. Querying SQL database and putting results in specific columns of excel
    By invent1 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-21-2012, 03:53 AM

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