Simple excel vbaemplois

Data Collection Excel Project I am looking for a freelancer who can help me with a data collection project. The project requirements are as follows: Type of data to be collected: - Sales data Source of the data: - Public records Organization of the data in the excel sheet: - By date Ideal Skills and Experience: - Proficiency in data collection and organization using Microsoft Excel - Strong attention to detail and accuracy in data entry - Familiarity with public records and their sources - Ability to work efficiently and meet project deadlines If you have previous experience in similar data collection projects and possess the necessary skills, please submit your proposal.

I am seeking a skilled Python developer who can create a script tool that can scan and assess both grade sheets and an...that can scan and assess both grade sheets and answer bubble sheets. Here's what I need: - A system that can accurately scan different types of sheets and convert the data into actionable information. - All assessments must be stored in an Excel format, organized by school. - In addition to other relevant details, I need the tool to extract class data from the scanned sheets. - read paper by scanner(desktop_application) Experience with OCR (Optical Character Recognition) would be a major advantage, as well as a firm understanding of data management and Excel formats. Proficiency in Python is absolutely necessary. Please ensure you have relevant expe...

I need assistance with data collection from online databases, primarily working with customer data. This role involves gathering and organizing necessary information into a structured and usable format, and will require: - Proficiency in browsing different online databases with a keen eye for detail - Expertise in organizing large sets of customer data - Verification skills to ensure data accuracy - Excellent understanding of data privacy standards Experience in similar projects will be highly appreciated. Knowledge of CRM systems will be a bonus, but is not mandatory. A successful partnership on this project could lead to long-term collaboration.

I'm looking for a graphics guru to extract approximately 1000 images from their backgrounds, leaving them transparent. The originals are simple in shape, and I'd need you to deliver the edited versions in both JPG format (with gray background) and as layered PSD files. For this project, you'll need: - Expertise in Adobe Photoshop - A keen eye for detail to keep the cutouts clean and sharp - An understanding of image formats and their conversion This is a per-image payment gig, with a remuneration of €0.10 per processed image. Perfect for those confident in their ability to complete lots of work accurately and efficiently. If this sounds like you, feel free to bid with relevant experience and sample work. Looking forward to a smooth and productive collaboratio...

I need an experienced data entry professional to help me with an Excel task. The task will be centered around accurately entering data, with no more than 10 columns and 50 rows. Your responsibilities will include: - Accurate data entry into excel forms, resumes, or sheets - Understanding data entry forms and capturing information efficiently - Ensuring accurate, up-to-date entry of the data To excel in this role, you should be proficient in Excel and have meticulous attention to detail. Essential skills needed for this job include: - Strong Excel skills - Accuracy and attention to detail - Strong data entry skills By the end of this project, I expect to have an accurate and updated Excel sheet. Knowledge in Excel functions and formulas ...

I am seeking an experienced 3D designer, preferably proficient in Blender, AutoCAD, or SketchUp, to work on a project of low complexity. The perfect candidate for this project should: - Have significant experience in 3D designing, especially lower complexity projects with few elements and minimal details. - Be able to explain their designing process in clear, concise terms. - Be willing to demonstrate their skill set and ability to adhere to my project's specific needs through their previous work, although this is not a necessity. The principal focus will be on the quality of experience and understanding the ability to implement simplicity in designs. I look forward to reviewing your applications.

I need a competent developer to create a Material Management System that specifically focuses on an Inword and Outword System. This system is aimed to efficiently manage and track our internal communication and revisions of documents. Main Features Needed: - Inventory tracking - Purchase order management - Document storage and organization Ideal Skills: - Proven experience in developing robust management systems - Proficiency in coding and database management - Superior understanding of material management principles - Attention to detail and excellent problem-solving skills. This project requires a keen eye for detail and a robust understanding of how to manage materials effectively. With your help, we can streamline our internal processes and improve our overall productivity.

I am in need of an expert Word VBA programmer to: - Develop custom macros for Word documents - Make these macros capable of converting Word files (.docx) to PDF, and vice versa (this PDF file -> .docx) using the website (PDF to WORD Converter) or free API (similar like quality). The ideal freelancer for this project will: - Have in-depth knowledge and experience in Word VBA programming and macro development - Be familiar with file conversion resources such as - Be capable of thoroughly testing the macro to ensure it functions correctly, specifically for document conversion. The goal of this project is not only to automate document conversion, but also to enhance workflow efficiency. If you are keen on taking part in this project, kindly send in your

