You are reading a single comment by @hugo7 and its replies.
Click here to read the full conversation.
London Fixed Gear and Single-Speed is a community of predominantly fixed gear and single-speed cyclists in and around London, UK.
This site is supported almost exclusively by donations. Please consider donating a small amount regularly.
aggi
@hugo7
I have two columns where I want to restrict fields/Data Validation for cells to a range. Easy enough.
However, I wan the 2nd column to be dependent on the first, which is where it seems to break.
eg
|Column A|Column B|
|Road Bike|All the Gears|
|Sweet Fixie|1 Gear|
|Single Speed|1Gear|
So when I type "Sweet Fixie" in a cell in column A, then the corresponding cell in Column B will only let me type "1 Gear".
Also the fields are in a 2nd tab which makes the cell path really long for the tiny fields box.
Any ideas?
I found something about naming cells, but it didn't really help.