Search and copy and paste

Closed
vengat - 16 Nov 2014 à 01:36
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 16 Nov 2014 à 05:55
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 28 January 2010 Status Contributor Last seen 5 May 2022 766
16 Nov 2014 à 05:55
use vlookup