I am on the lookout for a skilled graphics designer with proficient experience in vectorisation. For my project, the task will be to convert part of a image into a vector format. Points to note: - The primary reason behind vectorization is for utilizing the design in laser cutting. The picture is of a lighthouse. I already have an example of what i need. will send on contact. It is important to make the design, to identify the object. Its a specific lighthouse, i need it to be recognisable. I just need the lighthouse in the pictures vectirized to be able to cut it on a laser cutter. Please dont offer your service, if you dint consider this an easy job :-)

I am seeking an experienced, proactive sales representative skilled in SAS software and cold calling to drive sales among small to medium-sized businesses. The successful applicant needs to excel in prospecting and presenting, and have an impressive track record of exceeding targets. The key responsibilities will include: - Making a high number of sales calls each day - Converting a substantial number of leads to sales The ideal applicant will have: - Proven knowledge of SAS software - Excellent interpersonal skills - Extensive experience in cold calling - A previous B2B sales role is preferred Let's smash these targets together. Apply now! Strictly commissioned based on 20%, with the possibility for long-term employment if targets are met.

I am looking for a freelancer proficient in Excel who can efficiently handle data entry tasks. These tasks involve inserting text, numbers, and dates into Excel tables for a set of up to five tables. Each table will feature six columns and a variable number of rows. Ideal Skills and Experience: - Proficiency in Microsoft Excel - Experience in data entry - High attention to detail - Familiarity with text, numerical, and date-focused data - Ability to work within specific formats and structures. Your role is critical in ensuring these tables are filled accurately and promptly. Clear communication and commitment to the deadline are also imperative in this project.

For my evolving project, I am looking for a freelancer adept at data extraction and conversion from a webstore to CSV. Your task will be: - Convert an online store’s catalogue, currently in Excel format, into a CSV file. - The CSV file needs to include the following fields: Product Name, Product Price, Product Specifications, Picture URL, and Product Category. - Specifically, full resolution images are required for the Picture URLs. To align with my requirements, you need to have: - Strong Excel skills - Experience in data extraction - Familiarity with CSV file format - Understanding of image URL extraction and handling. This is an exciting opportunity to demonstrate your technical prowess in data manipulation and we look forward to potential collaborations.

Looking for an expert who can assist with Excel automation, specifically for data analysis purposes. Proficiency in Excel 2016 is crucial. - Skills Needed: * In-depth knowledge of Excel 2016 * Proven experience in automating Excel functions * Ability to troubleshoot and unlock password-protected files * Strong understanding of data analysis techniques The project involves enhancing the efficiency of routine tasks around data analysis. As I have elected not to provide specifics on the types of data analysis procedures to be automated, I would appreciate your input on leveraging the capabilities of Excel to streamline these processes. Please note, we will be dealing with a password-protected file, so a solid experience in handling such cases wi...

I require a dedicated professional who can take a series of scanned, handwritten PDF files and accurately translate them into an Excel format. The potential freelancer will need: The documents strictly contain textual data. Please note, it is not clear whether the documents contain discrete sections like tables, headers, footers, or they follow a simple paragraph style, so flexibility in dealing with various scenarios is essential. Excellent knowledge of Excel and strong data organization skills are crucial for this project, as my ultimate goal is a clean, easily readable, and sortable Excel document.

...Word or Excel files) can be opened without a hitch once saved. The ideal candidate for this job should: - Be proficient with Microsoft power automate, Outlook and OneDrive. - Have experience with automating tasks related to email and cloud storage. - Understand and remedy potential issues related to file accessibility after storage. Your role will involve: - Creating a streamlined process or application to automate the saving of email attachments to OneDrive. - Ensuring the saved files remain accessible and openable. - Testing the process to ensure all PDF, Word, and Excel attachments from Outlook seamlessly transition to OneDrive and remain functional. A successful delivery of this project means I'd be able to receive an email in Outlook, have its attachments (...

Veuillez vous inscrire ou vous connecter pour voir les détails.

