Excel add com port vba jobs

...Professional Excel Specialist | Data Management & Automation ? Looking for error-free, automated, and visually appealing Excel solutions? I specialize in data management, financial tracking, and automated calculations, ensuring efficiency and accuracy in every spreadsheet. Whether it’s a salary sheet, expense tracker, or grade report, I create smart, structured, and user-friendly Excel files tailored to your needs. ? Why Choose Me? ✔ Well-Organized & Error-Free Sheets – Easy to navigate, structured, and clean layouts ✔ Automated Formulas & Functions – Save time with calculations that work instantly ✔ Financial & Payroll Management – Salary sheets, budgeting, and billing trackers ✔ Data Visualization & Reports – Inte...

Hey :)! I’m looking for someone to help me with my gamification add-on, which I developed for the Anki learning program and is based on Pygame. The game is almost finished, but unfortunately, my programmer had to step away due to family reasons shortly before completion. The basic idea of the game is that studying Anki flashcards leads to success in the game. It currently consists of two parts: - A farming game inspired by Harvest Moon: You plant seeds, log in daily to water them, and eventually harvest food. This food is used to feed and level up your Ankimon (basically Pokémon for Anki) to prepare them for the second game. - A turn-based, chess-like game: You select three of your Ankimon and battle against another trainer. Studying flashcards generates moves in the ...

I'm facing a challenge with a prompt to modify a Microsoft word file. The pro...performed the task as instructed and provides me with a link to download the new file. But when I download this file, I notice that chatgpt has in fact not made any changes to the file. Where am I making a mistake. Can you please guide me. I want to create a chatgpt prompt or agent that analyses, reviews and modifies excel and word files Requirements: - Modify both Word and Excel files - Word modifications: Text edits, Formatting changes, Content review and suggestions - Excel modifications: Data entry and edits, Formatting changes, Formula updates and suggestions 1 use case is that the prompt should modify the file Updated audit report so that the comments should disappear as show...

I'm seeking an Excel expert to automate a variety of tasks. These include: - Data Entry: Streamlining the process of inputting information into Excel. - Data Analysis: Implementing functions or scripts to process and analyze the data automatically. - Reporting: Generating regular reports based on the analyzed data. The automation will need to interact with Google Sheets. It will have to both read from and write to the Sheets. The ideal freelancer for this project would be someone with a deep understanding of Excel, experience with Google Sheets, and a knack for data automation. Python or similar programming skills would be a plus.

I am looking for a freelancer to develop a well-structured, automated, and professionally designed Excel sheet for Portfolio, Program, and Project Management, aligned with PMI standards and requirements. 1. Excel Sheet Development The Excel file should be designed for comprehensive project tracking and management, incorporating the following: A. Portfolio, Program, and Project Structure • A structured Portfolio Management sheet to oversee multiple programs and projects. • A Program Management sheet to consolidate and track multiple related projects. • A Project Management sheet for individual project tracking, execution, and control. B. Core Project Management Features (Aligned with PMI Standards) • Project Overview Dashboard: Summary of por...

I need assistance with manual data input into an Excel spreadsheet and potentially creating a format or template for the data. Key Tasks: - Manual data entry into Excel - Potential assistance with creating a suitable format/template for the data Ideal Skills: - Proficient in Excel - Experience with data entry - Ability to create and set up Excel templates Please note that I'm not entirely sure what the final format will look like, so flexibility and creativity will be key.

I am looking for a professional who can create an automated voting script for Xtreme Toplist. The script should be capable of bypassing reCAPTCHA, and supporting proxy use. Requirements: - The script must be able to facilitate automated voting on the Toplist Website. - To Use Proxy & reCAPTCHA for each vote - To Use Windows - To work on the following sites xtremetop100 topg top...professional who can create an automated voting script for Xtreme Toplist. The script should be capable of bypassing reCAPTCHA, and supporting proxy use. Requirements: - The script must be able to facilitate automated voting on the Toplist Website. - To Use Proxy & reCAPTCHA for each vote - To Use Windows - To work on the following sites xtremetop100 topg top100arena arena-top100.com gtop...

I'm looking for an Excel Macro expert to create a macro for me that will automate reporting from local Excel files on my Mac. I need this to enhance efficiency and accuracy in my data handling.

