Vba extract sheet name jobs

I need a proficient web scraper to extract car models and prices from various car rental websites, specifically Hertz, Avis, Sixt, and Budget. This data will be collected on a weekly basis.

I'm in need of a Google Sheet that consolidates real-time grain cash bid information from local and regional elevators into one accessible location. Key Requirements: - The sheet needs to pull data from specific elevator websites: ADM Sauget, Bunge, Green Plains, and Cargill. - It should only focus on updating cash bids in real-time. Ideal Skills: - Proficiency in Google Sheets and data scraping. - Experience with automating Google Sheets for real-time data updates. - Familiarity with grain elevator cash bid data. This project will be a great fit for you if you're adept at creating automated Google Sheets and have experience working with real-time data.

...locations. Collect key information (business name, address, phone, website, and GMB optimization gaps). Organize findings into a Google Sheet. Google Business Profile Setup (When Hired): Set up and optimize GMB profiles for businesses that hire my services. Ensure profiles are fully optimized, including accurate business details, professional photos, and keyword-rich descriptions. This is an excellent opportunity for a freelancer with strong Google Maps research skills and experience with GMB optimization, who is looking for consistent, part-time work. Responsibilities: 1. Google Maps Research (Daily): Research 20–30 businesses daily to identify leads with poorly optimized GMB profiles. Compile research findings into a well-organized Google Sheet. 2. Google ...

I need assistance to extract data from a PDF document into an Excel spreadsheet for 200 organisations. The data includes organisation names, emails, telephone numbers, and postal addresses. Key Requirements: - Proficient in data extraction and Excel - Previous experience working with PDF files - Attention to detail to ensure data is accurately transcribed It is essential for the freelancer to have the ability to carefully transcribe the information from the PDF to the Excel spreadsheet without errors.

I'm looking for an Excel expert to create a training management sheet for me. Features of the Excel sheet should include: - Tracking of employee details - Logging of training topics - Scheduling and recording of training dates The primary use of this Excel sheet will be monitoring progress of employees throughout their training. Therefore, the sheet should be designed in a way that makes it easy to track individual progress and overall training effectiveness. Ideal skills for this job include: - Advanced Excel skills (formulas, pivot tables, data validation) - Experience in creating training or attendance tracking sheets - Understanding of training program metrics

...House API () with a Microsoft Access database using VBA. The goal is to retrieve directors' and secretaries' names and store them in a table, using company numbers from another table. Below are the detailed requirements: Requirements: 1- API Connection Setup: Establish a connection to the Companies House API using VBA in MS Access. Let me know what API type and credentials for authentication are needed. 2- Data Retrieval: Retrieve directors' and secretaries' names using the company numbers from an existing table in the MS Access database. Ensure the data is accurately parsed and stored in a new table (Optional). 3- Automation: Develop a VBA script to automate the data retrieval process. Additional Notes: Include instructions on how to use

We need to have the 2024 Rate card converted to an Excel sheet. They have discounted rates by 12.5% for Platinum Winter and 15% for Gold Winter, as shown in a column.

I need a WordPress developer to create a simple function that does the following: **Fetch Data from SQL: Retrieve the correct row from an SQL database based on a value passed in the URL query (e.g., ?workorder=12345). Extract the corresponding URL from the database. Display PDF: Use the retrieved URL to display a PDF file in a viewer, such as , in the same way as in this demo: **Integrate with Forminator: Pass the retrieved URL into a hidden field in a Forminator form, allowing it to be submitted with the form. **Additional Information: * The website is built with Oxygen Builder. * You will have access to all necessary systems to complete the task. * If you have experience with WordPress, SQL, PDF viewers (e.g., ), and Forminator, this task should

I'm seeking a talented writer experienced in crafting Wikipedia articles to create a biographical piece about a public figure. Key Requirements: - Proven experience in writing for Wikipedia - Exceptional resea...figure. Key Requirements: - Proven experience in writing for Wikipedia - Exceptional research and writing skills - Ability to adhere to Wikipedia's standards and guidelines - Capable of creating a compelling and neutral biography I can provide a wealth of resources including: - News articles - The official website of the subject - Interviews Your task will be to sift through these materials, extract the most relevant information, and present it in a manner that's suitable for Wikipedia. Please ensure to maintain a neutral point of view and adhere to Wikipe...

