Excel automatic data entry formula Jobs
I'm seeking a professional to assist with my eBay listings and dropship product sourcing. Your tasks will include: - Locating Amazon U.S. suppliers for specific product categories - Extracting dropship products into an Excel spreadsheet - Creating custom eBay template descriptions - Optimizing draft listing " custom Authentic cartier Glasses" and making auction posts live The ideal candidate should have prior experience with eBay product sourcing and listings, and be proficient in Excel. Understanding of product categories and ability to create appealing product descriptions will be a plus. Your primary focus will be on specific product categories, so familiarity with these categories will be beneficial. You will need to extract the following information fo...
I need assistance with transferring over 50+ meals from My Fitness Pal ...Fitness Pal into the Recipes section of the same platform. All meals are already entered in My Fitness Pal. Key Tasks: - Transfer each meal into the Recipes section ensuring all data (food products, calories) matches the meal exactly. - Categorize meals into specific types of recipes: Breakfast, Lunch, and Dinner. - Include the exact nutritional information from the meals (macronutrients, vitamins, etc.) in the transfer. Ideal Freelancer: - Must have experience with My Fitness Pal. - Attention to detail is paramount to ensure data accuracy. - Knowledge in nutrition would be beneficial. - Experience in data entry and categorization tasks. - Completed ASAP - I will provide the MyFitnessP...
...multiple Excel files that contain customer details such as name, address, suburb, postcode, and telephone number as part of delivery manifests for a freight provider. I'm looking for an Excel expert who can help me consolidate these files into a single, clean customer database. There are approximately 75 separate excel files and about 600 customers. Key Tasks: - Extract contact details from all files - Merge all files into one without duplications - Count and record how many times each customer appears across the separate freight manifests The final merged file should be in Excel format and include the contact details along with an appearance count for each customer. Ideal Skills & Experience: - Advanced Excel skills (data extractio...
...Flip Betting Site Development Project Overview: Coin Flip Betting Platform for ROBLOX Games I am looking to develop an online website for users to engage in coin flip-based betting with virtual items from popular ROBLOX games, such as Pet Simulator 99, Murder Mystery 2, Adopt Me, and maybe more. This platform will allow players to wager in-game items and track their betting history, profit/loss data, and wallet balance in a seamless, user-friendly environment. To accomplish this, I am seeking a talented and experienced team to bring my vision to life. Key Roles Needed: 1. Website Developer & Scripter We are in need of a highly skilled website builder with experience in creating dynamic, interactive websites. The ideal candidate should have experience developing platforms w...
I'm looking for an Excel wizard to craft a reconciliation tool for two payment datasets - our Genie Ledger and Payment Gateway Data. Key Tasks: - Identify critical data fields for reconciliation, focusing on Transaction ID, Amount, Date, Payer Information, Payment Method, and Bank Details. - Develop a user-friendly tool that compares both datasets and displays all calculations on a dedicated front cover sheet. - Spot any discrepancies and highlight them in red on the front cover sheet. Ideal Candidate Should Have: - Extensive experience with Microsoft Excel, particularly with macros and VLOOKUP. - Strong analytical skills and attention to detail. - Ability to present data clearly and in a list format. I need a straightforward solution with clear...
...player's progress, compares them to peers or bio groups, and helps parents and coaches quickly get actionable insights. Key Features: - Tracking of various soccer and kinesiology metrics - User-friendly interface for coaches and parents Ideal Skills: - Figma Design - Web Development - Data Integration - User Interface Design Your deliverable: - Interactive, high-fidelity Figma, Sketch, or Adobe XD design prototype The data used by the web interface will come from our servers, but for now, I will provide an Excel file with all the parameters. Please include relevant examples of your work in your proposal. For this project, I will give the dataset to the selected designer. Please read the attached scope of work before sending your proposal. I will know if you...
...preselected from the account level ) Only the cars that fit the filters will be displayed. After selecting a result from the list, the related page will be displayed where we have the following structure: Hero/ Title = Model, Years, Key Model and logo Vehicle Details: Program Transponder - Yes / No Program Remotes - Automatic / Manual / No Pin Code Reading - Automatic / Manual / Dealer / No Pin Code Source - TESTER / DEALER / EEPROM Pre-coded Key - Yes / No Pre-coding Read - Automatic / Transponder Type - ID-50/etc Add Key - Yes / No Working Key required - Yes / No Lishi Tool - Hu100/Hu64 Blade Model - Hu100/Hu64 Universal Remote - NB11/ Wired / etc Remote Type - OEM / Aftermarket /Universal Additional Details:(Various information and pictures will be present)(Free...
...Prompt the admin to input the message and attach any media (optional). 2. Ask if the message should be sent immediately or scheduled for later. • For scheduled messages, the admin specifies the date and time. • Once the broadcast is sent: • The bot generates an Excel report showing: • Total number of recipients. • Names and usernames of users the message was delivered to. 2. User Management • The bot will keep a record of all users who activate it. • Admin Command: /users • Generates an Excel report listing: • Serial Number () • Name • Telegram Username of each user. 3. Prize Distribution • The bot will handle contests where users can win prizes. • Command: /prize ...
I am looking for assistance in collecting and organiz...products Kama: 294 products Max Fritid: 1169 products Movera: 545 products Deliverables: Structured Data: Use the provided Excel sheet and fill in the designated columns with extracted information, including: 1) Product Name 2) Description 3) Product page URL 4) Image URLs (usually only one, but up to four images per product, if available) 5) Additional description, if available If any errors or issues occur (e.g., missing data, broken links, unavailable products), leave a clear comment in the designated "Comments" column explaining the problem. This can be done manually with copy paste, og with web scraping tools, as long as you got attention to detail to ensure high-quality data entry....
...and C# to help me automate my weekly email process. Currently, I manually prepare emails in MS-Word, pulling customer data from MS-Excel, and sending through MS-Outlook using mail merge. I utilize 25 different email accounts, sending 2000 emails from each account to my customers, with the content being a price list with images. I want a system that automates this process. The emails should be sent from the 25 accounts to the customers from the Excel file automatically, with each account sending out 2000 emails. Skills and experience required: - Proficiency in Microsoft Power Automate - Experience with C# for custom scripting - Familiarity with mail merge in MS-Word, MS-Excel, and MS-Outlook - Knowledge in creating both HTML and plain text versions of emai...
I'm seeking a meticulous freelancer for manual data entry tasks. You'll be working with provided PDF files and inputting data into an Excel spreadsheet. Key Responsibilities: - Carefully extracting and entering data from PDF files into an Excel spreadsheet - Ensuring accuracy and attention to detail throughout the process Ideal Skills: - Proficient in Excel - Excellent attention to detail - Previous experience in manual data entry - Comfortable working with PDF files.
...athlete-specific data fields. Data Fields to Collect for Athletes: The form must capture specific details such as: Full Name Date of Birth Blood Type Allergies Passport or ID copy upload (mandatory) Export Functionality: The system must allow the export of all registered athletes into an Excel file. The exported Excel file should include all the collected personal data in separate columns (e.g., Full Name, Date of Birth, Blood Type, Allergies, etc.). Uploaded documents (e.g., Passport or ID copies) should also be exportable or downloadable. Additional Notes: The solution must integrate seamlessly with WooCommerce's existing checkout process. The form and its functionality should be user-friendly and error-free. Security is essential for handling...
Bitte melde dich an oder Loge dich ein um Details zu sehen.
I'm an advanced user of Microsoft Excel, seeking assistance with some issues I'm encountering. You will need: - Extensive knowledge of Microsoft Excel - Experience with troubleshooting complex spreadsheet problems - Ability to communicate solutions clearly and effectively
...the attached Excel sheet. Fill out just the price, year, mileage, and link columns: 1. 2. 3. Facebook marketplace 4. https://www.ironplanet.com/Tanker+Trucks 5. 6. 7. 8. 9. https://www.truckplanet.com/Tanker+Trucks 10. 11. Then for any vehicles that meet all of the Criteria listed below, fill out all of the columns of the Excel sheet. You will
I need assistance with importing our sales leads from an Excel file into our CRM system, Recman. Key Requirements: - The Excel file is stored on Drive and needs to be accessed, processed and imported. - The specific data fields to be imported include: Contact information, Lead source, and Sales history. - No specific data transformation or mapping is required, the data can be imported as is. Ideal Skills: - Proficient in handling Excel files, particularly in a Drive environment. - Familiarity with Recman CRM is a plus. - Good attention to detail to ensure all relevant data fields are correctly imported.
I need a comprehensive movies list exported into a CSV from IMDB. list should include key details like title and release year, director and cast, as well as genre and rating. Ideal skills and experience for the job include: - Proficiency in data management and export - Extensive knowledge of movies and film industry - Skilled in using Excel or CSV formatting.
I'm in need of a seasoned Shopify developer who can tweak our currency conversion feature. Our current app lacks the capability to adjust prices based on the customer's location. Here's what I need: - Automatic price increase for international customers: Prices should surge for visitors from outside India. - Specific country pricing: For instance, a product tagged at ₹2,999 in India should show up as AED 381 (triple the converted price) in Dubai, rather than the current AED 127. If you're skilled in Shopify customizations and can implement this pricing strategy, I look forward to your proposal.
I'm looking for a freelancer who can create a comp...tracker in Google Sheets. This tracker needs to display the variance week after week across 52 weeks. Key Requirements: - Track a variety of data: product quantities, inventory levels by location, items received, items sold, on-hand inventory, transfers, and purchases. - Incorporate automation features: The tracker should automate data entry and calculations to streamline the process. Ideal Skills and Experience: - Proficient in Google Sheets with a deep understanding of its functions and capabilities. - Previous experience with creating inventory trackers or similar tools. - Ability to implement automation features in Google Sheets for efficient data handling. - Strong attention to detail to ensure ac...
Project Overview I am developing a feature-rich Property Management Platform that helps landlords, property managers, and staff streamline every aspect of property oversight. This project extends beyond basic property/tenant management, incorporating advanced financial accounting, invoicing, document management, automated notifications, staff/vendor management, analytics, data import/export, and robust security measures. Initially, we’ll focus on a web-based solution using React (front-end) and Node.js + PostgreSQL (back-end). We also plan to future-proof the system for possible expansions to desktop and mobile platforms. If you have experience building complex, secure, and scalable SaaS/web apps, we’d love to see your proposal! Key Features & Modules 1. Property...
I'm in need of a freelancer with experience in data entry, specifically handling numerical data sourced from online databases. Key Responsibilities: - Accurately input numerical data from various online sources into our system. - Ensure data integrity and consistency throughout the process. Ideal Skills: - Proficient in data entry, with a keen attention to detail. - Familiarity with online databases and able to navigate them efficiently. - Able to work independently and meet deadlines. Please note that familiarity with our internal systems and databases will be beneficial, but not necessary as training will be provided.
I'm looking for someone skilled in Excel to help me with a data transfer task. I need to pull information from one spreadsheet and add it to a column in another. Key Requirements: - Transfer of text data between two simple spreadsheets (comprising simple rows and columns) - Matching of data based on an exact match in a single column Ideal Skills and Experience: - Proficient in Excel - Attention to detail to ensure accurate data transfer - Experience in data handling tasks
I'm looking for a skilled Power BI expert who can help me create a comprehensive sales report. The data will primarily be sales data, and it will cover a variety of metrics and trends. Key Requirements: - The report should include: - Total sales - Sales by region - Sales by product - Stocked on entry - Stocked on exit - Sale by physical group - Possibly some extra metrics - The report should also incorporate additional sales metrics such as: - Stock on entry and exit - Sales trends - Top-selling products Ideal Skills: - Proficiency in Power BI - Experience in sales data analysis - Ability to interpret and visualize complex data sets
I need help organizing confidential client data in an Excel spreadsheet. The data is currently in one column and needs to be split into appropriate columns for First Name, Last Name, Phone number, Email, Birthdate, Mortgage start date, mortgage term, and Client Birthday. - Required Skills: Intermediate level Excel proficiency, with experience in using formulas to manipulate data in Excel. - Platform: The session will take place on Microsoft Teams, where I will share my screen. - Data Format: The data is currently organized in an Excel Spreadsheet. Due to the confidential nature of this data, I am unable to share it via email. The ideal freelancer for this job would be able to work swiftly and accurately, ensuring that...
I'm in need of a doors and windows-based software that can generate production drawings and quotations based on my cost estimations. I've laid out the algorithm in Excel files, which will be provided for this project. As a developer, your responsibilities will include: - Creating a user-friendly interface (UI) that allows easy access to the software's functions. - Implementing the cost estimation and production drawing generation features. The ideal candidate for this project should have robust experience in: - Java with JavaFX: This is my preferred programming language and framework for this project. - Software development for Windows: The software needs to be compatible with this platform. - UI design: The software should have a simple, intuitive interface. Plea...
I have a small excel file. I need to convert in excel VBA. The project will be completed by Spanish language. The file and more details will be shared via chat box. Thanks!
I'm seeking a skilled Excel expert to create a reconciliation tool for comparing two payment datasets. The first dataset comes from our internal ledger (Genie Ledger), and the second from our payment provider (Payment Gateway Data). Key Tasks: - Identify important data fields for reconciliation, considering factors like Transaction ID, Amount, Date, Payer Information, Payment Method, and Bank Details. - Develop a tool that compares the two datasets, showing all workings on a dedicated front cover sheet. - Identify any reconciliation discrepancies and highlight them on the front cover sheet. The ideal candidate should have: - Extensive experience in using Microsoft Excel, particularly with macros - Strong analytical skills - Attention to detail and abilit...
I need someone to manually enter text data from PDF files into an Excel spreadsheet. Ideal Skills: - Proficient in Excel - Attention to detail - Ability to accurately transcribe information from PDF files
I'm looking for an experienced recruiter to handle the sourcing and reviewing of CVs for entry-level, full-time positions in a variety of industries. Key Responsibilities: - Sourcing and identifying potential candidates for entry-level, full-time positions - Reviewing CVs and shortlisting candidates for initial interviews - Managing the recruitment process from start to finish Ideal Skills: - Proven experience in recruitment, particularly for entry-level positions - Excellent CV screening and candidate assessment skills - Strong communication and interpersonal skills - Experience in various industries Please provide your CV and a brief cover letter detailing your relevant experience.
I require assistance with developing a macro in Excel. The macro needs to interact with local Excel files and perform specific functionality. The details of the functionality will be provided after the initial discussion. Ideal skills and experience for the job include: - Proficiency in Excel, particularly in macro development - Experience with automating tasks in Excel - Ability to understand and implement specific instructions - Good communication skills for discussing project details
...sports event), and other cases defined by the organizer, which are publicly announced. By agreeing to the privacy policy described by the organizer during registration, the "family" grants access to their publicly shared account data, including their name, the number of collected points of a specific type, and other data outlined in the privacy policy. Participants can also view the publicly available account data of other registered participants. This data can also be made accessible to other internet users who are not registered in the system. The data is presented in virtual "family" leaderboards, where users can clearly see participants ranked based on the number of points they have accumulated. The points collected ...
I'm looking to develop a multiuser website for collecting school ID card data and capturing photos. Key Features: - User Access: The website will be accessed by teachers and administrators. - Photo Capture: Users should be able to upload photos from their devices and also utilize real-time camera capture. The website should NOT include editing tools such as cropping. - Data Collection: ID card data will be uploaded via CSV/Excel files. Ideal Skills: - Full-stack web development - Experience with real-time photo capture integration - Proficiency in handling CSV/Excel uploads - Knowledge in developing multiuser platforms Please provide examples of similar projects you have completed.
Presupuesto 8 dólares Hola. Necesito el apoyo para hacer una hoja de cotización funcional en excel, pero con el diseño de imagen corporativa .png / .jpg colocada como fondo. El diseño corporativo de la hoja membretada ya la tenemos y abierto a sugerencias para una mejor solución.
We are looking for...unrelated sites). We will provide: A list of websites you can use to offer links in return (, , etc.). A tracking system for reporting progress. Requirements: - Proven experience with link building and outreach strategies. - Excellent communication and negotiation skills. - Ability to use email tools and outreach platforms effectively. - Familiarity with Google Sheets or Excel for reporting progress. Payment Structure: - $100 for every 50 live and verified links. - Bonuses available for exceptional performance and securing links from high-authority sites (DA 50+). Websites You Can Offer in Exchange:
Usaha kami bergerak dibidang kuliner yang berlokasi di pluit. Kami sedang membutuhkan karyawan tetap untuk membalas chat customer via whatsapp, marketplace dan merekap order yang masuk setiap harinya. Persyaratan karyawan : - Wanita 20-30 tahun - Memiliki pengalaman menjadi admin onlineshop minimal 1 tahun - Rapih, teliti dan cekatan dalam bekerja - Memahami microsoft excel - Bisa menggunakan whatsapp dan marketplace dengan lancar. Untuk selengkapnya akan dijelaskan saat interview *Jam kerja jam 8.30-5 sore. Setelah jam 5 sore tetap harus membalas chat dari rumah.
...tickets. Key Features: - Need to be able to put lottery ticket on to the website and for people to pick those existing ticket - Secure Payment Gateway Integration: It's crucial that buyers can purchase tickets safely and conveniently. - User Account Management: Users should be able to create accounts to track their purchases, manage their tickets, etc. - Automatic Lottery Result Updates: The site should automatically update with the latest lottery results. - ticket connect with the scanner to upload lottery ticket - need website to use as mobile responsive Ideal Skills and Experience: - Proven experience with WordPress and eCommerce sites. - Strong understanding of secure payment gateway integration. - Experience with implementing user management systems
...intuitive interface for data entry, monitoring, and reporting. GIS Module: Geospatial data visualization. Integration of PostGIS for spatial queries. Mobile App: Offline data collection with synchronization. Support for Android and iOS. Dashboard: Real-time analytics and visualizations using libraries like D3.js or Chart.js. Interoperability Layer: Enable integration with external systems Data Storage: PostgreSQL for structured data. PostGIS extension for spatial data. Hosting: Cloud-based for scalability (AWS, Azure, or GCP). Use Docker containers for easy deployment and environment consistency. 2. Data Flow Design Input Sources: Mobile app: Real-time or batched data uploads. Manual entries via the MIS. Processing: Data...
...professional to set up a two-node Oracle 19c RAC database on Oracle VirtualBox 7.14 for a test environment. Key Requirements: - Host System: Windows 11 powered by Intel i5 12th Gen with 64 GB RAM - Install Oracle Linux Server 8.8 on both cluster nodes, assigning 12 GB RAM to each - Configuration of ASM with specified disk groups: - OCR: 3 GB - DATA: 30 GB - RECO 20 GB - Installation of Oracle 19c Grid software - DNS setup can be ignored - Use of Automatic Storage Management (ASM) for disk groups I have the Oracle Linux Server 8.8 ISO ready, and no special network settings are needed for the cluster nodes. The ideal freelancer for this project should have extensive experience with Oracle databases, VirtualBox, and Linux systems. Please be prepared to demonstrate ...
I need an expert in Excel automation and API integration to help me in calculating GHG emissions, specifically Carbon dioxide (CO2). The primary data source for the calculations will be an API, so experience with API integration is crucial. The project involves: - Automating the process in Excel for GHG emissions calculation - Using API for manual data entry - Focusing on Carbon dioxide (CO2) emissions The final output of the project should be in the form of a dashboard visualization. Therefore, experience in creating dashboard visualizations is essential.
I'm looking for help with rewriting and transferring some Excel tables for financial reporting. The tasks are straightforward and primarily involve basic data transfer without the need for specific formulas or calculations. Standard formatting is acceptable, so no specific formatting guidelines need to be followed. Ideal skills for this project: - Proficiency in Excel - Attention to detail - Basic understanding of financial data - Good data transfer skills
I'm looking for a professional with excellent attention to detail for a data entry project. The task involves manually inputting a variety of mixed data (text and numeric) into a system, which will primarily be used for data analysis. Key Requirements: - Experience with manual data entry - Proficiency in handling mixed data (text and numeric) - Understanding of data analysis processes - High level of accuracy and attention to detail - Able to meet deadlines consistently Your role will be crucial in ensuring the data is accurately recorded for analysis purposes. If you have a background in data handling and a keen eye for detail, I'd love to hear from you.
I need assistance with manual data entry from printed documents.
I am looking for an event manager for Lil Flea, a weekend event expecting 100-500 attendees. The role involves customer service, order taking, and data entry into a POS terminal. Training will be provided for product preparation. Key Responsibilities: - Serve customers and take orders - Input data into POS terminal - Learn and prepare our product Ideal Skills and Experience: - Strong customer service skills - Prior experience with POS systems - Event management expertise Please only apply if you are comfortable with a hands-on role and can manage a busy weekend event.
I need my intricate Excel sheet transformed into a PHP web application, complete with a MySQL database. The Excel file consists of 10 interconnected tabs, filled with VBA functions and classes. Key Requirements: - Replicate data calculations and transformations in PHP - Create user input forms and validations - Implement user authentication system with multiple roles - User roles should include: - Admin: Full control and oversight - Editor: Able to modify content - Viewer: Restricted to observation only Ideal Skills: - Proficiency in PHP and MySQL - Extensive experience with Excel VBA - Strong understanding of user authentication systems - Ability to replicate complex data processes in web applications Please only bid if you have a solid ...
...addresses. Source of Dataset: The dataset is provided in Excel format. Size: There are 11,817 entries requiring email addresses to be added. Data Type: The emails must be entered into the same spreadsheet. Important Guidelines: All email addresses must be sourced from publicly available information in compliance with GDPR and other applicable data protection regulations. The methodology used to locate these email addresses is at your discretion, provided it adheres to legal and ethical standards. Each email entry should be accompanied by a URL or source reference to verify its public availability. Ideal Candidate: Experience with manual data entry. Proficiency in spreadsheet software (e.g., Excel, Goog...
PHP Survey Script Tweaks Project Description: I have installed a raw PHP survey script and...inside the graph bars as text. Add Averages to Reports: In the report section, include an average of the survey results. This should be visible both on screen and in the exported .xlsx file. Skills Required: PHP MySQL JavaScript (for graph enhancements) Experience with data processing and performance optimization Deliverables: Improved CSV import functionality with faster processing and guaranteed file availability. Graphs with displayed values inside bars. Averages displayed in both on-screen reports and exported Excel files. Additional Notes: Please ensure the changes are thoroughly tested before delivery. Let me know if you require access to the server or additional informatio...
I need a professional who can create a simple HTML5 survey to be embedded in Gmail. The survey will consist of 1-5 multiple choice questions. The requirements for the project are: - The survey responses need to be recorded in a MySQL database. - Based on the user's responses, they should receive one of two automatic follow-up emails. - The follow-up emails are predetermined as 'Email A' or 'Email B', depending on the user's answers. - The survey needs to be created in such a way that it is easy for the user to interact with it within Gmail. Ideal skills for this job include experience with HTML5, MySQL, and email automation. A background in survey creation would also be beneficial as well as spanish speaking. Please provide examples of similar proje...
I'm in need of a diligent freelancer to assist with manual data entry. The task involves extracting information from PDFs and carefully inputting it into a database. Ideal Skills: - Proficient in data entry with a keen eye for detail - Familiarity with working on PDFs - Experience in entering data into databases - Able to maintain confidentiality and handle sensitive data with discretion - Good understanding of database management systems - Excellent time management skills to meet deadlines Your primary responsibility will be to ensure accuracy in the data transfer and to maintain the integrity of the information. Looking forward to your proposals.
I'm looking for a skilled PHP developer with Android expertise who can integrate a specific formula for calculating pathology test result value based on another test value into my existing custom-built system. This project involves both a PHP portal and an Android mobile app. Key Requirements: - PHP development for the portal - Android app development - Integration with a custom-built system - Understanding of mobile app development principles - Experience with backend system integration