Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2006
    Location
    Huddersfield, UK
    Posts
    154

    Unanswered: Linking data from another sheet to a drop down list...

    Hiya;

    I'm not as well versed with excel as access, and have encountered a slight stumbling block i hope someone can help me with.

    I have various bits of data all over a workbook (sheets 1 - 4) and I have the kew bits of data i need gathered from these other sheets on a master sheet (to hide) - This is sheet 6

    What I am working on is sheet 5

    in Col A - i have labels, col B has a drop down box that is linked to data in sheet 6

    What I need are for the other fields C - K to auto-populate depending on what is selected in Col B

    The data for the drop down, as i mentioned is stored in sheet 6, and the associted data is there also.


    Eg:
    ===A====|===B====|====c===|====d====| ----->etc
    Label |Drop Down|<--auto from B------------>

    Any help would be great on this,

    Dan
    sometimes simple is best.... and i'm just a simple fellow.

  2. #2
    Join Date
    Apr 2006
    Location
    Huddersfield, UK
    Posts
    154
    no need to reply now, i have done a lot of scouring the web today and found the solution... eventually.

    looks what i needed was a vlookup formula...

    dan
    sometimes simple is best.... and i'm just a simple fellow.

Posting Permissions

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