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.

ECNU-ICALK
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