Написание макроса для EXCEL

Automatic import of prices from supplier price lists in Google Sheets CSV format There are 5 different price lists in Google Sheets I have: Goodshop PROM crm SalesDrive Another one planned + Rozetka Another one planned + Hotline Task 1: Looking for someone who already has ready solutions So that the program finds the product article from 5 price lists or there is a table to match product articles because sometimes they differ slightly, like one has SAMSUNG and the other Samsung, etc. From the 5 price lists, it should find where the items are in stock, then the program selects where the best price is, then adds my profit percentage to the supplier's price and pulls the final price and availability to the Goodshop website TASK 2 To have the possibility of automatic product updates every day from Goodshop to Prom, but taking into account the markup for Prom (because they have a slightly complicated formula: 7% is added to the first 10,000 UAH and everything above 10,000 is 2%) In other words== Hello! I am looking for a developer (preference to those who already have READY solutions or similar cases). TASK: 1. Automation of 5 price lists (Google Sheets / CSV): - Consolidation of 5 different supplier price lists into a single system. - Mapping module (matching articles/SKUs): the ability to link your article with different names from suppliers (different cases, abbreviations). - Price selection algorithm: if there is stock on hand — take our price; if 0 — look for the cheapest supplier in stock ➔ add % margin. - Automatic export of final prices and stock to Goodshop (via API or through a feed). 2. Synchronization with Prom.ua: - Uploading updated prices from Goodshop to Prom.ua considering the custom markup formula for Prom (+7% for the first 10,000 UAH and +2% for everything above 10,000 UAH). We already have: Goodshop, Prom.ua, SalesDrive CRM. I expect in the proposals: timelines, cost, and whether you already have ready-made solutions for similar tasks.

Task for those who understand aviation. I have a web list of aircraft accidents. Each of the 900 accidents has a tail number of the crashed aircraft. Next to each tail number, you click the search button, Google search opens, and you look for any 1 high-quality photo of the aircraft with that tail number. Copy the link to that photo and paste it into the same list, just in the links section. And this is done 900 times. Parsing won't work here. We've already tried. Because different sites will + image search may show a different tail number or a random photo. Everything needs to be reviewed and done manually. But if there are suggestions - I would be happy to listen!

Parsing Collection of a database of active working contacts of entrepreneurs (Kyiv, Ukraine) It is necessary to collect a database of entrepreneurs and companies in one stage. Industry - any. Geography: priority is Kyiv and Kyiv region, as well as all of Ukraine.Only REAL WORKING CONTACTS from open sources are needed (NOT outdated phone numbers from the state register, but current numbers from business profiles).

There is a German website with a login and password. When logging in to the site from one browser, it allows working with multiple tabs. When logging in from different browsers, it logs out and allows working in one. The infrastructure for implementation is a virtual local network and Windows server.

https://docs.google.com/spreadsheets/d/1HM2nzGjhrepmaYujuKIa7PduNyWnWI5IWRooX_pLbGM/edit?gid=0#gid=0 perform parsing by codes, sheet: codes and fill in the table: sheet Clients Phone is required