Hello. Please help me if it is possible to do a macro. I have a list in Column A1-1000 and I need to search one by one from a website and then based on the result, I need to copy the result under the second table and paste it in my Excel file (maybe in another sheet).
Here is the example screenshot of the website and I need the result under the "Opportunities".
I've been trying to do a manual task so please help me if this is possible via macro. Thank you so much in advance!
Last edited by Siops; 02-16-2024 at 11:19 AM.
1. Are you still using XL2007 or have you updated. If you have updated to a newer version, please update your profile.
2. Pictures are pretty useless. Please provide the URL of the site you are trying to get data from and a sample workbook that we can manipulate data. See the yellow banner at the top of this page for instructions
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
Hello. Thanks for the quick response. Unfortunately, I canto share the URL due to it will require some credentials to access that's why I shared only a snapshot of it. Is it possible to do a general code for the url (I will just edit it)? Thanks again.
I would use Power Query to get the data from a web site. Here is a link on how to do that.
https://medium.com/@rxmufasa/web-scr...e-4233c65a5870
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks