How to combine duplicate rows and sum the values in excel vba jobs
I'm seeking a freelancer who is adept at typing fo...for a task that involves transcribing handwritten notes into Excel. The legibility of the handwriting is average, so this job demands patience, careful observance, and excellent data entry skills. - Your task would be to transcribe the data from handwritten notes into an Excel file. - The content you'd be dealing with primarily includes text. I'd prefer individuals who have previous experience in data entry, especially tasks that require extracting data from handwritten sources, and are proficient in using Excel. Attention to detail is a must, as accuracy is paramount in this job. Your ability to decipher moderately...
Please Sign Up or Login to see details.
I am currently working on a project that requires the integration of Excel with a PostgreSQL database. As such, I am in need of a freelancer who is proficient in both Excel and PostgreSQL. The primary tasks to accomplish include: 1. Exporting data from Excel to SQL 2. Updating PostgreSQL data using Excel You will be working with various kinds of data as we aim to streamline our operations in a more efficient manner. Ideal skills and experience include: - Solid understanding of PostgreSQL - Expert skills in Excel - Previous experience with SQL data exporting and updating The success of this project highly relies on a flawless data transfer between Excel...
...modern and minimalist logo for my brand. This logo should combine both text and symbol elements. It should be striking, memorable, and versatile. Key Requirements: - Combination of Text and Symbol: The logo should include both text and symbol components. The two should harmoniously work together to create a cohesive design. - Modern and Minimalist Style: The overall design should have a modern and minimalist aesthetic. It should be clean, simple, and timeless. - Color Scheme: The logo should incorporate both black and white as well as bold and vibrant colors. The use of color should be strategic and enhance the overall impact of the design. Ideal ...
I'm in need of an expert to assist with the cleanup of our Medicine database. The goal of this project is to accurately remove all duplicate entries improving the overall accuracy of the data. Ideal Skills & Experience: - Strong background in Database / Excel /CSV management, specifically in the medical field. - Proven track record of similar past work. In your application, please include details of similar projects you've worked on. Efficiency and precision are pivotal for this task. Looking forward to a neat and streamlined database!
The attached PDF lists every musician who played for the St. Louis Symphony between 1907-1908 and 1978-1979. I would like the data copied into a spreadsheet. To illustrate the desired format, I have entered the first 11 rows into the attached spreadsheet. The PDF is 34 pages long and I estimate it lists 1500 musicians. I would estimate the job will take 15 person-hours to complete. Thanks for your consideration!
I have a channel where I make EXCEL educational videos, I upload 12 videos a month, between 5 to 7 minutes each. YOU MUST BE ABLE TO : - Have experience in editing videos for YouTube. - Have basic knowledge of Microsoft Office, to be able to edit the videos better. - Be able to edit 10- 12 videos consistently every week (Some will be only 1 minute long). IF YOU WANT TO STAND OUT FROM THE REST SEND US YOUR PORTFOLIO
I'm in need of an expert who can perform photo extraction from a PDF file. The key requirements for this task are as follows: - The extracted photos need to be saved as a single PDF document. I don't require individual image files. - The resolution quality of the extracted photos must be high - 300 DPI or more. Please ensure this whilst extracting as it's essential for the final output. - The photos extracted should ideally follow a random naming convention. The order doesn't necessarily need to adhere to the page number or alphabetical rule. The ideal freelancer for this task would have experience in handling image data extraction, particularly from PDF files, and...
...can assist in building my brand's online presence. The ideal candidate will be able to create engaging visual and video content. Key Responsibilities: - Develop visually appealing content that's in line with our brand's aesthetics and values. - Create video content that's suitable for sharing on social media platforms. - Aim to increase brand awareness and engage with our target audience of business professionals. The content you create should be: - Unique and original - High quality and professional - Engaging and shareable Ideal Skills and Experience: - Proven experience in content creation, particularly in the visual and video mediums. -...
I need a word document translated from English to Russian as soon as possible. The file has 800 words. Need high quality human translation only. Google/AI or automatic software works are not allowed and will be rejected. Need the translation back in word document format maintaining the formatting and layout of the source file. I would also need an excel sheet prepared, with source texts in column A and translation column B. Need this to be done within 5-6 hours of awarding the project. Bid only if you are available to do it now. Price: 12 CAD fixed. Deadline: 5-6 hours max Don't bid if you don't agree the price and timeframe. Thanks!
...report in Microsoft Access from a MySQL database. The report should contain data from the MySQL database, calculations or summaries of data, visualizations or charts, and be structured as a paginated report, using SQL language. The report should be designed to be accessed as a printable PDF document. It is not required to be interactive, as a static report is sufficient for my needs. Key Requirements: - Proficiency in Microsoft Access, MySQL, VBA, PDF, Python, and Excel - Competency in SQL language for data manipulation - Experience in designing paginated reports The ideal candidate should have a proven track record of creating similar reports, with the skills and knowledg...
I need a word document translated from English to Simplified Chinese as soon as possible. The file has 800 words. Need high quality human translation only. Google/AI or automatic software works are not allowed and will be rejected. Need the translation back in word document format maintaining the formatting and layout of the source file. I would also need an excel sheet prepared, with source texts in column A and translation column B. Need this to be done within 5-6 hours of awarding the project. Bid only if you are available to do it now. Price: 12 CAD fixed. Deadline: 5-6 hours max Don't bid if you don't agree the price and timeframe. Thanks!
...Welcome! We are excited to present to you an exciting development project for an innovative and cutting-edge dating platform. Our mission is to revolutionize the online dating experience using artificial intelligence to create meaningful and authentic connections. **Project Objective:** Our goal is to develop a dating platform similar to , where users can interact with AI-generated profiles and engage in compelling and empathetic conversations. The platform must be able to charge users for private content and promote genuine emotional connections through interaction with AI. **Key Features:** 1. **AI-Generated Profiles:** We will use advanced AI generation algorithms to crea...
...Python-based machine learning model with the purpose of analyzing historical stock price data and intraday data to predicting future values. The overall goal is to be able to evaluate investment opportunities better. Ideal Skills & Experience: - Familiarity with Python is a must, as this will be the primary language used - Proficiency in regression models, LSTM , as the chosen Machine Learning model - Experience working with stock price data analysis and forecasting - A proven record in Machine Learning project Project Requirements: - Develop a python software that can ingest and analyze historical stock price data - Apply regression models to draw predictive insights about future st...
I am in need of a specialist to optimize my Amazon product listings for coloring books. The key focus will be enhancing visibility and maximizing customer engagement for my book collection. Here's what I am looking for in a freelancer: - Expertise in Amazon SEO and PPC ads, with a specific focus on product listing optimization. - Experience with book listing, preferably in the coloring books category. - Proven track record in improving visibility and sales on Amazon with optimized product listings. Your responsibilities will include: - Optimizing the titles, descriptions, and other pertinent details in each coloring book listing. - Suggesting effective marketing strategies tailored ...
...well. I am writing to provide a quote for the architectural design and structural calculation services you require for your house plan. Based on the information you provided, the scope of services will include the following: Architectural Plans: This includes the site plan, floor plan, elevation plan,and structural engineering calculations. Basic Services: I will confirm the design criteria and provide the necessary drawings based on the basic drawing you sent me. If there are any issues with the submitted drawing and modifications need to be made, I will be responsible for revising the drawing until a full set of plans is approved. As part of my commitment to providi...
As a professional with high-volume data, I'm seeking a highly skilled Excel expert. You should have proficiency in: - Data analysis - Data visualization - Excel formulas, functions and macros - Visual Basics Application (VBA) I'm dealing with more than seven datasets, each one having high complexity (many columns and over 5000 rows). I will need your expertise in managing and understanding this data. Ability to quickly comprehend and adjust to new data structures would be advantageous. Proven experience with large data sets and advanced Excel usage is a must for this project. Please include examples of previous similar work in your proposal.
I'm in need of an Excel formula expert to help me with a specific task. I need a formula that will COUNT cells based on the following criteria: - I need to COUNT the number of cells in a range that are greater than -250 - The count should be done for the last 50 cells (ongoing) Your task will be to help me create a formula that dynamically counts the number of cells based on the above criteria. I need this formula to be able to adjust as new values are added to the range. The ideal Freelancer for this project should have: - Extensive experience with Excel functions and formulas - Strong understanding of dynamic range referencing in E...
...a Digital Door Knocker, to join their sales and marketing team. This role involves using Instagram Direct Messages and other social media platforms to engage potential clients, persuading them to schedule consultation calls, and generating leads for potential affiliates and partnerships. The ideal candidate will report directly to the CEO, Scott Donnell, and will need to possess exceptional communication skills, the ability to build rapport, and a deep understanding of digital human interaction. Key responsibilities include managing Scott Donnell’s personal social media accounts, connecting with new and existing followers, and conducting high-level conversations ...
...cart module that is functional and generally performs well. However, it currently has a significant limitation: it only supports the store's primary currency, which in this case is the Polish Zloty (PLN). As I sell throughout the European Union, it is essential to add support for the Euro (EUR). At present, there is a problem with how prices are displayed in the abandoned cart emails. Since 1 Euro is approximately equal to 4 Polish Zloty, when a customer who shops in Euros abandons their cart, the reminder email incorrectly displays the prices in PLN but with a Euro symbol next to them. This causes confusion because the prices appear four times higher than they sh...
...proficient in Excel macros and ODBC data connections to automate critical processes in my business. Specifically, your tasks will involve: - Automating order tracking, inventory management, and vendor communication processes. - Connecting to Excel files, SQL databases, and CSV files using ODBC. - Developing an automated procurement system capable of: - Generating purchase requisitions, - Aiding in vendor selection and negotiation, - Creating and tracking purchase orders. Proficiency in utilizing Excel macros is a must, and experience with ODBC data connections and related platforms is highly desirable. Knowledge of procurement systems and order logistics would ...
2 excel files with VBA macro as per customer requirement
I need an expert in Microsoft Excel to build an efficient spreadsheet to monitor potential lost revenue due to late service deliveries. The ideal candidate would possess a strong background in creating financial models and understanding of revenue tracking. Key Requirements: - Proficient in Microsoft Excel, with emphasis on creating advanced, clear, and highly-functional spreadsheets. - Experience in financial modelling and understanding of revenue tracking. - Ability to automate the process as much as possible to minimize manual tracking. Objective: - Create an intuitive and efficient Excel spreadsheet to replace the current manual method of trac...
Implement the given algorithm in javascript and HTML for visualization
...talented logo designer to create a modern and sleek logo specifically for our POS (Point of Sale) system tablet based , This POS system is not a bank swipe machine it's a system for taking orders. Key aspects: - Design a logo suitable for a POS system: The logo should be designed keeping in mind that it will be used in a sales transaction system. - Incorporate the Company Name: The logo should prominently feature our company name. - Modern and Sleek: I'm looking for a modern, sleek and professional design, in line with the modern POS system usage. Company Background: We are a company offering a Point of Sale (POS) system. We currently have a logo for our company but are looking to create a ne...
...professional to diligently run through LinkedIn, identifying and documenting HR higher-ups within Fortune 500 companies. Ideally, I'm interested in Director of HR or VP of People roles. Your main task will involve: 1. Identifying: I'm targeting senior-level personnel only. Expertise in navigating LinkedIn search and understanding corporate hierarchies will be a plus point. 2. Documenting: I'd like the findings to be presented in a tabular form within an Excel document. Critical data points to be captured include the Company Name, individual's LinkedIn Profile link, and their Role. Your background in HR and corporate structures would be critical in understanding...
...experienced web developer to design a robust, user-friendly landing page and ecosystems for our various services and products. The page will serve multiple purposes including to: - Present detailed information about our various services - Facilitate user bookings - Display our range of products. We cater mainly to general consumers (B2C), so the design should be easy to navigate, engaging, and visually appealing. Additionally, the project extends to the development of multiple ecosystems comprising specific product pages. Each of these pages will be linked to several subpages outlining the services related to that particular product. Key features to include in the...
I'm looking for a skilled freelancer to help me create a pivot table in Microsoft Excel that will be used to find pricing quicker Key Requirements: - The pivot table must be created in Microsoft Excel. - The purpose of the pivot table is to find pricing easier The data sources which the pivot table will be using are confidential, and will be shared with the selected freelancer.
...HTML and PDF. The PDF version should be static, without interactive elements. - The conversion process can be done manually, using HTML and PDF editors, or automatically, for which you can suggest a suitable script or tool. You're also welcome to combine both methods if you believe it would be more efficient. - The HTML output should be easy to read and navigate. The PDF should retain this readability in a static format, making it suitable for printing and viewing but without interactive features. - You will have creative control over how to best represent the JSON form in these two formats. The end goal is to make the content accessible and...
I'm seeking a proficient individual to help with a data entry project. I have about 40 URLs, from which I need to extract the product names, prices, and descriptions. The goal is to collate this information in a pre-defined Excel template. Key Aspects: - Extract product names, prices and descriptions from 40 URLs. - Populate an Excel file with the gathered data.
...strong command of Microsoft Excel and Word. The tasks at hand are primarily data entry, table creation in Excel and development of an instruction manual in Word. Key Responsibilities: - Efficiently perform data entry tasks in Excel. - Create tables in Excel to visually present the data. - Develop an instruction manual in Word. Ideal skills for this project include: - Advanced proficiency in Microsoft Excel, with a strong expertise in data entry and structuring information. - Proficiency in creating tables, and potentially pivot tables. - Strong experience in creating documents in Word, preferably instructional or informative content...
I'm in need of an Excel calendar for 2024 - 2025 that will be used for tracking school days off and special events. The calendar should feature the following: - Ability to add and modify events - Monthly view - Color-coded categories - Dates should be highlighted with background color Ideal skills: - Proficiency in Excel, including knowledge of advanced functions - Experience in creating and customizing calendars - Design proficiency to ensure aesthetic and functional layout Look at the Sample
...talented graphic designers to create a cohesive visual identity for our existing family of logos. Our goal is to unify these logos under a single thematic design that reflects our brand’s core values and aesthetic. The logos currently serve different products and services but need a harmonized look and feel that connects them visually. The core is the figure "1". We need one Logo "1" as base logo too. So that the company is "1" with the subbrands 1Hosting, 1Marketing, 1Tool, ... We are thinking on just using the 1 alone, too. Scope of Work: Analysis and Research: Review our current logos and brand materials to understand the different t...
...currently in need of a professional who can produce a corporate video for my company. The video will primarily focus on showcasing our company culture and values, aiming to be inspirational in tone. Key Requirements: - The video needs to be uplifting and motivating, reflecting the core values of our organization. - Interviews with our clinicians and clients will be the main content of the video, so the ability to interact well with people and bring out their stories is crucial. - Creative input in terms of video editing, background music, and other visual elements is highly valued. Skills and Experience: - Proven experience in video produ...
I'm in need of a virtual assistant to help with a variety of tasks, specifically: data entry, email management, and conducting research. Ideal Skills and Experience: - Proficient in Google Docs and Sheets - Experience in managing email inbox - Can attend video calls and meeting to write MOM with clients I'm looking for someone who can commit to more than 20 hours per week. The ideal candidate should have a basic understanding of Excel or Google Sheets. Your job will be to document data, answer emails effectively, and conduct research on various topics. I am looking for someone who is timely, organized, and detail-oriented. Please reach out if you think you are a good fi...
I have a calculator form that needs some updates made. It allows the user to input measurements for an industrial hose to find out settings for crimping. Current form is here: Need to add an option for the user to calculate with Hose Wall Thickness OR Hose ID & OD. Here is a prototype showing how this will work: New page (needs some jQuery updates): Also have Excel with new formula
...logo designer to create a logo that will be used on gold business website and social media profiles. The primary goal of this logo is to convey a sense of professionalism. I don't have a specific color scheme in mind, so I'm open to suggestions. The Logo should be clean and minimalistic. You can get colour ideas from website listed in requirements below. Logo Requirements: 1. We need a primary logo and a icon version of the logo 2. Logo must be delivered in white, black, and colour versions 3. Logo must be delivered in web ready transparent format Brand Info: Main Logo Text = Kelowna Pure Gold & Silver Website URL = Ideal Skills and Experience: - Proven experienc...
One excel file with macro as per the customer requirement
I want a platform using binance APIs and web sockets to collect real time data and calculate the values and show in the form of heatmap using plotly heatmaps. I need 4 features. Liquidation heatmap, order book, net position heatmap and liquidation level. Ideally Pakistani developer (for easy communication). Refer to attached requirement
I'm in need of a classic-style logo for my company, True Texas Junk Removal. The logo should embody the essence of Texas, Value, and Integrity. It's essential that the design includes the following elements: - Lone Star: A prominent representation of the flag of Texas, which is the lone star state. - Trash/junk removal symbols: Elements like a trash can, broom, waste bin, etc., can be considered here to indicate the core business of our company. - Flag: The logo should also integrate the American flag's colors (red, white, and blue). The chosen freelancer must have experience in creating classic-style designs and understand how to incorporate these ...
I am seeking an experienced freelancer who is proficient in data mining tasks in Excel. the analysis must done in excel by installing the data mining tools in excel The ideal applicant should be capable of installing and executing data mining tools in Excel. Unfortunately, I cannot specify what data mining tasks will be performed, nor the type of data provided for the analysis as these details are not available just yet. However, in order to be eligible for consideration, please include: - Detailed project proposal showcasing your approach to data mining tasks. Feel free to inquire if you need any more details. A strong understanding of data mining ...
As a business owner, I need a data entry operator who is proficient and experienced with Excel formulas. This is fairly urgent, and I am looking to make a quick hire for this role. The complexity of the task at hand includes: - Data entry with calculations - interpretations are not necessary - The project needs to be completed as soon as possible The ideal candidate for this job would possess: - Speed and accuracy for data entry tasks - Strong proficiency with Excel - A deep understanding of Excel formulas - The ability to work under tight deadlines I look forward to seeing your bids and working with you. Thanks!
I need a knowledgeable and experienced pivotchart expert in Excel, who can assist in creating a line chart to visualize my customer data. This chart should effectively illustrate the purchasing behavior of my customers over time. A deep understanding of customer trending and Excel pivotchart is essential. Key Requirements: - Expertise in Excel pivotchart (specifically line charts) - Ability to analyze and visual customer data - Experience in monitoring customer purchasing trends - Quick and efficient work pace - Attention to detail and accuracy - Excellent data visualization skills This role requires strong organizational and analytical skills. Previous experience...
I'm in need of a professional and corporate portfolio design that can help establish my company's credibility. The ideal freelancer for this job will have experience creating similar portfolios for businesses. The portfolio will include: - About Us: A section that encapsulates our company's mission, history, and values. - Services: A detailed overview of the services we offer, including the benefits and unique selling points. - Team: An introduction to the key members of our team, including their roles and a brief bio. - Testimonials: Feedback and reviews from past clients or customers, emphasizing our credibility. - Portfolio: A showcase of our previous works, projects or case studi...
Simply recreate the given image with better quality and tweak it a bit so i can not get any copyright issues
I'm in search of a project coordinator with a background in team coordination and excel. The selected individual will be primarily responsible for planning and organizing a one time project, it will be plotting out some meetings and planninh some deadlines in excel. I'd like to ask them questions while they plan it out if possible! Key Requirements: - Strong Experience in Project Management: This is the most critical requirement. Experience in managing technology-related projects is highly preferred. - Strong Organizational and Time Management Skills: Ability to organize tasks efficiently and manage deadlines effectively. - Excellent Communication and Interperso...
Hello, I would like to present to you the new visual identity I created for brands that seek to stand out in the lingerie and intimate fashion market. With an approach focused on elegance, sensuality and sophistication, our logo offers more than a simple visual representation. She is the embodiment of the values her brand represents: confidence, beauty and self-expression. I would like to have the opportunity to create an excellent logo for you.
The project encompasses the following requirements: 1. I don't need his life story. I don't need the case details. I need only the role of Radhabinod Pal in this case. 2. I would appreciate it if anyone could provide full judgment. Specifically his judgment. 3. Books and articles on this judgment written by Radhabinod Pal. 4. Textbooks, academic papers, and possibly multimedia resources on the role of Radhabinod Pal. I am seeking your assistance in curating a collection of specific references and books on Justice Radhabinod Pal (1886-1967), who served as the judge of the International Military Tribunal for the Far East (1946-1948). In deliberations with judges from 10 other countri...
