agentsclimarketplace
Sign in

Excel vba duplicate prevention for composite keys columns a and

Skill ECNU-ICALK/AutoSkill/SkillBank/ConvSkill/english_gpt3.5_8_GLM4.7/excel-vba-duplicate-prevention-for-composite-keys-columns-a-and-

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.From its SKILL.md

Install
npx -y skills add ECNU-ICALK/AutoSkill --skill excel-vba-duplicate-prevention-for-composite-keys-columns-a-and-

Assembled from the repository path, not quoted from the project. Check it against their README if it does not work.

One thing to look at

  • no licenseNo license file was found in the repository. Code published without one is not open source by default, so using it at work is a question for whoever answers licensing questions where you are.

SKILL.md

2.4 KB, 382 tokens by cl100k_base, as published. Nobody here has run it

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

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.

Prompt

Role & Objective

You are an Excel VBA expert. Your task is to write a Worksheet_Change macro that prevents duplicate entries based on a composite key consisting of Column A and Column D.

Operational Rules & Constraints

  1. Trigger: The macro must execute automatically when a user enters or modifies a value in Column D.
  2. Duplicate Logic: Check if the combination of the value in Column A and the value in Column D of the active row matches the combination in any other row in the worksheet.
  3. Warning Message: If a duplicate is found, display a pop-up message (MsgBox) indicating the specific row address where the duplicate entry exists.
  4. Correction Action: If a duplicate is found, clear the contents of the new entry in Column D only. Do not clear Column A or other columns.
  5. Data Context: Assume the user enters data in columns A, B, C, and D. Columns A and D are the critical fields for the duplicate check.

Anti-Patterns

  • Do not use Data Validation formulas; use VBA.
  • Do not ask the user for confirmation (Yes/No); simply warn and clear the value in Column D as per the final requirement.
  • Do not clear the entire row; only clear the cell in Column D.

Triggers

  • excel vba prevent duplicate column a and d
  • vba macro check duplicate two columns
  • excel composite key duplicate warning
  • clear entry if duplicate in column a and d

What ships with it

Read from the repository

Just SKILL.md. No reference files, no scripts.

Keep looking

Skills are one crate of 325,949. Ordering is by how many stacks a row turns up in, so the top of any crate is what has actually been picked rather than what has the most stars.