Vb6 conditional formatting exceldela

I'm currently facing some issues with my Excel tracker. - The tracker contains a VBA macro file which seems to be causing formula errors and formatting issues. I'm unsure of the exact nature of these errors, but it's clear they are impacting the accuracy and usability of the tracker. I need a freelancer who can review and rectify these issues in the tracker. An ideal candidate would have strong experience with VBA and Excel, able to handle complex formulas and troubleshoot formatting problems swiftly. Your goal is to ensure that the tracker is fully functional and error-free. Experience with similar projects will be a plus.

As an individual currently managing a project with numerous details and a profit loss statement, I need assistance with daily tasks for our Excel sheets. This will include: - Data entry and organization to streamline workflow - Basic arithmetic calculations for accuracy - Statistical analysis to make informed decisions - Formatting and visual presentation for clarity This role requires proficiency in Excel, a keen eye for details, and strong analytical skills. Experience in financial or project management is a plus. The job will be ongoing and requires daily attention. If your expertise aligns with these needs, please apply.

I have a set of handwritten documents that need to be typed up. The handwriting is moderately legible, so attention to detail is important to ensure accuracy in the transcription. The final document should have a basic formatting, such as paragraphs and bullets. Ideal Skills and Experience: - Fast and accurate copy typing skills - Attention to detail - Ability to decipher moderately legible handwriting - Basic formatting knowledge to organize text into paragraphs and bullets

...startup and along with the subscription models. Key Requirements: - The website is currently based upon an existing template but needs additional work with a clear and user-friendly layout, ensuring that the target audience can easily find the information they need. - Creation of an additional 5-6 pages (all content supplied) - Clean up of existing 6 pages - Restructure of pricing plans and formatting of pricing options - Implement a contact form for potential clients or partners to get in touch easily. - Integrate a subscription sign-up feature to allow interested visitors to receive newsletters or updates. Ideal Skills and Experience: - Proven experience in designing informational websites - Understanding of user experience and user interface design - Proficiency in imple...

I need an Excel VBA code that can perform exact word matching within an Excel spreadsheet. - The code should generate a list of matched words.

I'm looking for an expert in Excel to assist with a project involving data entry and analysis. The Excel sheet you'll be working on has more than 50 columns and rows and will contain a mix of text, numbers, and dates. You'll be responsible for the following: - Accurate and timely entry of the data provided - Ensuring the data is appropriately formatted and organized - Conducting thorough data analysis, including but not limited to trends, comparisons, and any other insights that can be drawn from the data The ideal candidate for this project should have: - Proficiency in Excel and experience with large data sets - Strong attention to detail - Ability to perform data analysis and present insights - Good communication skills to provide regular updates a...

I'm on the lookout for a talented virtual assistant who thrives on lengthy hours of work and enjoys every second of it! This isn't your usual VA role, though - I'm seeking someone who can confidently handle the following responsibilities: - Social Media Management: More specifically, I need someone adept at Instagram. You'll be responsible for handling and managin...our audience. Ideal Skills and Experience: - Clear understanding of the Instagram platform and how to optimally engage audience in it - Skills in crafting Instagram worthy content - visuals, captions, and stories - Experience in managing professional instagram account is a plus - Must be organized, communicative, and able to handle long hours of work If this sounds like the sort of work you'd exc...

For this project, I require an expert who can efficiently extract text content from two distinct webpages and input my data into an Excel file organized by rows. Given that all types of data hold equal importance to me, of essence is for the professional to: - Accurately scrape all text content from the specified webpages - Ensure no data is skewed or omitted during this process - Neatly organize the data by rows in the Excel file The ideal candidate for this job should be proficient in web scraping tools and techniques, possesses an acute attention to detail, and is experienced in using Excel to ensure data is properly formatted and easy to analyze. Please note that minimizing errors during this process is critical, as the data collected will directly influence fur...

I'm in need of a skilled data entry specialist for multiple resume postings on LinkedIn, Indeed, and CareerBuilder. This will involve inputting detailed work experience, educational background, and s...inputting detailed work experience, educational background, and skills on the respective platforms. Key Requirements: - Posting on LinkedIn, Indeed, and CareerBuilder - Comprehensive resume data input - Knowledge of job responsibilities and achievements The ideal freelancer should have: - Proficient data entry skills - Familiarity with LinkedIn, Indeed, and CareerBuilder - Understanding of resume formatting and content - Ability to articulate job responsibilities and achievements Your work will directly impact my job search success, so attention to detail and a quality output...

