Simple excel vba script jobs

I require an experienced data cleaning specialist who can proficiently handle Excel spreadsheets. My project involves tidying up datasets related to customer, product, and financial data, though different types of data might need to be scrubbed too. This data cleansing task involves a lower volume dataset of less than 1,000 records. Key tasks include: - Identifying and correcting any inaccuracies. - Identifying and handling missing data. - Assuring the consistency of datasets. The ideal freelancer should have strong skills in spreadsheet management, a keen attention to detail, exceptional data analysis abilities, and a solid understanding of customer, product, and financial data. Experience in Excel and a proven track record in data cleansing are a must.

I am looking for a detail-oriented professional to assist me with basic data entry tasks in Excel. The primary responsibility will be to input data such as names and addresses into an Excel spreadsheet. Key Responsibilities: - Inputting basic data into Excel spreadsheet Furthermore, the project requires data verification. This means ensuring that the data has been accurately entered. You will be required to cross-reference the inputted data against the source material to detect any discrepancies or errors. Ideal Skills & Experience: - Proficient in Excel - Attention to detail - Strong data entry skills - Familiar with data verification processes - Previous experience in basic data entry This project is quite straightforward, but precision and accuracy ...

I'm looking for a skilled professional to assist me with various customer support, operation, and mana...manage customer inquiries through phone calls, email, and live chat. - Managing Customer Databases: This project requires proficiency in maintaining databases across various platforms including CRM systems, Excel spreadsheets, and online database platforms. - Analyzing Customer Feedback: An ideal candidate will have experience in analyzing customer feedback to help our services grow. The ideal freelancer for this project should possess: - Proven experience in customer support and management - Excellent communication and interpersonal skills - Proficiency in using various CRM systems, Excel, and online database platforms - Familiarity with analyzing customer feedbac...

Looking for a skilled individual to create a script to automate the process of data scraping from The project involves: - Extracting comprehensive data from the specified website. - Covering all possible details that can be scraped from the website. - Ensuring accurate and efficient collection of data. The ideal candidate should: - Have significant experience in data scraping and automation. - Have strong knowledge of back-end technologies. - Be able to quickly understand and map the structure of the targeted website. Your proposal should illustrate your experience and approach to this kind of task. Please also include an estimated timeline for completion.

I'm looking for a professional who can assist me with certain multimedia editing tasks. The work involves adding text, incorporating a logo, and trimming videos. Though I didn't specify the type of logo, it will be a standard, text-based, or image-based one. Ideal skills and experience: - Proficient in editing multimedia content - Capable of incorporating logos into videos - Skilled in adding text effectively - Experience with trimming videos - Ability to work flexibly with different types of logos Please reach out if you think you can help me with these tasks.

I need emails from these companies of CEO ot anyone else working in financials, sales, or partnerships. Data scraping from rocketreach of the emails of the people that you can find with relevance from these companies in the image. Excel sheet with company name in the rows and in the 3 columns full name, email and position in the company

Data entry operator and my work very clear

I'm looking for an experienced professional in Excel to create a custom financial tracking template for me. Bonus if compatible with both google sheets and excel. Key Elements: - The template needs to include sections for tracking income and expenses. - Additionally, I need sections for debt repayment tracking and Year To Date (YTD) tracking. - The template should be designed in a way that it is easy to update monthly Ideal Skills: - Proficiency in Excel and experience in creating financial tracking templates. - Knowledge of financial principles and ability to design a user-friendly, visually appealing template. - Attention to detail and ability to customize the template to meet my specific requirements. Please include samples of similar work you've done ...

Example style: We - LigoWave provide easy-to-use wireless networking solutions for businesses and communities, ensuring reliable connectivity with advanced technology. We will be releasing new product and we want video showing the highlight features with "Mike" as our older video...talented animator to produce a high-quality 2D video that is under two minutes long. Key requirements are: • Skilled in 2D animation. This is a must as it is the style we have chosen for this video. • An ability to produce engaging and captivating content within a short span of time. The video is less than a 1.30min . • An understanding and ability to work with existing scripts. We already have a script and we need you to bring this to life.

