Site data crawler extract excel jobs

As your client, I'm looking for an Excel VBA expert who can make my daily processes more efficient by creating an automated reporting solution for me. Key Tasks: - Design and implementation of a VBA macro in Excel to automate the generation of cost summary reports. - The automated reports should be populated by data from four different worksheets, namely Worksheet 1, Worksheet 2, Worksheet 3, and Worksheet 4. Ideal Skills and Experience: - Excel VBA Programming - Experience with automated reporting - Understanding of data manipulation in Excel. -Possible migration of Cost Summary data to Word contract. In your proposal, please share samples of previous automated reporting projects done with Excel VBA. Commitment to deliveri...

I'm on the lookout for a well-versed WordPress developer, proficient in WooCommerce and Google's PageSpeed Insights. The fundamental objective of my project is to optimize the performance of my e-commerce site selling digital products. Key Tasks Include: - Ameliorating overall performance and loading speed of Home Page - Optimizing Product Pages for quick and effective loading - Streamlining the Checkout Process, ensuring a seamless user experience. - Holistic enhancements in all aspects related to WooCommerce, including payment methods. The ideal freelancer for this job should have formidable experience with WordPress and WooCommerce, a proven track record of improving website performance using PageSpeed Insights, and a comprehensive understanding of e-commerce web de...

I am in need of services for a commercial civil/site design project. The specific scope of this project includes: - Drainage and sanitary systems design - Parking and access design The site that requires these services is medium sized, spanning between 1-5 acres. As such, I am particularly interested in freelancers who exhibit the following skills and experience: - Proficiency in civil and site engineering principles particularly for commercial properties - Proven experience in designing effective drainage and sanitary systems - Mastery in creating efficient and safe parking and access layouts - Familiarity with regulations and standards for commercial properties of a similar size Prospective candidates may present evidence of their past related work and expertise....

I am looking for a freelancer with expertise in PowerBi and Excel. The task will revolve around creating a one-time report/dashboard on PowerBi sourced from a single Excel spreadsheet. The ideal candidate should have: - Previous experience with PowerBi and Excel - Proven track record of data analysis - Attention to detail Please note that the Excel file won't be changing over time, so there is no requirement for the PowerBi report/dashboard to be updated. Content Description: I have statistics from every UFC fight and want basic visualizations made (I have a rubric)

I'm in need of a WordPress developer to help me with my agency site. I'm looking for someone who can show me their past work immediately. The primary goal of the website is to attract new clients. Key Points: - Need expertise in WordPress customization - Experience in website creation is essential - Ability to present a portfolio of past projects is a must I'm looking for a freelancer who can help me with this quickly. Please only apply if you have prior experience in this area and can show me your work right away.

I'm seeking a skilled developer to take my existing demo code and bring it to the next level. The application is web-based and is intended to automate the extraction of data from Word and Excel documents, and then compare the data for consistency. Key Responsibilities: - **Improved Data Extraction Accuracy:** The code should be enhanced to improve the accuracy of the data extraction process. The developer should implement robust methods to ensure that all necessary data is correctly captured. - **Enhanced Comparison Algorithm:** The comparison algorithm should be optimized to better handle the extracted data. The developer should ensure that the comparison is done accurately and efficiently. - **User-Friendly Interface:** The current d...

I need a professional SEO expert to boost the visibility of my hypnotherapy practice in Dallas. You'll be expected to optimize the website with specific Dallas-related keywords, target them in Google Ads, and acquire Dallas-specific backlinks. Key Project Points: - **SEO Optimization:** You'll be required to optimize the site for Dallas hypnotherapy-related keywords. These keywords will be discussed with you. - **Google Ads:** Your task will include targeting the selected keywords in Google Ads campaigns to attract more traffic. - **Backlink Building:** I'm looking for someone experienced in acquiring backlinks from Dallas-based platforms. Ideal Skills: - **SEO Expertise:** Proven experience in SEO optimization, particularly for local businesses. - **Google Ads Pro...

...aspect of the website is optimized for speed and efficiency. Key Requirements: - Implement product search and filtering functionalities to enhance user experience. - Set up a seamless shopping cart and checkout process for customers. - Integrate Shiprocket for efficient shipping services. - Incorporate a secure and reliable payment gateway. - Make performance optimization a top priority for the site. Ideal Skills and Experience: - Expertise in WooCommerce and WordPress development. - Proven experience in customizing and optimizing online stores. - Prior experience with Shiprocket or similar shipping integrations. - Strong understanding of different payment gateway options and integration processes. - A track record of improving website speed and overall performance. If you ha...