...(tariff payment and number of contacts). You need to make sure that these fields are also displayed in the mobile version of the site and add statement generation for these fields. * Set up the generation of a report (pdf file, form will be provided), which displays information about which users did not pay the bills of the previous month * On the 1st day of each month, files must be generated in Excel and XML-Format with the bank data entered by the contractor during registration and the amount to be paid from the account. One file for all users (form will be provided). * Fix the code when sending an E-Mail to the user at the time of invoice generation. Now email is sent many times in a row per day, it should be 1 time * Add one more page to the artist registration form, whe...

...tenure, salary and location of our employees. Your ability to structure and organize these aspects will be key. - Creating an Excel-based system: I'm looking for a dashboard that's easy to dissect and understand. As such, I'd like the final product to be in Excel spreadsheet format. This means you should be very proficient in Excel, knowing how to integrate formulas, tables and other relevant features. - Monthly updates: The dashboard should be designed to be updated monthly. You should be dedicated to ensuring that the data is up-to-date and accurately represented. Ideal freelancer should have: - Proven experience in HR analytics and dashboards - Excellent Excel skills - Ability to present complex data in a clear and concise manner - Strong...

I have an excel sheet with intermediate complexity data, including formulas and charts. I need someone to transfer this data into tables, with the primary goal of organizing the information for better clarity and ease of understanding. Key Tasks: - Type the data into tables: This needs to be done with meticulous attention to detail to ensure accuracy and integrity of the data. - Apply borders and shading: To enhance the visibility of the tables and make them aesthetically pleasing. - Utilize headers: Rows and columns should have appropriate headers to aid in quick data navigation. Ideal Freelancer: - Proficient in Excel: Ability to work with intermediate level of data such as formulas and charts. - Strong attention to detail: Critical for ensuring that data is entered accur...

I need a word document translated from English to Russian as soon as possible. The file has 800 words. Need high quality human translation only. Google/AI or automatic software works are not allowed and will be rejected. Need the translation back in word document format maintaining the formatting and layout of the source file. I would also need an excel sheet prepared, with source texts in column A and translation column B. Need this to be done within 5-6 hours of awarding the project. Bid only if you are available to do it now. Price: 12 CAD fixed. Deadline: 5-6 hours max Don't bid if you don't agree the price and timeframe. Thanks!

I have a set of scanned Hindi documents that need to be transcribed into Microsoft Word for further processing. Key Requirements: - Digitalization: The main purpose of this task is to convert the scanned copies into a digital format. - Basic Formatting: The text should be typed with basic formatting (e.g. bold, italic, etc.) but does not need to exactly match the scanned copies. Ideal Freelancer: - Proficient in Hindi: The freelancer should have a strong command of the Hindi language to accurately transcribe the content. - Experienced in Data Entry: This project requires good data entry skills to ensure accurate and efficient transcription. - Proficient in Microsoft Word: Prior experience with transcribing documents in Microsoft Word is preferred. 3 books in Hindi scanned...

I am in need of a powerpoint presentation with a primary focus on persuasion that's c...Proficient in creating persuasive content specifically tailored to government officials - Excellent technical communication skills In this project, you will take charge of the whole process from content creation to design of the presentation, ensuring seamless integration between the message and the visual elements. Your task would include: - Engineering content creation - Slide design and formatting - Use of persuasive elements - Presenting complex information in a simplified manner By creating a presentation that captivates while effectively communicating the message, we aim to influence government officials towards our engineering project. I encourage anyone with the right skill...

...looking for an Excel expert who can create a comprehensive sales target tracking spreadsheet for my customers. This spreadsheet should have several key functionalities. Features Needed: - Customer Information: It should contain a section where I can input and maintain all my customer's details. - Sales Tracking: The spreadsheet should enable me to track my sales targets daily and provide a detailed analysis of my performance. - Target Achievement: The spreadsheet should also be able to analyze the achievement or shortfall of selected items target completion by each customer. Analysis Required: - I would love to have a feature that shows how well sales targets are being achieved as per defined targets. Ideal candidate should have great attention to detail, proficiency...

