Hi All
I have an Excel workbook (Excel 2002) which is accessed and modified by multiple people, there are 3 sheets within the workbook, 'Processing', 'Completed', and 'List Data'.
On the processing sheet there are open jobs with drop-down validation in 2 cells which fetches options from the list data sheet, this is fine but when the job is completed, the row is moved from the processing sheet to the completed sheet, however, I am having to go through daily and re-do the validation on the cells because people are Cut-Pasting into the completed sheet rather than Copy-Paste then clearing the cell contents.
Is there any way to automatically put the validation back in place after someone cuts the cells?