Vba pull data website jobs

I need an Excel 365 PowerQuery or VBA script that can fetch daily market data and handle potential data source interruptions or changes. Google Shhets example =INDEX(IMPORTXML("" & C31, "//span[@class='mod-ui-data-list__value']"), 1, 1). <Where C31 = Cell containing the Stock eg GB00B8XYYQ86, LU1033663649 or GB00B0CNH163 I need an identical function in MS365 Excel - either with PowerQuery OR VBA (preferable) Ideal skills: - Proficiency in Excel 365 and PowerQuery and VBA - Experience in web scraping and handling dynamic data sources. I am after a fixed quote for this project.

...Business Analyst – VBA, Advance Excel. Job Role: Senior Business Analyst Job Location: Remote Experience: 4 + Years as Business Analyst – VBA , Advance Excel 3+ years of experience is required in creating dashboards in Manufacturing, Banking, Retail Industry. Working Hour: 3 hour per day (per day) Salary: 150 – 200 INR Per Hour Job Responsibilities : • Understanding Company requirements. • Understanding, consolidating and analyzing data from spreadsheets. • Creating dashboards, reports and charts in Analytics tools. • Working on financial and other types of modeling projects. • Having knowledge Dashboard Creation, Mainframe automation through VBA. • Good Technical knowledge of VBAs, Macro, MS Office skills t...

I require a skilled Excel VBA developer to create a dynamic system in Excel. The process should work as follows: - The system will generate a new CSV file when I hit a specific button. - The new CSV file should contain 'item data'. The item data will include: - Item name - Item description - Item price The CSV file should be structured in a simple, easy-to-read format, with each item's data on a separate row. I need this system to be easily maintainable in the future, so please ensure that the code is well-commented and organised. Ideal Skills and Experience: - Proficient in Excel VBA - Experience in dynamically creating CSV files - Attention to detail for correct data formatting - Ability to create user-friendly interfac...

I'm looking for a VBA expert who can help me automate the modeling of intermediate mechanical components in Autodesk Inventor. Key Requirements: - Automate part modeling in Autodesk Inventor - The parts to be modeled are intermediate mechanical components, such as gears and brackets - The VBA code should allow user input for customization of the parts, specifying dimensions and features Ideal Skills and Experience: - Proficient in VBA programming - Previous experience with Autodesk Inventor - Strong understanding of mechanical components and their modeling - Ability to incorporate user input into VBA code for part customization This project is perfect for someone who enjoys automating processes and has a good understanding of mechanical engineering prin...

I'm currently facing some issues with my Excel tracker. - The tracker contains a VBA macro file which seems to be causing formula errors and formatting issues. I'm unsure of the exact nature of these errors, but it's clear they are impacting the accuracy and usability of the tracker. I need a freelancer who can review and rectify these issues in the tracker. An ideal candidate would have strong experience with VBA and Excel, able to handle complex formulas and troubleshoot formatting problems swiftly. Your goal is to ensure that the tracker is fully functional and error-free. Experience with similar projects will be a plus.

I need an Excel VBA code that can perform exact word matching within an Excel spreadsheet. - The code should generate a list of matched words.

I'm seeking a developer who can take on a project where the main goal is to create interactive reports using ActiveRe...project where the main goal is to create interactive reports using ActiveReports. Mainly just need help with c# scripting Key Requirements: - **Data Source**: The reports will need to pull data from databases. - **Functionalities**: The interactive reports should allow users to filter and sort data. Additionally, time metrics from the database should be displayed in a user-friendly manner. Ideal Skills: - Strong experience with ActiveReports or similar reporting tools. - Proficient in integrating reports with databases. - Previous work on creating interactive reports with filtering and sorting capabilities. - Excellent understanding of ...

I'm looking for a proficient professional who can create a report in Microsoft Access from a MySQL database. The report should contain data from the MySQL database, calculations or summaries of data, visualizations or charts, and be structured as a paginated report, using SQL language. The report should be designed to be accessed as a printable PDF document. It is not required to be interactive, as a static report is sufficient for my needs. Key Requirements: - Proficiency in Microsoft Access, MySQL, VBA, PDF, Python, and Excel - Competency in SQL language for data manipulation - Experience in designing paginated reports The ideal candidate should have a proven track record of creating similar reports, with the skills and knowledge necessary to work wit...