MATLAB USERS Visual Processing and Object Detection: The first task will be to detect and segment objects in images using traditional computer vision methods. It will be necessary to automatically separate the balls from the background and evaluate the accuracy of the segmentation. Feature Calculation: The second task will be to extract texture and shape features. By using appropriate algorithms to calculate the shape attributes of the balls, it will then obtain textural attributes with gray level collaborative matrices. Object Tracking: The third and final task will be to track the movement of a ball by applying a Kalman filter. Working with real and noisy coordinates, it will create a tracking algorithm and compare the tracked path with the real one. summarize this in 250 words

I'm seeking an Excel expert to create a user-friendly data entry workbook. The job is straightforward and requires the following: - **Data Entry:** The workbook should mostly focus on simple data, like names and dates. I am not looking for any intricate calculations, formulas, or pivot tables. The main focus is on creating an Excel workbook that streamlines the process of entering simple data in a structured and efficient way. Experience in creating user-friendly UX within Excel is a plus. No integration with external systems or services is needed - this is a standalone project. I look forward to collaborating with an experienced professional who can deliver an effective, easy-to-use data entry solution within Excel...

I require AutoCAD shop drawings for the intention of construction planning for a commercial building. The freelancer should include comprehensive architectural details. A strong background in creating accurate AutoCAD drawings detailing architectural specifics for commercial projects ...accurate AutoCAD drawings detailing architectural specifics for commercial projects is a must. The desired candidate will need a strong understanding of construction processes, especially within the commercial realm, to ensure every detail contributes to a seamless build. Your craftsmanship will directly influence our build strategy, so we expect precise and detailed work. Please only apply if you excel in AutoCAD and have direct experience in the realm of architecture and construction of commercial ...

I need a web scraping expert to help me get data from a third-party search site. The project is urgent and needs to be completed ASAP. Key Requirements: - Skilled in web scraping techniques - Proficient with tools for scraping - Able to work under tight deadlines - Excellent communication skills Please note that the specific search site is not mentioned, but the task involves scraping information from it. If you have the experience and can work quickly, please reach out.

I'm looking for a seasoned Excel expert to create a set of macros that can automate my data extraction process. Here's what I need: - Automate data extraction: The primary purpose of these macros is to enable automated data extraction from local files. The data in question is stock market data. The ideal candidate for this project would have: - Proficiency in Excel: You should have a strong grasp of Excel, particularly in designing and implementing macros. - Experience in data extraction: You should have a track record of successfully automating data extraction processes. Looking forward to hearing from you.

I am looking for an expert in Excel to design a dynamic spreadsheet for project tracking. This spreadsheet will focus on monitoring task progress and deadlines. Key Features: - Daily updates: I will be updating task progress and deadlines daily, and so I need the spreadsheet to be user-friendly and efficient. - Task highlighting: If a task is falling behind schedule, I need it to automatically become highlighted in red. This will help me prioritize tasks and ensure no deadlines are missed. - This will need to show throughput for every phase and also provide an average through in volume. Skills and Experience: - Proficient in Excel - Experience in creating dynamic spreadsheets - Understanding of project management principles. I look forward to working with a detail-orien...

I am doing a website design and need a good designer who can work in a modern minimalistic way.

I'm in need of a freelancer capable of efficient and precise textual data entry into Microsoft Excel. This project requires a keen eye for detail, a high level of accuracy, and excellent organizational skills. You should be fluent in English and proficient in using Excel. To make an informed bid, freelancers should include the following: - Examples of past work related to data entry, particularly with Microsoft Excel. Stats that display the accuracy and efficiency of your work would be a huge plus. - Any relevant experience in data entry or related fields. Please note, attention to detail and Excel proficiency are paramount to this project.

For this task, I am specifically seeking a freelancer who is proficient at data entry and familiar with Excel spreadsheets. The project primarily involves numeric data, so accuracy is vital. Key Responsibilities: - Input numeric data into an Excel spreadsheet. - Maintain a minimum 98% accuracy level. Ideal Skills and Experience: - Proficient in Excel. - High attention to detail. - Experienced in numeric data entry. - Proven track record of maintaining high levels of accuracy. Please ensure you have the necessary skills and experience before placing your bid. I look forward to your detailed proposals.

