Vba Cross Sheet Partial Search And Copy Macro

What the source does

• FilesystemNone observedNo reads or writes in the source
• NetworkNone observedNo outbound calls in the source
• ShellNone observedNo commands run in the source
• DependenciesPinnedNothing floats
• SecretsNone foundNo keys in source

Five audit layers

Gates applied: no behavioural pass.

Audit 0.4.1 · source sha 04e912cff54b · 14 Oct 2026Report an issue or request a re-scan

• PublisherECNU-ICALK GitHub organizationOwner of the repository this skill is read from
• Source folderECNU-ICALK/AutoSkill/SkillBank/ConvSkill/english_gpt4_8_GLM4.7/vba-cross-sheet-partial-search-and-copy-macroThe exact folder we audited
• LicenceNot declaredAs the repository states it
• Commit pinned for this verdict04e912cff54bA new audit runs when the source changes
• Repository statusNot archivedLast push 157 days ago
• Sandboxed runNot runSkills are read, not executed; layer L4 is skipped

Its description: Generates VBA code to search for a user-provided string in a source sheet using case-insensitive partial matching and copies found values to the corresponding cells in a destination sheet.

---
id: "0898887a-3c9c-43a8-bf55-bae6b59ab8ff"
name: "VBA Cross-Sheet Partial Search and Copy Macro"
description: "Generates VBA code to search for a user-provided string in a source sheet using case-insensitive partial matching and copies found values to the corresponding cells in a destination sheet."
version: "0.1.0"
tags:
  - "vba"
  - "excel"
  - "macro"
  - "search"
  - "copy"
  - "automation"
triggers:
  - "vba code to search and copy"
  - "excel macro partial match copy"
  - "search value in sheet and copy to another"
  - "vba inputbox search copy"
  - "copy found values to same location"
---

# VBA Cross-Sheet Partial Search and Copy Macro

Generates VBA code to search for a user-provided string in a source sheet using case-insensitive partial matching and copies found values to the corresponding cells in a destination sheet.

## Prompt

# Role & Objective
You are a VBA expert. Write a macro that prompts for a string, searches for partial matches in a source sheet, and copies found values to the same coordinates in a destination sheet.

# Operational Rules & Constraints
1. **Input**: Use `InputBox` to prompt the user for a search value.
2. **Search Logic**: Iterate through the `UsedRange` of the source sheet. Check if the cell contains the search string as a substring (partial match). The comparison must be case-insensitive (ignore big or small letters).
3. **Copy Action**: If a match is found, copy the cell value from the source sheet to the destination sheet at the exact same row and column index.
4. **Feedback**: Display a message box indicating success (e.g., "Value(s) found and copied") or failure (e.g., "Value not found").

# Anti-Patterns
- Do not perform exact matches only.
- Do not use case-sensitive comparisons.
- Do not copy values to a different location than the source cell's coordinates.

## Triggers

- vba code to search and copy
- excel macro partial match copy
- search value in sheet and copy to another
- vba inputbox search copy
- copy found values to same location

Excerpt, first 2,026 characters of SKILL.md, verbatim from the audited commit. It is text from someone else’s repository, quoted so you can judge it before your agent reads it.

git clone https://github.com/ECNU-ICALK/AutoSkill
git -C AutoSkill checkout 04e912cff54b

Works in

1. 2026-10-14
   ✓SAFE B 89 / 100

   first audit · source 04e912cff54b

Questions about Vba Cross Sheet Partial Search And Copy Macro

• github.com/ECNU-ICALK/AutoSkill/tree/main/SkillBank/ConvSkill/en — the audited source at commit 04e912cff54b and every finding aboveObserved · 14 Oct 2026

Spotted something wrong? Report a correction · Methodology