Hi,
i have lots of dropdowns in different columns, i.e E6:E405 J6:J405 etc, the dropdown is using an if to check if holidays are allowed, depending if this is yes or no it will show one of two lists, one with holidays,lieu,unpaid and one without just showing things like shift swap etc.
because of this i need to prevent cells being overridden unless the value is in the list being used, this is because the holiday availability is now used and needs to be locked down, but i need to be able to enter the other options still, is there anyway to prevent the cells being overwritten ? ideally still being able to copy and paste dropdown values only.
Thanks
i have lots of dropdowns in different columns, i.e E6:E405 J6:J405 etc, the dropdown is using an if to check if holidays are allowed, depending if this is yes or no it will show one of two lists, one with holidays,lieu,unpaid and one without just showing things like shift swap etc.
because of this i need to prevent cells being overridden unless the value is in the list being used, this is because the holiday availability is now used and needs to be locked down, but i need to be able to enter the other options still, is there anyway to prevent the cells being overwritten ? ideally still being able to copy and paste dropdown values only.
Thanks