I am in need of a proficient Wordpress developer to integrate IDX feed into my real estate website. In this project, you will be required to incorporate specific features into the IDX integration including: - Property search functionality - Map display - Property detail pages The primary goal of my real estate website is to build an easy-to-use platform where users can browse through various properties, providing potential leads and prospective clients with detailed information. Potential freelancers should ideally have extensive experience with Wordpress and IDX feed integration. To help you succeed in this project, providing proof of past related work would be beneficial but not obligatory. I am particularly interested in freelancers who are capable of demonstrating experience in si...

I am urgently in need of an expert in Data Build Tool and SQLite database who can efficiently develop a data pipeline. The pipeline will handle extracting all files from a specific folder location on my local drive. The goal here is to create a pipeline that can universally extract all types of files. Ideal Skills and Experience: - Proficient with Data Build Tool - Extensive knowledge of SQLite database - Prior experience with data extraction projects - Quick turnaround time - Ability to work with local storage systems This is a two-hour assignment and the steps required for the task are detailed in the document provided. Your quick assistance is highly appreciated!

I am urgently in need of an experienced graphic designer/auto cad drafts person to bring about changes in my site map layout. Understanding of user-friendly design and site navigation is paramount for this project. - Task at Hand: - Modify current site layout While the specific changes weren't mentioned. Freelancers with a keen eye for detail and design and prior experience working with site maps are necessary. This project is urgent, so immediate start is required. Please include similar past jobs in your proposal. Prioritized attention will be given to those who can showcase a strong understanding of user experience in their work.

Need to extract data from website: , into an Excel file. Specifically name, discipline (medical practitioner, midwife, nurse, OT, physio, psychologist, podiatrist), location (incl suburb and postcode), initial registration date, registration expiry. There would be at least 100,000 rows of data. Only barrier, is this data is not able to be 'searched' efficiently. Individual names can be looked up. Or disciplines with a select number of names demonstrated...but I can't find a way to show ALL clinicians at once. Looking for a solution which can reliably pull all the names from the database.

I'm looking for an Excel expert who can build a simple yet effective sheet for basic arithmetic calculations. Key requirements: - Perform basic arithmetic operations: The main functionality of the sheet should be to perform basic arithmetic operations such as addition and subtraction. - Real-time collaboration: The sheet should support real-time collaboration, where multiple users can edit the Excel file simultaneously. Ideal skills and experience: - Strong background in Excel: The freelancer should have a deep understanding of Excel and the ability to create formulas for basic arithmetic. - Real-time collaboration proficiency: Experience in implementing real-time collaboration features in Excel will be highly beneficial. - Attention to detai...

I'm looking for a reliable and experienced data entry specialist who can assist me with entering data from images. The images will be directly uploaded to a website, and I need the data to be transcribed into various formats like Excel sheets, Word documents, and for copywriting purposes. Ideal Skills and Experience: - Prior experience with data entry from images - Proficiency in Excel and Word - Copywriting experience is a plus The primary goal of the project is to create a comprehensive database in various formats, so the ability to accurately transcribe and organize data is crucial. The chosen freelancer should have keen attention to detail and a high level of accuracy.

My vision is a website that compiles news stories from various sources, catered specifically to industry professionals. It needs to evoke the user-friendly link navigation found on sites like drudgereport.com. Key Objectives: - Provide a centralized, reliable resource for industry-specific news - Curate content from various websites, maintaining high standards of relevance and credibility - Generate ad revenue without hampering user experience Functional Requirements: - User-friendly link navigation: Essential for facilitating ease of access to various news stories - Effective ad placement: Ads should be strategically placed to generate revenue, without obstructing the user's navigation or distract from the news content Ideal Skills: - Proficiency in website design and development ...

...potential clients. - Convert conversations into promising leads. - Record conversational details into our database. REQUIRED SKILLS AND EXPERIENCE: - Exceptional persuasive communication skills. - Proven experience in lead generation. - Familiarity with the corporate events and conferences sector. - A resilient attitude to handle potential rejections and keep going. This role demands someone ready to excel in a fast-paced environment while showcasing dedication, autonomy and agility. Your ultimate aim will be to assist in the company's expansion through the successful generation of potential leads. This is an excellent opportunity for someone looking to apply and enhance their telecalling skills while significantly contributing to a growing company in the event managemen...

