Using vba to automate excel jobs

I am in need of an experienced freelancer who can assist with various types of data entry tasks. This primarily involves: ...need of an experienced freelancer who can assist with various types of data entry tasks. This primarily involves: - Transcribing data from handwritten documents - Entering data from digital documents - Inputting data from spreadsheets The volume of data to be entered is moderate, falling between 100 - 1000 records. The preferred software for this project is Excel, therefore, proficiency and solid experience in using this application is necessary. Attention to detail and accuracy will be essential for this position. Understanding how to use spreadsheets effectively, and a proven track record in data entry are important skills that...

I have a 7-page spreadsheet that needs consistent formatting and customization to reflect my school's brand identity. The system should be able to easily add and delete rows/columns via right-click menu options. Key Requirements: - Format and make consistent a 7-page spreadsheet. - Implement school branding elements. - Enable easy addition and deletion of rows/columns via right-click menu options. Ideal Skills: - Proficiency in Excel formatting and customization. - Graphic design skills for incorporating branding elements. - Experience in creating user-friendly menu systems.

I'm looking for an experienced chatbot developer who is certified with uchat to create a chatbot that will primarily focus on process automation. The chatbot should possess the following features: - Natural language processing to understand and respond to user queries effectively - Integration with the uchat platform for seamless operation - Customizable responses to cater to specific needs and scenarios User interaction will involve both text-based and voice-based communication. The primary goal of this chatbot is to automate various processes. This will require complex logic and an understanding of the business needs behind the processes being automated. Ideal candidates for this project will have: - Proven experien...

Please Sign Up or Login to see details.

Algo Trading setup Description: We are seeking an experienced individual in algorithmic trading and API integration to assist in setting up automated trading signals. Our algorithm, currently operating on the TradingView platform, generates precise buy and sell signals. However, we require assistance in seamlessly translating these signals into actionable trades on our trading platform. The primary objective of this project is to integrate our existing algorithm with the trading platform's API to automate the execution of trades based on generated signals. The selected freelancer will be responsible for establishing a robust connection between the algorithm and the trading platform's API, ensuring timely and accurate execution of orders. Key tasks i...

I'm in need of an experienced Flutt...Android and iOS systems. Requirements: - Develop a logistics and delivery app: The project focuses on creating a comprehensive software that can manage delivery services. It should include features such as route optimization, real-time tracking, delivery scheduling, and scanning capabilities. Skills & Experience: - Proficiency in Flutter: The candidate should be well-versed in Flutter development to ensure a seamless and efficient app. - Previous Experience: An ideal candidate should have a strong track record of developing similar applications. - Strong understanding of logistics: Knowledge of logistics and delivery processes is a plus as it will help in designing an efficient app. If you think you are the right fit for this task, k...

...expert in Excel to build a comprehensive tracking file. This task involves: - Establishing a data entry form to easily input inventory and project progress details. Knowledge of creating user-friendly interfaces within Excel is beneficial. - Implementing automated calculations to streamline the data analysis process. Strong mathematical and analytical skills are essential. - Creating a graphical representation of data to facilitate understanding. Experience in data visualization is a must. The spreadsheet will track fewer than 10 types of inventory data and project progress data. Your familiarity with inventory management processes and project tracking would be highly valuable. This assignment calls for you to use Excel's capabili...

I am looking to streamline my excel data entry process. Needs centralized on the automation of numerical data entry in my Excel spreadsheets. Key requirements: - Automate simple data entry into few columns. - Experience with Excel data entry automation required. - Should have good knowledge of Excel functionalities and automations. - Ability to handle numerical data efficiently. Experience in handling simple data entry (few columns) and automating the same would be ideal for this job. Reach out if you need more information and looking forward to your expert assistance in this process improvement.