As a professional with high-volume data, I'm seeking a highly skilled Excel expert. You should have proficiency in: - Data analysis - Data visualization - Excel formulas, functions and macros - Visual Basics Application (VBA) I'm dealing with more than seven datasets, each one having high complexity (many columns and over 5000 rows). I will need your expertise in managing and understanding this data. Ability to quickly comprehend and adjust to new data structures would be advantageous. Proven experience with large data sets and advanced Excel usage is a must for this project. Please include examples of previous similar work in your proposal.

2 excel files with VBA macro as per customer requirement

One excel file with macro as per requirement

One excel file with macro as per the customer requirement

...multiple cryptocurrency exchanges, specifically Binance, Coinbase, and Deribit. Key Features: a Python application that connects to Deribit. It should allow me to: • Pull live instrument prices o Would want to be able to pull many instruments at once – I.e. every futures expiry for all listed currencies / All option strikes across multiple expiries • Pull my positions / balances / margin usage • Place / view / amend / cancel orders o Send multiple orders at once o Cancel specific orders o Cancel all outstanding orders • Record market / Position / transaction data Latency / Speed of execution is important so will need to be as fast as possible 2. Repeat the above for the following exchan...

...Bolt Zinc plated, 5/16″ x 2-1/2″ x 5“ Ideal for securing pipes, cables, and machinery, this zinc-plated U bolt offers strength and durability. With its precise dimensions of 5/16″ x 2-1/2″ x 5″, it provides a snug fit for various applications. Whether for industrial or residential use, this U bolt is a top choice among professionals. N349-001 V671 Pull in Stainless Steel, 6-1/2″ Upgrade your cabinets and drawers with this sleek stainless steel pull. Measuring 6-1/2″ in length, it offers ample space for comfortable grip and easy access. Its corrosion-resistant finish ensures long-lasting beauty, making it an excellent addition to any modern kitchen or bathroom. N103-291 V34 Double Hinge Safety Hasp in Zinc plated, 4-1/2″...

...should be able to directly pull the current prices from both Uber and Lyft to allow for a real-time comparison. Other Functionalities: - **User Registration and Login**: Users should have the ability to register for an account and login to access additional features. - **Social Media Integration**: The site should be integrated with social media platforms to allow users to share their comparison results or posts from the blog. Design Style: - **Clean and Minimalist**: I prefer a clean and minimalist design style for the site. This is to ensure that the focus remains on the comparison feature and make the site easy to navigate. Ideal Skills: - Proficiency in WordPress Development - Experience in creating comparison sites - Strong understanding of APIs for real-time data...

I am in need of a skilled Python expert to transform a raw excel report into a final template version of excel. The project requires two main tasks: Formatting and re-arranging of columns along with calculation updates for one column. Key Points; - Need 3 open reports to pull the information and split the reports at the end. - Formatting Changes: The report needs specific columns to have pre-defined blank values for certain columns: Col B, E, J, R, W, AB, AE, AJ, AV, BG, BI, BJ, BQ, BU, BV, BW, BX, BY, BZ. - Calculation Updates: The calculation layer within the excel report needs to be updated and finalized. The ideal freelancer for this project should have a profound understanding of Python and extensive experience in manipulating and formatting excel reports. I am looking for s...

...that can bring data from 2 or 3 sources and incorporate a calculator, and digital signing capabilities. It would require a login to access and would have unlimited logins. It would mainly be information porting from one platform to the other. • Integration with Hawksoft CMS: To facilitate seamless data transfer related to client information and documents. • User Interface Design: To amalgamate Hawksoft CMS, Marketing 360 CRM, and a custom calculator into a cohesive agent interface. • Marketing 360 CRM Integration: For fetching and updating customer details efficiently. • Payment Schedule and Interest Rate Calculator: Integrated within the interface to enhance usability. • Secure Document Signing: Automating the population and processing of documen...

