matt-gilbert
Member
Hi. I need to create a dependant data validation list based on the adjacent cell value. I have done this before as per link below
http://www.contextures.com/exceldatavaldependindextablesindirect.html
This method however does not suit my requirement. My spreadsheet is attached and my requirement is as follows;
1. tbl_Cable_Schedule needs a drop down list in col B (Drum No). I would like the list to only show Drum No's that have the Cable Type as shown on adjacent cell in col A. Drum No comes from tbl_Drum_Schedule. For example, validation list on tbl_Cable_Schedule cell B6 should only list 1 and 6.
2. It would be nice for validation list to show tbl_Drum_Schedule col F records so that I don't have to keep switching back and forth to see how much cable is left on a particular drum. I have shown this under tbl_Cable_Schedule.
Any help would be greatly appreciated. Thanks!
Matt
http://www.contextures.com/exceldatavaldependindextablesindirect.html
This method however does not suit my requirement. My spreadsheet is attached and my requirement is as follows;
1. tbl_Cable_Schedule needs a drop down list in col B (Drum No). I would like the list to only show Drum No's that have the Cable Type as shown on adjacent cell in col A. Drum No comes from tbl_Drum_Schedule. For example, validation list on tbl_Cable_Schedule cell B6 should only list 1 and 6.
2. It would be nice for validation list to show tbl_Drum_Schedule col F records so that I don't have to keep switching back and forth to see how much cable is left on a particular drum. I have shown this under tbl_Cable_Schedule.
Any help would be greatly appreciated. Thanks!
Matt