Freelance Opportunity: AP Script Expert for Excel Sheet Automation We are looking for a skilled AP Script Expert to help automate processes in Excel sheets for our business. The ideal candidate should have expertise in creating, editing, and debugging Google Apps Scripts to streamline data handling, calculations, and report generation. Requirements: Proven experience with Google Apps Script for Excel/Google Sheets automation. Ability to create custom scripts to automate repetitive tasks, manage data, and enhance productivity. Knowledge of integrating third-party APIs (if needed) with Google Sheets. Strong problem-solving and debugging skills. Effective communication and ability to meet deadlines. Scope of Work: Analyze the current Excel workflow and identify automation opp...

I have a project which involves processing a spreadsheet of 4100 EANs. The primary task will be identifying the SKU and size from the data. The EANs are currently stored in an Excel (.xlsx) spreadsheet. - Skills Requirement: Proficiency in Excel and data mining is essential. Experience with SKU and size identification will be a significant advantage. - Task: Extract SKU and size information from the provided EANs data. Please note, the specific SKU and size information that needs to be extracted has not yet been defined. A flexible approach and readiness to adapt to evolving project requirements will be key.

I need assistance with an Excel file. The city name is currently located in the middle columns and needs to be moved to a different column. All of the data is in one sheet. The ideal freelancer for this project should have: - Proficient Excel skills - Attention to detail - Data management experience

...allow customers to browse products, place orders, and receive updates. Project Requirements: Product Display: Showcase MiG-25 protein powder with images, descriptions, and pricing. Order Placement: Enable customers to place orders directly through the app. User Authentication: Allow customers to create accounts or log in for personalized features. Backend Integration: Connect the app with a Google Sheet or Airtable for managing product inventory, orders, and customer details. Payment Gateway: Include an option for payment processing (optional: Stripe, PayPal, etc.). Notifications: Set up email or in-app notifications for order confirmations. Responsive Design: Ensure the app works seamlessly on mobile and desktop. Preferred Skills: Proficiency with Glide app development. Strong ...

I'm looking for an expert Java developer who can assist me with a project focused on creating a specific web application. This involves using Visual Studio Code (VSC) and developing weekly content to complete the assignment. Key Res...implementing user authentication and database interaction features. - Excellent content creation skills. - I have attached the assignment details (its in 3 parts), sot the students should be able to provide 3 submission. - I have attached the weekly contents in excel sheet. I will need you to be good in creating weekly contnets meeting the topic lsited in the excel sheet but at the same time implementing the skills and knowledge toward completing the assignment. Please only contanct me once you go through the assignment and the excel ...