I'm looking to create a detailed list in Excel from the website AND filtered by clicking on 'Hardware' under 'Products' which is on the left side in the 'Filter' section. The list should have two columns - the first for the Company Name and the second for the Description available on the website. Key Requirements: - Copy the Company Name into Column 1 and the Description into Column 2 of the Excel sheet. - Description should be directly copied from the provided URL. Ideal Skills and Experience: - Proficient in Excel and web scraping. - Attention to detail to ensure accurate data transfer. - Previous experience with similar projects would be advantageous.

I have a simple data entry project. Watch the explainer video. excel file to enter into is attached to the project

Excel Chart Re-Design for University Work Allocation System We are looking for somebody to complete the development of an excel-based teaching allocation database for a relatively large university department (approx 100 teaching staff). We currently make use of an excel template that roughly cross-references university courses with teaching staff and allocated time commitments for specific tasks. This is quite a complex information array, however, with so many staff members and courses (approx. 120), especially where multiple staff members are co-teaching courses with different task responsibilities. While our current template achieves its desired information management purpose, in its present state its structure is relatively complex and not user-friendly or ...

Hello, We are currently seeking a talented freelance professional proficient in SCO OpenServer, Python, Progress, and ideally with a grasp of the Microsoft Power platform. Our recent project, conducted in collaboration with an external consultant, involved setting up a data extraction system from print files using a Python script, subsequently transferring them to a Power Automate flow. With the conclusion of our collaboration, we're now seeking to establish a sustainable solution for the ongoing maintenance and development of this system. If you're proficient in SCO OpenServer, Python, Progress, and ideally the Microsoft Power platform, we want to talk to you! Our team is looking for a freelance professional to maintain and develop our data system.

Looking for an expert who can bring my educational content to life with vibrant, engaging 3D animations. The animations should be a blend of character-based and abstract to maintain viewer interest. Key Requirements: - Skilled storyteller through 3D animation. - Experience in character-based and abstract animation. - Excel in conveying complex information simply and clearly, ideally within an educational setting. - Ability to work collaboratively, ensuring your creations align with my vision. Enhance your bid with relevant work samples, especially animations used for educational purposes. I am excited to see your creativity at work!

Website on Wordpress License key generator with DB API for Excel Template connecting to DB for license key validation. Dashboard for administrator enter buyer/customer account credetials. The administrator must be able to enable and disablle accounts. Update Excel Template LicenseValidation code for connectiing to API/DB. I will privide this Excel Template code file.

I need an Excel expert to update my spreadsheet. The main tasks include: - **Formulas and Calculations:** I require formulas to be implemented for various calculations. The freelancer should possess a strong understanding of Excel functions and be able to apply them accurately. - **Formatting:** The formatting of the spreadsheet needs to be updated. This includes: - **Font Styles and Sizes:** I need the text in the spreadsheet to be consistent and visually appealing. The freelancer should have a good sense of design and layout. - **Number Formats:** Incorrectly formatted numbers need to be corrected. The freelancer must be meticulous and detail-oriented in this aspect. - **Color Changes for Expired Dates:** An important part of the project is changing the color of cel...

I'm looking for an experienced Excel and PineScript expert to create custom Excel formulas replicating my developed PineScript indicator. The indicator performs functions for Bollingerbands and Keltner Channels. The task will be to incorporate Open, High, Low, Close prices into the Excel formulas. Please note, data collection or data visualization is not required for this project. To give your best, you should possess an advanced understanding in: - PineScript - Creating complex Excel formulas Looking forward to your informed bid.

I need help with an Excel sheet that will be used for data analysis, specifically sales distribution. The sheet will include a mix of sales data, customer information, and product inventory. Key tasks: - Organizing and inputting the provided data correctly - Creating a system for sorting and analyzing the data - Developing a system for tracking sales distribution effectively - Potentially applying necessary calculations and formulas to enhance the data analysis Ideal Skills: - Proficient in Excel, including data analysis and financial functions - Experience with sales data and distribution analysis - Strong attention to detail and organizational skills - Ability to create formulas and calculations - Familiarity with customer information and product inventory management Ple...

