0

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?

2
Contributors
2
Replies
3
Views
8 Years
Discussion Span
Last Post by Will Gresham
0

Not sure how I can put it any clearer...

Is there any way to automatically put the validation back into cells after someone cuts/deletes the values?

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.