I need an organized mind to help with research and data entry of a list of companies in a specific industry. Your main responsibility will be organizing this data. While basic Excel skills are a must, experience with data organization, particularly in a business context, would be highly beneficial. The data will be divided into 4 separate categories, so whoever takes on this task needs to have a keen attention to detail and an understanding of categorization. This project is perfect for an individual who thrives in organizing and systematizing data.

**Tour Costing Sheet Structure** 1. **Tour Details** - Tour Name - Tour Code - Duration - Destinations 2. **Client Information** - Client Name - Number of Adults/Children - Contact Information 3. **Accommodation** - Hotel Name - Room Type - Meal Plan - Cost per Night - Total Nights - Total Cost 4. **Transportation** - Vehicle Type - Distance - Cost per Kilometer - Total Cost 5. **Sightseeing and Activities** - Activity Name - Per Person Cost - Number of Persons - Total Cost 6. **Miscellaneous Expenses** - Guide Fees - Entrance Fees - Other Expenses 7. **Pricing** - Subtotal (Sum of all costs) - Markup Percentage - GST (Goods and Services Tax) - Final Price 8. **Payment Details** - Deposit Require...

I need an experienced professional to assist me in editing, formatting, and reducing the word count of a document. Key requirements: - This is a document, not a presentation or web content; hence, the ideal candidate should have proven experience in editing large textual documents. - The primary goal here is to meet a publication limit. This requires the editor to be skilled in maintaining the essence of the content while reducing the word count significantly. - The document needs to be formatted according to APA style guidelines. Therefore, the ideal candidate should be familiar with and proficient in this formatting style. This project will require a combination of excellent editing skills, an understanding of publication requirements, and adherence to APA style guideline...

I am currently working on a project that requires the integration of Excel with a PostgreSQL database. As such, I am in need of a freelancer who is proficient in both Excel and PostgreSQL. The primary tasks to accomplish include: 1. Exporting data from Excel to SQL 2. Updating PostgreSQL data using Excel You will be working with various kinds of data as we aim to streamline our operations in a more efficient manner. Ideal skills and experience include: - Solid understanding of PostgreSQL - Expert skills in Excel - Previous experience with SQL data exporting and updating The success of this project highly relies on a flawless data transfer between Excel and PostgreSQL. Your expertise will be extremely valuable to our project's completi...

I'm in need of an expert to assist with the cleanup of our Medicine database. The goal of this project is to accurately remove all duplicate entries improving the overall accuracy of the data. Ideal Skills & Experience: - Strong background in Database / Excel /CSV management, specifically in the medical field. - Proven track record of similar past work. In your application, please include details of similar projects you've worked on. Efficiency and precision are pivotal for this task. Looking forward to a neat and streamlined database!

I have a channel where I make EXCEL educational videos, I upload 12 videos a month, between 5 to 7 minutes each. YOU MUST BE ABLE TO : - Have experience in editing videos for YouTube. - Have basic knowledge of Microsoft Office, to be able to edit the videos better. - Be able to edit 10- 12 videos consistently every week (Some will be only 1 minute long). IF YOU WANT TO STAND OUT FROM THE REST SEND US YOUR PORTFOLIO

...modification. I have an image that requires a full transformation of its current text. Key specifications include: - Changing text completely, replacing current words with those suitable for a business advertising context. - Adjusting the image's brightness, cropping, and removing the background to enhance its visual appeal. - Text to be replaced is name and title, it should use the same style and formatting as found for the name and title on this page: - background colors should remain as on the existing webp file It's crucial that you have experience in professional graphics editing and are able to deliver high-quality work in a timely fashion. A good eye for details and understanding of effective business messaging will be advantageous.

I need a word document translated from English to Russian as soon as possible. The file has 800 words. Need high quality human translation only. Google/AI or automatic software works are not allowed and will be rejected. Need the translation back in word document format maintaining the formatting and layout of the source file. I would also need an excel sheet prepared, with source texts in column A and translation column B. Need this to be done within 5-6 hours of awarding the project. Bid only if you are available to do it now. Price: 12 CAD fixed. Deadline: 5-6 hours max Don't bid if you don't agree the price and timeframe. Thanks!