...(advance, standard, last-minute). Show Name: Clearly state the name of the show from which ticket price data was collected. Note whether the show is a long-running production or a special/limited run (if evident). Deliverables Excel Spreadsheet Detailed table for each theatre showing: Ticket price ranges by seating category (premium, mid-tier, budget). Seating category proportions (estimated). Dynamic pricing variations (day-of-week, seasonal, and time-based trends). Show name for each dataset. Summary sheet for ownership groups with: Aggregated ticket price ranges. Pricing trends by group and time of purchase. Evidence Folder Include screenshots showing: Ticket prices for each theatre. Dynamic pricing variations (where applicable). Seating plans (if availabl...

I'm in need of a proficient VBA CorelDRAW programmer for the 2024 version. My project involves creating a VBA script that generates QR codes within a specific template of a certain size. The script should also arrange these QR codes for printing on various printer sizes, specifically a custom size of 48x96 inches. Ideal candidate should be skilled in: - CorelDRAW and VBA - Understanding of QR code generation - Experience with custom printer size arrangements - Ability to work with specific size templates (small, medium, large)

I need a professional who can help me extract data from my Clover POS system on a daily basis. This data extraction will specifically focus on orders, with an emphasis on breaking out taxes and fees separately instead of having them lumped together as 'fees'. Key Requirements: - Data needs to be extracted daily and made available for download from a secure server. - The extracted data must be formatted in Excel. Ideal Skills and Experience: - Proficiency in data extraction from Clover POS system. - Expertise in Excel for data formatting. - Experience with secure server data handling. - Ability to meet daily deadlines. Please note, the goal is to have a detailed, clear and precise breakdown of each order, with taxes and fees itemized separately. This is essential for my ...

I need an Excel sheet specifically designed for conducting profit and loss analyses. The primary function of this sheet will be to facilitate financial calculations. Key Requirements: - Creation of an Excel sheet tailored for profit and loss analysis - Integration of functionalities for various financial calculations Data Entry: - All data will be entered manually, so the design should be user-friendly and intuitive for manual data input. Ideal Skills: - Proficiency in Excel - Experience in financial analysis - Ability to create user-friendly spreadsheets

I'm looking for a professional tester to conduct thorough testing on my website before we go live. The testing should cover both the front-end and back-end, with all glitches and errors documented in an Excel sheet, categorized, and using Scrum methodology. Front-End Testing: - Usability testing: Assess the user experience and interface design. - Performance testing: Measure the responsiveness and stability. - Cross-browser testing: Ensure consistent functionality across multiple browsers, specifically Chrome, Firefox, and Safari. Back-End Testing: - Security testing: Identify any potential vulnerabilities. Ideal candidates for this project should have extensive experience in website testing, and be proficient in using Excel for documentation and Scrum for project management...

I'm looking for a professional logo designer to create a sleek, modern logo for my dental laboratory. The logo should incorporate a tooth icon and follow a blue and white color scheme. Ideal skills and experience for this job include: - Proven experience in logo design, particularly in the medical or dental field - Strong understanding of modern design aesthetics - Ability to work with specified color schemes - Creative thinking to incorporate a tooth icon into a professional design The final design should be clean, minimalist and easily recognizable, representing the quality and precision of our laboratory.

...experienced web developer to repair and implement a function that allows users to download free sheet music after registering via a pop-up form. The pop-up form should collect user details and ensure the visitor is added to the mailing list via the Arigato Pro plugin, but only if the visitor is not already registered. The issue is currently present on certain pages of our website, , including the page “A Minor Indulgence – Free Sheet Music for the Flute.” Key Responsibilities: -Repair Existing Function: Replicate the working functionality of the download button from the page Free Sheet Music for the Flute – A Minor Indulgence to the page A Minor Indulgence, by Andrew Scott – Free Sheet Music for the Flute. -User Registration and...

As a modern company, I'm seeking a logo for my website that encapsulates the essence of our brand with a sleek, minimalist design. Key requirements: - The logo should primarily represent our company name. - It should embody a modern, minimalist style. - Creativity is key, as I want a unique design that stands out. Ideal skills: - Proficiency in graphic design software. - Strong portfolio of modern logo designs. - Excellent understanding of minimalist design principles.

I'm seeking an automation expert to help extract product information from an FTP server and update my Shopify store. Key Requirements: - Extract product information from the FTP server - Automate the process to ensure regular updates on Shopify Ideal Skills and Experience: - Proficiency in data extraction from FTP servers - Experience with Shopify updates - Automation expertise - Familiarity with product information management. Note: The specific product information to be extracted and updated, as well as the format of the data on the FTP server, will be discussed further. Please bid if you have relevant experience and can provide references.

...actionable insights. Key Features and Requirements: 1. Task Management Automation • WW Team: a) Automatically retrieve daily orders from Smartsheet and export them into Excel. b) Create an editable Excel sheet for my team to update their progress on orders. c) Generate KPIs such as: • Completion times for orders. • Missing parts or delays per order. d) Provide a clear summary of completed orders. • PP Team: a) Download two sheets (latest status of orders and a new list of orders). b) Organize them in chronological order in an Excel sheet for tracking. c) Include fields for: • Picker’s name. • Total boxes. • Completion time/date. • Total time per order (to calculate picking efficiency KPIs). 2. Gemba Walks and ...