More details: What specific functionalities do you need in the inventory management sheet? Track stock levels, Automate ordering, Generate usage reports How will the initial data be entered into the inventory sheet? Manually What type of items will be tracked in the inventory sheet? Finished goods, Cleaning supplies

I'm seeking a skilled PHP developer who can seamlessly publish real-time Excel data from my PC or OneDrive onto my WordPress website. This Excel file, which contains some external links, needs to be displayed in a customized table format. Key Requirements: - Expertise in PHP and WordPress - Proficient in handling Excel data and creating table formats - Capable of implementing real-time data updates - Experience with integrating external links into Excel Ideal Candidate: - A PHP developer with a strong background in WordPress and real-time data publishing - Able to customize Excel data into a table format - Quick and efficient in delivering high-quality work

I'm looking for an Excel sheet that can help me track my daily body vitals. The metrics I need to monitor are heart rate, blood pressure, and body temperature. I will be inputting the data manually, but I also want the sheet to be compatible with data from my smartwatch. Ideal Skills: - Excel expertise - Understanding of health metrics - Experience with data tracking sheets Key Features: - Manual data input fields - Compatibility with smartwatch data - User-friendly design

I am a data analyst in need of assistance with creating a sales report in MS Excel. Ideal skills for this project: - Expertise in MS Excel - Strong data analysis skills - Experience in sales report creation Looking forward to your bids.

Looking for a freelancer to assist with data entry and creation of documents in Excel. The ideal candidate should have experience with both numerical and textual data entry, and be proficient in Excel. The project involves creating and entering less than 50 documents, and we are open to suggestions on format and templates.

Job Description: We need a detail-oriented freelancer to format and tidy up our existing educational worksheets while adding consistent AI-generated images. ? Key Task Overview: ✅ Text & Layout Alignment – Ensure all text, lines, and elements are neatly structured. ✅ Image Insertion – Generate consistent, lookalike images (AI-generated, NOT from Google) and place them appropriately in each worksheet. ✅ Prepare for Website Upload – Ensure each worksheet is visually appealing and ready for publication. ? Important Notes: DO NOT use random Google images. Use AI tools (e.g., Canva AI, MidJourney, etc.) to maintain a uniform style across all worksheets. The trial will start with 2 worksheets before proceeding to all 20 worksheets. This task is simple, and we will not ac...

...payments. Core Features: ✅ Trip Management • Manually add/edit trips or bulk upload via Excel/CSV. • Automated trip assignment based on driver availability & location. • Live trip modifications (e.g., change pickup times, cancel trips). ✅ Automated Route Optimization • Uses Google Directions API to generate optimized routes. • Real-time traffic adjustments to reduce delays. • Supports multi-passenger trips (patients traveling in the same direction). ✅ Driver Monitoring & Tracking • Live GPS tracking for active drivers. • View driver workload & trip acceptance rates. • Send manual trip reassignment notifications if needed. ✅ Medicaid Billing Integration • Generates Medicaid-compliant trip logs for ...

I need assistance in arranging data related to gemstone manufacturing on a single spreadsheet. The ideal candidate should be proficient in Excel and experienced in data organization. Key requirements include: - Proficient in Excel - Ability to manipulate and analyze data - Experience relevant to gemstone or manufacturing processes Deliverables: A well-organized and clearly presented sheet containing all relevant data for gemstone manufacturing, ready for analysis.

I need a Python script that can extract hotel names and their corresponding page links from various travel and hotel booking w...Proficiency in Python, particularly in web scraping libraries such as BeautifulSoup or Scrapy, selenium. - Knowledge of data extraction techniques and tools. - Experience with manipulating and structuring data for easy interpretation and usage. Please note that the format for the extracted data has not been specified yet, so flexibility in your coding to allow for various output formats (CSV, JSON, Excel) would be beneficial. Additionally, while the primary focus is on hotel names and page links, potential to expand the data set to include hotel addresses, ratings, and room prices would be appreciated. Please bid if you have the required skills and e...

Looking for assistance with Excel sheets and real estate tasks for my building and real estate projects. Let me know if you're interested!