As your client, I'm looking for an Excel VBA expert who can make my daily processes more efficient by creating an automated reporting solution for me. Key Tasks: - Design and implementation of a VBA macro in Excel to automate the generation of cost summary reports. - The automated reports should be populated by data from four different worksheets, namely Worksheet 1, Worksheet 2, Worksheet 3, and Worksheet 4. Ideal Skills and Experience: - Excel VBA Programming - Experience with automated reporting - Understanding of data manipulation in Excel. -Possible migration of Cost Summary data to Word contract. In your proposal, please share samples of previous automated reporting projects done with Excel VBA. Commitment to delivering high...

Need to extract data from website: , into an Excel file. Specifically name, discipline (medical practitioner, midwife, nurse, OT, physio, psychologist, podiatrist), location (incl suburb and postcode), initial registration date, registration expiry. There would be at least 100,000 rows of data. Only barrier, is this data is not able to be 'searched' efficiently. Individual names can be looked up. Or disciplines with a select number of names demonstrated...but I can't find a way to show ALL clinicians at once. Looking for a solution which can reliably pull all the names from the database.

I need an Excel VBA expert to automate the generation and visualization of customer data reports. This task requires the building of a dashboard to simplify the report generation process. Key Tasks and Skills Required: - Strong understanding of Excel VBA for automation tasks. - Experience in building dashboards for report generation. - Skills in visualizing customer data within Excel. Outcome and Project Scope: - Develop an automated process for report generation. - Ensure the dashboard is user-friendly and visually appealing. - The final output should provide easily digestible customer data insights.

I need an Excel expert to build a tool that can automatically validate and correct any incorrect country codes in the file. Requirements: - Replace inc...list: The correct country codes should be determined based on a predefined list. - Daily updates: The tool should be able to handle daily updates. Ideal Skills and Experience: - Advanced Excel skills: You should have a deep understanding of Excel functions and VBA programming. - Data validation: Experience with data validation and manipulation in Excel. - Attention to detail: It's crucial that the tool is accurate in identifying and correcting country codes. - Timely updates: Experience in creating tools that can handle daily data updates would be ideal. If you have experience with similar projects, p...

I need a seasoned VBA and Macro expert to assist me with the creation of an interactive dashboard for a small project. The main tasks include: - Development of VBA code to automate repetitive tasks. - Creation of custom functions to enhance the dashboard's functionality. - Ensuring the dashboard can generate reports effectively. I'm specifically looking for someone with: - Proficiency in VBA and Macro. - Previous experience in creating interactive dashboards. - Ability to generate reports through coding. - Good communication skills and attention to detail. If you're confident in your VBA skills and have a good eye for visualizing data, I'd love to discuss this project with you.

...single, optimized sheet. In this new file, we should only pull specific data columns including Defect ID, Defect Type, Date Opened, Priority, Description, Reproduction Steps, Actual Result, Date Closed, Assigned To, and Comments. These columns must be combined while maintaining clarity and structure. After this task, a dynamic dashboard that displays the current state of the project is required. This dashboard should offer a variety of visualizations. We are particularly interested in bar charts, pie charts, and line charts to present the data in a clear and digestible manner. Ideal candidates for this project are those with: - In-depth expertise in Excel data management - Experience in creating dynamic dashboards - A competent hand at data visualiza...

I have an existing VBA application that performs various calculations. I need to convert the VBA application to a Python-based desktop application. Key Requirements: - The converted application should perform the same calculations as the original VBA application. - The application should have a user-friendly GUI for easy input and output. - I am looking for a programmer with experience in both VBA and Python, to ensure a smooth and accurate conversion. Ideal Skills: - Strong proficiency in VBA and Python. - Experience in desktop application development. - Knowledge in creating user-friendly GUIs. - Ability to accurately replicate functionality from VBA to Python.

As the client for this project, I urgently require an expert in VBA.

...and baby alligators for coloring. - Interactive Question: "What do baby alligators eat?" Include a small, outlined wheel that students can spin after coloring each section with possible food options. - Fun Facts: - Create bubbles with fun facts that are written in a large, clear font. These bubbles can have borders or backgrounds that students can color. - Quiz Section: Include quiz questions with pull-tab answers. Each quiz question can be on a small, separate card that students can color....