I am seeking a proficient specialist in Excel 2010, with extensive experience in the creation of VBA Macros, designing data entry sheets, automating tasks, and generating reports. Key responsibilities include: - Design and develop efficient VBA Macros - Design accessible and streamlined data entry sheets - Automate various Excel tasks for increased productivity - Generate comprehensive and insightful reports Ideally, you have advanced knowledge of Excel and VBA Macro programming, demonstrating a proven track record in dealing with complex Excel projects. A strong understanding of spreadsheet automation and report generation is fundamental to execute this project successfully.

I'm seeking a proficient developer to build a comprehensive demo or starter code integrating Snowflake and Kafka using AWS cloud. The ideal candidate should have deep understanding of concepts such as: - Data ingestion - Data transformation - Data storage and retrieval The code should ensure: - Optimal performance - Scalability - Security The code can be written in Python or Java. In-depth knowledge of these languages, as well as experience with Snowflake and Kafka integration, is a necessity for a successful bid on this project.

I'm in search of a meticulous data entry specialist to assist with my Excel-related work. Key responsibilities: - Data entry: The work pertains to entering simple, text-based data into Excel sheets. - Data sourcing: This role requires you to source the data before entry. Ideal skills for this project: - Proficiency in Excel: A strong grasp of Excel functions and formulas is a must. - Data entry experience: Previous experience with data entry, especially in Excel, is preferred. - Research skills: A knack for sourcing data efficiently and accurately.

I have two PDF files that contain about 150 records each that I need entered into a single spreadsheet. I do not require any specific categorization, but rather a direct, one-to-one transfer of the information from the PDFs into the spreadsheet. The data fields needed are names, addresses, emails phone number etc Ideal Skills: - Proficiency in data entry - Experience with working on PDFs - Attention to detail - Familiarity with spreadsheet software (such as Excel)

I require an Odoo expert to automate tasks within my business. This involves: - Sales and CRM: A seamless system that streamlines sales and communication with our customer base - WhatsApp Integration: An impressive system that sends and reacts to WhatsApp messages automatically - Email Automation: An efficient system that allows automatic replies, scheduled sending, and manages email campaigns This project demands a good understanding of Odoo and automation techniques, knowledge of WhatsApp and email systems, and a knack for simplifying complex workflows. The objective is to improve efficiency, communication, and customer interaction within the company. Upon customer sign-up, the system would trigger a series of communications via WhatsApp, SMS, and Email thr...

Please Sign Up or Login to see details.

I need a proficient Excel user to create a workbook for my multiservice business. What I Require: - The ability to record both cash, check and card income, as well as expenditure for each. This tool needs to be able to accommodate and separate these different transactions for easy access and clarity. Desired Features: - It should automatically calculate the daily and monthly income for each category. - Must also offer a daily and monthly balance for cash flow. Skills & Experience: - Strong Excel skills are a necessity. - Ideally, the freelancer should have experience with creating business financial sheets. Timeline: - I'd like this project completed as soon as possible. Urgency is key.

? Seeking HubSpot Automation and Integration Expert! ? Please send the proposal for your monthly price, we are wanting to find a full-time person who can join our team . We're on the lookout for a skilled HubSpot Automation and Integration Expert to join our team. Responsibilities - Manage and ensure the cleanliness of databases across various clients. - Handle API integrations and effectively connect various systems to HubSpot using tools like Zapier and Make .com. - Optimize HubSpot objects and automate processes, including form submissions that trigger deal creations and associate contacts. - Develop and manage workflows and lifecycle drip email campaigns tailored to different client needs. - Oversee the creation and analysis of custom re...

I'm in need of a freelancer who can assist me with the styling and formatting of an Excel spreadsheet. Your task will primarily involve applying cell style formatting. Specifically, I'm requiring assistance with: - Implementing cell style formatting. Please note that while the exact type of cell styles are not defined yet, I will be able to provide more details and guidance once the project begins. Ideal skills for this job would include: - Proficiency in Microsoft Excel - Previous experience with complex Excel formatting - Ability to work independently and on deadline Please, in your bid, include examples of any similar jobs you've completed.

