+ Reply to Thread
Results 1 to 9 of 9

Auto fill data from another sheet

  1. #1
    Registered User
    Join Date
    03-12-2017
    Location
    Westcoast NewZeland
    MS-Off Ver
    2021
    Posts
    12

    Auto fill data from another sheet

    Hello, Im trying to create a BOP sheet where i input product codes and their descriptions are auto filled from another sheet.
    I cannot seam to do this with help!

    I have a list in page two looks like this.
    collumA= product code. Collumn B= product description.

    Page 1 needs to auto populate the data from collum b depending on what code was selected from collumn A.

    Any tips?
    Last edited by BelleH123; 03-13-2017 at 06:40 PM.

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    35,973

    Re: Auto fill data from another sheet

    Try:
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Trevor Shuttleworth - Excel Aid

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Registered User
    Join Date
    03-12-2017
    Location
    Westcoast NewZeland
    MS-Off Ver
    2021
    Posts
    12

    Re: Auto fill data from another sheet

    That ones says there is a problem with the Formula?
    I tried it on a blank excel too just to double check.

  4. #4
    Forum Expert
    Join Date
    12-11-2011
    Location
    Netherlands
    MS-Off Ver
    office 365
    Posts
    2,953

    Re: Auto fill data from another sheet

    Change the comma in semicolon.
    Maybe that will help.
    If it does'nt upload a small excel file.
    Willem
    English is not my native language sorry for errors
    Please correct me if I'm completely wrong

  5. #5
    Registered User
    Join Date
    03-12-2017
    Location
    Westcoast NewZeland
    MS-Off Ver
    2021
    Posts
    12

    Re: Auto fill data from another sheet

    Ok here is a simple excel sheet that might help me explain myself!

    Thanks so much guys.
    Attached Files Attached Files

  6. #6
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    35,973

    Re: Auto fill data from another sheet

    Please help me with a formula. If I type 200ch in A1, I would like B1 to auto populate with 5.016. The part numbers and coades are specified on the second sheet.
    Cell B1:
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    or, depending on Regional Settings:

    Cell B1:
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    That is, change all the commas to semi-colons

  7. #7
    Registered User
    Join Date
    03-12-2017
    Location
    Westcoast NewZeland
    MS-Off Ver
    2021
    Posts
    12

    Re: Auto fill data from another sheet

    test.JPG
    Please see attached pic

  8. #8
    Registered User
    Join Date
    03-12-2017
    Location
    Westcoast NewZeland
    MS-Off Ver
    2021
    Posts
    12

    Re: Auto fill data from another sheet

    Whoops! i had a ' instead of a " !!!!

    Thanks heaps! its working perfectly.

  9. #9
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    35,973

    Re: Auto fill data from another sheet

    You're welcome.

    Usually easier to copy and paste rather than retype, especially for long or complex formulae



    If you are satisfied with the solution(s) provided, please mark your thread as Solved.


    New quick method:
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

    Or you can use this way:

    How to mark a thread Solved
    Go to the first post
    Click edit
    Click Go Advanced
    Just below the word Title you will see a dropdown with the word No prefix.
    Change to Solved
    Click Save


    You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.

+ 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. Replies: 4
    Last Post: 07-19-2016, 05:20 AM
  2. auto fill data that repeat every 33 rows into another sheet
    By bonnetjt in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-11-2014, 11:53 AM
  3. Auto fill out exact matching data for multiple entries from another sheet
    By ryan4646 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-10-2013, 07:05 AM
  4. How to Auto Fill data from on sheet to another
    By Papalue in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 08-06-2012, 10:55 PM
  5. Replies: 28
    Last Post: 02-03-2012, 05:12 AM
  6. Multiple Timesheets, auto fill from data sheet
    By edwinkbell in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-15-2009, 05:26 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