I require a skilled Excel VBA developer to create a dynamic system in Excel. The process should work as follows: - The system will generate a new CSV file when I hit a specific button. - The new CSV file should contain 'item data'. The item data will include: - Item name - Item description - Item price The CSV file should be structured in a simple, easy-to-read format, with each item's data on a separate row. I need this system to be easily maintainable in the future, so please ensure that the code is well-commented and organised. Ideal Skills and Experience: - Proficient in Excel VBA - Experience in dynamically creating CSV files - Attention to detail for correct data formatting - Ability to create user-friendly interfac...

I need an online store data extraction specialist to pull key information (product name, price, and barcode number) from a particular online store. - The extracted data should be delivered in an Excel spreadsheet. - This is a one-time task; there is no need for continuous extraction. It's essential that you're proficient in web scraping techniques, able to navigate through the store's pages, and extract the right data accurately. Experience with online store data extraction is preferable. Please indicate any relevant past projects in your bid. Looking forward to working with a pro who can deliver quality results efficiently.

I'm looking for a solution to generate QR codes within an Excel document. The QR codes will be primarily used for URLs. The Attached Document Need Text Data from "Sheet Data" Column A into B2 Need Text Data from "Sheet Data" Cloumn B into A11 as a QR Code Need Text Data from "Sheet Data" Cloumn C into G1 as QR Code The data will be manually pasted into "Sheet Data" I need this for 50 Sheets Pages to ignore Coverpage, Inside and Page Breaks Key Requirements: - Ability to generate QR codes in Excel: The end product should be an Excel script or add-in that can create QR codes based on the URLs provided. - Implementation of standard QR codes: Custom designs are not required. The focus is...

...Textured Patches: We'd like to integrate patches with varied textures into accessible areas of the hoodie, such as inside the pockets or on the sleeves. The idea is for these patches to be easily reachable for fidgeting purposes. Possible materials for these patches include corduroy, velvet, sequins that flip back and forth, and soft, plush fabrics, aiming to cater to different tactile preferences. Pull Strings with Beads or Knots: An upgrade to the standard hoodie strings is proposed by adding beads or knots, which can be manipulated to provide tactile feedback. These could be crafted from various materials, further enriching the sensory experience. The tech pack should include all necessary details for production, including measurements, materials, colors, trim, hardware, ...

Looking for an expert in Excel VBA and Macros to automate various processes in my work-flow. Here's the brief rundown of the task involves: - Automated data analysis which includes summarizing data, filtering, Slicers, automatic calculation, and the visualization of data. - Creation of a Custom excel automatic dashboard for real-time reporting and data visualization. Ideal Skill-Set: You should be knowledgeable and experienced in the use of Excel VBA and Macros for automation. Prior experience in VBA, Macros, data analysis and report generation would be a major advantage. Familiarity with automated summary, filtering, Slicer and calculation methods is essential; knowledge of using Macros to create dashboards for real-time rep...

I'm looking for an experienced VBA programmer to extend and modify the existing 'getpdf' project. The key focus is on integrating it with Microsoft Excel. Key Responsibilites: - Integration with Microsoft Excel: This involves extracting data from Excel files and downloading data from VBA which is PDF-based data, renaming it, and using Selenium. Ideal Skills: - Strong VBA programming skills. - Proficiency in integrating VBA with Microsoft Excel. - Experience with Selenium for web data extraction. - Prior work with GETPDF data extraction preferable.

I require a skilled Excel VBA developer to create a dynamic system in Excel. The process should work as follows: - The system will generate a new CSV file when I hit a specific button. - The new CSV file should contain 'item data'. The item data will include: - Item name - Item description - Item price The CSV file should be structured in a simple, easy-to-read format, with each item's data on a separate row. I need this system to be easily maintainable in the future, so please ensure that the code is well-commented and organised. Ideal Skills and Experience: - Proficient in Excel VBA - Experience in dynamically creating CSV files - Attention to detail for correct data formatting - Ability to create user-friendly interfac...

Development and Enhancement of Excel VBA Project Tracker.

I'm on the lookout for highly skilled Excel VBA developers who can enhance my workbook's functionality and deliver efficient solutions. The scope of this project includes: - Automating data entry procedures to increase efficiency, reduce errors, and ensure accuracy - Designing custom Excel functions for a more streamlined experience - Producing comprehensive reports as per need Key Skills and Experience: - Proficiency in Excel 2013 and Excel 2016 is a must. - Strong knowledge of Excel VBA development - Prior experience with data automation and custom function creation - Expertise in generating powerful reports in Excel I am focused on seeing quantifiable improvements in efficiency and data accuracy through your work. If you have the required...

