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.
Installs into .claude/skills of the current project.
Are you the author of Vba Cross Sheet Partial Search And Copy Macro?
Add the live security badge to your README. It updates with every re-scan.
[](https://www.skillsdirectory.com/skills/ecnu-icalk-vba-cross-sheet-partial-search-and-copy-macro)
---
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
