Hi All
Found the site searching the web while trying to find help in creating a spreadsheet i am trying to create. I only have a basic knowledge of excel and would love to learn more and thought this place looked like the right place to do this.
I dont know how to explain this but i will give it a shot.
i have 2 sheets the second sheet contains the following information
first column is steel size, the second column is the weight for that steel section in calculated in meters. Ie 75x40 is 5.92kg for 1 meter
My first sheet i want to create the following
a Data validation list which i can select the steel size (i know how to create this).
When i have chosen the steel size from the list i want it to display its weight in the next column next to the list as shown above.
how do i create this?
i have a few other questions, but dont want to bomb the first thread with everything
Thanks in advance
Kyle
Found the site searching the web while trying to find help in creating a spreadsheet i am trying to create. I only have a basic knowledge of excel and would love to learn more and thought this place looked like the right place to do this.
I dont know how to explain this but i will give it a shot.
i have 2 sheets the second sheet contains the following information
75 x 40 | 5.92 |
100 x 50 | 8.33 |
125 x 65 | 11.9 |
150 x 75 | 17.7 |
180 x 75 | 20.9 |
200 x 75 | 22.9 |
230 x 75 | 25.1 |
250 x 90 | 35.5 |
300 x 90 | 40.1 |
380 x 100 | 55.2 |
first column is steel size, the second column is the weight for that steel section in calculated in meters. Ie 75x40 is 5.92kg for 1 meter
My first sheet i want to create the following
a Data validation list which i can select the steel size (i know how to create this).
When i have chosen the steel size from the list i want it to display its weight in the next column next to the list as shown above.
how do i create this?
i have a few other questions, but dont want to bomb the first thread with everything
Thanks in advance
Kyle