I need a word document translated from English to Simplified Chinese as soon as possible. The file has 800 words. Need high quality human translation only. Google/AI or automatic software works are not allowed and will be rejected. Need the translation back in word document format maintaining the formatting and layout of the source file. I would also need an excel sheet prepared, with source texts in column A and translation column B. Need this to be done within 5-6 hours of awarding the project. Bid only if you are available to do it now. Price: 12 CAD fixed. Deadline: 5-6 hours max Don't bid if you don't agree the price and timeframe. Thanks!

...Length: 240 pages Key Requirements: 1. Incorporate a specific village photograph (attached) that I wish to use as a key element on the cover. This photo must be featured prominently in the cover design. 2. Use the attached photograph of the rancher as inspiration for the back cover design. 2. Create a cover that fittingly embodies the genre of a personal memoir. 3. Deliver a design that meets the formatting specifications for Kindle and Amazon Print. 4. Incorporate back cover text (synopsis and Author info) that I will provide. Ideal Freelancer: The perfect candidate for this job has experience in book cover design, particularly for memoirs. Additionally, proficiency in working with provided photographs and transforming them into compelling covers is crucial. Strong communica...

I am in need of a specialist to optimize my Amazon product listings for coloring books. The key focus will be enhancing visibility and maximizing customer engagement for my book collection. Here's what I am looking for in a freelancer: - I need you to know more about KDP marketing than I do. I only know the basics. I need an advanced skilled...listing. - Suggesting effective marketing strategies tailored to coloring books. - Execute strategies once approved. - Expertise in Amazon's A9 algorithm to optimize listings. Through these efforts, the ultimate goal is to increase the visibility of my coloring books on Amazon, targeting a better ranking in search results, and thereby improving sales. If you have the skills and experience to excel in this role, I would be thrill...

I'm in need of an expert in Adobe Acrobat Pro and JavaScript to design a dynamic PDF form incorporating conditional logic. This form should allow drop-down answers to influence subsequent fields. Key aspects of this project include: - Developing a dynamic, interactive PDF form - Utilising JavaScript for the implementation of conditional logic based on drop-down answers - Creating an interactive user interface for an optimal user experience The ideal freelancer for this job is someone who has proven expertise in JavaScript and Adobe Acrobat Pro, with considerable experience in creating complex, dynamic PDF forms. Knowledge of user interface design will also be beneficial in ensuring the form is user-friendly and interactive.

As a professional with high-volume data, I'm seeking a highly skilled Excel expert. You should have proficiency in: - Data analysis - Data visualization - Excel formulas, functions and macros - Visual Basics Application (VBA) I'm dealing with more than seven datasets, each one having high complexity (many columns and over 5000 rows). I will need your expertise in managing and understanding this data. Ability to quickly comprehend and adjust to new data structures would be advantageous. Proven experience with large data sets and advanced Excel usage is a must for this project. Please include examples of previous similar work in your proposal.

I'm in need of an Excel formula expert to help me with a specific task. I need a formula that will COUNT cells based on the following criteria: - I need to COUNT the number of cells in a range that are greater than -250 - The count should be done for the last 50 cells (ongoing) Your task will be to help me create a formula that dynamically counts the number of cells based on the above criteria. I need this formula to be able to adjust as new values are added to the range. The ideal Freelancer for this project should have: - Extensive experience with Excel functions and formulas - Strong understanding of dynamic range referencing in Excel - Excellent communication skills to explain the logic behind the formula in layman's terms Please include any relevant...

I'm seeking a highly skilled programmer proficient in Excel macros and ODBC data connections to automate critical processes in my business. Specifically, your tasks will involve: - Automating order tracking, inventory management, and vendor communication processes. - Connecting to Excel files, SQL databases, and CSV files using ODBC. - Developing an automated procurement system capable of: - Generating purchase requisitions, - Aiding in vendor selection and negotiation, - Creating and tracking purchase orders. Proficiency in utilizing Excel macros is a must, and experience with ODBC data connections and related platforms is highly desirable. Knowledge of procurement systems and order logistics would be beneficial. Successful completion of this project req...