We are currently seeking a skilled professional for a virtual data entry role. Below are the job requirements and expectations: Primary Responsibilities: • Enter data from PDF files into Excel spreadsheets. • Ensure accuracy and attention to detail. Job Requirements: • Proficiency in Excel. • Typing speed of at least 30 words per minute (to be verified via a typing test on ). • Ability to work virtually with high-speed wired internet (minimum 25 Mbps). • Access to a desktop computer in a professional setting. • Familiarity with remote access software such as AnyDesk or TeamViewer, as the work will be done on our computer. • Availability to work between 10:00–11:00 AM Vancouver time (Pacific Daylight Time). Additional Real ...

I'm looking for a freelancer to fix the CSS code for a Chrome add-on (Stylus) used on the website golem.de. The website has visual bugs such as misalignment and incorrect sizing in the header. Please assist with correcting these issues based on the provided code. ### Issues: 1. Header alignment should be centered. 2. Elements are larger than intended. ### Resources: - Stylus Add-on: - Current Code: (Provided) - GitHub source/style reference:

I'm looking for a freelancer to fix the CSS code for a Chrome add-on (Stylus) used on the website golem.de. The website has visual bugs such as misalignment and incorrect sizing in the header. Please assist with correcting these issues based on the provided code. ### Issues: 1. Header alignment should be centered. 2. Elements are larger than intended. ### Resources: - Stylus Add-on: - Current Code: (Provided) - GitHub source/style reference:

The work will be done using the form available at the link This page is developed in PHP, Mysql and is already ready and working with Insert and sending to the database. But I need an improvement. The form registers all information in a single table mysql and this table already has thousands of records. But I would like that when the user fills in the first field "CARGO", the database table with that same term is consulted and the other fields below are auto-filled if there was a selection. This will save a lot of time manually filling out each field, because there are already several records in the database with similar information. I will provide the Cpanel data to access the page source code and database. Is it possible for someone to help me?

I'm looking for a freelancer to create an Excel workbook that consolidates data from 7 source sheets into a main sheet. The solution should dynamically update in real-time as the data in the source sheets change. PLEASE SEE THE ATTACHED PDF FOR A BETTER UNDERSTANDING. Key requirements: - Use either Excel formulas or Power Query. VBA and Macros are not allowed. - Summarize totals for each unique combination of columns A-D from the source sheets. Note : data both sheets could go up to 1000 + rows. Deliverables: - A fully functional Excel file where the main sheet updates in real-time. - Clear documentation or a short instructional guide explaining how the solution works. Ideal skills and experience: - Strong Excel skills and expertise in using P...

Enhance an Excel file about real estate investment. I'll highlight entry values in green, correct and insert formulas when needed.

I'm looking for a custom Excel template to organize my extensive sports memorabilia collection. The collection includes various types of items, such as: - Autographed items - Trading cards - Game-used items - Pop figures - Jerseys - Balls - Movie memorabilia The template should be user-friendly, allowing for easy input and tracking of each item. Ideal candidates should have experience in creating digital templates, preferably for memorabilia or similar collections. Skills needed: - Advanced proficiency in spreadsheet software - Experience in template creation - Knowledge of sports memorabilia is a plus. Please submit your proposal if you have the required skills and experience. I am not looking to create a logo or websitr

I need an Excel dashboard created from our data that we currently track in Excel across multiple locations. The dashboard should display a variety of key metrics including: - Sales data - YOY Data - Membership Sales - Membership Conversions - Labor as a percentage of revenue - Birthday party revenue and YOY data for same week LY - Concessions Revenue and YOY data for same week LY The ideal freelancer should have: - Expert proficiency in Excel - Experience in creating dynamic dashboards - Ability to visualize data using bar charts and line graphs - Understanding of sales and revenue tracking The dashboard should be able to visualize data using bar charts and line graphs, as well as dynamic dashboard visuals. The dashboard will need to refresh data on a weekly basis. ...

I have an Excel workbook with 7 source sheets and 1 LV (Landing View) sheet. The task is to automatically consolidate data from the 7 sheets into the Main sheet using either Excel formulas or Power Query (VBA and Macros are strictly off-limits). Requirements: - The solution needs to be dynamic, updating the LV sheet in real time as data in the 7 source sheets changes. Deliverables: - A fully functional Excel file where the LV sheet updates in real-time based on data from the 7 sheets. - Clear documentation, or a short instructional guide, explaining how the solution works. Ideally, the freelancer will have strong Excel skills, expertise in using Power Query, and a good understanding of data mapping. Experience with creating dynamic Excel solu...

