anish.ms
11-11-2020, 09:24 AM
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!
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!