Excel vba conditional formatting duplicates jobs
I need to hire a Word expert to format a 55-page Final Rep...appearance. - Resizing photos: The images included in the report need to be made smaller. This should be done by adjusting their sizes using the arrows in Word. - Editing footnotes: The footnotes in the report need to be reviewed for any potential formatting issues. However, there are no specific changes or corrections that need to be made. Ideal candidates for this job should have: - Proficiency in Microsoft Word, specifically in formatting complex documents - Experience in resizing images within Word - Understanding of academic writing and formatting standards (e.g., footnotes) Please note that this project requires attention to detail and the ability to follow specific instructions. A quick turnaround ti...
...children's book cover artwork and I need someone with experience in book cover formatting to convert it for IngramSpark's requirements. The specifics of the task are as follows: - Format size: The overall dimensions of the cover should be 8.5x11 inches. - File format: The final output should be in JPEG format. - Content: No additional text is needed on the book cover apart from the title and author's name. - Color: The color scheme of the cover art is already determined. Your role will be in ensuring the cover meets IngramSpark's specific formatting guidelines, not in changing the color scheme. The ideal freelancer for this project would have previous experience in graphic design, particularly in book cover formatting. Understanding and fami...
...features: - **Input & Output Format**: - The system must take a Word document as input. - The output should be a Word document while preserving all the original formatting. - **Language Support**: - The tool should be able to rewrite the document in both English and Spanish. - **ChatGPT Version**: - I prefer the latest ChatGPT 4 for the rewriting task. Ideal Skills: - Proficiency in ASP.NET Core 8 and Visual Studio 2022. - Extensive experience with ChatGPT 4 and natural language processing. - Ability to handle multilingual content, specifically English and Spanish. - Strong understanding of maintaining document formatting during content rewriting. Please note that the primary goal is to rewrite the content in a formal and professional manner that maintai...
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 workflow. Looking forward to your proposals.
I need a professional to consolidate and transfer formatting and illustrations from two versions of a booklet on Microsoft Publisher 2019 to a Word file with the correct content. Your task will involve: - Ensuring the booklet's formatting is consistent and professional. - The formatting and placement of illustrations and other visual elements are according to instructed guidelines. - Utilizing advanced formatting tools in Word to create headers, footers, page numbers, and styles. - Maintaining and enhancing the booklet's overall aesthetic and educational value. The ideal candidate for this job should have: - Proficiency in Microsoft Publisher 2019 and Word. - Experience in handling booklet materials. - A keen eye for detail and design. - Strong comm...
...Start Time - New Zealand Start Time - Stadium Name - City - Distance from Sidcup, UK (as per the provided Google Maps link) **Instructions:** 1. **Data Entry:** - Gather fixtures from reliable sources such as: - [ECB Official Site]() - [Cricbuzz Schedule]() - Ensure the data is accurate and up-to-date. 2. **Formatting:** - Organize matches by date and start time. - Clearly distinguish between different tournaments and formats. - Use separate sheets for each tournament if necessary, but ensure a master sheet includes all fixtures. 3. **Time Conversion:** - Convert match start times to both UK and New Zealand time zones. 4. **Stadium Information:** - Include the stadium name and city where each
...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 calculations, as well as capability to implement adv...
I have an existing Excel macro that is predominantly used for handling formatting tasks within the Excel file. However, I need an expert who can assess and modify it to ensure compatibility with Excel for Mac 2019 or later. Key Requirements: - The existing macro primarily deals with formatting tasks within the Excel file. - The data in the Excel file is stored in both text and numerical formats. - The main change required is to update the formulas in the macro to ensure it functions smoothly on Excel for Mac 2019 or later. The ideal freelancer for this job would have prior experience with: - Excel macros and VBA - Formatting tasks in Excel - Updating or creating cross-platform Excel macros This ...
I'm looking for an experienced web developer to help me with some quick fixes on my website. Key Issues: - Slow Loading Time: My homepage and product pages are experiencing slow loading time. The website is currently loading in more than...quick fixes on my website. Key Issues: - Slow Loading Time: My homepage and product pages are experiencing slow loading time. The website is currently loading in more than 10 seconds, and I need this to be improved to less than 10 seconds. - Formatting Issues: There are also some formatting issues on the website that need to be corrected. Ideal Skills and Experience: - Proficiency in web development and optimization - Experience in resolving slow loading time issues - Strong understanding of responsive web design and CSS for fi...
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
...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 would be a plus Please note that while the task is to transfer data,...
--- ### 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 each installer. - Automat...
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 as merging cells - Understanding the rules or criteria for merging specificall...
I am looking for an expert who can as...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 macros for cross-platform compatibility...
I need a Pptx document translated from English to Simplified Chinese as soon as possible. The file has 2000 words. Need high quality human translation only. Google/AI or automatic software works are not allowed and will be rejected. Need the translation back in word Pptx format maintaining the formatting and layout of the source file. Price: 30 fixed. Deadline: 24 hours max Don't bid if you don't agree the price and timeframe. Thanks!
...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 apps with live translation capabilities. - Strong background in AI development, specifi...
...REQUIRES YOU TO USE MICROSOFT WORD IN TRACK CHANGES MODE Key Project Requirements: - The project involves converting over 100 citations and references to Chicago style. - The current citations and references are in endnote format, and need to be carefully edited to conform to Chicago style. - In addition to the standard Chicago style rules, familiarity with my school's specific requirements for formatting is essential. Ideal Freelancer: - Experience with academic writing and strong knowledge of the Chicago citation style is crucial. - It would be advantageous to have experience with editing endnotes to in-text citations. - A background in editing for academic institutions or familiarity with specific school style guides would be beneficial. Please ensure you have the...
...while maintaining the content, context, and style of the original material. - Convert PDF documents into editable Word formats, ensuring that the layout and formatting are preserved. - Edit and format Word documents to meet specific client requirements. - Ensure translated documents meet the quality standards and timelines set by clients. **Requirements:** - Must be a native speaker of Spanish with an excellent command of English. - Proven expertise in translation with a strong understanding of linguistic nuances between Spanish and English. - Proficient in converting PDF documents into editable Word formats. - Experience in formatting and editing Word documents with attention to detail. - Ability to work independently and deliver high-quality work under tight deadlines. ...
I have a database containing over 600 serial numbers. Email serial number has an associated email address. Instead of listing the same email address multiple times, I would like a script to place all serial numbers by one email address. This will enable me to email the customer once with ALL of their serial numbers in one email. ...over 600 serial numbers. Email serial number has an associated email address. Instead of listing the same email address multiple times, I would like a script to place all serial numbers by one email address. This will enable me to email the customer once with ALL of their serial numbers in one email. Example: Hannah Walker appears in the database 5 times, the script should remove the four duplicates of Hannah Walker and put all 5 serial numbers by...
...consistency with multilingual support (Swedish, Danish, English). Contact Form: Implement validation, translations, CAPTCHA, and backend management. Multilanguage Support: Set up inputs for Swedish, Danish, and English without auto-translation. Articles and Blogs: Improve layout, image handling, and formatting consistency. Search Function: Enhance search to include titles and body text. Main Picture: Add functionality to change the main picture with size guidelines. Home and About Pages: Ensure consistent formatting and editable content. DNS and Email Setup: Correct domain pointers and enable email functionality on server. Proven experience with Django web development and multilingual websites. Strong knowledge of HTML, CSS, and JavaScript. Familiarity with backend systems...
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.
...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 procedures and functions - Prior experience with similar tasks involving Excel report generation from SQL data - Excellent problem-solving skills and ...
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!
I am in need of a proficient editor and proofreader with excellent formatting skills for my personal documents. - I have a total of 2 documents that require attention. These documents are a mix of Word and PDF formats, and I require them to be meticulously edited, proofread, and professionally formatted. - The primary purpose of these documents is personal, so I'm seeking someone with an understanding of how to maintain a casual yet polished tone. Your expertise in English grammar, spelling, syntax, and an eye for detail is critical for this project. Experience in document formatting (maintaining consistent font types, sizes, and spacing) is also highly desirable. Proficiency in both Word and Adobe Acrobat is a big plus. Your ability to meet deadlines and communicate e...
...formatted according to Amazon's guidelines, with the content posted on this platform. Key requirements: - Writing: Deliver engaging, well-structured articles with a clear focus on informative biographies of historical figures. - Illustrating: Create relevant and eye-catching illustrations that compliment the articles. - Amazon Expertise: Able to post content following Amazon's requirements on formatting and guidelines. Ideal candidate: - Background in history and travel writing. - Experience in creating biographies. - Proficient with illustration software. - Prior experience posting content on Amazon is a huge plus. - High attention to detail and ability to meet deadlines. If you're a writer-illustrator with a passion for history and travel, and you're fa...
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 experience, and can start work promptly.
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.
I'm looking 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 abilities Please include your relevant experience in your applicat...
Ebook and formatting for an already illustrated book
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 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 am seeking a proficient freelancer to convert 1-5 Word documents to Overleaf Latex Journal Format. These d...documents to Overleaf Latex Journal Format. These documents include not only text but also graphics and tables, necessitating an eye for detail and good command of layout techniques. The ideal candidate will have extensive experience in Word-to-LaTeX conversions and dealing with documents that are graphically rich. The successful freelancer would demonstrate a deep understanding of LaTeX syntax and formatting, and the capacity to preserve the structure and aesthetics of the original Word documents in the process of conversion. Efficiency and accuracy will be key attributes for this task. I have 4 documents & Latex template. I want those documents to be converted into ...
...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 any experience with Pivot Tables, Statistical Formulas, or Macros/VBA woul...
I'm seeking a skilled freelancer to help me standardize and improve the formatting of my Google Sheet. The main focus will be on creating consistent cell styles for optimal readability. Specific requirements include: - Implementing a minimalist and clean design theme throughout the sheet - Creating a uniform style for all cells, making sure the data is easy to understand at a glance The ideal candidate will have: - Proficiency in Google Sheets, with a strong understanding of formatting options and best practices - A keen eye for design and the ability to create a clean, minimalist look - Experience with data visualization and turning complex information into easily digestible formats If you're confident in your ability to transform a spreadsheet into a visually...
Hello, I need complet the Amazon categories catalogue excel in french
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 struggling with QuickBooks Snappt, needing help with troubleshooting issues related to printing PDFs. Additionally, I'd like to streamline my paystub downloading process to avoid the need for printing, looking to have them saved directly as PDFs. Key Respo...for a solution that will download paystubs directly as PDFs, without the need for printing. This should enhance efficiency and save time in the long run. Ideal Skills and Experience: - Proficiency in QuickBooks: Experience with QuickBooks, especially Snappt, is fundamental for this project. - Troubleshooting Abilities: A proven track record of resolving technical issues related to printing and formatting PDFs. - Automation Expertise: Skilled in developing software or scripts for automating processes, in this case...
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.
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 am seeking help with APA 7th edition format for an academic paper. This includes in-text citations, reference list formatting, and title page formatting. The specific requirements for this project are: - Formatting in-text citations according to APA 7th edition guidelines. - Ensuring the reference list is accurately formatted and adheres to APA 7th edition standards. - Formatting the title page according to APA 7th edition guidelines. The ideal candidate for this job would have: - Proficiency in APA 7th edition format. - Strong attention to detail. - Experience in academic editing. The paper is VERY SMALL (less than 2000 words).
I need a skilled Excel professional to create a comprehensive spreadsheet for financial tracking. - Data Type: The primary focus will be on financial data, so the spreadsheet must expertly handle these calculations and entries. - Data Organization: The data should be organized by project. This includes clear separation of financial data under different project heads, ensuring a clean and easily navigable interface. - Functionality: I am looking for an Excel expert to incorporate some key features to help make the data easier to understand, like conditional formatting. Ideal Skills: - Proficient in Excel, particularly in managing financial data - Experience in creating user-friendly and logically structured spreadsheets - Understanding of conditional...
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 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
...that the focus is solely on the property by removing any unnecessary elements. - Enhancing colors and lighting: Making the images visually appealing through color adjustments and lighting enhancements. - Image Sharpening: Emphasizing on the sharpness and details of the images. - Lens correction: Correcting any lens-related distortions to ensure the pictures are accurate. - Image Resizing and Formatting: Preparing the edited photos in the appropriate dimensions and resolution for optimal display on Airbnb. - Straightening: Ensuring the images are correctly aligned both horizontally and vertically. - HDR Blending: Merging multiple exposures to create dynamic, high-quality images. - Twilight Conversion: Transforming some of the daylight images into twilight shots for added visual ap...
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.
I am looking for a skilled and experienced professional who can render detailed plans and elevations for my residential construction project. Your task will involve: - Preparing construction drawings that effectively communicate design intent. Your work should be easy to understand and facilitate the building process. - Providing compreh...detailed drawings can be used for accurate cost estimation. Your background in architectural design or civil engineering, coupled with proficiency in CAD software, will be extremely beneficial. Experience in residential construction projects is a must. Please keep in mind the crucial role these drawings play in the project's execution and the importance of accuracy and attention to detail. If you excel at this, you might be the right fit ...
...seeking a proficient data analyst with strong statistical analysis capabilities. Your main responsibilities will be: - Data Cleaning & Preparation: This includes cleansing the data from any incomplete records, duplicates or errors. - Statistical Analysis: You'll need to conduct a thorough statistical analysis of the data, utilizing regression analysis specifically. The project will involve various types of data including numerical, categorical, and textual data. Since we'll be working in a professional environment, knowledge and proficiency in MS Office is a must. This includes Excel, PowerPoint, and Word. Ideal candidates should be well-versed in data analysis and have a strong statistical background. Proficiency in using MS Office is also a key requ...
I'm in need of an Excel macro expert who can help me with a data arrangement task. The task involves transferring sequences of cells data from one grouped workbook to multiple original workbooks and worksheets. The data transfer should be based on specific criteria. Key Requirements: - Data transfer based on a specific criteria: The macro should transfer data based on a specific criteria. This involves arranging the data from the grouped workbook into different cells in a column in the original workbooks based on predefined conditions. - Conditional Logic: The macro should include conditional logic. This means that the data transfer should not just be a simple copy-paste operation, but should involve logical conditions for accurate and efficient data arrangement...
