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