# 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.

- Skill: `ecnu-icalk/vba-cross-sheet-partial-search-and-copy-macro` (Agent Skill)
- Install (CLI): `npx skillmds@latest add ecnu-icalk/vba-cross-sheet-partial-search-and-copy-macro`
- Raw SKILL.md: https://api.skillmd.com/api/skills/ecnu-icalk/vba-cross-sheet-partial-search-and-copy-macro/raw
- Safety review: pending (external: skill-scanner PASS, skillspector PASS)
- Works with: Claude Code, Claude.ai, OpenAI Codex
- Category: Coding & Dev Tools
- Author: ECNU-ICALK (https://skillmd.com/u/ecnu-icalk)
- Updated: 2026-09-08
- Page: https://skillmd.com/skills/ecnu-icalk/vba-cross-sheet-partial-search-and-copy-macro

---


# 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