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