home/categories/business-apps/ecnu-icalk-autoskill-skillbank-convskill-english-gpt3-5-8-excel-vba-composite-key-duplicate-prevention-skill-md
business-appsbusiness
excel-vba-composite-key-duplicate-prevention
Generates a VBA Worksheet_Change macro to prevent duplicate entries based on two columns (e.g., Company Name and Invoice Value). It triggers on entry in the second column, checks for existing matching pairs, alerts the user with the row number of the duplicate, and clears the new entry.
maintainer
ECNU-ICALK
अपडेट किया गया 3/16/2026
स्टार
304
फोर्क
34
quick start
Installation and usage
Generates a VBA Worksheet_Change macro to prevent duplicate entries based on two columns (e.g., Company Name and Invoice Value). It triggers on entry in the second column, checks for existing matching pairs, alerts the user with the row number of the duplicate, and clears the new entry.
इंस्टॉलेशन
$ install --globalskills.sh
उपयोग
इंस्टॉल करने के बाद, आप टर्मिनल में यह कमांड चलाकर इस स्किल का उपयोग कर सकते हैं:
skills use excel-vba-composite-key-duplicate-prevention