Scrape agent's full name, company, mobile number, and suburb from the provided RealCommercial link. Store the data in a structured spreadsheet format. Remove duplicate entries to ensure clean data. Deliver the final CSV or Excel file.

Looking for an ace designer to design a modern and premium feel homepage for my startup. The current page: The text on the page is perfect but the design is horrible. Some immediate instructions for the project: 1. Let's say we can showcase use cases like 2. I'd add our headline - The Tinder for wealth management - Your Wealth, Your Way - Financial Freedom, One Match Away 3. We need to add cookie validation. 4. We would like to showcase how the platform looks inside. 5. It would be good to divide the FAQ into 2 columns like in this 6. Have a top banner to say we have an open waiting list. 7. The design must be responsive. Here are some websites I like for inspiration: https://www

...Scientific research labs • Medical and clinical labs • School/educational labs • Governmental labs • Food testing labs • HPLC labs • Cytogenetics labs • Industrial labs Data Requirements: Each laboratory entry must include the following: 1. Laboratory Name 2. Address 3. Telephone Number 4. Email Address (mandatory) 5. Website (if available) Project Deliverables: • A spreadsheet (Excel, Google Sheets, or CSV format) containing at least 1,500 unique laboratory contacts. • Each row should represent one laboratory, with columns for the required data points above. Important Details: • Labs from Mexico or Brazil will NOT be accepted. Please do not include any contacts from those countries. • All data must be acc...

I am looking for a WordPress expert to help with my site. My site is currently experiencing slow loading speeds and I am concerned about its security. I have not implemented any significant optimizations to date. Key areas of focus: - Set up Document Plugin and migrate existing help documentation from old site (https://enly8.com/onlinehelp/) to new (). We use Echo Knowledge Base (free edition for now) - Set up Directory listing plugin (Directory Pro) and migrate existing data to new site - Enhance the loading speed: Identify bottlenecks and implement effective solutions to boost the loading speed of the site. - Fortifying the site’s security: Assess site’s current security measures and implement necessary enhancements to safeguard it from potential threats. - Few mino...

I need assistance in exporting questions, answers, and explanations from a ChatGPT report into an Excel document. The data consists of 400 items formatted as text paragraphs in the report. Please see example link below: If you open the file above, you will see there are 400 questions organised into: 1) questions 2) correct answer 3) Explanations When you try to ask ChatGPT to export all data into an excel document it doesn't do this properly. It only gives a sample of the questions. I want a freelancer to find a way so that you can instruct ChatGPT to properly export all data so it matches what is produced from before. We have over 100+ documents with each document containing 400+ questions. If you can do it for 1 correctly

I'm looking for a freelancer who can set up an automated process that transfers my inventory details from QuickBooks Desktop to an Excel sheet on a daily basis. Key Requirements: - Data Transfer: The project entails transferring inventory details from QuickBooks to an Excel sheet on a daily basis. - Data Processing: After the data is transferred, I need it to be summarized in the Excel sheet. Ideal Skills: - Proficiency in QuickBooks Desktop - Advanced Excel skills - Experience with data automation Please ensure you have the relevant experience and skills before bidding. I look forward to your proposals.

I'm seeking a proficient accountant with strong financial analysis skills and expertise in Microsoft Excel. Key Responsibilities: - Conduct comprehensive financial analysis - Manage accounts payable and receivable Ideal Skills: - Proficient in Microsoft Excel - Strong financial analysis capabilities - Experienced in managing accounts payable/receivable

...a tailored Excel template to streamline my work checks. Currently, I have to manually copy and paste complicated formulas and use text replace functions to substitute keywords like LESS and PLUS with their mathematical counterparts. For examples sake, I want to put in "(25%LESS1/8LESS1/16 of 7/8) of 1/2 of 1/2 of 8/8" in A1, and have a Cell then automatically output that info. I have used substitute functions, then did evaluate formulas, but doesn't turn out right. Key Responsibilities: - Develop an Excel template that can process long form mathematical expressions and return values automatically, saving me the tedious work. - Ensure the template can handle mixed operations including addition, subtraction, multiplication, and division. Ideal Skills: - St...

