wow Yaar you rock.....................................u made it very simple.4 din sa matha kap gaya tha khojte khojte aapne bata ka pura tension hi reliaze kar diya .
Thank you, maine life main kabhi RUclips pe comment nahi kiya and i never liked HRs but your video here has increased my respect for the HR community. You'll receive positive karmic points!!
Glad it helped.Thank you for your kind words. You can also watch our Latest video on X-Lookup function in excel : ruclips.net/video/dUG8gAD4A-s/видео.html
Happy to help.Thank you for your kind words. You can also watch our Latest video on X-Lookup function in excel : ruclips.net/video/dUG8gAD4A-s/видео.html
Glad to hear that.Thank you for your kind words. You can also watch our Latest video on X-Lookup function in excel : ruclips.net/video/dUG8gAD4A-s/видео.html
You're welcome!.Thank you for your kind words. You can also watch our Latest video on X-Lookup function in excel : ruclips.net/video/dUG8gAD4A-s/видео.html
Glad to hear that.Thank you for your kind words. You can also watch our Latest video on X-Lookup function in excel : ruclips.net/video/dUG8gAD4A-s/видео.html
Glad it helped,Thank you for your kind words. You can also watch our Latest video on X-Lookup function in excel : ruclips.net/video/dUG8gAD4A-s/видео.html
Our pleasure!.Thank you for your kind words. You can also watch our Latest video on X-Lookup function in excel : ruclips.net/video/dUG8gAD4A-s/видео.html
Most welcome 😊,Thank you for your kind words. You can also watch our Latest video on X-Lookup function in excel : ruclips.net/video/dUG8gAD4A-s/видео.html
Happy to help.Thank you for your kind words. You can also watch our Latest video on X-Lookup function in excel : ruclips.net/video/dUG8gAD4A-s/видео.html
Happy to help.Thank you for your kind words. You can also watch our Latest video on X-Lookup function in excel : ruclips.net/video/dUG8gAD4A-s/видео.html
So nice of you.Thank you for your kind words. You can also watch our Latest video on X-Lookup function in excel : ruclips.net/video/dUG8gAD4A-s/видео.html
yes we can add those things too. Thank you for your kind words. You can also watch our Latest video on X-Lookup function in excel : ruclips.net/video/dUG8gAD4A-s/видео.html
Hope u got what u want.Thank you for your kind words. You can also watch our Latest video on X-Lookup function in excel : ruclips.net/video/dUG8gAD4A-s/видео.html
hi, there is an error occurred, when i press F% or play button - a pop shows run time error '9' and when i debug it. this line is highlight with yellow colour. While VBA.Trim(Sheets("Sheet1").Cells(iRow, 1)) "" Kindly help me to apply
Always welcome.Thank you for your kind words. You can also watch our Latest video on X-Lookup function in excel : ruclips.net/video/dUG8gAD4A-s/видео.html
Great technique bro. I really love this technique and successfully copied all contacts to my phone. Very valued information from you. Keep it up my friend. One query, Lot of my contacts are from Abroad where we require to give + symbol before contact number for country representation, When i remove ","(comma seperator) from .csv to excel converted file, the plus symbol also got removed. How to be fix this issue?
Happy to help,Thank you for your kind words. You can also watch our Latest video on X-Lookup function in excel : ruclips.net/video/dUG8gAD4A-s/видео.html
very easy way to add better than google ..sir i need to know can you help me .. how to fast make broadcast list for customer in whats app ... with contact add fast i have more than 3000 customer so all customer name mix up and mix so how to arrange and this all sir ! Thank you so much
Glad to hear that!.Thank you for your kind words. You can also watch our Latest video on X-Lookup function in excel : ruclips.net/video/dUG8gAD4A-s/видео.html
hi there , thanx it is very useful. But i am facing an error " THE MACROS IN THIS PROJECT ARE DISABLED. PLEASE REFER TO THE ONLINE HELP OR DOCUMENTATION OF THE HOST APPLICATION TO DETERMINE HOW TO ENABLE MACROS. Please suggest will be grateful to you
thanks sir my suggestion is that you should complete the process by showing mobile settings how to do. then your video will be complete. thanks for your good work
wow Yaar you rock.....................................u made it very simple.4 din sa matha kap gaya tha khojte khojte aapne bata ka pura tension hi reliaze kar diya .
Sir very best. I just transfer more than 10000 contacts to my phone for marketing. Thanks sir
Keep it up.Thank you for your kind words. You can also watch our Latest video on X-Lookup function in excel : ruclips.net/video/dUG8gAD4A-s/видео.html
Excellent trick boss..... 200% working !!!
Great.Thank you for your kind words. You can also watch our Latest video on X-Lookup function in excel : ruclips.net/video/dUG8gAD4A-s/видео.html
Thank you, maine life main kabhi RUclips pe comment nahi kiya and i never liked HRs but your video here has increased my respect for the HR community. You'll receive positive karmic points!!
Thank you sir do subscribe my channel
thank you 💓💞💞🎉🔥
Thank you So much Brother.....Finally I got the right video after 2 days of searching....I appreciate your Work Brother❤❤❤
Thanks bhy. Love you. Bhot badi problam solve kade aap ne
Thanks
Kacki Bro...🤩👍
जय हो महोदय जी। सही काम हो गया आज।
जय हो महोदय जी
Tried it. Very useful❤
ALLAH AAP KO SEHAT KI DOILAT AATA FARMAAY BOHAT BOHAT SHUKRIYA BHAI AAP KA AAP NAY MAIRA BOHAT BARA MASLA HAL KAR DIYA
This is the best comment of my life ever. Thank you❤️❤️❤️
TOO GOOD TECHNIQUE..LUV U MAN..MAY Gbu
Thank you! Cheers!
Thankyou so much. This worked 100% Great video
Glad it helped.Thank you for your kind words. You can also watch our Latest video on X-Lookup function in excel : ruclips.net/video/dUG8gAD4A-s/видео.html
Thank you Sir.. It really Works and help to save lot of time....
Happy to help.Thank you for your kind words. You can also watch our Latest video on X-Lookup function in excel : ruclips.net/video/dUG8gAD4A-s/видео.html
Thank you so much. It is very helpful. Aur aapka samjane ka tarika bhi bahut acha hai.
Your welcome
Your video really helped me bro. thanks a lots, continue your great work.
Glad to hear that.Thank you for your kind words. You can also watch our Latest video on X-Lookup function in excel : ruclips.net/video/dUG8gAD4A-s/видео.html
if we dont add last name section so it will work ?
Yes it will work
@@BeingHR thnx
Thank u!...u saved a lot of time of mine!!
Thank you
It worked now ..Thanks a lot
You're welcome!.Thank you for your kind words. You can also watch our Latest video on X-Lookup function in excel : ruclips.net/video/dUG8gAD4A-s/видео.html
Thank you sir... U really helped me alot... It really works
Glad to hear that.Thank you for your kind words. You can also watch our Latest video on X-Lookup function in excel : ruclips.net/video/dUG8gAD4A-s/видео.html
Thank you so much its very usefull me to converting my 12 pdf files.almosth there 12000 contacts🙂
Great 👍
Brother please help me.. please 🙏🙏🙏
Thanks thanks ...vary vary thanks....................
You saved my life
Really useful thank you.. so much for this video
Thank you for your kind words. You can also watch our Latest video on X-Lookup function in excel : ruclips.net/video/dUG8gAD4A-s/видео.html
100% WORKING BOSS
NICE
Thank you for your kind words. You can also watch our Latest video on X-Lookup function in excel : ruclips.net/video/dUG8gAD4A-s/видео.html
THANKS, IT WORKS AND IT IS VERY EASY. THANK YOU FOR MAKING THIS VIDEO AND MAKING OUR WORK EASY.
Code pls
Thank you for your kind words. You can also watch our Latest video on X-Lookup function in excel : ruclips.net/video/dUG8gAD4A-s/видео.html
thanks man...it works great
Glad it helped,Thank you for your kind words. You can also watch our Latest video on X-Lookup function in excel : ruclips.net/video/dUG8gAD4A-s/видео.html
Boss, Kay bolu .... You Make my work so easy ... Thank you so much
Thank you for your kind words. You can also watch our Latest video on X-Lookup function in excel : ruclips.net/video/dUG8gAD4A-s/видео.html
Its Amazing ...Thanks Being HR
Our pleasure!.Thank you for your kind words. You can also watch our Latest video on X-Lookup function in excel : ruclips.net/video/dUG8gAD4A-s/видео.html
It's really helpful
Thankyou
No-1 Supper dear
Amazing this really works ..
Thank you..
Welcome 👍.Thank you for your kind words. You can also watch our Latest video on X-Lookup function in excel : ruclips.net/video/dUG8gAD4A-s/видео.html
It's worked for me...Thank you so much.
Thank you for your kind words. You can also watch our Latest video on X-Lookup function in excel : ruclips.net/video/dUG8gAD4A-s/видео.html
Thank you bhai so help full
Thank you for your kind words. You can also watch our Latest video on X-Lookup function in excel : ruclips.net/video/dUG8gAD4A-s/видео.html
superb work.Thank You so much
Most welcome 😊,Thank you for your kind words. You can also watch our Latest video on X-Lookup function in excel : ruclips.net/video/dUG8gAD4A-s/видео.html
Thanks bro you have saved lot of time and effort for me.
Happy to help.Thank you for your kind words. You can also watch our Latest video on X-Lookup function in excel : ruclips.net/video/dUG8gAD4A-s/видео.html
Successfully worked
Thanks
Thank Your Sir 😊
Thank you so much bro
Welcome
is it possible to convert 45k contact from xlsx file to vCard at one shot.....??
Thanks a lot, sir. It works very well and saves a lot of time.
Happy to help.Thank you for your kind words. You can also watch our Latest video on X-Lookup function in excel : ruclips.net/video/dUG8gAD4A-s/видео.html
@@BeingHR hello hr thank u for help...
But when i run the script to module.... Error 9 is coming
EXCELLENT
థాంక్స్ its working
Thank you for your kind words. You can also watch our Latest video on X-Lookup function in excel : ruclips.net/video/dUG8gAD4A-s/видео.html
THANK YOU. VERY USEFUL.
Your welcome ❤️
Superb ,its working well..thank you..small query :Is there any limitation for contacts?
No limitations
Not at all. thankyou for watching
What do you write in the output path when you're using mac?
Write where you want to save. Suppose you want to save it on any folder on desktop select that folder and press cmd+i and copy the path.
awesome Bro thnkyu
Thank you for your kind words
find it really useful in 2021
thanks
Your welcome dear ❤️
Great Content
Aaramse , hogaya bhai ... Thx
Thank you for your kind words. You can also watch our Latest video on X-Lookup function in excel : ruclips.net/video/dUG8gAD4A-s/видео.html
Thank you very much for the video
Ur welcome
It was very helpful
Thank you for your kind words. You can also watch our Latest video on X-Lookup function in excel : ruclips.net/video/dUG8gAD4A-s/видео.html
Good job bro thank you
Thank you for your kind words. You can also watch our Latest video on X-Lookup function in excel : ruclips.net/video/dUG8gAD4A-s/видео.html
Thanks alot sir
So nice of you.Thank you for your kind words. You can also watch our Latest video on X-Lookup function in excel : ruclips.net/video/dUG8gAD4A-s/видео.html
thanku sir it works
Thanks Buddy. It worked perfectly.
Suggestion: Include code for additional fields like email, Landline No, etc.
yes we can add those things too. Thank you for your kind words. You can also watch our Latest video on X-Lookup function in excel : ruclips.net/video/dUG8gAD4A-s/видео.html
Please help me..
Hi, Unable to do Alt+F11, I am using lenovo, can you tell me exact step of creating the visual basic file.thx
cant help
Thanks, it's very useful
Thank you for your kind words. You can also watch our Latest video on X-Lookup function in excel : ruclips.net/video/dUG8gAD4A-s/видео.html
Visual basic window nhi open ho rha alt +F11 se? what to do?
You may go to developer tab and click on visual basic window.😊
excellent i was stuck up due to covid 19 virus able to convert 550 excel contacts into whatsapp
Hope u got what u want.Thank you for your kind words. You can also watch our Latest video on X-Lookup function in excel : ruclips.net/video/dUG8gAD4A-s/видео.html
very useful information and explained in simple language. Can you please tell if we want to add one more column of email id, what can we do ?
Thank you so much 😊 it’s really helpful n saved lots of time
Glad to hear that
coding kaha he maam
Thank you soo much
GENIOUS. IT IS WORKING PERFECTLY. THANK YOU FOR MAKING MY WORK SIMPLE
Code send me
Hello what if i am using i phone then what format i should typen in excel including company name and email
i don't think it will work for I-phone
Thank you for your kind words. You can also watch our Latest video on X-Lookup function in excel : ruclips.net/video/dUG8gAD4A-s/видео.html
Please help
Run-time error '9'. Subscript out of range
??
Run-time error '9':
Subscrit out of range
Yes how to solve these
Awsome method and its working perfectly. Thankyou sooooooooooooooooooooooooooooooooooooooooooooooooooooo much
Thank you for your kind words. You can also watch our Latest video on X-Lookup function in excel : ruclips.net/video/dUG8gAD4A-s/видео.html
AWESOME
Cheers!.Thank you for your kind words. You can also watch our Latest video on X-Lookup function in excel : ruclips.net/video/dUG8gAD4A-s/видео.html
hi, there is an error occurred, when i press F% or play button - a pop shows run time error '9' and when i debug it. this line is highlight with yellow colour.
While VBA.Trim(Sheets("Sheet1").Cells(iRow, 1)) ""
Kindly help me to apply
You have not copied the script properly
Thanks a lot...
Your welcome 😃
SUPER BROOOOOOOOOOOOOOOOOOOOOOO LOVE YAAAAAAA THANKS ITS WORKING
'
How?
Thank you for your kind words. You can also watch our Latest video on X-Lookup function in excel : ruclips.net/video/dUG8gAD4A-s/видео.html
Can we send msg to all of the saved numbers through pc?
thank you so much bro you really helped me a lot god bless you...….
Always welcome.Thank you for your kind words. You can also watch our Latest video on X-Lookup function in excel : ruclips.net/video/dUG8gAD4A-s/видео.html
When i put script macros macro name is coming
Thanku for help hr... But i am facing some issues with it....
When i run script into module...
It shiws runtime error 9...
Plz help me😊😊😊
Very useful and clear explanation. Thanks bro
need help sir
error is. Open OutFilePath For Output As FileNum
Thank you. Will this script work on a three or four-column Excel sheet? I wanted to add another column for land line number.
VERY EASY THANK YOU
Your welcome
Thanks bro for useful tip.. it helped a lot.. but need more help .. to delete duplicates.. and incomplete numbers..
Wait for my next videos
@@BeingHR Hope you'll make it soon.. waiting for that ..
Thanks a ton sir
Thank you for your kind words. You can also watch our Latest video on X-Lookup function in excel : ruclips.net/video/dUG8gAD4A-s/видео.html
Love from Pakistan
Such comments give me more motivation to make content full videos 💜❤️💙💚
Am adding C Drive as I don't have D drive but its not happening. Its showing Run-time error 75
Path/File access error. What to do.. pls reply asap
It’s because you may have rename the sheet-1 name
Great technique bro. I really love this technique and successfully copied all contacts to my phone. Very valued information from you. Keep it up my friend. One query, Lot of my contacts are from Abroad where we require to give + symbol before contact number for country representation, When i remove ","(comma seperator) from .csv to excel converted file, the plus symbol also got removed. How to be fix this issue?
when you are writing your contact details at that time mention + symbol in the cell and give a try
Link bhej digiye module ke excerpt ki
Thanks Man
Happy to help,Thank you for your kind words. You can also watch our Latest video on X-Lookup function in excel : ruclips.net/video/dUG8gAD4A-s/видео.html
very easy way to add better than google ..sir i need to know can you help me .. how to fast make broadcast list for customer in whats app ... with contact add fast i have more than 3000 customer so all customer name mix up and mix so how to arrange and this all sir !
Thank you so much
U can simply have common first name for all and then just select it and paste it
What can do now
Thanks for your help. God Bless
Thank you for your kind words. You can also watch our Latest video on X-Lookup function in excel : ruclips.net/video/dUG8gAD4A-s/видео.html
THANKS
Hey where i can scripts to convert excel file to contacts file to paste in module.
I have the same issue
Link : docs.google.com/document/d/1EouM9Z6zgsEisMm9QRhjwxvK6M6YNMfEqGayKNrKHc0/edit
thank you, helped me a lot
Glad to hear that!.Thank you for your kind words. You can also watch our Latest video on X-Lookup function in excel : ruclips.net/video/dUG8gAD4A-s/видео.html
@@BeingHR how to get script
Wanted to add email id also how to do bro please help me
you need to add it in script and excel
Hi... while i am doing ALT + F11 screen in not opening
You can manually open it by clicking on developer and then on visual
hi there , thanx it is very useful. But i am facing an error " THE MACROS IN THIS PROJECT ARE DISABLED. PLEASE REFER TO THE ONLINE HELP OR DOCUMENTATION OF THE HOST APPLICATION TO DETERMINE HOW TO ENABLE MACROS. Please suggest will be grateful to you
Carefully paste the script
works fine
Thank You
You're welcome
showing error i copy ten times but error are some
While VBA.Trim(Sheets("Sheet1").Cells(iRow, 1)) ""
Can I convert 4 fields like first name, last name, mobile number, whatsapp number
Yes
WHEN I RUN SCRIPT FOUND RUN ERROR 76..WHAT IS IT..PLS HELP
Open OutFilePath For Output As FileNum
Kindly give sheet name as it is shown in video
thanks sir my suggestion is that you should complete the process by showing mobile settings how to do. then your video will be complete. thanks for your good work
Thank you for your kind words. You can also watch our Latest video on X-Lookup function in excel : ruclips.net/video/dUG8gAD4A-s/видео.html
Hey bro I'm getting an error msg
Run-Time error '76'
Path not found
Plz help i did everything yo said I'm struck in last process to save contact
Carefully paste the script. Before that try to make a excel in the same format shown in video.
Good
Brother i tried but it is showing that subscript out of range
Plss help mee its very urgent for me🙏🙏
Please carefully copy and paste it bro