I'm looking for an Azure professional who can help me set up an Azure cloud solution to host my Excel data. The project involves: - Hosting Excel Data: I will provide you with an Excel file, which I would like hosted on Microsoft Azure. The data in this file will not be updated frequently, just once for now. - Web Application: I would like the Excel data to be accessed through a web application. This means you will need to set up a simple, user-friendly interface for viewing and possibly manipulating the data. Ideal Skills: - Experience with Microsoft Azure, particularly in hosting data. - Proficiency in setting up web applications. Please get in touch if you have the right expertise, and we can discuss the project further.

I am seeking a detail-oriented freelancer to input text and numerical data into 3 small Excel spreadsheets, containing 1 column each. 2 spreadsheets for emails, one called Minnesota, one called Midwest. 1 spreadsheet of inventory numbers. See attached. Only emails are needed. Inventory is on yellow paper Ideal Skills: - Proficient in Excel - Attention to detail - Knowledge of data organization and management Highlight the entries that you are not sure of, or the handwriting is to difficult to read. English fluency in a must.

The task centers around leveraging Python programming and machine learning skills to perform data analysis. The data to be analyzed are contained in an Excel sheet, specifically focusing on customer data. The ideal freelancer for this task should exhibit the following: - Strong proficiency in Python programming. - Solid experience with machine learning. - Familiarity with data analysis, particularly descriptive analysis. - Ability to accurately interpret customer data. The task requires a reading of the Excel sheet and performing data analysis based on the customer data contained within. The chosen Python and machine learning expert will focus on descriptive analysis techniques to extract meaningful insights. Your insights should guide our strate...

I'm in need of an experienced PowerShell script writer, specifically for Power BI associated data management tasks. As part of the project, code will be required to execute the following tasks: - Data extraction from Excel files, CSV files, and SQL databases - Transformation of data, including extraction and update of parameter values from Data Models in each Workspace Ideally, the freelancer would carry a strong understanding and hands-on experience with PowerShell scripting, Power BI, data transformation techniques, and working with database source files like Excel, CSV, and SQL formats.

I am in need of an automated solution for a task I currently undertake on a daily basis. The task involves merging sales data from two spreadsheets to create one consolidated spreadsheet. This crucial operation currently takes me about an hour every day, and I am seeking assistance to build an efficient process, ideally through a script, that can handle this for me. The end result will be a daily spreadsheet detailing which locations are owed orders. Ideal Skills and Experience: - Proficiency in Excel and creating Excel scripts - Knowledge of sales data and data merging - Ability to automate manual tasks - Attention to detail with data accuracy.

Hello, I have 6 simple contact web forms that I would like recorded into a single matrix. The goal is to see the field alignment and comparison between the form data.

...Microsoft 365 and Outlook to configure my email accounts and set them up ready for use with Power Automate and Microsoft Defender. Key Requirements: - Expertise in Microsoft 365 and Outlook email configuration - Proficiency in setting up email accounts - Experience in using Power Automate to automate email workflows and integrate with other tools or platforms - Knowledge of Microsoft Defender The goal is to have my emails set up efficiently and securely, with the ability to automate workflows and integrate with other tools/platforms, all while ensuring the highest level of security with Microsoft Defender. Your role would be to configure the email accounts, set up Power Automate for email workflows, and in...

I'm seeking an expert data analyst specializing in financial data analysis for real estate development projects. The focus...our upcoming construction project, specifically concerning future projections for the next 10 years. Candidates should be competent in: - Creating custom excel/ google sheet template - Forecasting Capital Expenditure - Predicting Cash Flow - Delivering revenue Projections Your role will involve analyzing, interpreting, and providing insights on these aspects. Proficiency in financial modeling and forecasting is a must. Knowledge about the construction sector will be highly regarded, and prior experience in real estate development is a bonus. To make informed decisions, we're relying on accurate and in-depth analysis so your attention t...