I need to convert an Excel file into a Google Sheets document. The main objective is to facilitate data sharing with colleagues and partners efficiently, hence the need for the conversion. Key Responsibilities: - Convert Excel files to Google Sheets without changing the data structure - Ensure data integrity during the conversion process The ideal candidate for this task should have: - Proficiency in Microsoft Excel and Google Sheets - Experience with data management and conversion - Great attention to details ensuring no data loss or distortion occurs during the conversion No need to worry about macros, as there are none in the original Excel file. This should be a straightforward conversion task. Please only apply if you are confident in your skills and a...

I am in need of an education verification specialist for a preemployment opportunity based in Hanover. Though it is not explicitly stated, thoroughness is an implied demand of this position. Either degree, diploma or course verifi...Include any relevant experience in education verification. - Provide a track record of their past work, if any. - Draft a detailed project proposal to demonstrate an understanding of what the project demands. Although the format for the education verification information wasn't specified, preference would be given to freelancers who can work and are versatile across all formats (PDF, Word document, Excel spreadsheet). Applicants must possess good organizational skills, attention to detail, and the ability to work effectively under the pressure of t...

I'm in need of an expert in Excel with a strong command of mathematical calculations, conditional formatting, and data analysis. You will be primarily working with numeric and date/time data. Key requirements: - Mastery of mathematical calculations within Excel - Proficiency in using conditional formatting - Solid understanding of data analysis techniques The outcome of this role involves: - Generating comprehensive reports from complex data - Automating tasks for increased efficiency Experience in automating tasks and generating reports within Excel is highly valued.

Veuillez vous inscrire ou vous connecter pour voir les détails.

I need a proficient Excel professional to handle some text data entry tasks, specifically focusing on detailed product descriptions. Your main responsibility will be: - Inputting product specifications into Excel spreadsheets The ideal candidate must have a keen attention to detail and excellent Excel skills. Knowledge in product specifications will be a great advantage. Please submit your bid with any relevant data entry experience and we can discuss further.

I require an experienced data entry specialist with proficiency in Microsoft Excel to assist me. The tasks involve: - Inputting and organizing relatively small amounts of data (less than 100 rows) - Analyzing data and generating reports Ideally, the freelancer should be familiar with Excel formulas and macros. Good data interpretation skills and attention to detail are needed to accurately analyze and reports the results. A capacity for hard work is also appreciated, as I am dedicated to this work and will need someone who can keep up.

I'm in need of a Virtual Assistant based in South America who can assist with cold calling businesses. Your primary responsibility will be to reach out and set appointments for me. Here's what I'm looking for: 1. Fluency in English language. 2. Capable of doing outbound cold c...skills. 4. Proven experience in appointment setting, preferably from a B2B context, is a must. 5. Must have the ability to persuade and deal with objections professionally. 6. Should be self-directed, assertive and have the ability to work in a fast-paced environment. Your success in this role will be measured by the number of appointments you can set. This is a fantastic opportunity for those who excel in telemarketing and appointment setting. If this matches your skills and experience, I...

I am in need of a talented PCB designer who can assist with the basic design of a circuit board. This project's main aim is to replace an existing circuit board. Details related to the project: • This is a fairly simple task with only a few components involved, making it very suitable for those who excel in basic PCB design. • I have a schematic diagram that I will provide. Your task will just be to take that schematic and translate it into a PCB design. Ideal Skills and Experience: • Extensive experience with PCB design • Familiarity with basic components • Ability to translate schematics into PCB designs • Strong attention to detail This project is a fantastic opportunity for someone looking to showcase their PCB design skills on a ba...

I'm in need of a skilled professional who can manage the daily tasks involved in my accounting and bookkeeping. Your responsibilities will include: - Handling accounts payable - Reconciling bank statements - Generating financial reports I use QuickBooks, Xero, and Excel spreadsheets in my daily operations. Therefore, experience and proficiency in these tools are highly required. Experience with daily accounting tasks is a big plus. Attention to detail, high reliability, and a keen understanding of finance protocols will be ideal for this role.