I require a freelancer to extract and consolidate numeric data from existing databases. The data should be transformed and presented in a workable database file format. Key responsibilities include: - Extracting data from various data sources - Ensuring data integrity and quality - Transforming the data into a database file format Ideal Skills and Experience: - Proficiency in database management and data extraction - Strong understanding of data transformation - Attention to detail and precision - Ability to ensure data quality and integrity - Prior experience working with numeric data is a plus.

...com designed and built using WordPress. It needs to support both English and Spanish languages, with the ability to easily manage recipes in both languages. Creativity is key at this stage - I want to be surprised with your interpretation. A vital aspect of this website is a lead generator integrated with ZohoCRM for lead tracking. It should use the webform provided by Zoho. Additionally, the site should incorporate a store locator function, guiding customers to physical locations where our products are sold. Ideal skills and experience for the job: - Proficiency in WordPress and ZohoCRM integration - Experience devising and maintaining bilingual websites - Experience creating interactive and user-friendly store locator/maps - Understands GDPR requirements for collecting pers...

I need an Excel VBA expert to automate the generation and visualization of customer data reports. This task requires the building of a dashboard to simplify the report generation process. Key Tasks and Skills Required: - Strong understanding of Excel VBA for automation tasks. - Experience in building dashboards for report generation. - Skills in visualizing customer data within Excel. Outcome and Project Scope: - Develop an automated process for report generation. - Ensure the dashboard is user-friendly and visually appealing. - The final output should provide easily digestible customer data insights.

I need a Civil Engineer to assist with the conceptual design phase of an infrastructure planning project. Key Tasks: - Conduct a thorough site analysis and assessment. - Provide detailed insights and data on the physical and environmental characteristics of the site. - Offer recommendations for the best use of the site. - Prioritize sustainability and efficiency in the proposed infrastructure. Requirements: - Proven experience in infrastructure planning, particularly in the conceptual design phase. - Expertise and knowledge in site analysis. - Strong understanding of environmental and sustainability considerations in civil engineering. - Excellent communication and reporting skills. This project is ideal for a civil engineer who is passionate about cre...

Specification: Facebook-Web-Scraping and Web-Crawling Write Swift Code that prompts the user to give username and password This information is used to login to facebook and scrape facebook for facebook friends and extract the following information: - Name - Birthday and month and if available year - Gender This information should be made available in a JSON or XML format. The code will be embedded in an app. It is important that this web-scraping activity can run in the background of the app invisible to the user.

As a data enthusiastic business, we're seeking a talented freelancer who can design an effective Power BI Dashboard to integrate various data sources including Excel spreadsheets, CSV files, and SQL databases. The ideal freelancer would: - Have extensive experience with Power BI and DAX language integration. - Demonstrate an excellent grasp of designing dashboards that report on KPIs. - Be well-versed with creating DAX calculations in the Power BI environment. We require the dashboard to focus on specific metrics, therefore, a strong understanding of reporting on KPIs using DAX language is a must. Additional Skills: - Proficient in Microsoft Excel and SQL databases. - Understanding of data integration and reporting. - High attention to detail. ...

I'm seeking a skilled developer who can perform specific updates to my Laravel website. Key tasks include: - Front-End Design Changes: Your main responsibility on the design front involves refining my site's navigation. This implies that you'll need to understand how the navigation menu is currently arranged and accurately remove specific items. - Database Optimization: I am excited to augment the performance of my website. For this, I require optimal reformation of the existing database structure. This task demands proficiency in managing Laravel databases and an understanding of optimization best practices. The ideal candidate for this project is detail-oriented and exhibits a strong understanding of Laravel, database optimization techniques, and UI/UX principles. Knowl...

Confirmis () is a Singapore-based business information provider specializing in connecting businesses with global capabilities; comprised of industry veterans, Confirmis business model is designed to overcome perennial lack of data (let alone quality data) to support effective decision making, particularly in developing economies. As a Site Verifier, you will be responsible for verifying a company’s existence through visual data by conducting a site visit to ensure that we provide reliable and accurate information to our client. JOB DESCRIPTION: • Conduct basic verification with the subject company’s authorized representative, such as line of business, key executives' name, etc. • Take pictures of the subject company and its...