I'm in search of a proficient Excel specialist to assist with various tasks related to public data and knows how to do formulas ! . Your primary responsibilities will include: - Data Entry: Accurately inputting information into Excel sheets. - Data Analysis: Utilizing Excel's powerful tools to make sense of the data, organize it and seperate it - Report Generation: Creating comprehensive reports based on the data analysis. Key skills and experience required for the job include: - Proficiency in Excel, with a particular focus on data entry, analysis and report generation. - Experience working with public data. - Expertise in generating charts and applying formulas.

I'm looking for an Excel expert to help me create a comprehensive spreadsheet for an educational charity. Key Responsibilities: - The main purpose of the Excel Spreadsheet will be to compare various metrics of specific areas (London Boroughs) within the Region. - We need to compare a variety of metrics. The specific metrics will be populated later, but they could include population statistics, crime rates, and educational outcomes. - The level of detail in the comparison needs to cater for both high-level overviews and detailed analyses. Ideal Skills and Experience: - Proficiency in Excel is a must, with experience in data analysis and spreadsheet creation. - Understanding of educational metrics and social statistics would be a plus. - Ability to create user-f...

I have an old and heavy Excel sheet that often lags. I need an updated, optimized, and improved version without any errors. My primary use for this Excel sheet is data analysis. Specifically, I use it for: - Statistical analysis - Data visualization - Using pivot tables The sheet typically handles more than 100,000 rows of data. Ideal skills for the job include: - Advanced expertise in Excel - Experience with data analysis - Skills in optimizing Excel sheets for heavy data usage - Proficiency in creating error-free and efficient spreadsheets Please note, I need this task completed as soon as possible.

...Responsibilities: - Implement and integrate Zoho CRM, Zoho Books, and Zoho Projects into our operations via Zoho One. - Ensure the systems work seamlessly together to enhance efficiency and productivity. - Facilitate improved tracking and reporting of our financials through Zoho Books. - Optimize our project management processes through Zoho Projects. Data Migration: - I have existing data from excel on customers and past histrorical data that needs to be migrated from another accounting software to Zoho Books. This includes financial records, customer data, and project history. Ideal Skills: - Proven experience in Zoho One implementation and integration. - Proficiency in Zoho CRM, Zoho Books, and Zoho Projects. - Strong understanding of financial tracking and reporting. - Exp...

I'm looking for an experienced data analyst who excels in working with Excel spreadsheets. Your primary tasks will involve: - Data entry and formatting: I have a substantial amount of data that needs to be inputted and formatted correctly in Excel. - Data analysis: Once the data is properly formatted, you'll be responsible for analyzing it in Excel. The ideal candidate will have: - Proficiency in Excel, including advanced functions and formulas - Strong skills in statistical analysis - Attention to detail to ensure data accuracy - Ability to meet deadlines If you're up for the challenge, I'd love to hear from you!

I need a straightforward Excel sheet that helps me calculate my monthly expenses. I want to be able to input daily amounts and have them total automatically. Expenses to Track: - Material - Invoices - Tools - Gas - Other - W9 - Cash - Cows Key Requirements: - The Excel sheet should be organized for daily entries with a monthly total - No charts or visual aids are required, just a simple, functional design Ideal skills for this project include: - Proficiency in Excel - Experience in creating user-friendly spreadsheets - Ability to understand and cater to specific data tracking needs

I need expert assistance to set up and manage my MySQL database on a Windows server. Specific Tasks: - I have MySQL installed. I have several very large files I want to import, but MySQL is telling me they are to large - Database Optimization: Once imported I want the database set u...a Windows server. Specific Tasks: - I have MySQL installed. I have several very large files I want to import, but MySQL is telling me they are to large - Database Optimization: Once imported I want the database set up in a certain way - Generally need advice on how to update the database - Report generation: I need specific reports generated . I'm not sure the best tool to do this but maybe excel? I'd like to form an ongoing relationship with an expert to help me develop the database an...