I'm seeking a skilled financial analyst to prepare a detailed report on Company C's financial health. The primary goal of this analysis is to provide insights on the company's performance and help in making well-informed recommendations. Key aspects to emphasize in the report: - Revenue growth: A clear picture of the company's revenue trends. - Profit margins: Analysis of the company's profitability and how it compares to industry standards. - Debt levels: Understanding the company's debt situation and its potential impact on future performance. - Valuation: A comprehensive evaluation of the company's worth. - Business summary: A concise overview of the company's operations and key strengths. - Risks: Identification and ...

Excel task to do the task t0 d0

I'm looking for a skilled professional to automate the task of entering data from specific Outlook emails into a structured format. The ideal candidate will have experience in: - Automating data entry tasks, and particularly from emails. - Working with Outlook's API or related tools. - Developing scripts or software to extract and categorize email content based on specific criteria. Key requirements include: - Extracting and processing data from emails based on criteria like sender's identity and keywords. - Ensuring the data is accurately transcribed and structured according to a predefined format. - Ensuring the process runs smoothly and efficiently, with the ability to handle a large volume of emails. - Providing a user-friendly soluti...

I...an experienced developer who is well-versed in React JS and Node JS for the development of an e-commerce platform. This platform will be designed to support a range of e-commerce functions, with the main focus being on product search and filter options. Key responsibilities & requirements: - Proficiency in React JS for front-end development - Experience with Node JS for back-end development - Strong understanding of e-commerce structures and functionalities - Ability to integrate user-friendly product search and filter options The ideal candidate should be someone who has not only the technical expertise, but also the vision and creativity to enhance the user experience through these key functionalities. A portfolio showcasing previous e-commerce projects ...

I need a skilled Excel professional to help me with data analysis and manipulation using the Solver add-in to solve optimization problems. Key Requirements: - Perform data analysis and manipulation in Excel - Apply Solver add-in to solve optimization problems Ideal Skills and Experience: - Strong proficiency in Excel - Prior experience with data analysis and manipulation - Familiarity with Solver add-in in Excel - Ability to interpret data to solve optimization problems - Attention to detail and accuracy for successful data manipulation Please include your relevant experience and how you can address the task described above in your bid.

I am looking for a skilled Excel dashboard developer to build a proficient tool to track vital business metrics a balance scorcard. The ideal candidate for this job should have: - Expertise in creating user-friendly KPI and balanced scor cards dashboards. - Understanding of various KPIs including revenue growth, customer acquisition, and conversion rate. Key Project Details: - I already have specific KPIs to be tracked and would share them with you post project initiation. - The dashboard should be designed to automatically update on a monthly basis based on manual input that would be added to calculation sheet for each kPI. - The dashboard must be easy to read, understand, and interactive. - the dash board should include risk alert for K...

...for a range of products. The ideal candidate must excel in rendering techniques, possess meticulous attention to detail, and have the ability to breathe life into products through stunning visual representations. Responsibilities: Create photorealistic 3D models of products. Develop high-quality textures and materials. Render product images and videos using industry-standard software. Collaborate closely with the creative team to ensure alignment with brand guidelines. Optimize renders and videos for various platforms. Requirements: Demonstrated expertise in 3D rendering, modeling, texturing, and lighting. Proficiency in industry-standard 3D software. A strong portfolio showcasing past product visualisation projects. Exceptional attention to...

I'm looking for an Excel expert to develop an NSE options chain tool that will provide real-time data. The primary goal of this software is to facilitate educational purposes by explaining the basic concepts of options trading. Key Requirements: - Real-Time Data: The tool should be able to fetch and update real-time data from the NSE options chain. - Educational Focus: The content presented should be geared towards explaining the basic concepts of options trading in a clear and easy-to-understand manner. - Excel Proficiency: The ideal candidate should have a strong command over Excel and be able to integrate real-time data sources effectively. Ideal Skills and Experience: - Advanced Excel Skills: Proficiency in VBA...

I hope you are well, sorry for the rush. I always give you the highest quality work and am ready to be by your side anytime. I hope you are happy with my service. I hope to get good comments from you. We will work together more thanks!