I need an expert in Excel 365 who can link two sheets for me. The first sheet should update the second in real-time. - Data Type: The data to be linked is mixed, consisting of both text and numerical data. - Version: The linking has to be done in Excel 365. Please only reach out if you're proficient in Excel and can ensure real-time data linking. Thank you.

I have multiple Excel files that need to be consolidated into a single Excel workbook. Each file should be placed in a separate sheet named according to its original file name. No data transformations or cleaning are required. Ideal skills for this project include: - Proficiency in Microsoft Excel - Experience in data consolidation tasks - Attention to detail to ensure correct file placement and naming.

Proposal for building a new scraper which contains feature. all sku from google sheet 2. Go to Website tradezone and serach for SKU 3. Fetch data like price and other required details. 4. Save Scraped data back to Google sheet Apart from all other feature you will get a two month of support as well.

I'm looking for someone to collect and verify data of CEOs and Managing Directors from the provided link. The total will be data from 3900 companies. Data Requirements: - Full name and title - Email and contact number - Company address Please check the Google sheet and make a sample of 10. If the sample is satisfactory, we can continue with the project. The highlighted columns in yellow are the ones I need. Budget is fixed, please only bid if you agree with the budget.

Hello, I have experience in Python, web scraping, and data extraction using tools like Scrapy, Pandas, and Selenium. I can quickly debug your script and ensure it meets all your requirements. Here’s how I plan to help you: 1. Fix bugs in your script within 2-3 hours. 2. Add functionality to match conditions and extract data as per your requirements. 3. Provide an easy-to-use script for future use. I will deliver the output in the required Excel format. Looking forward to your response so we can start immediately! Budget: $8 (as per your project description). Timeframe: First phase within 2-3 hours. Thank you,

I'm seeking a proficient Excel VBA programmer to create a script for my Purchase Order workbook. This project involves both an existing workbook and the creation of a new one. The VBA script should be triggered automatically when the workbook opens. Key Tasks: 1. Implement filters at the top of the worksheet. 2. Adjust the width of Column C (Products). 3. Insert new columns with specified modifications: a. After Column I: Discrepancy (using formula: =I2-H2) b. After Column J: Reason (with a dropdown list sourced from the next sheet) c. After Column K: Notes (a free text column) 4. Apply specific formatting to the columns: a. Column A: 40 points b. Column B: 10 points c. Column C: 60 points d. Column D: 35 points e. Columns E-J: 15 points ...

I'm looking for a skilled web scraper with API development experience. The task involves extracting product information from three specific websites. Key Requirements: - Extract product descriptions from specified websites - Develop an API to facilitate this - Present data in a user-friendly JSON format Ideal Skills: - Strong background in web scraping techniques - Proven experience with API development - Attention to detail - Ability to work independently If you've successfully completed similar projects in the past, I would love to hear from you!

I'm seeking a professional engineer to design a TPE sheet extrusion machine meant for industrial production. The machine needs to be capable of processing Thermoplastic Elastomer (TPE) and producing sheets with a width of 1800 mm. Key project specifications: - Design must cater to industrial-scale production - Compatible with Thermoplastic Elastomer (TPE) - Producing sheets of 1800 mm in width Ideal candidates should have extensive experience in machine design, particularly for industrial production, and knowledge of TPE materials. A portfolio demonstrating past successful designs will be highly advantageous.

I'm seeking an expert in plastic sheet extrusion machine design. The primary objective of this project is to create a machine capable of producing TPE sheets, which will be used specifically for the manufacturing of car mats. Key Requirements: - Design of a plastic sheet extrusion machine - Specific focus on TPE sheet production line - Should have experience working with some machine manufacturing company

I'm in need of a creative and unique name for my Australian cuisine food delivery app. This app caters to all types of Australian food, targeting both locals and tourists, and is built on the principles of fast delivery, fresh and local ingredients, and ultimate convenience. My requirements are: - The name must not be trademarked worldwide. - It should reflect the app's values of speed, quality and ease of use. - It needs to be catchy and appealing to a wide audience. Experience with branding and knowledge of international trademark laws would be highly beneficial for this project.

