excel-vba-composite-key-duplicate-prevention

By ECNU-ICALK. Updated March 16, 2026. Categories: Business Apps.

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.

View repository on GitHub

SKILL.md

The description above is the indexed summary. With JavaScript enabled, this page also loads the SKILL.md text from GitHub.