Vba read data excel project jobs
I'm looking for an extremely meticulous freelancer to help me transfer mixed format data from a PDF to Excel. The content is comprised of simple list items, so no need to handle complex structures or tabular data with calculations. However, attention to detail is critical as I require 100% accuracy in the results. Ideal skills and experience for this task: - Significant data entry and file conversion experience - Superior attention to details - Proficient with Excel and PDFs - Proven track record of delivering 100% accuracy in similar tasks.
...an experienced data scraper who can extract news event information from and meticulously compile it into an excel file format (GOOGLE SHEET) , year by year. Subsequently, create another excel file once completed the orignal one where all the years' data will be consolidated into one single tab of the file. Key requirements include: - Proficient in data scraping. - Excellent skills in data organization and excel management. - Ensuring no miss-information during the data transfer. To apply, freelancers should provide: - Relevant past work, particularly in data scraping and excel data management. - Detailed project proposal, demonstrating your understanding of the task. Please note, the specific...
I am in need of a proficient English translator to assist in translating a technical document of a basic complexity level. Key Responsibilities: - Translate a beginner level technical document from its source language to English - Ensure the translation clearly communicates the intended meaning of the original document Ideal Candidate: - Excellent command and understanding of En...document Ideal Candidate: - Excellent command and understanding of English language - Familiar with translating technical documents - Exceptional understanding of technical terms and jargon, even though there's a possibility that industry-specific technical terms might not be present The main goal is to maintain the tone and message of the original document, ensuring a smooth, comprehensible read...
I am looking for an Excel professional to help me enhance the formatting of my sales data spreadsheets. Below are some key aspects of the project: - **Main Task**: The key task here is to significantly improve the formatting of my spreadsheets, making it simple and convenient to analyze and review extensive sales data. - **Ideal Candidate**: You should be highly skilled in Excel, proficient in creating and managing complex spreadsheet formats. The ability to offer innovative and creative solutions for better data visualization is also highly desirable. - **Formatting Needs**: While I've foregone specific formatting changes, your expertise in managing and tuning aspects such as data validation rules, cell colors and conditional forma...
I'm looking for an experienced Excel specialist that can help create templates tailored for project management. The focus will be on tracking activity such as: - Task progress: I need a clear way to visualize the start and end dates of different tasks. - Project timeline: We need to monitor a high-level view of all the activities in the business. - this will needs tabs for BG activity over various cost centres, to view as a dashboard. Comms tracker, social media tracker, bid tracker, awards tracker, pursuits tracker This system should help us understand where we are in a given project and what needs to be done to keep everything on track. Strongly proficiency in Excel and a background in project management software will be a great advantage...
...standard-provided module, featuring an eye-catching, modern, and clean design. 2. Including more data analysis features: The revised worksheet should also come with advanced data analytics features to allow for an efficient insights extraction. 3. Enhancing decision rule options: Crucially, the final output should incorporate sophisticated decision rule options to facilitate better data-driven decisions. A crucial detail is that the current format of the worksheet and report is xls, and I want it to remain as such in its upgraded form, retaining an easy-to-read font and colour scheme while boasting organised and intuitive sections. Professionals with a strong background in spreadsheet management, data analysis and reporting, and seamless design tra...
I am in need of a professional who can provide meticulous bookkeeping and financial statement preparation for my business. Currently, we are using QuickBooks and Excel in managing our accounts, thus someone with capability and experience in these tools is highly appreciated. Additionally, I'm seeking quality editing services encompassing proofreading, copyediting and content editing. It is important for the successful freelancer to have an acute attention to detail and a solid understanding of grammatical rules. Ideal skills and expertise for this job would include: - Proficient in QuickBooks and Excel - Extensive bookkeeping and financial statement preparation experience - Strong proficiency in proofreading, copyediting and content editing - Exceptional attention...
I'm looking for an expert in Shopify and digital products to assist in setting up my store that will carry more than 50 digital documents. The products range from Microsoft Word, Excel to Visio files. Ideal Skills: - Proficiency in Shopify - Experience with digital product setup - Ability to suggest and implement design and layout The project requires: • Set up for an extensive digital product inventory • Capability to advise on layout and design I am open to design suggestions to create an intuitive and customer-friendly Shopify store. This should make it easy for visitors to browse, select, and purchase digital documents. Demonstrable experience in similar projects would be an added advantage. I've attached a .png file that would be displayed as ...
Hi, I need someone very experienced with importing variable products from Excel. Attached is a sample file. I'm having issues Doc on importing variable products using this plugin - :~:text=To%20import%20variable%20products%2C%20go,data%2C%20then%20run%20the%20import.
I urgently need an expert with strong PHP and Firestore experience to efficiently create a PHP method for me. This simple method should be designed to be able to retrieve data from any collection in Firestore and return it in JSON format. Key requirements include: - A PHP method that can fetch data from any collection in Firestore - The method should return the data in JSON format - The task needs to be completed ASAP, hence I would prefer someone who is ready to start immediately The right freelancer for this job should be competent in PHP, Firestore, and JSON with a strong understanding of web backend development and should be able to execute this task quickly and effectively. Note: I am only consider to pay the amount that you bid.
1. We have 32 backups from the same database as .sql-files. From one table of this database we need all instances in one csv-file (with the same codepage as stated in the sql-file ). So basicly you must: - import 1st backup on your sql-server - export the table "contracts" to "csv for Excel" - repeat for all 31 other backups - put everything together in one big csv-file that is readable in Excel (pls maintain german umlaute) 2. There should be a menu-item (i.e. "Report"); clicking this asks for the date "Welches Datum?"; the current date is proposed but can be changed by choosing a date in a calendar. The report should consist of: 1. All customers that have been added at the given date. 2. All contracts that have been added at ...
...**************************************************** Project description : I want the details of 200 companies and their CEO's with very specific criteria. This is an intensive, manual work project that will take at least 12 hours of dedicated effort of searching through Linkedin / Google/ general web search. Please proceed further, only if you are willing to work hard and devote time to complete the task correctly. It CANNOT be automated or run via a script. It CANNOT be sourced from databases such as Apollo.io. Please do not waste your valuable time trying to do either. The criteria are: 1. Must be a CEO, Director or MD - only these 3 designations are acceptable 2. Must have a <last name> from the list in the attached Excel sheet - only these...
As a client requiring precise and frequent data extraction, I'm seeking a skilled freelancer experienced in web scraping to assist with extracting specific data points from Website 1. Data Details: - The data point of interest is "Time wise status" - The objective is to have this information converted into excel format. Frequency: - The task requires real-time data scraping, with updates to be captured every 5 minutes. Desirable Skills and Experience: - Solid experience with web scraping techniques - Proficiency with Excel - Ability to create a solution that can scrape data every 5 minutes - Experience with Website 1 or similar sites would be an added advantage.
I'm seeking a skilled freelancer to assist with a special effects video editing project. The focus will be primarily on delivering compelling motion graphics and animations within a short film of 5-10 minutes length. Key Skills and Experience: - Expertise in special effects editing - Creativity in implementing motion graphics and animations - Ability to deliver quality work efficiently despite tight deadlines - Previous experience in similar projects is a bonus Please note that audio service is not required in this project, so those who excel in special effects and visual editing will excel in this project. Let's create something visually stunning together!
...in need of a professional who can assist with data cleaning, formatting and entry for my Excel sheets. This project requires an individual who is proficient in data validation as this is an essential function to successfully carry out the task. You will be working with Excel sheets specifically for data validation during data entry and database management. Experience with Excel and a good understanding of data formatting is an absolute must for this project. Key Responsibilities: - Data cleaning and formatting - Data entry and database management - Validating Excel sheets during data entry Skills and Experience: - Proficient in Excel - Experience in data validation - Know...
I am looking for a specialist who can help automate several tasks on my desktop. Key Duties: • Open specific apps including Python, Excel, and one other unnamed app. • Execute data entry tasks. • Extract text files. • Run existing Python scripts. For this role, a background in automation, a firm grasp of Python, and knowledge in handling Excel are vital. Proficiency in other automation tools or scripts would be an added advantage. Understanding how different apps interact will also be key to this role. I will show you my desktop to you over TeamViewer. And explain you my work. The objective is to streamline my workload, improve efficiency and reduce manual input where possible. Your expertise will be invaluable in setting this up and ensuring...
I am currently in need of a highly skilled virtual personal assistant (PA) ideally based in the Philippines who can aid me in staying impeccably organised and managing a variety of tasks. Here are the specific responsibilities: - Organising tasks and appointments to ensure that my schedule is fully optimised and nothing slips through the cracks. - Managing Zoom meetings, overseeing both the technical aspects and overall coordination. - Handling YouTube posting, including video uploads and channel management. Previous experience with YouTube channel management is preferred. - Designing visual content using Canva. A strong graphic design background and a keen eye for aesthetics would be beneficial. - Running email campaigns using MailerLite or Mailchimp. This would involve designing, ...
...database. Candidates must have expertise in: - Development of React applications. - Integration of .NET API. - Working with SQL databases. - **Core Functionalities:** - **User Authentication:** Secure login system using email and password. This system should ensure that user data is protected and only authorized users can access the application. - **CRUD Operations:** The ability for users to create, read, update, and delete data within the database seamlessly. This includes managing user details, settings, and other data points relevant to the application. - **Role-Based Access Control (RBAC):** Different levels of access and permissions for users based on their role within the application. - **Ideal Skills and Experience:** - **React.js:** Proficiency ...
I am looking for an efficient data scraping specialist who can extract information from I need all the fields provided in the URL listings. Criteria: -Ideal candidates should have a thorough working knowledge of data scraping software and have previously worked on similar projects. - I don't have specific fields to extract but I'm interested in, the more data you can extract, the better. - All the data gathered should be delivered in an organized Excel format. - Cleaning or preprocessing the data isn't a current requirement. - Efficient and detailed scraping abilities will be beneficial for this task. This project will require you to navigate through approximately 7,000 search results on the indicated website. An attached...
Hi, I need someone to organize some Excel Files for me. I have a list of domains and emails. I need to organize the domains and emails together. I can give more info in the chat. I have a $50 budget and am hoping to complete it within a day.
If you are a "developer company" do not bid I support freelancers to earn a wage, not a CEO to buy another house! Read API doc before bidding !!!! API Doc - Staff Area Features Add IP Blocks to Eg start IP end Must be able to add entire range easily Create customer Accounts Assign IP to that customer Suspend and delete user account and delete all set rules on assigned IP when deleting user View and edit customers set rules on IP addresses User Features Set Filters, manage, update, remove filters as in API docs Change password Control panel to have a basic, clean bootstrap design
I'm in search of a skilled graphic designer to create an edgy, dynamic logo to help draw in my target...lilies (flower). Traditional stars, not religious symbols. I need it to appeal to a demo of middle aged, middle income women of all ethnicities in the USA. Color palette should be a variety of pinks and silver with black outlining and for a white background. Site URL is and I would like those words incorporated as well. Please confirm via chat when you bid that you've read the project description and can provide what I'm requesting. Before starting design work, ask any clarifying questions you may need to ask first. I've had an issue with designers starting work and then the samples are not anywhere near what I said I wanted. I am trying to be as speci...
...software widely used in convenience stores across the United States. My goal is to improve and streamline my sales reporting system by: - Setting up daily reports in PDI Essentials for better tracking and analysis. - Integrating this software with custom Excel sheets, which I currently use for reporting. Your main tasks would involve designing and setting up this integrated system. Therefore, proficiency in using PDI Essentials and advanced Excel skills are required. Knowledge in convenience store operations and sales reporting is a plus. This project will be paid hourly in U.S. dollars. Your task is crucial in optimizing my convenience store’s reporting system, thus impacting decision-making and overall operations. If you have the skills, experience and in...
I need an experienced Excel professional who can help me extract both textual and numerical data from a particular sheet and organize it in a new one with precision. Key tasks include: - Extract specific text and numerical data from one Excel spreadsheet - Prepare a new sheet and structure it in a table format You should be proficient in Excel with experience using specific formulas or functions in addition to a thorough understanding of data extraction and organization processes. Familiarity with my specific worksheet would be an added advantage. Please indicate in your bid if you have experience in handling similar tasks. If you are skillful, accurate, and timely, then I encourage you to apply for this project.
We are in need of a skilled illustrator to create bright, playful, cartoon-like MDMA pill images. The ideal candidate should excel in cute and playful aesthetics, as the art will be used to propel a marketing campaign intended to spark excitement. Key project requirements: - Highly inventive and colorful designs - Style should be cheerful and engaging to our audience - Previous experience in creating cartoon art preferred - Familiarity with marketing and understanding how to evoke emotions through artwork will be beneficial Please include any relevant work samples or portfolio pieces in your bid. Exciting opportunity for creative professionals looking to push the boundaries. We're all about fun and engaging content, can't wait to see what you bring to the table...
I require someone to take my large VCF contacts ...take my large VCF contacts file containing 7000 entries and comprehensively transfer them to an Excel spreadsheet. Key Project Details: - Extraction of Name, Phone Number, and Email Address from each contact file. - Names need to be split; allocating 'First Name' and 'Last Name' to separate columns in the spreadsheet. Ideal Candidate Attributes: - Strong proficiency in Excel and data manipulation. - Experience in VCF and Excel conversions. - Strong attention to detail to ensure data accuracy. - Ability to work expediently is also a plus, given the volume of contacts. Please note, no additional fields or information are required beyond name, phone number, and email address. R...
I need a system using Excel or Google Sheets, or a simple web application capable of compiling payroll tax data as per the attached Excel file to generate a PDF report named EA Form, with an emailing function to send it to the respective employees. Key tasks: - Generate a PDF report (EA FORM) using the excel data - Email the PDF report (EA FORM) - Print the PDF report (EA FORM) Ideal skills required: - Proficiency in generating reports from excel data - Skills in PDF report designing - Skills in automated email systems.
...CAD drawing proficiency. Your task will be: - Taking my hand-drawn residential landscape plans and transforming them into digital versions: - Experience in horticultural designs is not required. - Familiarity with various software is a plus, maybe Excel and Indesign. The proposed planting plan to be drawn up is in pencil. Other plans showing hard landscape and levels will follow in pencil, for drawing up. To illustrate what I need, I attach examples of: - a planting plan for your information, of the kind I need for this project. Yours need not be exactly the same - it is for use as a working drawing and does not need to be a pretty picture. - a planting schedule for copy pasting onto the planting plan, as an example - a landscape levels plan as an example I loo...
...local utility to: 1. Back up the Excel Spreadsheet by making a copy, keeping the last 10 copies 2. Automatically append the contents of 1-2 CSV files found in a folder to an excel spreadsheet 3. Move processed files into a COMPLETE folder 4. Log the results in a local text file. Full story: My software exports 2 CSV files daily to a local computer. These CSVs show the products that have been sold and the quantities of each product sold for that day. We need to add these rows of data to a master Excel sheet, and it should be done automatically when a new file is detected, OR at a specific time each day. The fields would be Date Sold, Erply ID, UPC, Internal ID, Description, Qty Sold The CSV files would be The Excel Spreadsheet would be called...
I'm in need of a data extraction specialist with strong experience in web scraping to extract text content from a specific website with open data. This data should then be organized in an Excel spreadsheet following a format that I will provide. Skills required for this job include: - Experience with web scraping and data extraction - Knowledge of Excel and data organization Please note that the information extracted should adhere strictly to the provided format. With your bid, kindly include any past similar projects you've successfully completed. This helps me gauge your understanding and experience in this field. This is an important project for me, so completeness, accuracy, and confidentiality are top priorities. If ...
For my ongoing work, I need assistance in converting an existent VBA script from Excel 16 on Windows to properly function on Excel 2016 on a Mac. The script I currently have is responsible for automating a series of key tasks which substantially help my productivity, specifically: - Arranging and sorting my data Successful candidates should be comfortable with both operating systems, have an excellent command over Excel, and a deep understanding of VBA scripting. Prior experience in Excel-to-Mac conversions is also beneficial. This job requires clever problem-solving, meticulous attention to detail as well as the ability to clearly communicate the changes made.
I am urgently in need of a Virtual Assistant to streamline some data entry tasks and conduct web research for my organization. Expectations: - Perform data entry tasks - Conduct web research on various topics Time Commitment: - Full-time employment; over 40 hours per week. Required Skills & Experience: - Proficiency in Microsoft Excel - Extensive experience in web research - Solid understanding of Google Search engine - Detail-oriented; capacity for handling high-volume tasks Preference will be given to candidates proficient with data entry software. Although not required, this would be a plus. Overall, I'm looking for efficiency, accuracy, and a good work ethic. If you believe this describes you, please bid!
I need an expert Excel user who can effectively refine and organize data in an existing file. Your role will primarily entail removing any entries from file A which are already present in file B. Key responsibilities: - Scan through each entry in file A to identify duplicates in file B - Erase or omit entries that exist in both files For this project, proficiency in Excel and keen attention to detail is necessary. Previous experience with data refining tasks will be beneficial. To ensure the successful completion of this project, you should be able to follow directives strictly, and apply logical reasoning skills when necessary. For confidential reasons, the specific data information will be provided only to the chosen freelancer. Than...
Hello, Do not send me a copy/pasted message. Only messages that match this description will be read. I am looking for large volumes of posts in a short time on social media and email. The goal is to find customers who are parents and are interested in $20 off their first class at Outschool. I have attached a guide. I will work with the team that is willing to start working at a low hourly rate and can provide a high output. If we are able to meet a minimum target of performance and have some positive results the project will include bonuses.
...can achieve a read range of up to 10cm. Key aspects of the project to note are: - Size: The reader should be small in size, portable and convenient. - MCU: The design should harness the power of the CH32V003 MCU. - Firmware: Basic firmware functionality will include reader initialization. When read send data via uard - End Device: The completed RFID reader will be configured to link up with an embedded system. Candidates with a proven track record in small electronical device designs and experience in firmware development with an emphasis on initialization will be ideal for this role. Knowledge of RFID reader designs, CH32V003 MCU and analog components is a necessity. Deliverables: - RFID reader schematic - PCB layout - Basic initialization firmware. S...
I need an automated system built on Excel for my business. Invoice, Stock Mgmt, Payments, Expenses. Will pay in INR.
[Tool] Use UiPath, not UiPath X. DO NOT use other RPA tool. [Detail]Process Excel tables row by row and paste them into Google Docs. A (Create Notice of Appointment to Employees) --[Input] "" --[Output Goal]Copy Excel(.xlsx) data and paste to Google Docs( not microsoft Word). Create google docs that is very similar to following Example. --[Output Example] B (Create Test for Interview Candidates) --[Input] "", --[Output Goal]Copy Excel(.xlsx) data and paste to Google Docs( not microsoft Word). Create google docs that is very similar to following Example. --[Output Example]
I'm seeking a professional with proficient knowledge in Microsoft Excel, who can perform basic arithmetic calculations (addition, subtraction, multiplication, division) on a single worksheet. Your responsibilities will include: - Implementing formulas to perform arithmetic operations - Ensuring high data accuracy - Validating calculations results. Ideal candidates will have previous experience with similar tasks and a keen attention to detail for ensuring accurate calculations. Strong Excel skills are a must. The freelancer should be able to begin work immediately.
...****************************************** Project description : I want the details of 200 companies and their CEO's with very specific criteria. This is an intensive, manual work project that will take at least 12 hours of dedicated effort of searching through Linkedin / Google/ general web search. Please proceed with reading further, only if you are willing to work hard and devote time to complete the task correctly. It CANNOT be automated or run via a script. It CANNOT be sourced from databases such as Apollo.io. Please do not waste your valuable time trying to do either. The criteria are: 1. Must have Indian CEO, Director or MD - only these 3 designations are acceptable 2. Must have a <last name> from the list in the attached Excel sheet - ...
In need of an experienced Microsoft Excel specialist who can assist with a task in MS Excel I have an excel workbook that has a lot of formulas. As a result, it is taking a lot of time even when I add a row. I need someone who can fix this for me. Due to the urgency of the project, I need someone who can start as soon as possible. If this sounds like something you’d be capable of, please place your bid. Completion is required ASAP, so your immediate availability is key. Please apply only if you have handled a similar situation below. Also, to make sure that you have read this description, please start your proposal with the word "Bruno" Thank you.
Turkish Recording Project We have a project, that needs Native Turkish speakers, we will give you the text, and you need to record 50 short sentences. you just need to download our software, to read our text and record it, it's a very easy job. 1. You will need to record in a quiet place without loud background noise. and without an echo. 2. Each person Price is 3$ for 50 short sentences record. If you are interested please let me know sure. I will contact u. A Good Opportunity For New Freelancers For taking 5 Star Review after their completion of the project. Thanks :
Repost of the following project: https://www.freelancer.com/projects/excel/transform-text-evaluable-format. The required files will be exchanged after nomination.
Calling all digital nomads: Seize the opportunity to delve into th...work experience in Link Building (Q&As, Forum Submissions, Directory Submissions, Article Submissions, Image Submissions, Social Bookmarking etc.) Excellent written and verbal communication skills in English Language. Strong organizational skills and attention to detail. Willingness to learn and take on new challenges. Should be tech-savvy. Sound knowledge of Google Sheets, Google Docs & Microsoft Excel would be an added advantage. Benefits: Remote, providing flexibility for a comfortable work environment. Gain hands-on experience in SEO and Digital Marketing. Flexible working hours to accommodate academic commitments. Competitive rates based on qualifications and experience. Marketing background will be...
...language, coupled with intelligence, and a proactive work ethic. A pivotal aspect of our requirements is finding someone marked by complete adaptability to engage in diverse and innovative tasks, where a rapid learning ability is a crucial asset. The range of responsibilities includes website evaluations, product comparisons, the utilization of our proprietary software, and task execution within Excel. The expected working hours are 8 hours per day, and compensation ranges from $150 to $250/month, contingent upon productivity levels. The nature of the work is dynamic, requiring flexibility and a willingness to tackle new challenges every week. For instance, this week may involve comparing prices for the following week, scrutinizing details of upcoming products, discovering new p...
I am in need of an inventory reconciliation template, specifically tailored for Excel, to effectively keep track of my products throughout the manufacturing process. Key Components Needed: - Ability to track the Product ID, quantities on hand, and monitor progress throughout manufacturing stages. - A system that marks milestone stages such as raw material sourcing, production progression, quality control measures, and finished goods. Ideal Skills for the Job: - Freelancers with strong experience in Excel-based inventory management systems. - Keen attention to detail. - Knowledge of manufacturing processes.
In need of a fast, accurate, and reliable professional to assist with spreadsheet data entry and transcription from written documents. All tasks will be conducted using Microsoft Excel. Key Responsibilities: - Spreadsheet data entry - Data transcription from written documents Ideal candidate should have: - Proficiency in Microsoft Excel - Experience with data transcription from written documents - Meticulous attention to detail - Excellent typing speed with high accuracy rate
...currently on the Admin with RBAC module only. The tasks would include: - Integration of modules related to Mutual Funds, Fixed Deposits (FD), and National Pension Scheme (NPS). - Migrating existing data from excel to Database - Unfortunately, the specific features needed for these modules weren't defined. Hence, I encourage freelancers to ask for more details if necessary. Candidates must have: - Expertise in integrating complex modules into existing systems. - Proficiency in PHP. - Strong understanding of the financial services industry. A successful application should contain: - A comprehensive project proposal detailing how you would tackle this integration. Please note, a detailed functionality for the Mutual Fund, FD and NPS modules has not been sp...