I'm seeking an experienced data engineer for a project focused on building and managing a data warehouse using Amazon Redshift. Key Responsibilities: - Design and implement a comprehensive data warehouse on Amazon R...data warehouse on Amazon Redshift. - Work on optimizing the performance of the warehouse. - Able to potentially integrate various data sources in the future. Ideal Skills: - Proficient in Amazon Redshift. - Strong background in data warehousing concepts. - Experience with performance tuning of data warehouses. - Knowledge of various data source types (Relational databases, NoSQL databases, CSV/Excel files). Please note that the integration of diverse data sources is a potential future requirement, so having the skills and experience to handle this would be hig...

I'm looking for an experienced developer to port existing Arduino and Raspberry Pi project (found at ) to an STM32 microcontroller. The project involves sensor integrations, data logging, and control algorithms. Key Requirements: - Porting critical features from the existing project - Implementing WiFi capabilities using the STM32's built-in WiFi module - Open to using alternative libraries or frameworks instead of the ones used with Arduino and RPi Ideal Skills and Experience: - Proficient in STM32 programming - Experience with Arduino and Raspberry Pi - Knowledge of sensor integrations and data logging - Familiarity with control algorithms - WiFi module implementation experience - Ability to suggest and use alternative libraries or frameworks.

I need assistance with combining 1-2 Excel documents for the purpose of archiving. Ideal Skills and Experience: - Proficiency in Excel - Attention to detail - Data management skills

I need a comprehensive Excel-based ERP application that focuses primarily on Financial Management. This mini-ERP should help me manage my processes, see projections, and calculate finances seamlessly. Key features of this Excel Dashboard should include: - Real-time tracking of income, expenses, and cash flow. - Advanced income and expense categorization and tracking (e.g., specific projects, departments). - Trend analysis and forecasting capabilities. - Automatic bank reconciliation with accounting records. I require a professional who has: - Proficient Excel skills and experience in creating ERP applications. - Strong understanding of financial management principles. - Ability to incorporate advanced tracking and forecasting features. Please note, while Financial ...

...proficient Excel macro developer who can automate a series of tasks for me. The primary objectives include: - Data Cleaning: Streamlining and organizing data to enhance its quality and usability. - Report Generation: Automating the process of report creation to save time and effort. - Complex Calculations: Building macros to perform intricate computations seamlessly. The macros will primarily interact with Excel files and Databases. As for triggering the macros, I would like to initiate them manually. Ideal skills and experience for this job: - Strong proficiency in Excel and VBA (Visual Basic for Applications). - Prior experience in developing macros for data cleaning, report generation and complex calculations. - Familiarity with databases and ability t...

I'm in need of a detailed Excel sheet for my company, specifically for the Operations department. This sheet should include various registers and time sheets, all interlinked with formulas for seamless data flow. Key Components: - Invoice Register - Expense Register - Salary Register - Employee Time Sheet - Invoice Incoming - Invoice Outgoing - Outgoing Purchase Order - Purchase Order Incoming (Sales Order) - Apex and Opex Register - Asset List - Billing Forecast - Expense Forecast - Hire Employee List and Salary Register - Payroll Master and ESOB Calculator and Register The project also requires the creation of a single dashboard. The main purpose of this dashboard is to track the financial performance of the company. It should prominently display: - Total revenue and exp...

I'm looking for a skilled Excel VBA developer. I need a worksheet modification that will control data entry into cell H8 based on the status of cell D8, and enforce data type constraints. Requirements: - If cell D8 is BLANK: Allow user to enter data into cell H8. - If cell D8 IS NOT BLANK: Populate cell H8 with data from cell H12 and lock the cell from user changes. - Implement numeric-only validation for cell H8. Additional Information: - Cells D8, H8, H12 are unlocked and the sheet is password protected. - The functionality should persist for future users, even after data row 8 has been saved and cleared by an existing VBA script. Ideal skills include: - Proficiency in Excel and VBA - Experience with implementing data validation and conditional ...

I need a freelancer who can help me to create a bill from an Excel sheet and convert it into both an Excel file and a PDF. Ideal skills and experience for the job: - Proficiency with Excel - Experience with creating bills - Knowledge of PDF conversion - Attention to detail - Ability to meet deadlines