• Automate the collation of data from two sheets, "Data" and "Report," into one Excel workbook. • Transfer data from specified columns in the "Data" sheet to new columns in the "Report" sheet. • Implement exception handling to address missing values during the data transfer process. • Develop an email notification feature to inform managers about the completion of the collation process. • Add "Data" suffix to transferred column names in the "Report" sheet for differentiation. • Provide a solution to automate the process without manual copying and pasting of VBA code. • Name the final file as "Book of Transfer_[Date of extraction from the porta...

I'm in need of a VBA or VSTO developer who can assist with data validation tasks in Excel. You would be responsible for: - Validating numerical and textual data - Organizing validated data in a separate sheet Ideally, you should have experience in working with data validation, especially in Excel. You should also be knowledgeable about building or modifying VBA / VSTO for data validation. Specific criteria for data validation are available and will be provided. Your skills in understanding validation requirements will be instrumental. Familiarity with Excel functions and features is necessary, and proficiency in handling both numerical and text-based data will be of importance. Strong attention to detail will be crucial...

I need a freelancer well-experienced in VBA to automate the generation of reports for my business, specifically in Gmail. It's critical for this project to be completed as soon as possible, and here are the specific needs: - Develop VBA scripts that will automatically generate and send specified reports. - Must have a deep understanding of Gmail infrastructure in order to correctly implement the automation process. - Must demonstrate a proven track record in completing similar automation tasks. Your expertise in ensuring efficiency and accuracy is important. If you believe you're the perfect candidate and can deliver this project promptly, please reach out.

I am looking for a knowledgeable freelancer to support me in implementing Optical Character Recognition (OCR) on images for the purpose of extracting text. mainly on google docs/drive then storing that text in a seperate folder This task involves: - Using OCR to pull text from a variety of images accurately. - Utilizing the text extracted to engage with the ChatGPT API. The goal is to generate synthetic text from the obtained information. The perfect candidate for this job is one with experience in OCR systems, proficiency in using ChatGPT API, and a deep understanding of automation for enhancing process efficiency. Successful completion of this task will result in a system that is not just efficient but reliable in minimizing error margins—increasing overall productivity....

I'm in need of an expert in SQL and VBA who can assist with a one-time project. The job will entail: - Writing complex SQL queries - Automating tasks in Excel using VBA - Conducting data analysis and generating reports This will be performed on Microsoft SQL Server. As such, considerable experience with this DBMS is a requisite. Primary skills and experience for the role include: - Expert level proficiency in SQL and VBA - Extensive experience with Microsoft SQL Server - Familiarity with automating Excel tasks and data analysis - Previous experience in report generation This is a one-off project with the possibility of future collaborations for similar tasks. If you have the necessary skills and experience, I'd like to hear from you.

...Understanding of data processing security and privacy. So, If you're able to send notifications into my what's app number from excel sheet, Then; You're welcome and this contest is for you. Details: I'm engineer, Working for an industrial company and really want to handle the spare parts with the inventory and purchasing managements for assuring that all spare parts available with certain quantities all the time. Requirements: **Data Synchronization**: The connecting should sync data between Excel and WhatsApp in background. - **Automated Messaging**: The Updated data values needed to send automated messages to one contact. These messages will be alerts, and The content of these messages will be generated by data within the Exce...

...paper. Developers should have an advanced understanding of OCR systems to pull this off. Although the client skipped on the preferred operating systems, developers bidding for this project need to have cross-platform development skills to ensure the app is accessible on iOS, Android, and Windows. The application also may possess features such as membership management, workout tracking, and class scheduling, hence a developer with experience in these areas would be preferred. Ideal Experience & Skills: - Proficient in OCR technology - Prior experience in mobile application development - Familiarity with gym-related applications - Familiarity with cross-platform app development - Excellent problem-solving skills, data accuracy and attention to detail - Demonstrated abi...

