Dear Experts,
Need your Support for my subjected Query…
In the attached workbook there are four worksheets!
Reference: - It has the details of worksheet Name and Name Range against worksheet where the tracking to be done and it’s a Dynamic content (VBA must refer Name Range from C2:C3)!
ProjectA 08Nov2016: - Daily Production commitment for a Project!
ProjectB 08Nov2016: - Daily Production commitment for a Project!
Changes Tracker: - (This is Where I need your expertise suggestion)
1. In Project_A Name Range (anywhere) for an Example C7 Cell; When I am trying to Edit the content, my created User form to be popped up
2. Requested by, Reason for Changes & Remarks I will enter it then, When I am press “Add to Database”
3. Requested by Content to be updated in C Column Last Blank Cell. Reason for Changes content to be updated in Column D Last Blank Cell. Remarks Content to be updated in Column E Last Blank Cell Respectively
4. Whichever cell I am trying to Edit, in this Cast it is C7, The First column that is Column A and same Row content to be updated in Column B Last Blank Cell (In this case it is Product 6)
5. In Column A Last Blank cell, the current Date & Time to be updated.
After completion of “Changes Tracker” Worksheet updation, Now Excel should allow us to edit in the specified Name Range up to 60 Seconds from completion of “Changes Tracker” Updation or Saving of File (Which is First comes Up). After that for any further changes excel should demand a User form filling.
Above actions must be applicable for both the Name Range which is mentioned in Reference worksheet C2:C3
After User form popup, If I press cancel at any time, User form must close without any actions in changes tracker.
Looking forward, Your suggestion for the same.
Thanks & Regards,
Rajeshkumar R
Bookmarks