I need a skillful video creator who can bring my brand to life with compelling talking head style videos. They need to be highly engaging and less than 1 minute in length. ...need a skillful video creator who can bring my brand to life with compelling talking head style videos. They need to be highly engaging and less than 1 minute in length. Required Skills: - Proficient in creating high-quality, talking head videos - Ability to deliver concise and engaging content within tight timeframes - Creative thinking with a knack for communicating brand stories visually -Script and everything will be provided from our side If you meet the above requirements and have an eye for captivating visual storytelling, kindly hit the bid button. I look forward to reviewing your proposals and prev...

...fields into an Excel (.xls) file. The database consists of approximately 150,000 entries. Each record includes data such as name, business name, contact information, date of foundation, etc. Ideal Skills: - Strong experience in Web Scraping - Proficiency in transferring data into .xls format - Attention to detail to ensure all available fields are captured Purpose and Deliverable: - The objective of this project is to use this information for data analysis. - The final output will be an Excel (.xls) formatted file containing each scraped database entry. Operation Specifics: - You would be required to locate and scrape the database by Zip codes. - A full export of all accessible information per entry is needed. Your expertise in internet research, data mining, and...

I am seeking a t...numbers for promoting my business. Key Features: - Bulk Phone Number Verification: The tool should be able to check multiple phone numbers at once. It should separate the active numbers from the inactive ones. - Whatssap Compatibility: The tool needs to connect with Whatssap API to confirm the activity of the numbers. Delivery: - Data Export: I require the verified numbers to be exported to an Excel spreadsheet for easy access and use or .txt file Skills & Experience: - Proven experience in API integration, specifically with Whatssap. - Strong programming and software development skills. - Experience in building phone number verification tools will be a plus. Please provide examples of similar projects you have worked on previously. Looking forward to y...

