Data scrap vbatrabajos
Scrap Google search bank names using Python - Retrieve data from the first search result page only and obtain the stock tickers - Ideal skills: Python programming and web scraping expertise So, the search will be as an example: JP Morgan Ticker and i need to obtain the ticker of the bank.
I have a excel file with VBA already completed -- it works perfectly when file is not is on desktop. However, when file / folder is moved into OneDrive, it doesnt work -- i believe due to the path or location? If you know how to fix, pls message me and I will do screen-share with you to try and resolve via my computer. Need asap. Thank you.
...on website: - This is an US American company that sells construction equipment. Design elements like dirt, USA flag, concrete, etc. are good 5. Sample - Attached '' is what our previous guide looked like. This is an example of the type of info we want to include. 6. Content - Front Cover: Our logo title: Rental Guide sub title: Earthmoving, Compaction, Utility, Scrap, Demolition Pretty picture and design elements - Back Cover Our logo website URL, contact numbers (get from Sample) Pretty picture and design elements QR code to this URL: - Front Content Get content from the attached file (Rental ) - use first three tabs There are images embedded in the Excel file, pull those images out, cut out the backgrounds and use them
Need automation expert who can scrap data from sites.
...when selected, separated by | (or other separator sign). Desktop versions can offer such functionality by this VBA code: or However, the web version does not support VBA. It seems the web version works with OfficeScript or JavaScrip (via an add-in). I’ve found info that this functionality is not really achievable via OfficeScript (but do tell if I’m wrong about that). Hence the need for an add-in. Details of the add-in’s functionality: 1. Support for many multi select lists per file. Our current drop down lists are based on Excel’s data validation, the drop down appear near a cell after the user clicks in that cell. The add in could also display
Hi, Pablo-- Hope all is well. I have a new project for you and wanted to see if you're interested. I'm creating a pretty in-depth financial dashboard, with data populated pretty extensively between multiple sheets. Likely several more complex INDEX and XMATCH/MATCH (or a combination of them) functions that will need to be written. It may need some level of VBA. I'm happy to connect if you're interested. Thanks! Jim
I am in need of an Excel VBA solution that can search through 1-10 PDF files for text only. I do not have a preferred alternative software or method for PDF searching. The ideal candidate should have experience with Excel VBA, PDF manipulation, and text extraction. The solution should be able to extract text from PDFs then highlight on the text with red color and draw rectangle rounded then take this page and save it as pdf
Ms Access VBA code to get quote for package from UPS, FedEx and USPS as well as create labels...
I am looking for a freelancer who can help me scrape data from using EAN codes. I have a list of EAN codes that I would like to use for the scraping process. The ideal candidate should be proficient in web scraping techniques and have experience with Amazon.com. First step before we hire is to provide a EAN code and get a an example response on what data is available to scrap. One we get all available data we will confirm what information is needed. Mostly interested in all seller's names or/and IDs and their prices, they delivery times and product ranking. This is a one time scrapping.
I am looking for a freelancer who can build a NAVER Datelab shopping data scrapping tool with Excel VBA. The below is the URL that I want to scrap. URL: The project requires the following: - Scrapping NAVER Datelab shopping list categories and ranking per each category - The scraped data should be presented in an Excel spreadsheet - The Excel VBA code should be reusable for future scrapping tasks * I would like to have a dashboard that I can choose a specific category. When I choose that category and run the VBA, it should show a product ranking list in that category. **I failed to make one per the below video. I am positive that it would not be a hard task. Sample URL:
I am looking for a VBA coder who can help me automate report generation in Excel. Need somebody who has hands on coding experience in VB scripting with automation as needed
Looking for Marketing/Sales person to work as a team with me to sell an ERP system for recycling/scrap yards. Pay is 50% of all sales that you make and 50% of all professional services purchased by your client account. The system is already developed and ready to implement. You will only be required to solicit potential scrap yards and get them to view a live demo which I will perform until you feel comfortable enough to demo the finer details of the software.
...Error that I am experiencing with a VBA Macro using Microsoft 365 Apps for Business Build 2305 (latest) and One Drive for Business Version 23.101.0514.0001 and Windows 10 (updated till date). Problem started last week! The Runtime 68 Error is occurring in several files when loading and input form involves selecting/saving/retrieve path. The same macros worked perfectly on C: drive or whenever onedrive is logged out. Previously worked ok with onedrive..no change in code! Same issue with another computer. Added trust location similar to from regedit: HKEY_CURRENT_USERSoftwareSyncEnginesProvidersOneDrive Ideal skills and experience for this job include: - Strong knowledge of VBA Macro programming and Microsoft 365
I am looking for someone to create an Excel dashboard for my project management needs. The main purpose of the dashboard is to track project progress and identify areas for improvement. I have a specific layout in mind for the dashboard, which I can provide to the freelancer. However, I need help preparing the necessary data and tables for the dashboard. The freelancer should have experience in data organization and analysis, as well as proficiency in Excel, VBA. The ideal candidate will also have experience in project management and be able to provide suggestions for improving the dashboard's functionality.
I am in need of a freelancer who can create VBA code for an Excel Solver project. The objective of the optimization problem is currently unclear, as the client did not answer the relevant question. Additionally, the constraints and limitations for the project, as well as the inputs and outputs, were also left unanswered. However, the ideal freelancer for this job would possess the following skills and experience: - Proficiency in VBA programming for Excel - Expertise in optimization and solver methods - Ability to work independently and efficiently - Strong communication skills to clarify project requirements with the client If you are confident in your abilities to create VBA code for an Excel Solver project, please submit a proposal with your relevant experience an...
I'm using to send emails from a microsoft access app. This uses VBA to send via command line. Website was recently moved to WIX and email opperate from gmail workspace, can not get email working. Not sure about how to configure gmail workspace to allow or parameters for
Scrap all CRM Software consulting firms with bias for Salesforce. I need at least a 100 names with as many details as can be found. Example of details: 1. Office location and Cities they offer services. 2. Market Capitalization. 3. Size of workforce. 4. Expertise or areas of focus (example Salesforce, AWS, SAP) 5. Communication/ Channels of communication. (Example website, Twitter, Facebook etc) 6. Awards won. 7. CSR (corporate social responsibility) 8. List of companies they consulted for ( customer success list) 9. Reputation score. 10. Transparency (fixed service rates or variable rates) Group the list (of companies ) by City (Office Location).
XL-VBA Script Task We are looking for an Excel VBA expert to develop a script to automate routine tasks. The goal of the script is to streamline our workflow Specific Task to Automate: - The user will copy and paste multiple rows in XL (given below spreadsheet). The script will: -Engage either through a button or automatically. - Loop through single or multiple columns to find identical, repetitive strings and then reassign a sequential id value (string). - Loop through single or multiple columns to find and correct repetitive parent-child id values (strings). - Only pre-tested (for QA) submitted scripts will be fully awarded. Zero tolerance for bugs
I am looking for a VBA expert to help me with webscraping from a specific website. I need the scraper to extract specific data and export it into an Excel spreadsheet. The ideal candidate should have experience in VBA and webscraping, and be familiar with the website I want to scrape.
I am looking for a VBA expert to help me with webscraping from a specific website. I need the scraper to extract specific data and export it into an Excel spreadsheet. The ideal candidate should have experience in VBA and webscraping, and be familiar with the website I want to scrape.
I am looking for an experienced Excel user to help me design a reusable workbook. The purpose of the workbook is mainly for data management/analysis, and I have a specific layout in mind that needs to be followed. The workbook should include some advanced features such as Data Validation, Pivot Tables, and Power Query, Power Pivot, or Macros/VBA. This workbook should be reusable and should include all necessary coding and features necessary to achieve this. It should also be user-friendly and intuitive, with easy-to-follow instructions. If you have the skills and experience necessary to successfully complete this task, please apply.
I am looking for a skilled freelancer to help me scrape text data from a website for my data analysis project. The ideal candidate will have experience with web scraping tools and techniques. The project requires scraping data automatically from a website and organizing it into a spreadsheet. Skills and experience needed include: - Proficiency in web scraping tools such as Python, Beautiful Soup, and Scrapy - Experience with data analysis and organizing data into spreadsheets or databases - Strong attention to detail and ability to accurately scrape data - Good communication skills to provide updates on progress and ask questions if needed If you have the skills and experience I am looking for, please apply to this project.
I am looking for a freelancer to help me with some ExcelVBAwork. The main purpose of the project is data analysis, specifically medical data. I expect the freelancer to analyze between 1-5 sheets of data. A strong understanding of Excel and VBA programming is required for this project. I look forward to working with someone who can help me to complete this project quickly and efficiently.
I am looking for a freelancer to help me out with a project. I am upgrading my MS Access application to Windows 11 and need assistance in changing the application icon. I already have an existing icon selected that needs to be replaced. However, I will need assistance from someone familiar with VBA code to make this change. So, if you have experience with VBA coding and have worked with Windows 11 applications before, then this might be the perfect project for you! I'm using the following version of access: Microsoft® Access® for Microsoft 365 MSO (Version 2301 Build 16.0.16026.20002) 64-bit. I'm currently using this code, but the Access icon is still displayed in the main window on windows 11: "AppIcon",
Excel VBA for network and sub network generation
...script/web-scrap/automation for $5 (negotiable). I will compare amongst other freelancers. There will be so many website need be scrapped. Here's how the job is : 1. You scrap from google finance 2. You dump the data to that google sheet IS&BS, with the same exact format 3. Then you make the Valuation components & DCF sheet which is linked to that IS&BS sheet (I will pay extra $10 for this, so tell me if you can't do this third step or not). ----------- ok, $5/script ok ? I will compare amongst other freelancers I have many such script needs be done I need you to scrap all of the indonesian's stock market into such a Gsheet I have so many such tasks ----------- We need you to make dozens of script files, which will scrap a...
I am looking for a freelancer to help me scrape data from a soccer website called () i need ig profiles of soccer players in the Chilenian League. Specifically, I want to extract their instagram link, follower count, engagement rates. I have a list of specific soccer players to focus on. The scraped data should be delivered in an Excel file. Please find here: Video explanation of the Task. Ideal skills and experience: - Experience in web scraping and data extraction - Familiarity with Instagram's API - Proficiency in Excel and data analysis.
Hello We have a website that is a marketplace with various people selling products on it. It is not very big website. I need someone to scrap all of the following data for me:- Categories and Sub Categories 1) Get me all the Categories including all various sub categories that they have 2) Get me number of active listings for each Categories and various sub categories 3) get all listing titles, listing price, seller name, and seller phone number. Organize these details under various categories and sub categories I need results in both English and Thai. I dont need the script but the scrapped result this is very basic work. i need it done very fast within 2 days
I need a macro for Excel 365 that will allow me to export specific columns of data to a new CSV file. The exported file must be in CSV tab delimited format. The criteria for selecting the data to export will be based on specific columns. I also need the macro to match data in the other 4 sheets and delete certain rows based on criteria before exporting. Ideal skills for this job include experience with Excel macros and proficiency in VBA. Match, Delete and Export Excel 365 Macro This project is based on the enclosed sample active workbook, which has the following worksheets (one in each tab, labeled: Cases, Casework, Comments, Contacts, plan_request The macro should run in Excel 365. The macro should basically delete all the entries from a specific &ldquo...
Excel Macro to run on Mac Hello, I have a macro that works well on PC but not Mac. The macro is simple; it launches a user form that has list when the user clicks on a cell with data validation. Row source doesn’t work in Excel Mac. Many columns could have different validation lists:ranges. Again, doable in Excel Pc. Ideal skills and experience for this job include: - Proficiency in Excel and VBA programming on Mac I am open to discussing additional requirements and details with potential freelancers. Thank you for your interest in my project.
We had a freelancer who we've used to make many spreadsheets and calculator tools who has not had time recently to help with turn around projects quickly, so we are looking for another person. This current project is a calculator tool used for budgeting projects. We need to create validation rules, a few math expressions, ...are looking for another person. This current project is a calculator tool used for budgeting projects. We need to create validation rules, a few math expressions, and then pivot tables and reports. We want to be able to have people use this tool without needing to worry about worrying about viruses, so we are not using any macros or vba. Aside from skill with Excel, the person we select needs to have excellent math skills and be good with large number...
Files are available at this link: htt...these are sample files for testing. The deliverable: EXE file - Similar to the file () Full Visual Studio Project/Solution folder so I can modify it on my end. ********************************************************************** Scope 2: After successfully completing Scope 1, we will move to Scope 2. This is a bigger phase of the project and it involves a) Integrate VBA scripts in the EXE that we built b) Download Files to disk c) Load PowerPoint files from the URL d) Integration with Azure e) SSO integration I will provide detailed instructions when we move into Scope 2. ********************************************************************** Next step: Please review Scope 1 and share the Cost and Time to complete it.
I have an Excel sheet and w...sheet and want to dynamically fetch data from some rows and display user forms accordingly. I have an Excel workbook, it has 4 sheets. 1. General: in this sheet, the user can enter different space types at the bottom. So what I want is, as the space type is entered, dynamically buttons are added on the second sheet (mechanical), with names the same as the space type names the user entered in the general sheet. now when the button is clicked I want a form to be opened in which the user can enter values, and those values are then pasted on the specific cells, and a similar should happen in other two sheets named electrical and plumbing i have already done the dynamic creation of buttons but i am stuck on how to trigger the on click and display the user f...
I want someto protect my website .. getting scrap or automation for filling
We have an online excel document that tracks ...going through our workshop. we need to be able to take data from specific lines in this excel and print that data on a label. The excel data is getting updated all the time and the labels are printed immediately after updating so we cannot use standard label printing software as it does not pickup the changes quickly enough. I am looking for a developer who can create a VBA or software solution that can print labels using live data from an MS Excel document. I have a specific label format in mind that I would like to use for this project. The ideal candidate should have experience in Visual Basic for Applications (VBA) programming language. The labels will contain text only, and I am looking for a ...
Data entry for web scrap of email and names
Excel VBA Visual Basic Data Entry Word Web Search
Looking for an experienced web scraper that can scrape the airline website and extract the flight data and flight prices. Requirements / Specs: - Create an API(JSON) or a js/php file that I can use - Must in Javascript or PHP - Must use simple http request (axios, fetch, guzzle, ...),Puppeteer, Playwright, jsdom, cheerio, Symfony DomCrawler - Result must be returned under 5 seconds, please tell me if you can’t return the result in under 10s, for example the website is too slow - Recommended scrap their mobile apps with figure out their API - I need the source code to run on my system - I will provide input format, expected output format, test cases and more details URL
Looking for an experienced web scraper that can scrape the airline website and extract the flight data and flight prices. Requirements / Specs: - Create an API(JSON) or a js/php file that I can use - Must in Javascript or PHP - Must use simple http request (axios, fetch, guzzle, ...),Puppeteer, Playwright, jsdom, cheerio, Symfony DomCrawler - Result must be returned under 5 seconds, please tell me if you can’t return the result in under 10s, for example the website is too slow - Recommended scrap their mobile apps with figure out their API - I need the source code to run on my system - I will provide input format, expected output format, test cases and more details URL
We have a sheet that contains dtaa for invoices. we need to insert a row so we charge for carraige for each new order line. some orders contain mulitple linesbut we only need one carraige charge. The data is in same row as the order line To acheive this I have a sheet that we then take the data and I have put into new sheet, we then need to insert a row ina new sheet if a cell above changes, you then need to take a cell in that row and insert in new sheet. Adding delivery to each order insert a delivery row using the info from the first line of that order number Every time column K changes insert line P= =='order-item-details (14)'!AE21 T = 4014 S='order-item-details (14)'!AH2 U= “20%(VATon Income)” AB= “Invoice”
Looking for an experienced web scraper that can scrape the airline website and extract the flight data and flight prices. Requirements / Specs: - Create an API(JSON) or a js/php file that I can use - Must in Javascript or PHP - Must use simple http request (axios, fetch, guzzle, ...),Puppeteer, Playwright, jsdom, cheerio, Symfony DomCrawler - Result must be returned under 5 seconds, please tell me if you can’t return the result in under 10s, for example the website is too slow - Recommended scrap their mobile apps with figure out their API - I need the source code to run on my system - I will provide input format, expected output format, test cases and more details URL
I need professional in VBA EXCEL to do the following One excel file can read any excel file Then summarize it with progress and other details which can be written manually
Looking for an experienced web scraper that can scrape the airline website and extract the flight data and flight prices. Requirements / Specs: - Create an API(JSON) or a js/php file that I can use - Must in Javascript or PHP - Must use simple http request (axios, fetch, guzzle, ...),Puppeteer, Playwright, jsdom, cheerio, Symfony DomCrawler - Result must be returned under 5 seconds, please tell me if you can’t return the result in under 10s, for example the website is too slow - Recommended scrap their mobile apps with figure out their API - I need the source code to run on my system - I will provide input format, expected output format, test cases and more details URL
I am looking for a freelancer who can provide a VBA function in my spreadsheet to call the ChatGPT API. The spreadsheet is written in VBA. I require basic functionality only for the integration and the intended purpose is automated data entry. The ideal candidate should have experience in VBA programming and API integration. Specific skills required for this project include: - VBA programming - API integration - Basic understanding of ChatGPT API functionality
It's urgent! Hi, I have an excel sheet and i want to dynamically fetch data from some rows and display user forms accordingly. Thanks
Nous avons développé un fichier Excel avec VBA pour aider les entreprises à identifier leurs hauts potentiels. Il s’agit d’un formulaire qui se compile et qui calcule les cotes données par les gestionnaires pour positionner l’employé dans un graphique et le comparer avec les autres membres de l’équipe . Nous souhaitons transformer ce fichier en application que nous voulons vendre aux clients. Nous souhaitons que la personne nous aide à : - améliorer notre outil au niveau de la présentation des résultats - le convertir en plateforme accessible sur cloud - les gestionnaires doivent pouvoir avoir leur propre accès (user et mot de passe) pour accéder aux résultats de le...
In spreadsheet , Column F (Field2) are a list of Youtube channels. For each channel, we want the scraper script to find the Youtube URL of the channel. For example, in Row 2, the URL for 滾石唱片 ROCK RECORDS is @RockRecordsTaipei . Candid...com/spreadsheets/d/1GmYRNUvKt_i80B_fxsP09Ajau-cQ7iaHvRkHNMGiDi8/edit?usp=sharing , Column F (Field2) are a list of Youtube channels. For each channel, we want the scraper script to find the Youtube URL of the channel. For example, in Row 2, the URL for 滾石唱片 ROCK RECORDS is @RockRecordsTaipei . Candidates should state on which platform they plan to use, such as Google App Script, VBA, etc. Thank you
I am looking for a freelancer to create a VBA coded Excel sheet to track test results for my medical history. The sheet should include charts or graphs to visualize the data. No security measures are needed. Ideal skills and experience: - Proficiency in VBA coding and Excel - Experience with medical data tracking - Ability to create visually appealing charts and graphs for data visualization
Criar código vba para um UserForm cujos dados explicativos serão enviados via chat.
