Dundee Lad
Active Member
- Joined
- Sep 6, 2003
- Messages
- 311
I need to make 2 columns with lists in each row.
in column A lets say the list would be 1-50, when someone clicks into the cell to enter a number then the drop down would appear and they could choose 1-50.
In Column B if they chose say the value of 1 in Column A then in column B I would only want them to be able to pick from A-D. If they chose 2 in Column A then column B would be E-F
hope this makes sense,
in column A lets say the list would be 1-50, when someone clicks into the cell to enter a number then the drop down would appear and they could choose 1-50.
In Column B if they chose say the value of 1 in Column A then in column B I would only want them to be able to pick from A-D. If they chose 2 in Column A then column B would be E-F
hope this makes sense,