...into a Modal. Key Requirements: - Provide the framework for an auto-population feature in the HTML code. Whether this is through regular html or implementing a DOM. Once you've shown what code works for more than 2 of the div ID's in the script I will duplicate across all other scripts. No need for your to do this yourself. Just provide the initial coding. - The auto-population should be activated based on two specific VAR (variable) included in the "Autopop ". The autopop will then open a specific Menu item based on the VAR and the Script AutoPop Matrix. - Take the existing birthday pop-up (included at bottom of (HTML to update.txt.) and convert it into a modal but include all of the same criteria for population. Ideal Skills and Experience: - Str...

I'm looking for a freelancer with excellent attention to detail and proficiency in Microsoft Excel and Word. As part of this project, you will be required to manually enter data from Excel files into a Word document. Key Requirements: - Strong Microsoft Excel and Word skills - Proven experience in accurate, manual data entry - Ability to work with robust data sets Deliverables: A Word document with the data accurately entered from the provided Excel files. Your ability to deliver clean, accurately transcribed data is essential for the success of this job. Attention to detail is paramount. I look forward to working with detailed and skilled freelancers.

I need an assistive hand in a data extraction task that requires sharp focus and meticulous attention to detail. The task involves: - Extracting email addresses from an Excel spreadsheet - Maintaining accuracy and precision during the data entry process, ensuring no data is missed or inaccurately entered Proficiency in Microsoft Excel is a must for this task. Previous experience in data extraction or data entry is highly desirable. You should be adept at handling large volumes of data, have a keen eye for detail, and are able to keep track of your progress systematically. Let me know your capacity per day/week as this can be an ongoing project. Please dont negotiate on the price beyond the Bid provided

For my company, I need an expert with extensive experience in data consolidation and import to QuickBooks. - The project involves the migration of the company's financial data for the years 2022 and 2023 which is stored in Excel spreadsheets currently. - The data needs to be consolidated into a single file before importing into a new Quickbooks instance. As an ideal candidate, you should have: - Experience with Quickbooks data import - Excellent understanding of data consolidation - Proficiency with Excel spreadsheets - A keen eye for detail and the ability to maintain the integrity of financial data during the import process.

I'm in need of an experienced Excel professional to help me build a secure data management system. This system will be used to handle both financial and customer information. Key Requirements: - **Data Security**: A robust system that ensures the privacy and integrity of the financial and customer data. - **User Management**: The system should be designed for 1-10 users, allowing them to access and input data securely. - **User Experience**: While the users are expected to have advanced Excel skills, the system should be designed with clear interfaces and user-friendly features. Ideal Candidate: - Proven experience in designing secure data management systems in Excel - Proficiency in VBA and Excel's advanced features - Strong understanding of data s...

Searching for an experienced and innovative video editor-animator, specifically proficient in 3D animation. The selected candidate will be entrusted with the task of editing and adding animation effects to a pre-recorded video. The editing and animation work will be based on the script that I will provide. Ideal Skills: - Comprehensive understanding of editing software and 3D animation tools - Ability to create realistic and detailed visual effects - Proven track record of animation or video editing Primarily, the chosen professional will need to contribute a contemporary and in-depth aesthetic touch to the video. Relevant samples of pervious work in a similar vein will be appreciated. Please note that the specifics of the project will be unveiled only once agreement is reached...

...to work with. We now want help to create some new features. - We want to have a droplist with all the variants of The Configurable Product but still keep the original texts and links for the Simple Product. The Configurable Products is hidden and we only want to show each Simple Product separately, but inside the Simple Product there should be a droplist with all variants. When you select a variant, we want you to be redirected to chosen Simple Product. So we need a function that checks if the product is linked to a Configurable Product but retrieve a list of links to all the interconnected Simple Products. We will need help with more things but we can start with these to move the project forward. Do not write to us if you have never worked with...

Zigzag indicator is coded based on breakout

I'm in need of a simple yet robust Android app for my workshop. The ideal candidate for this project should have experience in developing efficient and user-friendly applications for Android systems. Key Functions: - The app should provide a seamless offline experience, while also being capable of working online. - The primary features of the app should focus on creating and sending invoices, as well as generating vehicle inspection reports. The app should be designed to be intuitive, practical, and user-friendly. It should streamline the process of managing invoices and generating vehicle inspection reports, making it an essential tool for our workshop. Ideal Skills and Experience: - Proficiency in Android app development - Prior experience with creating invoicing and repor...

I am in immediate need of a professional with proven experience in writing legal Partnership Agreements. Specifically: - Proficiency in drafting Partnership Agreements is crucial. - The agreement must excel in providing measures for protecting sensitive information. - Understanding of confidentiality and data protection is mandatory. I am expecting work that is thorough, legally sound and protects my interests optimally. It is not about just getting it done but getting it done right. Previous experience with such documentation is a solid advantage. Kindly share your portfolio when applying. Accuracy, attention to detail, and understanding complex legal terminology are the skills that I am looking for. NB: Experience with sensitive information protection will be a bonus.

I have excel file where I want to clean. Merge columns and make it simple. You have to be able to fix it within 30 min not more

I'm looking for an adept Javascript developer who is proficient with React to create a function for my custom web app. Here's what you'll be working on: - DOM Manipulation: Your main task will be form manipulation. The ability to handle dynamic content that may be loaded post initial load is crucial. - Autocomplete Function: For this role, prior experience with form manipulation, particularly in React, is essential. Knowledge in working with server APIs for autocompletion is also valuable. Your creativity and problem-solving skills will certainly be beneficial in addressing the dynamic content challenge.

I need a talented script writer to craft a compelling and engaging radio script for an introduction to our company. Key Requirements: - The script should be specifically tailored for a radio format, ensuring it is concise and impactful within a limited timeframe. - The genre should be professional and informative, yet engaging. - The script needs to meet the goals of brand awareness, attracting new customers, and informing about our products and services. Ideal Skills and Experience: - Proven experience in script writing, particularly for the radio medium. - Understanding of marketing and branding principles, in order to effectively promote our company. - Ability to create engaging content that communicates the key messages clearly and effectively. - ...

I need a PowerShell script that can monitor and send email notifications for soon-to-expire client secrets and certificates within Azure. Key Requirements: - The script should be able to identify client secrets and certificates that are due to expire in 7, 15, and 30 days. - If an application or app registration does not have an owner assigned, the script should send the email notifications to a specific distribution list. Ideal Features: - Utilize HTML email templates for polished and professional notifications. - Include detailed logging, capturing individual email details and error logs, to ensure the script's operations are transparent and easily traceable. The script should be efficient, reliable, and easy to integrate into the Azure environment. E...

... The information required includes details on the CEO, senior management, and email addresses. The data should be compiled into a spreadsheet, such as Excel or Google Sheets, with separate columns for each piece of information. Key Responsibilities: - Researching and collecting information on the CEO, senior management, and email addresses of around 80 councils. - Ensuring the accuracy and relevancy of the data collected. - Organizing the data neatly into a spreadsheet, in a format suitable for subsequent upload to a CRM tool like Pipedrive. Ideal Skills and Experience: - Experience in data research and entry. - Proficiency in using Excel or Google Sheets. - Familiarity with CRM tools, particularly Pipedrive, is a plus. - Attention to detail and the ability to maintain d...

I'm looking for an experienced VBA coder who can focus on two main tasks. 1. **Fixing Existing Issues:** - My current VBA code has issues with execution errors and incorrect results. I need solutions to these two problems. 2. **Adding Modifications:** - I'm looking for someone who can add additional features to my existing VBA code. - Good user experience is important too so improvements on the user interface would be very beneficial. Ideal candidates will have an excellent understanding of VBA syntax, debugging, and error handling. Experience with user interface design is also appreciated. The aim here is to produce accurate calculations, formatted data or reports swiftly and easily.

I'm looking for a skilled developer to create an efficient FTP script that will allow me to upload files to a specific folder in cPanel. Key Requirements: - The script should be optimized for small files, as large file handling is not a priority. - It should be developed in a language suitable for FTP functionality. The script will be used to automate the process of uploading files to a specific folder on a cPanel server. The ideal developer should have experience in: - Building FTP scripts for file uploads - Working with cPanel and its file management system - Ensuring the script runs smoothly for smaller files Please include in your proposal your experience with similar projects and any relevant skills that make you the ideal candidate for this task.

Hello, I am in need of a developer capable of creating an Excel tool (.xls format) for efficient management of large amounts of data. The tool should have the following features: Storage of large datasets: The tool should enable storing a large quantity of data. Duplication removal: It should be possible to remove duplicates in Excel files to maintain a clean and organized database. Standardization of French numbers: All French phone numbers in the files need to be modified and put into the correct format, such as +33780000000. Editing and export: Users should be able to edit data in the Excel file and export the changes made. Archiving: Once the data is used, it should be possible to upload it to an archive for future reference. I would greatly appreciate it if you co...

I'm seeking a skilled Java and MySQL developer to assist me with two exercises from a training course. Here's a more detailed explanation of the job: - The exercises are centered around Error Handling and Debugging, along with Array and String manipulation and Exception handling. It's crucial that you are well-versed in these areas. -Since this is a learning exercise, I would appreciate it if the code included detailed comments and explanations. Please see the document attached for full details before bidding. Please apply only if you have experience and confidence in these areas.

I'm looking for a skilled ...Search for Cocomelon on youtube Key Requirements: - Proficiency in 2D animation - Ability to create visually appealing and dynamic animations that will keep the viewers engaged - Experience with creating animations for Youtube videos like Cocomelon youtube channel - Understanding of the best practices in creating animations that are suitable for online video platforms I will provide you with the script and guidance on the style and theme of the animations. Your role will be to bring these ideas to life through your animations. The ideal candidate will have a strong portfolio of 2D animations, preferably for online video platforms. The duration of each animation video will be between 2-5 minutes. Please provide samples of your previous work along...

I'm in need of a Pivot table in Excel to analyze my sales data. This will help me track and understand key metrics like units sold and profit margins. Key Project Details: - Data: Primarily sales data - Metrics: Primarily interested in tracking units sold and profit margins - Organization: The data should be organized by product and region Ideal Skills & Experience: - Advanced Excel proficiency, particularly with Pivot Tables - Strong analytical skills for identifying key metrics - Experience working with sales data is a plus - Ability to understand and visualize data in a meaningful way.

I need a freelancer to help convert my scanned PDF document into Excel format. The Excel should have the same layout as the original document in the PDF: - Expert in scanned document conversion to Excel is required as the document isn't text-based. - Advanced knowledge in layout replication is necessary because the converted Excel file needs to have the same structure as the original PDF. - Since the PDF contains unknown special data types, ability to deal with potential complexities (like images, graphs, complex tables) would be a plus. The ideal freelancer for this project should have a proven track record in PDF to Excel conversions and dealing with scanned documents. Bonus points for experience with complex data types.

I am in need of a proficient freelancer with expertise in data cleaning and data analytics to handle an upcoming project involving Excel. Specifically, the tasks will involve: - Removing duplicate entries, - Correcting inaccuracies in data as needed, - Formatting data to enhance its visual interpretation. The next part of the project involves data analysis, where the focus is on: - Creating data visualizations, particularly concerning the sales trends in our dataset. A background in Excel-based data correction and visualization is essential. Ideally, you've had previous exposure to sales data and are capable of understanding and predicting trends. Your bid should reflect your ability to accurately complete these tasks in a timely fashion.

I urgently need to extract the emails from Excel and place each one in a separate cell. In the image, you have an example of what I want.

We are looking for a skilled freelancer developer specialising in creating prompts for AI-powered video script generation. The ideal candidate will possess a keen understanding of content creation tailored for diverse audiences and have the ability to harness the capabilities of AI tools like ChatGPT to produce engaging and innovative video scripts. Responsibilities: Develop creative and effective prompts for generating video scripts using ChatGPT. Collaborate with our team to understand specific video content needs and audience engagement strategies. Conduct research to ensure prompt accuracy and relevance. Iterate and refine prompts based on team feedback and script performance. Deliver high-quality prompts that align with project goals and deadlines.

To count the stock only. (One time) Based on total purchase, deduct total sold, overwrite the remaining stock quantity. Then work done. NOT OVERWRITE THE CODE.

...acre farmers. The site should serve as a detailed resource, highlighting key aspects of our work and organization. Key Features: -A professional look and feel `-Wordpress based - A comprehensive "About Us" page to outline our mission, goals, and team. - A clear display of our contact information on every page. - Easliy updated by ourselves with graphics based on data collected and stored in MS Excel -Potential for client login The perfect candidate for this job would be an individual with a keen eye for modern web design, experience building informational websites, and ideally some knowledge in Australian agriculture. Good communication skills are necessary, as you'll be expected to collaborate with our team closely. A successful end result would result in a u...

I'm looking for an Excel expert to help me clean up a dataset. I have a large dataset that contains both text and numeric data that needs to be cleaned up. The specific issues I'm facing are: - Text Data: There's a need to find and remove any duplicated values, missing values, and correct any formatting issues. - Numeric Data: The numeric data in the dataset has inconsistent decimal places and a few outliers that need to be identified and adjusted. Ideal skills for this project include: - Proficiency in Excel, particularly in data cleaning and data analysis. - Experience in handling both text and numeric data. - Strong attention to detail to identify and rectify issues within the dataset. Please, only apply if you have experience with similar tasks and ca...

I'm seeking a skilled scriptwriter for a drama script intended for a film targeted at adult audiences. The ideal candidate should have experience and proficiency in scriptwriting, particularly in the drama genre. Key Requirements: - Proficiency in scriptwriting for film, particularly in the drama genre - Understanding of adult audience sensibilities - Ability to craft compelling and engaging dialogues - Experience in creating a coherent and gripping plot - Understanding of the pacing and structure of a film script Experience in scriptwriting for films or similar media will be highly beneficial. I'm looking for a professional who can deliver a high-quality, engaging script that captivates and resonates with an adult audience.