In search of a competent Excel specialist adept in Microsoft Access for multiple automation tasks. I need assistance with: - Macros Development: The main tasks include automation and creating tools. The proficient use of macros in daily operations is essential. - Report Generation: Specifically, the generation of technical proposal reports. Alongside this, the candidate should also be capable of automating the formula calculation process. Familiarity with financial, sales, and project status reports is an added advantage. - Tool Building: The capacity to build tools and other operations geared towards improving efficiency is crucial. Ideal skills include deep understanding of Excel functionalities, proficiency in Microsoft Access, extensive experience in automation via macr...

...need an Excel expert to build a tool that can automatically validate and correct any incorrect country codes in the file. Requirements: - Replace incorrect country codes: The tool should replace the incorrect country codes with the correct ones. - Predefined list: The correct country codes should be determined based on a predefined list. - Daily updates: The tool should be able to handle daily updates. Ideal Skills and Experience: - Advanced Excel skills: You should have a deep understanding of Excel functions and VBA programming. - Data validation: Experience with data validation and manipulation in Excel. - Attention to detail: It's crucial that the tool is accurate in identifying and correcting country codes. - Timely updates: Exper...

...manage MIS excel sheets pertaining to data analysis, sales forecasting, and expense tracking on a daily basis. Key tasks: - Establishing excel sheets to analyze a broad range of data - Constructing a sales forecasting model within the excel sheets - Regular tracking and management of expenses via the excel sheets Data sources would primarily be spreadsheets and databases. These excel sheets will require daily updates, enabling close monitoring of key metrics. Ideal skills: - Proficient in Microsoft Excel - Exemplary skills in data analysis and modeling - Good understanding of databases and how to extract data from them Experience in handling and managing sales and expense data is crucial...

I need an expert to migrate my products from an Excel file to my WooCommerce store. Key Requirements: - Migrate products from an Excel file to WooCommerce - Use attributes to define variations within a single product - Update existing product descriptions during the migration Ideal Skills and Experience: - Strong experience with WooCommerce and product migration - Proficiency in handling product variations using attributes - Attention to detail for updating and modifying product descriptions - Excellent knowledge of data import/export and product management on WooCommerce. - Ability to ensure a smooth and error-free migration process.

I'm looking for an experienced bangladeshi WordPress developer to design and implement a business website for me with an integrated online shop. Key Requirements: - Experience in building WordPress business websites from scratch. - Proficient in setting up online shop functionalities. - Ability to incorporate desired local payment methods in the shop (Bkash, Nagad, Roket in Bangladesh). Ideally, you should have: - A portfolio of previous Wordpress business sites with integrated online shops. - Knowledge and experience with local payment methods in Bangladesh. - Excellent communication skills in English. Your task will be to initially design the website, implement the online shop, and ensure it's capable of accepting payments through the specified local methods. Please incl...

I'm looking for a skilled freelancer who can help me with importing product data from XML sheets. The data needs to be imported into multiple Prestashop faced search feature tables. Key project details: - I need the product information to be imported - The data needs to be updated daily and in real-time - Multilingual support is not required, so a single language is sufficient Ideal Skills and Experience - Proficiency in working with XML data and importing it into systems - Expertise in Prestashop and its search feature tables - Experience with real-time data updates in web applications - Strong problem-solving skills and attention to detail Import data from xml sheets into multiple prestashop faced search feature table. Here's an ou...

I have a significant amount of text that needs to be typed into Excel quickly. The data is in a simple text format, no complex formatting required. Key requirements: - Proficient in Excel and typing - Attention to detail - Ability to work under tight deadlines The data is straightforward text and requires no specific formatting or analysis. The ideal freelancer will be skilled in data entry and be able to commit to a quick turnaround time.

As a client with emphasis on quality, I need the support of an experienced Python programmer who can take charge of the frontend aspect of my web development project. At the core of this project are the following requirements: - Full proficiency in Python as the main programming language for the task - Demonstrated experience in frontend web development using Python - Familiarity with the best practices in Python programming - Capacity to effectively communicate, provide regular updates and accept feedback The missing response for the third question won't be an issue — I am more interested in a Python programmer who can bring their own unique ideas and solutions. You are encouraged to showcase your creative problem-solving skills. Apply if you have the necessary skills and ...

I am seeking an Excel expert who can meticulously enter extensive amounts of text, numeric, and alphanumeric data into my spreadsheet. The task involves entering names, contact details, sales information, and inventory data. The size of the task is quite substantial, with up to 1,048,576 rows and 16,384 columns involved. The role requires a keen eye for detail, accuracy, and dedication. If you are efficient in Excel and possess experience with handling large data sets, your skills will be highly valuable for this project.

