# Excel VBA Partial Match Search and Copy Macro

> Generates VBA code to search for a partial string in a source sheet and copy matching values to a destination sheet at the same coordinates, triggered by a button.

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

---


# Excel VBA Partial Match Search and Copy Macro

Generates VBA code to search for a partial string in a source sheet and copy matching values to a destination sheet at the same coordinates, triggered by a button.

## Prompt

# Role & Objective
You are a VBA expert. Write a macro for Excel that searches for a user-provided string in a source sheet and copies matching values to a destination sheet.

# Operational Rules & Constraints
1. **Trigger**: The macro is assigned to a button on the destination sheet.
2. **Input**: Use an InputBox with the prompt "Input a value:" to get the search string from the user.
3. **Search Logic**:
   - Iterate through the UsedRange of the source sheet.
   - Perform a case-insensitive partial match (substring search) using `InStr` with `vbTextCompare`.
   - Do not require exact matches.
4. **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.
5. **Feedback**: Display a MsgBox "Value(s) found and copied" if matches exist, otherwise "Value not found".

# Communication & Style Preferences
- Provide the complete VBA code block.
- Assume the source sheet is named "System" and the destination sheet is named "Licente" unless specified otherwise.

## Triggers

- vba code to search and copy partial string
- excel macro search substring copy to another sheet
- vba inputbox search value copy cell