I am trying to create a drop down list that will vary from cell to cell, depending on a set criteria.
In Col A there will be one of three possible codes (e.g.A, B or C). The drop down list (col B)will change depending on the code selected. I've tried it with validation lists but it means changing the lookup for each individual cell in col B. I have no idea about Visual Basic so I'm trying for a solution another way. Can anybody help please??
In Col A there will be one of three possible codes (e.g.A, B or C). The drop down list (col B)will change depending on the code selected. I've tried it with validation lists but it means changing the lookup for each individual cell in col B. I have no idea about Visual Basic so I'm trying for a solution another way. Can anybody help please??