We need a highly skilled individual with extensive experience in document and presentation design. You will be tasked with: - Modernizing our statement of work, proposals, contracts, and PowerPoint presentations. - Updating layout and formatting. Bring outdated formats into the modern age with a refreshing touch that reflects our brand. - Revising content and language. Our output needs to resonate with the audience, so a quality copywriting ability is crucial. - Adding visual elements and graphics. You'd pepper appropriate visuals throughout our documents and slides, enhancing understanding and engagement with our messages. The style we envision for this task is clean, modern, and professional. If you have an understanding and feel for our described style, we want to work wit...

One excel file with macro as per requirement

I need an expert in Microsoft Excel to build an efficient spreadsheet to monitor potential lost revenue due to late service deliveries. The ideal candidate would possess a strong background in creating financial models and understanding of revenue tracking. Key Requirements: - Proficient in Microsoft Excel, with emphasis on creating advanced, clear, and highly-functional spreadsheets. - Experience in financial modelling and understanding of revenue tracking. - Ability to automate the process as much as possible to minimize manual tracking. Objective: - Create an intuitive and efficient Excel spreadsheet to replace the current manual method of tracking potential lost revenue due to late service. Skills Needed: - Microsoft Excel - Financial modelling - Adv...

I'm looking for a professional who can restructure and redefine my existing resume. I need help with the overall layout, for...input on the wording, content, ensuring that it communicates precisely what potential employers are searching for will be invaluable. I'm also open to suggestions on how to effectively design it to stand out from others. Key Skills: - Strong Knowledge of high-impact resume design - Proven experience in the Sales industry - Adept at optimizing resumes for Job applications - Excellent wording and formatting skills - Able to offer constructive feedback with specific, professional industry-oriented advice and examples. If you have an impressive track record of transforming standard resumes into professional, job-winning tools, you're the right...

I'm seeking a professional to diligently run through LinkedIn, identifying and documenting HR higher-u...Identifying: I'm targeting senior-level personnel only. Expertise in navigating LinkedIn search and understanding corporate hierarchies will be a plus point. 2. Documenting: I'd like the findings to be presented in a tabular form within an Excel document. Critical data points to be captured include the Company Name, individual's LinkedIn Profile link, and their Role. Your background in HR and corporate structures would be critical in understanding the perfect fit for my requirements. Strong organizational skills, meticulous attention to detail, and proficiency in Excel would be highly appreciated. Overall, a good grasp of LinkedIn-based research would...

I'm seeking a knowledgeable freelancer to construct a traditional, professional resume for my career in the Military/Security field. Ideally, I would like it formatted as a Word document. Key Requirements: - Proficiency in Microsoft Word, ensuring clean formatting and easy modification on my part. - Experience in crafting resumes, specifically in law enforcement and security sectors. - A keen eye for a professional, traditional layout that highlights my experiences and skills. Please include samples of previous similar work in your bid. Your attention to detail and understanding of the Military/Security sphere will be greatly appreciated.

I'm looking for a skilled freelancer to help me create a pivot table in Microsoft Excel that will be used to find pricing quicker Key Requirements: - The pivot table must be created in Microsoft Excel. - The purpose of the pivot table is to find pricing easier The data sources which the pivot table will be using are confidential, and will be shared with the selected freelancer.

I'm seeking a proficient individual to help with a data entry project. I have about 40 URLs, from which I need to extract the product names, prices, and descriptions. The goal is to collate this information in a pre-defined Excel template. Key Aspects: - Extract product names, prices and descriptions from 40 URLs. - Populate an Excel file with the gathered data.

I'm seeking a skilled individual with a strong command of Microsoft Excel and Word. The tasks at hand are primarily data entry, table creation in Excel and development of an instruction manual in Word. Key Responsibilities: - Efficiently perform data entry tasks in Excel. - Create tables in Excel to visually present the data. - Develop an instruction manual in Word. Ideal skills for this project include: - Advanced proficiency in Microsoft Excel, with a strong expertise in data entry and structuring information. - Proficiency in creating tables, and potentially pivot tables. - Strong experience in creating documents in Word, preferably instructional or informative content. - Attention to detail, as accurate data entry is vital. - Strong communica...

I'm in need of an Excel calendar for 2024 - 2025 that will be used for tracking school days off and special events. The calendar should feature the following: - Ability to add and modify events - Monthly view - Color-coded categories - Dates should be highlighted with background color Ideal skills: - Proficiency in Excel, including knowledge of advanced functions - Experience in creating and customizing calendars - Design proficiency to ensure aesthetic and functional layout Look at the Sample

