You are reading a single comment by @aggi and its replies.
Click here to read the full conversation.
aggi-
That looks fuller than the one I read last night.
... Or maybe I'm less tired.
@Chalfie - cheers for the links. TBH Idk why I'm even doing this, I should probably just send the sheet and thst link to the team using it. "yeah if you could just make sure the codes don't get mixed up that would be great."
It's for a sheet that gets uploaded to a system Fwiw.
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.