Member Avatar for Will Gresham

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
  • 100 Views
  • 4 Days Discussion Span
  • Latest Post Latest Post by Will Gresham
Member Avatar for ajithraj

can u pls specify it more clearly

Member Avatar for Will Gresham

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?

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.