Hello all
I am having trouble finding a way to do the following and any help would be very much appriciated:
I have a list of different types of pipes which will be updated from time to time in there seperate table. Example table below The actual List however is 1000 lines. (note the last two columns are calculation results based on othe column omitted for clarity, the rest are data entries)
<tbody>
</tbody>
What i need is to be able to select the pipe material via a drop down list in a separate work sheet (but must only be unique entries) from this selection it will allow me to select the unique pipe diameters in the next cell over drop down list. then from these two it will allow me to select the unique pressure class from the third drop down list. from these three selections i will then populate cells 4 and 5 next to the drop down lists with the corresponding data in columns 4 and 5 in the above table.
I'm sorry if i have missed a similar example in the forum my seach returned alot of data validation examples but i have tried it using a little vb and the advanced filter function but all i can get to is the pipe diameter after that it is beyond my abilities i think.
Thank for the help
Mat
I am having trouble finding a way to do the following and any help would be very much appriciated:
I have a list of different types of pipes which will be updated from time to time in there seperate table. Example table below The actual List however is 1000 lines. (note the last two columns are calculation results based on othe column omitted for clarity, the rest are data entries)
Material | Pipe Nominal Diameter | Pipe pressure class | Actual Internal Diameter | Velocity of fluid |
uPVC | 200 | Class 20 | 186 | 10 |
Ductile Iron | 200 | C30 | 201 | 15 |
Steel | 150 | 4.5mm 300W | 153 | 1 |
oPVC | 63 | Class 16 | 52 | 2 |
uPVC | 160 | Class 16 | 156 | 5 |
Ductile Iron | 250 | K9 | 251 | 6 |
HDPe | 450 | PN 16 PE 100 | 402 | 8 |
HDPe | 50 | PN 12.5 PE100 | 42 | 55 |
OPVC | 75 | Class 6 | 65 | 68 |
<tbody>
</tbody>
What i need is to be able to select the pipe material via a drop down list in a separate work sheet (but must only be unique entries) from this selection it will allow me to select the unique pipe diameters in the next cell over drop down list. then from these two it will allow me to select the unique pressure class from the third drop down list. from these three selections i will then populate cells 4 and 5 next to the drop down lists with the corresponding data in columns 4 and 5 in the above table.
I'm sorry if i have missed a similar example in the forum my seach returned alot of data validation examples but i have tried it using a little vb and the advanced filter function but all i can get to is the pipe diameter after that it is beyond my abilities i think.
Thank for the help
Mat