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.From its SKILL.md
npx -y skills add ECNU-ICALK/AutoSkill --skill vba-cross-sheet-partial-search-and-copy-macroAssembled from the repository path, not quoted from the project. Check it against their README if it does not work.
One thing to look at
- no licenseNo license file was found in the repository. Code published without one is not open source by default, so using it at work is a question for whoever answers licensing questions where you are.
SKILL.md
2.0 KB, 318 tokens by cl100k_base, as published. Nobody here has run it
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
- Input: Use
InputBoxto prompt the user for a search value. - Search Logic: Iterate through the
UsedRangeof 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). - 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.
- 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
What ships with it
Read from the repository
Just SKILL.md. No reference files, no scripts.