Results 1 to 7 of 7

Thread: Pulling Value From A Table
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    May 2019
    Location
    Kelowna
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Pulling Value From A Table

    Hi Everyone, I need some help automating an excel sheet I use at work. None of the "Excel Experts" at work can tell me how to do this. I'm not sure if it's even possible to do what I want to do.

    So we use this excel sheet to calculate shipping, the shipping rates are based off of where the load is going and how many pallets are being shipped. Right now we ave to manually look up and input the value for the skid rate and the number of pallets into the sheet used for the calculation.

    Is there a way to set 2 drop downs and have the sheet automatically pull the values into the right spots?

    I'm an absolute beginner to VBA, but I do have some programming experience with C#

    Any help with this would be hugely appreciated.

  2. #2
    Board Regular James006's Avatar
    Join Date
    Apr 2009
    Posts
    3,210
    Post Thanks / Like
    Mentioned
    18 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Pulling Value From A Table

    Hello,


    Is there a way to set 2 drop downs and have the sheet automatically pull the values into the right spots?
    Very probably ... a simple formula will do the job ... an ' Index / Match ' combination ... no need to use VBA ...

    But ... all of this will remain theoretical with the actual structure of your sheet ...

  3. #3
    Board Regular My Aswer Is This's Avatar
    Join Date
    Jul 2014
    Posts
    15,382
    Post Thanks / Like
    Mentioned
    27 Post(s)
    Tagged
    10 Thread(s)

    Default Re: Pulling Value From A Table

    Vba can do things like this but to provide you a script that will do this always requires specific details

    Like sheet name where on sheet are rates found and on and on

    Give us a example of what you want with specific details

    If I select Gas from a drop down List in column C and Select where the Gas is going in column D same row and how many pallets entered in column D same row put results in column E same row.

    See we need specific details like this.
    Be sure and always test this script on sample data the first time you use this as to avoid any problems with your data. Always trying to learn more and help others where I can. I'm using Excel 2013.
    Patience please Iím not perfect yet. "Memories are forever"

  4. #4
    New Member
    Join Date
    May 2019
    Location
    Kelowna
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Pulling Value From A Table

    Right now the rates are in a separate file ( I know, I have my work cut out for me). The way the rates are set up is the locations are are in column A and go down starting in cell A2, the number of pallets are in row 1 and start in cell B1 and go across. I need to move this data into the second sheet of the Excel file we use for calculating the costs. So, we would select the location from a drop down list based on the locations column. The number of pallets doesn't really need a drop down if there is a way of searching by the number the we put in a certain cell.

    I can probably upload a copy of the sheet we use for the calculations, but not the sheet filled with the rates.

  5. #5
    Board Regular My Aswer Is This's Avatar
    Join Date
    Jul 2014
    Posts
    15,382
    Post Thanks / Like
    Mentioned
    27 Post(s)
    Tagged
    10 Thread(s)

    Default Re: Pulling Value From A Table

    Thanks for that explanation. But still not many specific details.
    Like you said in another file. But you did not say the workbook name or where on the other Workbook.

    And I asked where the final Results should be entered and I did not see where you answered that question.

    This is beyond my knowledgebase.
    I will continue to monitor this thread to see what I can learn.
    Be sure and always test this script on sample data the first time you use this as to avoid any problems with your data. Always trying to learn more and help others where I can. I'm using Excel 2013.
    Patience please Iím not perfect yet. "Memories are forever"

  6. #6
    New Member
    Join Date
    May 2019
    Location
    Kelowna
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Pulling Value From A Table

    So I have figured out how to do this. It can be accomplished using the INDEX and MATCH functions. Here is a youtube video with a great explanation for how to use INDEX and MATCH.

    https://www.youtube.com/watch?v=F264FpBDX28&t=212s

  7. #7
    Board Regular James006's Avatar
    Join Date
    Apr 2009
    Posts
    3,210
    Post Thanks / Like
    Mentioned
    18 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Pulling Value From A Table

    Quote Originally Posted by MaxQTIme View Post
    So I have figured out how to do this. It can be accomplished using the INDEX and MATCH functions. Here is a youtube video with a great explanation for how to use INDEX and MATCH.

    https://www.youtube.com/watch?v=F264FpBDX28&t=212s
    Re,


    Please refer to message # 2 ... on may 10th ...

    Very probably ... a simple formula will do the job ... an ' Index / Match ' combination ... no need to use VBA ...

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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