DATABASE sheet on attached lists various jobs.
STATUS sheet should list jobs that are currently scheduled and those that have been completed.
Sheet Change macro below has two issues:
(a) Macro does not "fire" every time a number is added or changed in Col K of the Database, even though I have set Application.EnableEvents = True at the outset AND declared it in the Immediate window.
(b) When it does work it copies the relevant record perfectly to the CURRENT Section of the STATUS sheet, but if a date is then entered in Col M it is not moving the record in the STATUS from Scheduled to Completed, and when it copies the Completed Date from the Database it is posting it in Col 6 and not Col 5.
All solutions, suggestions and alternatives welcome as ever.Please Login or Register to view this content.
Ochimus
Bookmarks