I'm urgently seeking a talented developer (or team) to create a comprehensive Android and iOS app, along with a corresponding website, for my wholesale pharmaceutical business. The main features of the app and site should include: - Daily stock upload: The system must have an interface that supports daily stock uploads using Excel files, ensuring seamless updates on available products. - Order Placement: Customers should be able to browse my products, fill their baskets, and place their orders with ease. - User Registration and Login: Users should be able to create profiles, providing details such as contact information, billing/shipping addresses, and prescription details. Logged-in users should have the option to track their orders and view order history. Freelancers appl...

I need an expert in Excel who can optimize my current dashboard. Specific tasks will include: - Enhancing the data analysis function of the dashboard - Improving the visualization of sales and HR manpower data The data will be updated on a monthly basis. Therefore, the dashboard should be designed for easy updating and automation. If you have relevant experience in designing and optimizing Excel dashboards, especially for sales and HR data analysis, your skills are highly desirable for this project.

I'm seeking a skilled professional who can diligently perform data entry tasks. The prime responsibilities will be: - To accurately input text data into an Excel spreadsheet and web-based forms. - The task requires complete fluency in English. - The data needs to be arranged according to a specific, custom layout in the Excel spreadsheet, the details for which will be provided during the project. The ideal freelancer would be adept in data management, ensuring accuracy, and should possess advanced Excel skills. Prior experience in specified data entry and a thorough understanding of English is a must for this project.

I am looking for a freelancer who can help me with gathering current data on Open Interest and Volume from the NSE and BSE option chain. The ideal candidate should have experience in data collection and analysis, with a strong knowledge of the stock market and options tradin...include: - Gathering current data on Open Interest and Volume from the NSE and BSE option chain - Presenting the data in web page with filters - Ensuring that the live data is up-to-time and accurate The freelancer should have the following skills and experience: - Proficiency in data collection and analysis - Strong knowledge of the stock market and options trading - Experience working with Excel and creating tables for data presentation If you have the necessary skills and experience, please submit your...

I'm looking for an experienced professional to develop a financial model using Excel that relies on total return over a variable number of days and volatility for stock selection and risk differentiation. This model will employ adaptive allocation methods. Ideal qualifications: - Deep knowledge and experience in financial modelling and analysis - Proficiency in Excel - Understanding of portfolio selection and allocation - Familiarity with financial metrics such as Return on Investment (ROI), Standard Deviation, and Sharpe Ratio Project details: - The model should incorporate total return over a flexible duration for stock selection. - Volatility should serve as the basis for managing risk within the portfolio. - The financial model will need to be updated with new da...

Landing Page (E-commerce): A visually appealing landing page resembling an e-commerce platform to deter bots. It will include: Login and registration functionalities. Product view page for browsing items. Customized design for the 404 error page. Verification page for phone numbers. Main Betting Page: A central betting hub where users can bet on HTD (Head, Tail, Draw) outcomes and review their last 11 betting events through a convenient navigation bar. Contact Page: Easily accessible contact page featuring an email contact form for inquiries. Privacy Policy | Risk Disclosure: Clear pages dedicated to privacy policy and risk disclosure to ensure transparency and user understanding. Navigation Bar: The navigation bar will be responsive and user-friendly, featuring: Account icon with a ...

I'm seeking an Excel expert who can design and build an org chart that visualizes my company's structure. The primary requirements of the project are: - Creating an innovative org chart with 5 to 10 levels of hierarchy. This should lucidly identify reporting relationships and aid in future workforce planning. - Chart must be dynamic and editable, allowing easy updates when there are organizational changes or expansions. Ideal candidates for this project should demonstrate: - Proficient knowledge and experience with Excel. - Previous examples of detailed, dynamic org charts created in Excel. - Strong understanding of organizational structures and how to best represent them visually. - Excellent attention to detail and accuracy.

I need an experienced Excel and VBA specialist to assist with a project that involves data cleaning and generating reports from a CSV file. This file contains dates and times against power usage for apartments and needs to be processed in Microsoft Excel. The job tasks include: - Fixing inconsistent data entries in the CSV file - Extracting time of usage for each apartment - Creating a repeatable VBA script for future use Ideal freelancers will have strong experience in: - Microsoft Excel for managing and manipulating CSV files - VBA for creating automated tasks related to data cleaning and report generation Your help will save me time and effort in terms of managing this CSV file and creating valuable reports in the future. Successful completi...