I'm in need of a seasoned Chartered Accountant who can effectively analyze my business's annual financial performance. Your main responsibilities will entail: - Creating a comprehensive summary of all the profits and losses I've encountered over the year. - Providing a detailed breakdown of the Balance Sheet, Cash Flow Statement, and Equity Statement. I will provide you with full access to my accounts. The final report should be delivered in an Excel spreadsheet. Ideal candidates should possess: - Extensive experience in financial analysis. - Proficiency in creating detailed and understandable Excel reports. - Prior experience working with small to medium-sized businesses. Please include examples of similar projects you've completed in your application.

...for Instagram, Facebook, and TikTok. * Visuals: Quick rhythmic cuts of band performances, interspersed with gritty urban footage reminiscent of Montreal or NYC, and striking pop art style inserts. * Text/Graphics: Display of our band name and album title, using preferred fonts and open to evolving styles. * FX Styles: VHS Aesthetic, Dark Noire, Glitchy, Vintage MTV, Pop Art (like the old Batman TV visuals). Materials Provided: A mix of live show photos and VHS-digitized footage, ranging from crisp to vintage blur, via Dropbox. Bonus Skills: 1. Ability to extract usable snippets from low-profile films and YouTube visuals. 2. Capability to animate still images using AI technology. Please share your ideas and cost estimates for bringing this vision to life...

I'm seeking a skilled Excel programmer to create a macro. This macro should compile various employee data from different sheets into a new Excel sheet. The task involves data cleaning, analysis, and report generation. Key Requirements: - Experience in Excel macro development - Understanding of data cleaning and analysis - Ability to generate summary reports, pivot tables, charts and graphs - Familiarity with handling employee data Please note, the goal is to create a macro that can automate this process, saving time and ensuring consistency in data compilation.

$15.00 Job I have a URL: I'd like to make it so users cannot change the room name "room=hamchat" If a user tries to change the room name it will default back to Ideal skills and experience for the job: - Proficient in URL manipulation - Understanding of web development and server-side scripting - Capacity to implement access control measures

...mortgage foreclosure excess proceeds data. This is a flexible, ongoing position with cash bonuses for honesty and accuracy. Your main task will be to find data on mortgage foreclosures sold within the past 90 days. Key Responsibilities: - Collect data from public records, real estate websites, and county auctions. - Input data into an Excel sheet with a flexible structure. Key data points include: date of sale, foreclosed address, city, county, state, owner name, phone, email, opening and closing bid. - Leave cells blank for missing data. Ideal Skills and Experience: - Previous experience in data collection, particularly in real estate or mortgage foreclosures is preferred. - Proficiency in Excel with a keen attention to detail. - Strong understanding of honesty and acc...

I'm looking for a web developer with experience in building on Squarespace or Wordpress to create a site for me that showcases and facilitates the sale of my privately owned domain names. Key Requirements: - The site should have sections for the Home, Domain Listings, Contact Page, and About. - Each domain listing should have the option for me to include a branding Image shown simiar to a thumbnail, that can be sold as an addition to a domain purchase, for a small fee. - An eye for design and user experience is crucial, as the site needs to be visually appealing and easy to navigate. Similar colors and feel as Godaddy. -I'll need Afternic and Escrow.com Ideal Skills: - Proven experience with Squarespace - Excellent design and UX skills - Ability to integrate e-commerce func...

I am seeking an experienced Bubble developer with expertise in API workflows and JSON parsing to help me complete a backend workflow in Bubble. The goal is to process data from QuickBooks Online’s Balance Sheet API and store specific values, such as "Total Bank Accounts" and "Total Accounts Receivable," in a Bubble database. I already have: - A working API connection in Bubble that returns the JSON response. - A backend workflow triggered by the API call. What I need help with: - Extracting specific values from the returned JSON response, such as: "Total Bank Accounts" and its corresponding balance. "Total Accounts Receivable" and its corresponding balance. - Mapping these extracted values to fields in a Bubble database Thing. - Ensuri...