...applications for personal use. This project requires a rapid turnaround, ideally within 24-48 hours, so immediate availability and proficiency in mobile development are crucial. Key Features: The mobile apps should retain all the functionality of the existing web application with the following modifications: • Exclusion of top and bottom navigation menus. • Omission of a splash screen. • Disabled pull-down refresh option. • Prevention of zooming capability. • Text selection disabled except within input fields. • Capability to send push notifications. Qualifications: • Strong proficiency in and familiarity with its conversion to mobile platforms. • Extensive experience in both iOS and Android development, including implementing ...

I'm urgently needing someone proficient in server administration. The task involves setting up custom nameservers and migrating a site from one...someone proficient in server administration. The task involves setting up custom nameservers and migrating a site from one cPanel to another. I have full access to both the current and the new cPanel. The website that will be migrated is a PHP script safelist mailer. I'm counting on your expertise to guide that process. IDEAL CANDIDATE: -WHM Dedicated Server experience - Experienced in cPanel to cPanel website migration - Proficient in setting up custom nameservers - Knowledge of PHP - Problem-solving skills - Able to work promptly and efficiently. You'd really save the day if you can pull off this tas...

I'm urgently needing someone proficient in server administration. The task involves setting up custom nameservers and migrating a site from one cPanel to anoth...urgently needing someone proficient in server administration. The task involves setting up custom nameservers and migrating a site from one cPanel to another. I have full access to both the current and the new cPanel. The website that will be migrated is a PHP script safelist mailer. I'm counting on your expertise to guide that process. IDEAL CANDIDATE: - Experienced in cPanel to cPanel website migration - Proficient in setting up custom nameservers - Knowledge of PHP - Problem-solving skills - Able to work promptly and efficiently. You'd really save the day if you can pull off this tas...

I'm looking for a highly skilled macro coder to assist me with the development of advanced custom macros in Microsoft Excel. This project will require a deep understanding of VBA and prior experience with integrating macros with external databases or APIs. Key Requirements: - Develop advanced custom macros in Microsoft Excel - Implement integration with external databases or APIs - Ensure the macros are efficient, reliable and user-friendly Ideal Skills: - Proficient in VBA (Visual Basic for Applications) - Experience in developing advanced Excel macros - Knowledge in integrating with external databases or APIs I look forward to working with a professional who can deliver high-quality, efficient and effective macros.

Do the following tasks as far as you can. Even if you get stuck anywhere, document the process in a way that you can present it to us afterwards. 1. Find the OWASP Juice Shop 2. Fork it to your GitHub Account 3. Run the application on your machine 4. Find the Score Board 5. Find any of the vulnerabilities and fix it directly in the app code 6. Open a pull request with this fix and a meaningful description in your repository 7. Enable dependabot updates for the frontend 8. Get a list of all PRs of your repository on the commandline

...looking for an Excel VBA expert who'll be prepared to take on challenges on the go, as this listing lacks specific task detail. I rely on you to be innovative and foresee potential tasks such as automating data entry, creating macros, or generating reports. Ideal Skills & Experience: • Proven VBA scripting in the Excel environment • Experience with automation, macros, and report generation • Demonstrable troubleshooting skills In your application, please showcase your past work, how much experience you have, and provide a detailed project proposal. While the specific tasks aren't predefined, your application should reveal your versatility and expertise in VBA scripting. The project's ultimate purpose is unknown, potenti...

I have a daily dataset of the prices and funding fees of cryptocurren...format for ease of understanding and comparison. Any tool or programming language that can efficiently and accurately perform this task is acceptable. The goal is to create a structured, automated process that can handle this daily task with precision. Ideal Skills and Experience: - Strong Excel skills, especially in formulas and functions. - Prior experience with automation in Excel, macros and VBA programming. - A good understanding of cryptocurrencies and their pricing. - Ability to deliver a clean and user-friendly layout for the output. Your work will significantly ease my daily workload and improve my decision-making process. I look forward to your proposals. Screen of excel file.

I'm seeking a VBA expert who can help me create a tool that will generate both PDF and Word documents from a specific column of an Excel file. The Word document should contain some static data derived from the column details. The primary requirements are as follows: - The tool should be able to generate both PDF and Word documents. - The Word document should include some fixed data from the Excel details. - An interactive graph should be included in the Word document, based on the data from the specific column.