I need a macro to retrieve data from the [login to view URL] website. I have attached an excel file of products and their EAN.
In the column A, you can see some EAN codes.
1st step: the macro must copy the EAN code and paste it in the search bar of the website ([login to view URL])
2nd step: validate the search
3rd step: : Put in the J column the lowest price in the world ( ex: [login to view URL] - In green)
4th step: Put in the H column the lowest price in France (ex: [login to view URL] - In red)
5th step: Put in the I column the link to buy the lowest price in France (ex: [login to view URL] - In purple)
6th step: Click on the lowest price worlwide, ([login to view URL] - at the bottom right in yellow you have the link to buy the lowest price in the world)
7th step: Repeat the six steps for each line of the excel file
Normally no price will be missed. What can happen is that the French price can be also the cheapest price in the world. In this case, it can be seen twice in the same line.
VERY IMPORTANT: I need to run the macro myself and the macro should work no matter the number of line.
Expert here to do and complete this project professionally and quickly
I have done similar projects
I can do trial work before hire me sir , will wait for your reply, Thanks, Syed
hi,
I am very good in Excel vba, macro, chart etc. if you want to see my excel skills i can share with you some of my work on excel. I feel fit myself for this project. please contact with me.
Thanks.
Urgent Services of
Data Entry
Web Search
Document Formatting
Creating Excel Sheet
etc ……………..
Dear Client:
If you are in the searching of right FREELANCER for your project then you are at the RIGHT place. Welcome to MY Profile
Hello,
I have the Excel macro that retrieves the lowest prices and the links you requested.
It performs a search for each line in the Excel file.
You can contact me and I can send you a sample .xlsx file that has the prices and links filled for the EAN codes you provided in the example so you can review it.
Best regards,
Madalina
To acquire a good position, with honesty and hard work, in any organization where chances of advancement and learning are available for skilled and hardworking people.
Hi,
I have worked in automation testing for years. I developed a lot of macros. But I have not done combination of these 2 things.
I can research and finish it in 2 days.
Thanks,
Tuan