Quote Originally Posted by Aussiebear View Post
Welcome to VBAX yanyan9896. In your code you haven't suggested where it needs to be pasted. Its like getting in a car to go somewhere, you know where you are leaving from but not to where you are headed.
Thanks for your reply. This macro is used for a Microsoft Word Document. I expect the macro can copy names according to the Excel file (which is the names in the attached List) to the clipboard. Then the macro will paste what copied into a designated Excel sheet.

Since I received no response after I have asked it for many times in different forum by telling the whole story, I decided to just asking how to use macro to copy specific texts according to an Excel file to the clipboard. Then I will try my best to figure out the remaining part. That's why I don't suggest where it needs to be pasted.

I deeply apologize for the inconvenience caused.