I need an IT consultant Wix site primarily for lead generation. The site should be clean, professional, and easy to navigate, enticing potential leads to reach out for IT services. For the logo, I'm looking for a minimalist design, that cleverly incorporates my company's initials. Ideal Skills: - Extensive experience in Wix website design and layout - Expertise in creating minimalist logos - Understanding of lead generation strategies in web design Please share your portfolio containing similar design samples. I look forward to finding the right fit to bring this project to life. If your bid isn't your full, final price, don't even bother. Also, if your automated response includes anything related to budgeting, your bid will be immediately eliminate...

I need a reliable freelancer to assist with data input. Here's a breakdown of the project: - **Task:** Your primary job will be to input data from online forms into either Microsoft Excel or Google Sheets. - **Experience Required:** It is necessary for you to have prior experience with both of these tools. This will ensure you're able to work efficiently and accurately. - **Attention to Detail:** Given the nature of the task, it's crucial that you have excellent attention to detail. Even the smallest mistake can have significant implications. If you have the experience and skills mentioned above, I would love to hear from you.

...problematic error with my Excel sheet. An error message keeps popping up and the sheet becomes protected every time I enter a price. Ideally, instead of locking the entire sheet, only specific columns should be locked when a password is triggered by clicking a button. Key issues: - Error message arising upon entering a price - Automatic sheet protection following action Work Required: - Identify and fix the error triggering the message pop-up - Adjust VBA codes to lock specific columns upon password entry: - Columns A to L - Columns Y, Z to AK - Columns CW to DH - Columns DO to DS - Columns DT, DV, DX, DZ, EB, ED For this task, I need a freelancer proficient in VBA and Excel, specifically with experience with sheet protection issues. A thorough understanding...

I will go to the mentioned place and take pictures of the building, road, board picture.

I'm looking for a skilled C++ developer to create a CAD software primarily focused on 3D modeling, compatible with Windows OS. Key Features: - Primarily 3D Modeling: The software should excel in 3D modeling capabilities, providing robust tools and functionalities for creating and editing 3D designs. - Compatibility: The software should be specifically designed to run seamlessly on Windows operating system, ensuring optimal performance and user experience. - File Format Support: The software should support importing and exporting of DWG files, for compatibility with AutoCAD files. Ideal Skills and Experience: - Proficient in C++: Extensive experience in C++ development, with a strong understanding of software architecture and design patterns. - CAD Software De...

Scope of work, SureCart (high level). SureCart, SureTrigger, and SureMembers are powerful tools for creating and managing subscription-based platforms. Here's a detailed scope of work based on your requirements: Platform Setup and Configuration: Install and configure SureCart, SureTrigger, and SureMembers plugins/extensions. DONE. Set up payment gateways for processing transactions (Stripe, PayPal). DONE. Configure user roles and permissions for different membership levels (Freemium, Plus, Pro, Premium). Customize email notifications for user registrations, subscriptions, and other relevant actions. Product and Subscription Setup: Define and create payable products for each membership tier (Freemium, Plus, Pro, Premium). Set up subscription plans with varying features and access le...

I'm in need of a WordPress expert to develop a clean and efficient website for my cleaning company. The website should initially include a Home page but have the space and capabilities to expand later. This project does not have an established timeline, so I value quality and efficiency over speed. However, I do expect regular process updates. To sum up, these are the specific requirements: 1. Develop a WordPress website 2. Initial creation of a Home page 3. Potential for future expansion to include other pages such as Services and About Us 4. No rush on project completion while maintaining good communication Your experience with WordPress is essential, and prior work on similar projects would greatly appeal to me. Does creating clean websites that reflect the businesses they re...

Firstly, I want to know if what I am asking can actually be created in Excel 365 and used in Excel 365 Online. Please dont reply to this post without replying that it can or can't be done. If not, an alternative solution would be greatly appreciated. I need help creating an excel spreadsheet to track student progress in a course using 5 different options that also includes the date the option was selected. I can create the drop down list with the submission options, and apply color rules but I can not work out how to make the cell below change to the same color as the option selected and the date it was selected appear in the same cell. I need to include the date the option was selected selected and because you can't have two formulas in conditional form...