pick list and Data Validation
Hi,
Is there a way how to get sheet that has been filled with "Pick from drp-Down list" method to be updated in a way that it would be possible to use Data Validation? BR makelei |
pick list and Data Validation
Hi,
Take a look at Debra webpage http://www.contextures.com/xlDataVal02.html#TwoWord "Makelei" wrote: Hi, Is there a way how to get sheet that has been filled with "Pick from drp-Down list" method to be updated in a way that it would be possible to use Data Validation? BR makelei |
pick list and Data Validation
Thanks Eduardo,
I have used these featurea often and are working just fine. My problem is that someone has started to update the table with mouse right click using "Pick From Drop-down List". Now when this is used it will disable visibility of data validation feature. Actually you are able to define it, but when cell is activated, arrow and list will not be visible. This is the very first time I have come agross this and do not know how to return back and get this data validation to work as it should. BR Makelei "Eduardo" wrote: Hi, Take a look at Debra webpage http://www.contextures.com/xlDataVal02.html#TwoWord "Makelei" wrote: Hi, Is there a way how to get sheet that has been filled with "Pick from drp-Down list" method to be updated in a way that it would be possible to use Data Validation? BR makelei |
All times are GMT +1. The time now is 03:39 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com