...Extraction Bot Developer Position Overview: Looking for a Python developer to create a YouTube channel caption extraction bot with specific requirements for handling large-scale video processing. Project Requirements: Create a bot that processes YouTube channel video pages (e.g., @TheCookingFoodie/videos) Core Functionalities: Process all videos from a channel's video page Extract and save: Video titles Video URLs Closed captions (CC) Save data in text files named after each video Process videos chronologically (oldest to newest) Handle 1000-2000 videos per channel Technical Specifications: Language: Python Implementation using Python requests or YouTube-specific libraries Error Handling Requirements: Handle video page loading failures with refresh capability Log videos

I need a skilled Python developer to create a web scraper for me. The scraper should be able to extract structured data, like tables, from various e-commerce websites. The project requires a deep understanding of web scraping techniques and best practices in Python.

Please Sign Up or Login to see details.

...receive $20 as a contest prize. Multiple winners (2-3) may be chosen if there are several qualified candidates. Video Requirements Flute Players will play the tunes only (no tutorials or announcements necessary). If hired, you are welcome to use the videos you create to promote your flute-playing career, but you may not offer them for sale or distribute any provided sheet music. Important Terms All sheet music usage is for personal use only and may not be shared or uploaded elsewhere. retains ownership of the video copyrights and reserves the right to publish them. Bidding Guidelines Also quote your price for creating all 140 videos (NOT your hourly rate). No place marker bids—your bid price should reflect your total price. Applications ...

I'm looking for a research assistant who can help me collect and analyze both quantitative and qualitative data for an academic project. Key Responsibilities: - Data Collection: Gather both quantitative and qualitative data relevant to the research. - Data Formatting: Organize and prepare the collected data in Excel/CSV files and Word documents. - Data Analysis: Analyze the data to extract meaningful insights. Ideal Skills: - Proficient in data collection and analysis - Experienced in academic research - Skilled in using Excel and Word - Capable of working with both quantitative and qualitative data. Please, only apply if you're experienced in academic research data collection and analysis.

...I will provide access to BigQuery so the freelancer can set up datasets and organize the data directly within the platform. Scope of Work: Data Extraction and Transformation: - Extract data from SQL tables (e.g., inventory, item details, sales history) based on specific fields and filters - Ensure data is cleaned and formatted for smooth loading into BigQuery. BigQuery Setup and Organization: - Access BigQuery to set up and structure datasets (e.g., inventory_data, sales_data, item_details). -Ensure the datasets are organized and optimized for analytics. Python Automation: Develop Python scripts to: - Extract data from the SQL database. - Load data into BigQuery, ensuring incremental updates and handling duplicates. - Schedule the scripts to run multiple times a day u...

I'm looking for a Java developer to create an applicatio...store data of customers and hawkers in an organized manner, and will include several important features. Key Data to Store: - Customers: Contact information, Subscription details, Address (Street, City, Pincode), Area (Linked to the Area Panel), Subscription Start Date, Hawker Assigned - Hawkers: Contact information, Subscription details, Delivery routes Essential Application Features: - Excel sheet export button - Database storage - Bill generation option Technologies to be used: J2SE, JavaFX, and MYSQL. The ideal candidate should have extensive experience with these languages and technologies, and should be able to create a user-friendly interface. Please provide examples of similar projects you have worked on in...

I'm in need of a Python developer who can create a script for me. The script should be capable of extracting goals from ChatGPT's output and organizing them into a JSON file. Goals should be categorized by their dates. Key Requirements: - Proficient in Pytho...can create a script for me. The script should be capable of extracting goals from ChatGPT's output and organizing them into a JSON file. Goals should be categorized by their dates. Key Requirements: - Proficient in Python programming - Experience with data extraction and JSON formatting - Ability to write efficient, clean, and well-documented code The script needs to be able to identify and extract any goal recommendation based on following duration: - Week - Month - Year Please provide examples of similar p...

I'm in need of a professional and corporate-themed Facebook background wallpaper for my rideshare service. The design should be modern and sleek, utilizing the primary colors of orange and cyan. Key Elements: - The design should feature cars with a happy person in them, navigating around a city. - The overall color palette should be orange and cyan, consistent with our branding. - The design should maintain a professional and corporate feel, despite its vibrant subject matter. Ideal experience would include: - Graphic design with a focus on modern, corporate aesthetics. - Experience creating social media graphics. - Understanding of branding and color palette consistency.