I'm looking for a freelancer who can help me automate my JIRA tasks by creating a subtask for every paragraph within the Description field. Key Requirements: - The automation should trigger whenever there's a double line break in the description. - The subtask should inherit all attributes from the parent task, including Summary and parsed Description. - The parsed paragraph from the parent task should be included in the subtask. Successful freelancers should be able to: - Build JIRA automations - Be familiar with the JIRA system and the programming languages or tools that can be used for creating such automations. This includes JavaScript and any other language that JIRA supports. Your application should demonstrate your expertise and experience in this area. P...

I'm in need of an Excel expert who can help me automate data entry and formatting tasks. I also need assistance in creating a macro to generate daily status reports. Key Tasks: - Automate data entry tasks - Automate formatting tasks - Create a daily status report macro Requirements: - Proficiency in Excel and VBA macro creation - Experience in automating data entry and formatting - Previous history of generating reports using VBA - Strong communication skills and ability to understand and translate my requirements efficiently.

...need of a skilled Excel expert who can assist with advanced formulas and functions. The main task will be related to carrying over formulas in both the same sheet and different sheets. Key requirements: - Advanced knowledge and experience in Excel formulas and functions - Proficiency in carrying over formulas across multiple cells and sheets - Ability to efficiently manage and implement complex formulas Your responsibilities will include: - Identifying the most suitable formulas based on specific requirements - Implementing the formulas accurately and ensuring they work correctly - Carrying over these formulas as needed across multiple cells and sheets If you're an Excel guru with a strong background in advanced formulas and functions, and are...

I need a skilled Excel VBA Macro expert to develop a VBA macro that can automate reports, specifically with numerical data. Your task will revolve mainly around creating a function that streamlines the reporting process, making it efficient and error-free. Ideal Skills: - Extensive knowledge in Excel VBA - Strong background in automated reporting using Excel - Familiarity with handling numerical data Experience required: - Prior experience developing Excel VBA macros - Proven track record in creating automated reports .

Please Sign Up or Login to see details.

I'm in need of an experienced individual to expertly handle data entry tasks. Specifically, the role will involve inputting personal customer details into databases. Ideal Skills and Experience: • Proficiency in using Excel • Attention to detail • Experience in data entry, particularly with personal customer details • Ability to handle confidential information responsibly Your primary task will be to input data accurately and efficiently. Please ensure you have the above-mentioned skills before bidding. A keen eye for detail and confidentiality are paramount.

I require an expert capable of uploading an Excel dataset into S3 using Lambda and Snowflake to produce reports. The focus will be on identifying data anomalies over time. Your responsibilities will include: - Loading Excel data into S3 - Implementing Lambda and Snowflake for data processing - Generating time-series reports on data anomalies Ideal skills for this role include proficiency in AWS S3, AWS Lambda, and snowflake, with a keen understanding of time-series analysis in Excel reports. Experience in identifying and analyzing data anomalies is also a key component for this project. The aim is to visualize the irregularity in the data, enabling me to make informed decisions based on these reports.

I need a proficient Excel macro creator to help with tasks involving data automation and formatting. The macro will need to work seamlessly across multiple sheets in Excel 365. Key tasks involve: - Automated data entry across multiple Excel sheets. - Formatting the entered data to adhere to specific standards. Ideal Skills and Experience: - Advanced knowledge of Microsoft Excel 365. - Complete understanding of Excel Macro creation. - Demonstrated ability to automate data entry and formatting in Excel. Your commitment to timely and accurate results will be highly appreciated. Thank you in advance for your time and efforts.

I have a current report in Excel 365 that I'd like to improve. Key Requirements: - Automate formulas to avoid errors: I need an expert to automate specific formulas in the report, which primarily involve Sum, Average, and Count functions. - Complete totals by searching information in the other existing sheets: For this, the formulas should pull information from Sheet 1, Sheet 2, and Sheet 3 to ensure the accuracy and completeness of the totals. Ideal Candidate: - Experience in Excel 365, particularly in automating formulas and cross-referencing data from multiple sheets. - Attention to detail and the ability to ensure the accuracy of the final report. This project is ideal for someone who is skilled in E...