I need a web application developed specifically for desktop use that will facilitate gathering customer feedback through surveys. Core features should include: - Facilitating creation of numerous types of questions - Customizable survey appearance - Conditional branching in surveys Ideal skills for the job include proficiency in web application development, understanding survey mechanisms, and delivering user-friendly design. Experience in tailoring products for specific platforms, in this case, desktop, is crucial since the application does not need to be responsive for other devices.

I'm in need of a virtual assistant to help with a variety of tasks, specifically: data entry, email management, and conducting research. ...help with a variety of tasks, specifically: data entry, email management, and conducting research. Ideal Skills and Experience: - Proficient in Google Docs and Sheets - Experience in managing email inbox - Can attend video calls and meeting to write MOM with clients I'm looking for someone who can commit to more than 20 hours per week. The ideal candidate should have a basic understanding of Excel or Google Sheets. Your job will be to document data, answer emails effectively, and conduct research on various topics. I am looking for someone who is timely, organized, and detail-oriented. Please reach out if you think you are a goo...

I'm seeking a professional with skills in creative and artistic book formatting to work on my memoir, which is more than 200 pages long. Key tasks: - Apply a creative and artistic style to the layout and overall design of the memoir. - Ensure the formatting is consistent and enhances readability. Skills and Experience Required: - Prior experience in formatting and designing long-form content - Proficiency in artistic book design - Strong attention to detail - Familiarity with memoir genre will be a plus. Looking forward to collaborating with an expert who can provide imaginative, out-of-the-box formatting designs to make my memoir uniquely captivating.

I have a calculator form that needs some updates made. It allows the user to input measurements for an industrial hose to find out settings for crimping. Current form is here: Need to add an option for the user to calculate with Hose Wall Thickness OR Hose ID & OD. Here is a prototype showing how this will work: measurements for an industrial hose to find out settings for crimping. Current form is here: Need to add an option for the user to calculate with Hose Wall Thickness OR Hose ID & OD. Here is a prototype showing how this will work: New page (needs some jQuery updates): Also have Excel with new formula

I'm in need of a skilled freelancer who can deliver a well-rounded Google sheet to capture important aspects of monthly personal finance, it's crucial that the created sheet can be adaptable to handle text, numerical, and date/time data. Key features: - Data validation - Pivot tables - Conditional Formatting - charts/graphs To be a right fit for this task, you should have a strong grasp on creating and optimizing Google Sheets, with these particular functions. Showcasing your past work in similar projects will strengthen your application. I'm looking forward to collaborating with you on this project to create a solid and functional Google sheet.

One excel file with macro as per the customer requirement

I am seeking an experienced freelancer who is proficient in data mining tasks in Excel. the analysis must done in excel by installing the data mining tools in excel The ideal applicant should be capable of installing and executing data mining tools in Excel. Unfortunately, I cannot specify what data mining tasks will be performed, nor the type of data provided for the analysis as these details are not available just yet. However, in order to be eligible for consideration, please include: - Detailed project proposal showcasing your approach to data mining tasks. Feel free to inquire if you need any more details. A strong understanding of data mining in Excel is essential for this task. Looking forward to your proposals.

As a business owner, I need a data entry operator who is proficient and experienced with Excel formulas. This is fairly urgent, and I am looking to make a quick hire for this role. The complexity of the task at hand includes: - Data entry with calculations - interpretations are not necessary - The project needs to be completed as soon as possible The ideal candidate for this job would possess: - Speed and accuracy for data entry tasks - Strong proficiency with Excel - A deep understanding of Excel formulas - The ability to work under tight deadlines I look forward to seeing your bids and working with you. Thanks!

I'm in search of a project coordinator with a background in team coordination and excel. The selected individual will be primarily responsible for planning and organizing a one time project, it will be plotting out some meetings and planninh some deadlines in excel. I'd like to ask them questions while they plan it out if possible! Key Requirements: - Strong Experience in Project Management: This is the most critical requirement. Experience in managing technology-related projects is highly preferred. - Strong Organizational and Time Management Skills: Ability to organize tasks efficiently and manage deadlines effectively. - Excellent Communication and Interpersonal Skills: Ability to communicate effectively with team members, stakeholders, and clients.