View Single Post
 
Old 04-16-2019, 10:48 PM
ArviLaanemets ArviLaanemets is offline Windows 8 Office 2016
Expert
 
Join Date: May 2017
Posts: 873
ArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud of
Default

In case every field in columns OD:Speed can have only a certain set of values determined by description, it is possible using data validation lists in all fields, and making those lists depending on selection in column Description. It doesn't ecxactly restrict the entry, but for columns you want to restrict entry there will be nothing allowed to enter (the data validation list will be empty).

Otherwise I don't see a way for this. VBA doesn't help, as there is no event fired on activating another cell (as much as I know).
Reply With Quote