I'm currently in need of a software solution that can automate the process of creating new user IDs on IRCTC. The solution’s crucial feature would be an autofill functionality for the following details on the registration panel: - Name - Date of birth - Mobile number - Address - Email address Apart from this, the ability to generate random inputs for these fields is a must to ensure a smooth, streamlined registration process. Appropriate technical skills that would be beneficial for this project are: - Strong understanding of automation software development - Practical experience in random data generation - Knowledge on scripting to autofill forms - Experience with IRCTC's platform or similar would be a clear advantage. In conclusion, I am eage...

I'm in need of someone skilled in both astrology and mathematics. I require accurate calculations of planetary positions and insightful astrological predictions. merging the disciplines of Western astrology with numerological techniques. Required Skills: - Proficiency in Western astrology methodologies - Numerology knowledge, particularly in relation to astrology - Competency in astronomy-based mathematical computations - Experience generating astrological charts and predictions

I'm looking for an expert in Power Apps to enhance my project with additional functionality. As with most Power Apps endeavors, this one aims to automate processes, create a mobile app, and manage data and workflows. The project has a broad scope and I need a detail-oriented professional who can ensure everything runs smoothly. Despite skipping a few questions about the specifics, I will provide complete details once we start our discussion. Ideal Skills: - Extensive experience in Power Apps - Strong understanding of automation processes - Excellent communication skills - Attention to detail - Ability to integrate systems - Experience in mobile application development - Proficiency in data management and workflows

Looking for a skilled developer proficient in Python, Node.js, Postgresql, and Next.js. The project involves integrating an existing Python bot into a website to automate product data input. Key requirements: -Bot Integration: Seamlessly integrate the Python bot with the website's Node.js backend and frontend. -Automated Data Input: Ensure the bot reliably inputs product-related data, leveraging expertise in Postgresql for database management. -Error Handling: Implement automatic bug reporting in case of data input errors. If you have relevant experience in bot integration and database management, please submit your bid.

...that I need to be cleaned up. The main task is to remove duplicate entries. Key Points: - Main Task: The primary goal of the data cleaning project is to remove duplicate entries in the database. - Handling Duplicates: The duplicates should be automatically deleted, not merged or manually reviewed. Ideal Skills & Experience: - Database Management: A strong background in database management is crucial for this task to ensure the data is processed correctly without compromising the database integrity. - Data Cleaning: Experience with data cleaning processes, especially in handling duplicate records, is important. - Automation: The ability to automate the deletion of the duplicates efficiently and accurately is essential. Please bid if you ...

I need an Excel budget tracker developed, with specific focus on tracking and calculating expenses related to my business. - The tool should enable me to manually enter expenses and automatically sort these costs into categories. - The main category of interest is 'Commercial Expenses', so having a well-defined, categorizable section for this is important. - I additionally require a feature for budget calculation, providing an easy-to-understand analysis of financial outgoing compared to overall budget. Ideal freelancers for the job would be those proficient in Excel and financial analytics. Experience in developing similar budget tracking tools would be a valuable addition. I have a base of what I need. I need the budget data tab upda...

...CHANGE IS ALLOWED. READ CAREFULLY BEFORE YOU BID. See ATTACHMENTS. Cannot share Code before you accept. I have a Journal App built in PHP/JavaScript/Laravel which allows to enter Journal entries, country, some photos and one video of limited size, different costs etc (see ). The job is to implement the feature of Travel Route Map Creation using Leaflet and OpenStreetMap (both free, opensource). There is a tutorial here Users will be able to search a place in map, create lines of different colors from one place to another, add/tie blog posts, links and pictures with the map, dates, notes and then only map creator can download the map as Image/PDF. Leaflet free plugin is there for