Vba pull data website jobs
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.
I need a VBA script tailored to Excel that will assist in my data analysis projects. It should prompt me to enter a target amount, then let me select a range of cells that contain various amounts. The code should find a combination within the selected range that makes the sum equal to or closest to the target amount. It could be more than the target amount or less than the target amount but it should be closest. It should then highlight the cells that make the sum that is closest to target amount. It should also ensure that only visible rows are to be considered. Hidden rows are not to be considered. Key Requirements: - Prompt for target amount and range of cells - Find combination closest to target sum - Compatible with Excel 2016 and above Key Features: - Return the first...
In need of a qualified freelancer to automate tasks such as report generation and data manipulation in Excel using advanced VBA. Key Tasks: - Create automated processes in Excel for data manipulation and report generation - Work with Excel data sources exclusively Skills and Experience: - Expert in Excel VBA development - Proficient in the use of advanced Excel functions, including array formulas and 'What-if' analysis - Strong understanding of data handling in Excel The successful candidate will be expected to demonstrate a track record of automating complex tasks in Excel using advanced VBA, and manipulating data accurately and efficiently.
I am in need of a proficient VBA and Excel Macros expert to develop a simple, yet efficient invoice/billing application. Key Features: - Generation of invoices from input data. - Tracking and calculation facility for totals. - Maintaining a robust database for customers and invoices generated. Interface Requirements: - The GUI should be straightforward and user-friendly, allowing quick input, management, and retrieval of information. Data Handling: - The application should exploit Excel capabilities for the storage and manipulation of all the data, including customer and invoice records. Ideal Skills & Experience: - VBA and Excel Macros expertise. - Experience in creating user-friendly GUIs in Excel. - Able to develop robust database system...
I'm in need of an experienced data analyst to help me with a project focused on housing markets, specifically rent versus buy scenarios. Here are some details: - **Data Analysis Type**: I need a professional who can perform both data visualization and predictive modeling. You should be able to interpret the data in a meaningful and visually appealing way, as well as predict future trends or patterns based on the data analysis. - **Data Sourcing**: While the data size isn't predefined, you'll be required to source the data from multiple sources yourself. This means you should be well-versed in data collection, cleaning, and preparation. The sources should be relevant to the housing market, specifically the rent ...
...linked to specific Achievement Standard aspects. Student grading interface with data linked to tasks and aspects. Flexibility: Standardized workbook naming ("PrepA", "Year1B", etc.) to allow for scaling. Master File: A central file pulls data from teacher workbooks, providing schoolwide reporting. Automatic Updates: Master File refreshes data when teacher workbooks are saved (VBA preferred). Reports: Basic summaries within teacher workbooks, and comprehensive reports in the Master File. Desired Skills: Proficiency in Excel: Deep understanding of formulas, data linking, and sheet structuring. VBA Expertise: Experience with workbook events and automating updates. UI Focus: Emphasis on clear navigation and user-friendly data...
As I'm launching a new business, I need your expertise in developing VBA scripts and macros in Excel to help me automate several repetitive tasks. I am looking for an expert in MS Excel to develop a special MS Excel Macro which can be integrated to MS Excel environment, in order to generate an output file. This tool will allow us to transform a specific Input file into another Output file. • Input: catalog_product_option-YYYY-MM-DD • Output: The 2 files are attached, with a color mapping to recognize the columns in scope. In summary, we need to be capable to issue an export file in a specific format (see attached picture “”): • Specific Orders of the column (Green) • Suppress the duplicated values for some line items, on 3 fields. The macr...
I'm in need of a proficient Excel specialist who can help create a solution for selecting rows to display in Excel with a total at the bottom. Requirements: - Proficiency in Excel and experience with creating VBA or macros - Ability to display both numerical and text data - Ensure compatibility with Windows Operating System Please note, this task calls for a clean, simple solution. Your proposal should detail your previous work with similar Excel functions.
Need an Excel VBA expert to do automate a workflow of flagging the date of the first non-zero value in a row. I'm looking for a freelancer with the following skills: - Proficient in VBA programming. - Previous experience in developing Excel automation scripts. - Able to deliver the project as soon as possible.
I need an Excel macro develop...Requirements: - Email Trigger: The macro should send emails based on the completion date of each training module, not just the hire date. - Email Recipients: The email notifications should be sent to both the new hire and their manager. - Email Content: The email should include the name and email of the new hire, along with a list of overdue training modules. Ideal Skills and Experience: - Proficient in VBA and Excel: You should have a strong background in developing macros and automating processes within Excel. - Familiarity with Employee Training Systems: Experience with tracking and managing employee training programs is a plus. - Communication Skills: You should be able to effectively communicate with me to ensure the macro meets the business req...
I am seeking a proficient CVAT Data Annotation expert. Task involves: - Annotating video data, focusing on two specific Crossfit movements: the barbell thruster and pull-ups. - Annotated data should follow a specific file format which will be further specified. - The prime goal of this annotation is to develop an I3D AI model for activity recognition. Ideal Candidate: - Has considerable CVAT data annotation experience. - Has insightful knowledge of Crossfit and its specific movements. - Proven expertise working on I3D AI models. Your role is paramount to the success of our activity recognition project. If you thrive on meticulous detail and have a passion for fitness data, this task is a perfect suit for you.
...proficient WordPress designer, specifically experienced with the Salient theme, to work with me (I am a ux designer), to re-design 11 pages in an e-comm and blog website. These are the pages that need to be re-designed: 1. Home Page 2. Shop (list of products) 3. About 4. Product Page 5. Info page 1 6. Info page 2 7. Info page 3 8. Info page 4 9. Info page 5 10. Blog 11. Blog Post Page About: The website already exists, it is built in Wordpress with salient theme. I will provide detailed instruction like wireframes, colour palette, and artwork. It will be your job to work in the backend of Wordpress and salient to pull the design together. Ideal Skills: • Expert comprehension of WordPress and Salient Theme - Ability to follow design direc...
I need a proficient VBA professional who can help develop an Excel recruitment tracker dashboard. Key components should include: - Display recruitment data in visually engaging formats including bar charts, pie charts and tables. - Incorporate dropdowns using macros form control for flexible data querying. - Capture essential data points such as candidate name, the position applied for and the application status. - Provide tracking capabilities for application status reflecting stages like pending, shortlisted, and interview scheduled. -Should have recruitment metrics like Time to hire, recruitment funnel and other key metrics The ideal candidate should have robust skills in VBA and Excel, particularly in creating dynamic and interactive dashboards. ...
...formula or action algorithm that can handle specific data manipulation tasks. This Excel tool must be able to automatically select data from a certain type of table. Hence flexibility is essential. Likewise, it should be able to arrange this selected data against particular types of rows. The formula should be customizable to adapt to various row types. The main aim is to create a solution which allows for selection and rearrangement of data based on multiple potential criteria, whether by column header, row label, or specific values even though I have not specified them at this point. Therefore, excellent comprehension of Excel data manipulation, versatility, and a deep understanding of Excel’s inbuilt functions and scripting in VBA...
As a business owner, I'm constantly confronted with the tedious tasks of data entry, data formatting, sorting, and filtering. I am looking to automate this process to save time and improve efficiency. Key Features Needed: -A VBA Macro for Excel to automate data entry and formatting of a text (.txt) file. -Automation of data sorting and filtering needs to be incorporated. Ideal Skills & Experience: -Strong proficiency in VBA and Excel. -Experience in automating data entry, sorting, and filtering via Macros. -Real-world experience dealing with text files in Excel. With your help, I envision a tool that ultimately makes my life easier and my workload manageable.
I'm seeking an expert to build a PowerBI solution, primarily for financial planning and analysis (FP&A). Key project requirements: - Robust Integration with our SQL database to pull the necessary data. - Proficiency in creating illustrative Charts and Tables in PowerBI, enhancing data interpretation. - The dashboard should effectively track and analyze the key metrics such as Revenue, Profit Margin, and Sales growth. Ideal freelancers applying for this project should have: - Demonstrable experience in PowerBI and SQL database integration. - Solid background in creating visually engaging dashboards, specifically using Charts and Tables. - A solid understanding of FP&A metrics. - Proven track record in delivering similar projects. Please submit your b...
...engineer to create a website that will pull data from one website, specifically Website A, using the Manheim API. This data will then be transferred to another website, Carvana, for comparison. Key Requirements: - Your main task will be to create a website that fetches vehicle information and condition from Website A. - The website should be able to handle a large volume of data and keep it organized for comparison. - The data should be accurately and neatly transferred to Carvana's website. Qualifications: - Proficient in Manheim API - Extensive experience in full-stack development with the ability to handle complex data retrieval and management. - Familiarity with Carvana's ...
I'm in nee...DRIVE-THRU COFFEE SHOP. Key Requirements (PLEASE READ): 1) THIS MUST BE A DRIVE THRU 2) STYLE: I envision a modern and sleek design, which aligns with the aesthetics of contemporary coffee shops. 3)FEATURES: The design must encompass key elements of a functional coffee shop including branding/signage, outdoor seating area, drive-thru menu board, and order and collection windows where a car can pull up, order, and collect at the next window. 4) STRUCTURE: The container is a SINGLE STORY 40ft SHIPPING CONTAINER and the base colour is black. The design must be sleek to fit into a business park as well as vibrant as to be seen from the nearby roadway. 5) ENVIRONS: There will be an outdoor seating area in the grass area. PLEASE VIEW THE ATTACHED PLAN & SIT...
hi evryone simple project is needed in Excel i have date which is connected to server to import data so i need to update the Date by click at the icon "Update:" [ the icon connected to hyperlink for example] please see the attachment, and after the implement needed is will take the Cell: Date + "00:01" and return it back and it will automatically update> if is it possible by usuing formula in excel or use some VBA code
I have an Excel workbook. I would like to expand that workbook and add an inventory aspect to the workbook. I am looking for a developer with extensive experience with VBA script and custom functions in Microsoft Excel 365. If the first job goes well we will have more consistent work (other jobs) to be done.
I'm in need of a PHP script to pull bank transaction data from Plaid once a day. This is a simple project and can be very ugly. I will adjust the code once I have the working script. This is what I need. A single page with a button that I can click to "Link Bank Account". This will go through the process that Plaid uses to authorize access to banking data. It should return authorization tokens... Then I need the authorization tokens to be stored in a text file in the same directory. I will re-route these into my database once I have the script. I also then need one single PHP function that can retrieve bank deposits for that linked account. I will adjust the script to pull in whatever deposits I need so for now it can just pull in ...
I am looking to accomplish functions over how it looks right now. This is a concept we are looking to get done. login/register with tiktok logout to kill the session. find videos of the user store video link, desc of video, likes, shares, and comment counts for each of say the last 10 videos. please let me know if this can be done and how much.