I am in need of an Excel guru to assist with my project involving fewer than 5 sheets. Help is needed to organize and format data effectively. Beyond just basic formatting, the project also requires the use of advanced formulas, specifically VLOOKUP and INDEX MATCH. The ideal freelancer for this task should have: - Expert knowledge in Excel formatting and data organization - Proven experience in creating and using advanced Excel formulas like VLOOKUP or INDEX MATCH - Strong attention to detail and focus on data accuracy - The ability to complete tasks efficiently and on time. Rest assured, if this project is successful, there could be more opportunities for similar jobs in the future. Looking forward to your bids.

I'm looking for a proficient Excel expert with extensive experience in data cleaning to assist with a key task. Your primary responsibilities will include: - Identifying and removing duplicate data entries in Excel, Data cleaning - Creating Pivot tables and data aggregations - Efficient dashboard and visuals that showcases trends and patterns via graphical data representation. Please only bid if you are seasoned in creating pivot tables, using Power query and generating visually appealing data insights. Precision and attention to detail are essential skills for this project.

For this project, I need a skilled developer to create a data visualization webpage, similar to Google Earth. Ideal candidates should have a strong background in JavaScript, Python, a...shared with the selected freelancer. - Data: The website's function will be to display GPS coordinates (latitude and longitude) alongside relevant site information when hovered over. This would include Site Name, Site Description, and Site Statistics. - Source: All required data is contained in an Excel sheet which I will provide. The ideal freelancer would have experience in data visualization, and expertise in the programming languages mentioned. Additionally, a proficiency in working with Excel data is necessary. Detailed requirements and design specifics will be shared upon commen...

...in gathering text data from online resources and flawlessly entering it onto a spreadsheet. Key Responsibilities: - Sourcing text data from specified online resources - Accurately entering data onto a spreadsheet with minimal errors - Ensuring data entries are formatted correctly and uniformly within the spreadsheet Ideal Skills and Experience: - Proficiency in using spreadsheets: Microsoft Excel or an equivalent is required - Strong attention to detail: This is crucial to avoid mistakes in data entry - Experience in online research: Being able to quickly and efficiently find reliable online resources - Previous experience in data entry: A strong foundation in data entry tasks is desired. This project requires speed, accuracy, and a commitment to meeting set deadlines. If...

...currently runs but has one bug. The bug is that when you close the app and open it again, the "stop" button is actually "Play" and so the app is not registering that the audio is still playing. The functions are simple. It has a 'start', 'stop' button. That's it. It should continue to run in the background when it's part of the media controls. I can provide all images and the link to the https url where the mp3 stream is available, along with the source code for the application. Before you respond, you should know that I will only reply / contact you if you just give me a simple text submission.. Just tell me a bit about yourself, don't give me your standard copy / pasta of text. and also, to make sure that you...

I am looking for a skilled full stack web developer to develop my portfolio site from scratch. The site must be: - Make the site mobile friendly - Make the site look great on tablets - Enhancing the visual presentation and organization - Moving site to new server - Ready the site for phase 2, ecommerce We must have the finished site live within 2 weeks Ideal Skills and Experience: - Strong design and layout skills - Proficiency in MERN stack development, especially image display (lightbox, high resolution display) - Experience with theme and framework updates - Knowledge of SEO best practices - Ability to optimize website performance - Strong back-end design. If you are a talented MERN stack developer with experience in modernizing legacy websites and have the skills and expertise to ...

We need an online Virtual assistant to help us with our company tasks such as social media posts, research data entry etc... The tasks are very simple, however, this will be ongoing, daily work for the foreseeable future. Must be reliable and consistent in order to be successful in this role.

Hi Lin F., you have completed a scraping job for me for the last two years, I need it done again. Please have a look and apply: https://www.freelancer.com/projects/excel/Scrape-data-from-unprotected-URL

I need an expert to masterfully apply and tweak formulas and functions across entire rows and columns within my Excel spreadsheet. Your tasks will be to: - Implement formulas and functions - Apply them to entire rows and columns Ideal skills and qualifications for this job would include advanced proficiency in Excel, especially in applying lookups and mathematical functions like SUM, AVERAGE, COUNT. Proven experience with similar projects is highly preferred.

