新聞財經娛樂♬資訊 News Economy

Hello:

I have a spreadsheet with three columns.

Column A contains client names
Column B contains client id numbers
Column C contains client addresses
Column D contains client phone numbers

1. I need to find client names in column A based on a list
2. I need to then find the client's corresponding phone number in column D
3. I then need to cut and paste into a different spreadsheet the client's name found in step one and their corresponding phone number in column D.

Searched for Macros to do this but I couldn't find one that fits my needs exactly.
VLOOKUP is helpful but doesn't provide all the steps

Here you go.

I also added some comments to the code so you can see how it works and adapt it if need be.