Pulling Value From A Table

MaxQTIme

New Member
Joined
May 9, 2019
Messages
3
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.
 

Some videos you may like

Excel Facts

Whats the difference between CONCAT and CONCATENATE?
The newer CONCAT function can reference a range of cells. =CONCATENATE(A1,A2,A3,A4,A5) becomes =CONCAT(A1:A5)

James006

Well-known Member
Joined
Apr 4, 2009
Messages
3,680
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 ...
 

My Aswer Is This

Well-known Member
Joined
Jul 5, 2014
Messages
16,743
Office Version
2013
Platform
Windows
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.
 

MaxQTIme

New Member
Joined
May 9, 2019
Messages
3
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.
 

My Aswer Is This

Well-known Member
Joined
Jul 5, 2014
Messages
16,743
Office Version
2013
Platform
Windows
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.
 

James006

Well-known Member
Joined
Apr 4, 2009
Messages
3,680

Watch MrExcel Video

Forum statistics

Threads
1,096,411
Messages
5,450,272
Members
405,599
Latest member
capcomdevil

This Week's Hot Topics

Top