Excel vba find and replace text in column jobs
I’m in need of an experienced Excel software engineer who specializes in automation. The project revolves around automating data entry tasks in Excel. We are an accounting firm and I am looking to automate my compliance practices. Tasks include 1) rolling forward previous year excel work papers 2) taking information from. Client data sheets (excel) and importing into new excel workpaper workbook 3) data analytics based on metrics 4) hyperlink to source data Ideal candidates should have: - Proven experience with Excel macro programming and automation - Ability to work with numeric and legal data - Strong attention to detail to ensure data accuracy This will be a valuable addition to our w...
I need a Google Sheets expert to help me put together an extensive and detailed cricket schedule for the upcoming English summer season. Tasks Include: - Including International, Domestic, and Club tournaments and teams in the schedule - Organizing fixtures based on the date Additional Details: - Each fixture should have comprehensive information about the venue - Match timings should be included - Broadcast details for each match should be provided Ideal Skills: - Proficiency in Google Sheets - Knowledge of cricket and its various tournaments - Attention to detail to ensure that all necessary information is included - Time management skills to complete the project in a timely manner more details--- ### Task Description: Google Sheets Da...
...need an Excel expert to create a comprehensive spreadsheet to track and calculate project costs, revenues, expenses, and profits. Specific calculations required include sum, average, percentage. The Excel sheet should track the following: - Project cost - Project revenue - Project expenses - Percentage of account receivable - Percentage of account paid - How the client paid after tax - Description for the costs - Percentage of the costs - Percentage of the profit before tax - Percentage of account receivable before tax - Date of payment The data presentation in the spreadsheet should be in the form of tables and graphs. Experience with financial data analysis and management is vital. Understanding of cost and profit cal...
...looking for a skilled developer who can replace the native camera of my Android smartphone with an RTMP camera app . The primary use of the RTMP camera will be for live streaming from Obs Studio virtual camera to the RTMP camera. The RTMP camera will be the main camera of the smartphone. Skills and Experience: - Experience with Android development and camera APIs - Knowledge of RTMP streaming protocols and video encoding - Familiarity with OBS Studio virtual camera or ManyCam - Ability to integrate and configure the chosen RTMP server with the smartphone camera - Understanding of video recording and streaming best practices Deliverables: - Replacement of the native camera with the RTMP camera on the Android smartphone - Smooth integrati...
We are looking for freelancer for technological catalogues redesign and build in adobe indesign. Freelancer should be expert in adobe indesign, photoshop, ilustrator. We provide example project templates in adobe indesign, source data in pdf and excel. Based on source data our catalogue should be created and redesigned as template project. Project should be done in adobe indesign for printing and web
I have a PDF file with over 50 pages of data in mixed formats - text, numbers, and tables. The task is to accurately transfer this data into an Excel spreadsheet in a tabular format. Key requirements: - Data entry from a PDF file into an Excel spreadsheet - The data is of moderate complexity, so a good understanding of Excel is needed - The output should be a well-organized and clean Excel spreadsheet Ideal skills for this job: - Proficiency in data entry and working with large data sets - Advanced Excel skills, including the ability to work with mixed data formats - Attention to detail and accuracy to ensure the data is correctly captured - Experience with PDF to Excel data conversions wou...
--- ### Job Title: Excel Sheet Creation for Job Tracking and Payment Calculation **Description:** I need a custom Excel sheet to help me track jobs completed by my installers, including details about each job, such as dates, customer information, and payments. The sheet should be able to automatically calculate the total number of jobs done and the total payment owed to each installer. **Requirements:** 1. **Job Tracking:** - Columns for the date each job was completed. - Columns for the job details including customer address and account number. - Columns for the installer assigned to the job. 2. **Payment Calculation:** - Ability to input the payment rate per job. - Automatic calculation of the total number of jobs completed by ...
Just a quick bit of help needed in excel macro writing. See attached before and after showing a piece of the original data. and what i neeed the macro to achieve. WHAT IM ASKING If two adjacent cells in column b are equal, then add cells adjacent column c cells, put the result in the first column c cell and remove the duplicate row. AEE ATTACHED png. I need a tailored solution for a data manipulation task within Excel. Specifically, I am looking for an Excel macro that can accurately merge cells based on their adjacency. Essential skills and experience should include: - Expert knowledge of Excel and its macro functionality - Prior experience with data manipulation tasks such a...
I am looking for an ex...looking for an expert who can assess and modify an existing Excel macro for compatibility with Excel for Mac 2019 or later. The current macro mainly handles formatting tasks within the Excel file. Key Requirements: - Assess the current macro's compatibility with macOS - Modify the macro to ensure compatibility with Excel for Mac 2019 or later I don't have a strict deadline for this project, so you can work on it at your own pace. However, I am looking for someone who can get this done efficiently and effectively. Feel free to ask any questions for more information. Ideal Skills and Experience: - Proficient in Excel VBA and macros. - Extensive experience in adapting macr...
I find myself in need of a highly skilled individual capable of assisting with numerous projects across a variety of areas. Given the breadth of tasks, a versatile set of skills is vital. Specifics haven't been decided yet, but your experience may help mould these into reality. Key skills and experiences: - Website development - Mobile app development - Graphic design Tasks may include, but are not limited to: - Designing user interfaces - Developing backend functionality - Implementing payment gateways While I don't have a concrete vision for design, flexibility and a keen eye for aesthetics are beneficial. Whether it's a minimalistic, bold and colorful, or clean and professional look, the ability to adapt to different styl...
I'm in need of a skilled professional to help me create a data mining script. The task involves mining emails, data from a certain website and delivering the data in a raw text file format. Key Requirements: - Develop a data miner script that can effectively scrape email data from websites. - Ensure the script can handle multiple sources and is scalable for future needs. - Deliver the mined data in a raw text file format. Ideal Skills: - Proficiency in web scraping and data mining techniques. - Experience with developing scripts for text data mining. - Strong knowledge of scripting languages suitable for scraping like Python/BeautifulSoup, R, etc. Please provide samples of your previous similar projects or port...
...for a data sourcing and CRM expert to help me build a targeted lead list for prospecting. The ideal candidate will have experience in: • Identifying relevant data sources for lead generation based on an Ideal Customer Profile (ICP). • Sourcing high-quality contact information (emails, phone numbers) for 100-200 potential customers. • Data cleansing and validation to ensure accuracy. • Uploading the cleaned data into HubSpot CRM. Project Goals The goal of this project is to establish a foundation for targeted email marketing campaigns. This will be achieved by: • Creating a targeted lead list based on my ICP. • Uploading the lead list into HubSpot for easy campaign management. Your Responsibilities • Collaborate with me to define my...
...capabilities and includes an AI assistant with a focus on language understanding and real-time conversation support. Key Features: - Cross-Platform: The app should be developed for both iOS and Android, ensuring a wide user base. - Page Translation: Users should be able to translate live any page on their phone. - AI Assistant: The AI assistant should have the ability to provide information on various topics and should excel in language understanding, helping users with translation in real-time conversations with others. - Live Translation: The app should provide a smooth live translation experience for conversations. Ideal Skills: - Proficiency in React Native for cross-platform development. - Experience in building ap...
I am in need of a freelancer who can accurately convert my PDF files into Excel. The materials consist mainly of printed, electronically generated text. Given the nature of the work, the ideal candidate should: - Be proficient in both PDF and Excel formats - Have an eye for detail to ensure accuracy - Have experience dealing with extensive text documents - Possess strong typing and data entry skills Please bid if you fully understand the tasks and feel capable to deliver high-quality results. Your attention to detail and commitment to accurately completing tasks would make you an ideal candidate for this project.
I'm in need of an experienced C# desktop programmer who is well-versed in SQL Server 2019. The primary task is to ensure that new columns added to the database are correctly displayed in the Excel report generated by the application also fix some minor areas that will discuss in detail Key Responsibilities: - Troubleshoot and fix the issue of new columns not being displayed in the Excel report - Ensure that all relevant data is correctly fetched from the SQL Server 2019 database - Implement a seamless solution that does not affect the overall functionality of the application Ideal Skills and Experience: - Strong proficiency in C# programming language - Expert knowledge of SQL Server 2019, including stored procedur...
I'm in need of an individual from Vietnam who can assist with translating a personal letter from English to Vietnamese within a week. Following the translation, the task involves sending the letter to a Vietnam address via standard postal service. Key Tasks: - Translation: The personal letter is to be accurately translated from English to Vietnamese. The translation should maintain the tone and intent of the original text. - Mailing: Upon completion of the translation, the translated letter should be sent to a specified Vietnam address using standard postal service. Ideal Candidate: - Native Vietnamese speaker/ - I DO NOT KNOW THE ADDRESS OF THE PERSON WHO I WANT TO SEND THE LETTER. THE PERSON WHOM THE LETTER IS ADDRESSED IS A POPULAR PERSONALITY IN VIET...
My project involves removing a person from a photo and substitivng that figure with more of the fountain that is in the background of the same image. Here are key details: -The photo is in HEIC format. -The person should be entirely replaced in the image, not just removed. -Replace the person with a continuation of the fountain already present in the picture's background. The ideal freelancer for this project would be proficient in photo manipulation and editing, with specific experience in manipulating HEIC file formats. A strong sense of aesthetics and detail is crucial to ensure that the inserted fountain looks as natural as possible in the final product. First photo is the one I would like to be edite...
For my project, I'm looking for a highly detail-oriented professional with brilliant Excel skills. Key responsibilities include: - Managing and transferring both numerical and textual data in an Excel spreadsheet, ensuring the correct placement into columns marked by letters (A, B, C, etc). - You'll not be required to order the data in any specific way, just transfer into the appropriate columns. Skills & Experience: - Proven record in data entry tasks - Strong Excel skills - Ability to understand and interpret numerical and textual data Looking forward to your bids and kicking into this project soon!
v2 - user can find merchant and register in their user account. after admin approve, Merchant can create shop and promotion. User will get 0.1% of their total sales, check v3. - shop field (brand name, address, website, whtasapp, facebook, description, category, City, how many brands, open for agency?(radio button)) - promotion field (title, normal price, now selling price, description, expire date, point weight - V4 user can follow shop to see their promotion in feed, also can apply to be their agent. - agent can share the promotion with uniqic referral link which will earn 2% v3 - point system- user purpose any thing will get point same as the price, usd 23.12, will get 23.12 points. if point weight is 2, then he will get 46.24 point. - when userB pur...
I'm in need of an experienced data entry specialist who can assist in uploading 850 products onto my online store. You will be provided with the necessary product information (description, price, specifications) in the format of Excel/CSV files. Your tasks will include: - Accurate data input of all relevant product details - Verification and correction of any existing data entries - Ensuring all listings are in sync with their corresponding inventory Ideal Skills: - Experience in data entry, particularly e-commerce product listing is preferred - Proficiency in Excel - Attention to detail and accuracy are extremely essential - Fast typing speed with a keen eye for details. Please only bid if you have relevant ex...
I'm looking for a professional who can assist me with the typing of my novel manuscript. Your responsibilities will include: - Accurately typing out my novel - Formatting the typed content into an e-book format The ideal freelancer for this job would be experienced in: - Typing - MS Word - Excel calculations - E-book formatting Having an RS-CIT certificate would be a major plus. The ability to pay close attention to detail and produce error-free work is paramount. Experience in typing and formatting novel manuscripts is highly preferred. Finally, quick turnaround time is necessary for the successful completion of this project.
...SaaS app that will transform AI-generated text into undetectable AI text. The app should include three modules: AI Humanizer, AI Detector, and AI Generator. AI Humanizer: This module will convert AI-generated text to undetectable AI text that can bypass AI detectors like Originality AI, Undetectable AI, GPTZero, ZeroGPT, and Turnitin. It would also ensure that the transformed text maintains the original meaning and context while appearing human-written. AI Detector: This module will detect if the text given by the user is AI generated or not. AI Generator: This module will be used by user to produce high-quality, undetectable AI-generated content, such as essays and articles. Please bid only if you have extensive...
I'm looking for ...for an experienced freelancer who can create an Excel calculator for historical cryptocurrency prices from Binance and Luno. The calculator should also include fiat exchange rates for major currencies such as ZAR/USD bank sell rates Key Requirements: - Retrieve historical price data from Binance and Luno - Incorporate USD, and ZAR exchange rates - Organize the data and create user-friendly interface - Ensure accuracy and reliability of the calculator - Prioritizing the preservation of data privacy Ideal Skills: - Proficiency in Excel and data manipulation - Familiarity with cryptocurrency exchange APIs - Knowledge of major fiat currency exchange rates - Strong analytical and problem-solving abil...
...proficient English expert who specializes in reviewing academic texts, particularly within the scope of Science and Engineering. My aim is to ensure that my work is free of errors, easy to understand and meets the highest academic standards. Key Responsibilities: - Review and correct my English writing - Enhance clarity and improve sentence structure Ideal Skills: - Strong command of English language - Excellent grammar, punctuation, spelling, and vocabulary knowledge - Experience in academic writing, particularly in the field of Science and Engineering is a must - Proficiency in technical language related to Science and Engineering is desirable Please include examples of your previous work in academ...
...increase enrollment and, while doing so, provide some information on the specific attributes of each of our five branches. The successful freelancer should ideally have: - Proven expertise in creating compelling live-action video content suitable for social media - Excellent storytelling skills and the ability to differentiate between the general and specific content provided for each branch - A high degree of adaptability to utilize the provided assets and similar video samples The video should be approximately 8 to 9 frames long; assets, including sample videos, will be provided to aid your creativity. Please note the goal is not to simply recreate the sample videos. You will need to flex your creative muscles to ensure our video campaign stands ...
...skilled Wordpress professional to update and arrange my blog posts on my Elementor site. The updates include text editing, adding and replacing images, and adjusting the layout. Key Tasks: - Update 4 blog posts: The main task is to rewrite some of the content and add or replace images where necessary. This update should be done meticulously to maintain the quality and consistency of the posts. - Arrange 3 PDFs for publishing: You would need to work on 3 PDF files which include images. Your task will be to convert them for web use and publish them on the site. - Elementor and Wordpress proficiency: You must have a good understanding of Elementor and Wordpress to carry out the necessary updates and arrangement...
I'm in need of a skilled developer with strong experience in NodeJS, React, and Next/NestJS. The project I have in mind is a custom web application that will require: - Search Functionality: The application will have a search feature that allows users to find specific content or items efficiently. This will require robust search algorithms and user-friendly interfaces. - Payment Gateway Integration: The application needs to support payment processing. You'll need to integrate a payment gateway to handle transactions securely and seamlessly. Your experience in SQL will also be valuable to ensure efficient data management and integration with the web application. Please provide examples of your past work that demons...
I would like to see the result statistic in %. Important, when i refresh the excel i always want to see the last 5, last 10 and last 15 results.
I'm seeking a professional to curate and stitch together a 3-minute video tailored to inspire and uplift. The video serves as a personal vision, intended for my eyes only. (No commercial licenses for stock photos needed). Key requirements include: - Utilization of both stock and available video clips that you source/find. - *** I will provide a detailed list of the types of clips that should be included in the video. *** - Tone: The video should exude an inspirational vibe throughout the entire duration. It should speak to the soul, lifting spirits and encouraging reflection, HOPE, PEACE, JOY. - Color Scheme: The color palette for this video should be bright and vibrant. This choice is intentional, meant to further enhance the upli...
I have an excel file, need add product categorie on a column - budget 100€
I need a talented typist to help with a large-scale project. The task at hand involves typing numerous reports. These reports are not overly complex and do not require any advanced formatting or design work. Instead, basic formatting is all that is needed to give them a professional look. Key requirements: - Large volume of typing work - Typing and basic formatting of reports Ideal skills and experience include: - Proficiency in typing and formatting - Capability to handle a high volume of work - Attention to detail for accuracy - Experience with report typing is a plus
I'm seeking a de...developer to help me redesign the online text assignment plugin for Moodle. I'm looking to make the user interface more user-friendly and intuitive. This plugin should be rather simple as it is simply a redesign using elements that are already existing within Moodle pages by default Key responsibilities: - Redesign Moodle's online text submission type to improve user interface - Ensure the plugin is compatible with the latest version of Moodle Your qualifications should include: - Proficient in PHP, HTML, CSS, and JavaScript - Experience working on Moodle plugins - Strong understanding of user experience (UX) design The ideal candidate will be able to deliver a high-quality, user-friendly plugin that enhances the te...
...I am seeking in-depth legal research covering the United States jurisdiction, with a particular focus on unfair business practices. I require expert investigation into the topic of discrimination by placing reserves on merchant accounts. Key Responsibilities: - Comprehensive analysis of the related laws and regulations in the U.S - Detailed report explaining the implications and potential consequences of these practices Ideal Candidate: - Expertise in U.S business law - Proven background in legal research, preferably with a focus on unfair business practices - Ability to understand complex legal issues and explain clearly in layman's terms This project is more than just a research task. It's a chance to create genuine ...
Edit different Text from PDF with same format and font.
...assist with cleaning and analyzing a small dataset in Microsoft Excel. Key Responsibilities: - Data Cleaning: The dataset includes multiple columns and rows that need to be checked for inconsistencies, errors, and duplicates. - Data Analysis: After cleaning, I need the freelancer to perform basic data analysis to extract meaningful insights from the dataset. Ideal Skills: - Proficiency in Microsoft Excel and experience with data cleaning and analysis. - Attention to detail to ensure the dataset is thoroughly cleaned. - Basic data analysis skills to interpret the dataset and present the findings in a clear manner. Please note that the project does not require any specific tools or methods for analysis, but ...
Hello, I need complet the Amazon categories catalogue excel in french
I'm in need of a skilled programmer to create an automation code page for me. This code page will be focused on text processing, so a strong understanding of working with textual data is essential. Key Requirements: - Proficient in JavaScript: The automation code should be written in JavaScript to ensure compatibility with other platforms. - Automation Experience: The primary function of this code will be automating tasks. A proven track record in building automated processes is highly desirable. - Text Processing: The code must be able to accurately and efficiently process textual data. Experience in this field will be a huge advantage. If you have experience in JavaScript, a background in automation, and...
I'm in need of a freelancer with a high level of proficiency in Microsoft Excel to use conditional formatting over different tabs to help visualize duplications in large sets of numerical data. Ideally, you should not only be skilled in Excel, but also possess a keen eye for patterns and detail. Your job will encompass: - Applying conditional formatting across multiple tabs. - Highlighting duplications in numerical data. - Ensuring easy readability and understanding of the data presented. An understanding of data visualisation techniques would give you a competitive edge for this project. This task will require a close attention to detail and a strong understanding of Excel's conditional formatting tools.
I'm looking for a small change on the attached advertising banner ae. I need someone to simply update the text from "2015" to "2024".
I have a small dataset of less than 1,000 rows that requires both data cleaning and formatting. Additionally, I need assistance with data analysis and visualization. This is a one-time project, and I am looking for a skilled individual to handle this for me. Ideal Skills and Experience for this project: - Proficiency in Excel is a must. - Experience with data cleaning and formatting. - Ability to perform data analysis and create visualizations. - Attention to detail and an eye for accuracy.
...should incorporate both text and symbolic elements. The specifications are as follows: 1. Logo Type: - I require a combination of text and symbols, which should strike a perfect balance and are easy to comprehend. 2. Key Elements: - Please note, no specific elements are mentioned for the symbol part. I value your creative input in this regard. 3. Color Scheme: - The logo should radiate energy, hence vibrant and colorful scheme is mandatory. Your choice of colors should be harmonious and make the logo pop. Ideal candidates would have extensive experience in logo design, with a portfolio showcasing a diverse range of styles, especially vibrant color palettes. Creativity and expertise in symbolic int...
I have an Excel file with a macro that I need to be updated for compatibility with Excel for Mac 2019 or later. The current macro's compatibility with macOS is unknown to me, and I need an expert to assess and modify the code as needed. Key Requirements: - Update the existing macro for compatibility with Excel for Mac 2019 or later. - Ensure the modified macro functions correctly on a MacBook Pro 2018 intel OS Ventura. Ideal Skills and Experience: - Proficient in Excel VBA and macros. - Extensive experience in adapting macros for cross-platform compatibility. - Knowledge of macOS compatibility issues with Excel macros.
I want to make a Incentive structure in the attached excel. I am paying incentive to my staff. I have different types of incentive policy Each Incentive calculation is starting from the month "m" It will be accumulated and the Incentives will be paid on every month of "n" The process will start again and will repeat again. This process will depend upon the value that I am putting in the cells of "m" and "n". You have to correct the formula I have given in the sample or you can make a new formula
I'm looking for an experienced NodeJS and JavaScript programmer to help me with a school project focused on exploring cybersecurity concepts. Key Requirements: - The task involves writing a client request to obtain a flag from a vulnerability site with advanced complexity (e.g., bypassing security measures). - The project involves emphasizing on Remote Code Execution (RCE) and pollution while interacting with the vulnerability site, so experience in these areas is a plus. --- Challenge Name: Emu Apothecary Category: Vulnerabilities Description has just opened up their potion brewing website for other Emus to create new potion recipes! However, they are afraid that one of the human hackers will pollute their ingredients. Can you get Remote Code Execution (...
I am seeking an experienced SEO specialist to boost the online visibility of my brand within local search results. Here are my key requirements for this project: - Optimize my website specifically for my brand-related keywords, to ensure that our local customers find us easily when they look for our brand online. - The main goal is to get the visitors to contact us for more information about our offerings, once they land on our website from the search engines. Experience with local SEO, especially for brand-specific campaigns, will be highly regarded.
I have a small project that requires the entry of structured text data. The project will involve: Ideal candidate would have a strong attention to detail, excellent organizational skills, and a background in data entry. Experience with structured data formats is a plus. This should be a fairly quick task, but accuracy is key. I will share you more details in via chat box. Thanks
...logo and letter pad designs to create an innovative, custom design. Key Requirements: • Create a text-based logo with symbol elements. The design should be distinctive and contemporary. • Use a color scheme of blue and gold. Specifically, the design should feature blue letters with some elements in blue, while others should be in gold. My preference is for a vibrant, rich tone that ensures the design remains prominent and visually appealing. • Follow the examples provided in the attachments for the symbol elements to be incorporated into the design. The symbol chosen should reflect our brand and communicate our identity effectively. Ideal Skills: • Graphic Design • Brand Identity & Strategy...
I'm looking for a skilled developer to assist with syncing an Excel file to my phpMyAdmin database. Key Requirements: - Real-Time Syncing: The sync should take place continuously in real-time. Any updates made to the Excel file should be reflected in my phpMyAdmin database instantly. Skills and Experience: - Proficient in Excel and phpMyAdmin - Experience in data syncing and database management - Familiarity with real-time data syncing No specific data validation or transformation is needed during the import process. The goal is to ensure that any changes made in the Excel file are accurately reflected in the existing database.
We have diagrams for the cars. We want someone who can create a database of where we can find the analog fuel sensor wire under the dashboard. Project is for 1000 cars and can be long term.