I am in need of a dynamic Excel tool to perform data analysis tasks. The tool must be designed using autofill drop down list, and it will be utilised for: - Employee name selection - The drop down list should offer an autofill option for employee names. - Tallying Totals - The drop-down list selections should be capable of tallying totals. For this project, the ideal freelancer will have strong experience with Excel, particularly with creating and managing drop down lists. Experience with data analysis in Excel will be beneficial. Your task will be to create an easy to use, and automated system that can manage complex quantitative data.

I'm seeking an expert in data collection to gather email addresses from a list of retail shop websites I have. Your responsibility will be to: - Visit each website link that I provide - Identify and collect the contact email address - Organize the data in a spreadsheet, with each email in a separate row Deliverables: - A sprea...have. Your responsibility will be to: - Visit each website link that I provide - Identify and collect the contact email address - Organize the data in a spreadsheet, with each email in a separate row Deliverables: - A spreadsheet in either .xlsx or .csv format with the email contact for each retail shop. Desired Skills: - Data Collection - Data Entry - Attention to detail - Proficiency in Excel or similar spreadsheet software - Familiarity wit...

Looking for a skilled developer who can automate the process of extracting text content from RTF code and organizing it in a categorized structure in an excel spreadsheet. On github, I see someone has tried to some success. The file is located: To begin with I am interested in the English file Years Foundation to Year 10. English MRAC/2023/07/LA/ENG HTML RDF/XML JSON LD SPARQL You goal is to extract the hierarchy and structure as a usable document to teachers. Learning Area (English) --> Year Level --> Aspect of the Achievement Standard (A sentence) : it may then have General Capabilities

I am seeking a proficient Excel expert to enhance macros within an existing spreadsheet. My primary concern involves re-scripting macros for performance enhancement. On top of this, the spreadheet needs to have its calculation functions updated in certain areas. Hence, the ideal candidate should be comfortable in tweaking and improving formulas for better functionality. I also anticipate that some redundant aspects of the macros may be stripped off as we progress to streamline performance. Required Skills: - Proven Macro scripting and implementation in Excel - Solid understanding and experience in complex formula manipulation - Ability to optimize spreadsheet for improved performance and efficiency. Note: Specific deliverables relating to the calculation changes will be share...

I need a data expert who can perform inferential analysis on a dataset that is less than 1000 rows and columns. This task requires absolute proficiency in Excel, including functions and formulas associated with inferential statistics. Your ability to draw meaningful insights from raw data is essential. Skills Required: - Excel proficiency - Familiarity with inferential analysis - Ability to handle small to medium-sized datasets Experience preferred: - Previous experience in Excel-based inferential data analysis - Proven track record of data interpretation and insights extraction

I'm in need of a skilled developer with expertise in AppSheet, Excel, and ERP systems. Your task will be multifaceted, involving various aspects such as: - Data analysis and visualization - Spreadsheet automation - Developing an AppSheet app designed for ERP, focusing on billing, data collection, and data management The main functionalities I am looking for are: - Ability to generate and track invoices - Data entry and validation capabilities - Incorporation of Google Maps API - Budgeting features - Ability to export data to Excel A strong understanding of ERP systems, proficiency in AppSheet, and advanced Excel skills are essential to this role. Experience with Google Maps API is a significant advantage. You should be able to understand the essence and p...

Hi everyone, I will need a computer network analyst (ideally with cisco certification) with experience in measuring network delays, calculate jitter (with tools povided), do some graphs in excel etc. Analytical specific requirements in chat Deadline: 4/4 Budget: $20 USD

I am in need of an advanced Excel spreadsheet that will help track and output several key performance indicators (KPIs) on a monthly basis. The KPI dashboard should integrate the following parameters: - Sales pipeline - Revenue - Over $2,000,000 Per month - Overheads Average 3.75% of revenue for month - Gross profit 12 % - Projects on time >90 % - Defects closed <20 working days - Customer Satisfaction - Employee Productivity - Health and Safety The desired freelancer should have: - Proficient skills in Excel including pivot tables, charts, and formulas - Experience in creating KPI dashboards - Strong understanding of business metrics Please note that the dashboard should be mapped to be updated monthly. The focus is on clarity and ease of interpretation of the...