1 Attachment(s)
Help Required in Create and Open Folder and Track Changes
Hope you all are good and safe
Could somebody please help in modifying the codes as required below-
In the attached workbook there are two set of codes-
Sheet ("Follow-up Tracker")
Code checks the duplicates in column A and add a value in column V 'Follow-up Audit Files' against the row
And on selection change with Column V, it notifies the missing columns and creates / Open folder in the workbook path
/ Follow-up Audit Files/ Value in Column B / Value in Column A
I need help in changing the trigger from selection change to enter or double click in column V as now moving around the worksheet notifies and creates / open the folders
Sheet ("Track Changes")
I need to track only the changes in sheet "Follow-up Tracker' and not the changes in all the sheets and that too as per the example format given in sheet Track Changes 2
Cell Changed shall be Unique Code for the row and Column Heading for the column changed
Thanks in advance for your help!