← All skills

Excel VBA Duplicate Prevention for Composite Keys (Columns A and D)

100 / 100 · Low risk

Fine to try.

By ECNU-ICALK/AutoSkill (GitHub) · data · 613 stars · scanned at commit 94c47ca

Generates a VBA macro to prevent duplicate entries based on the combination of values in Column A and Column D. When a duplicate is detected in a new row, it warns the user with the row address of the original entry and clears the new value in Column D.

Works with any agent that supports SKILL.md skills.

What this skill can do

We found nothing in the files we read that matches our rules. That does not prove the skill is safe: see the limits of static scanning.

Install

Paste this into your terminal. It downloads exactly the version we scanned, not whatever is newest.

if [ -e ~/.agents/skills/'excel-vba-duplicate-prevention-for-composite-keys-columns-a-and' ] || [ -L ~/.agents/skills/'excel-vba-duplicate-prevention-for-composite-keys-columns-a-and' ]; then echo 'A skill folder named excel-vba-duplicate-prevention-for-composite-keys-columns-a-and already exists — not replacing it' >&2; false; else d=$(mktemp -d) && git clone --quiet --filter=blob:none --no-checkout 'https://github.com/ECNU-ICALK/AutoSkill' "$d" && git -C "$d" checkout --quiet '94c47ca488d4ba4117d20272e66d49b9877e68cf' -- 'SkillBank/ConvSkill/english_gpt3.5_8_GLM4.7/excel-vba-duplicate-prevention-for-composite-keys-columns-a-and-' && mkdir -p ~/.agents/skills && cp -R "$d"/'SkillBank/ConvSkill/english_gpt3.5_8_GLM4.7/excel-vba-duplicate-prevention-for-composite-keys-columns-a-and-' ~/.agents/skills/'excel-vba-duplicate-prevention-for-composite-keys-columns-a-and' && rm -rf "$d"; fi

Codex reads ~/.agents/skills directly. For Claude Code, Cursor, Copilot, Gemini CLI, Antigravity or OpenCode, also link it. For Claude Code: ln -s ~/.agents/skills/'excel-vba-duplicate-prevention-for-composite-keys-columns-a-and' ~/.claude/skills/'excel-vba-duplicate-prevention-for-composite-keys-columns-a-and' (other agents: ~/.cursor/skills, ~/.copilot/skills, ~/.gemini/skills, ~/.gemini/config/skills, ~/.config/opencode/skills). Or install through the finder skill, which does both.

Badge for your README

The badge for ECNU-ICALK/AutoSkill shows the score of its lowest-scoring skill.

[![SkillTrust](https://zalavijaysinh.github.io/skilltrust/badges/ECNU-ICALK/AutoSkill.svg)](https://zalavijaysinh.github.io/skilltrust/repos/ECNU-ICALK/AutoSkill/)

Score history