Search and copy and paste

Closed
vengat - Nov 16, 2014 at 01:36 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Nov 16, 2014 at 05:55 AM
Hello,

I have already created macro tool and I need to include another macro which is a value in cell D16 is the name. We have a list of 30 named in A100 to A129 and their phone number in
B100 to B129.we need have a code which should copy the and paste the phone number in A5.
please help with the code.it can also be a input box.when we can enter the name in input box and it give the value of phone number

Thanks,
Vengat
Related:

1 response

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Nov 16, 2014 at 05:55 AM
use vlookup
0