anvesh1818
New Member
- Joined
- Apr 27, 2020
- Messages
- 1
- Office Version
- 365
- Platform
- Windows
Dear All,
Hope you are safe at home.
I'm searching for a macro which can make my work easy and i can learn new things in macro.
My Query is very simple.
I have text list in column A text include company name with Location name (ex:"kfc 10003 new york") when i search this in google i can see a map box on right side, which i need to click on it copy the url and paste in column B. Again i wrote a formula in Column C which will separate lat and long value from url.
My request is to get a macro which will search the text and paste the url only which has box location map on the right side of web page and paste in Column B.
I apologize if my way of explaining is not good, I am in learning stage and will sure improve it.
Please find attached screen print of my query.
Thanks in advance.
Hope you are safe at home.
I'm searching for a macro which can make my work easy and i can learn new things in macro.
My Query is very simple.
I have text list in column A text include company name with Location name (ex:"kfc 10003 new york") when i search this in google i can see a map box on right side, which i need to click on it copy the url and paste in column B. Again i wrote a formula in Column C which will separate lat and long value from url.
My request is to get a macro which will search the text and paste the url only which has box location map on the right side of web page and paste in Column B.
I apologize if my way of explaining is not good, I am in learning stage and will sure improve it.
Please find attached screen print of my query.
Thanks in advance.