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