Compare columns excel vba code jobs
We are looking for a skilled WordPress developer to enhance our WooCommerce product pages with schema rating code. We want to optimize our product pages for search engines and provide users with valuable information directly in search results. Requirements: Experience with WordPress and WooCommerce development. Proficiency in schema markup implementation. Ability to ensure compatibility with WooCommerce and display product ratings in search engine results. Clean and efficient coding practices to maintain website functionality. Payment: We will make payment upon successful completion and verification of the project deliverables. Deliverables: Implementation of schema rating code on all product pages. Schema markup compatible with WooCommerce. Product ratings displayed in...
I'm in need of a comprehensive contact list for Queensland-based mine sites. I'd like the list to include: - Company name and contact details - Mine site location and address - Contact person and title I'm looking for a high volume of entries, so ideally more than 50 mine sites should be included. The final deliverable should be an Excel spreadsheet. Ideal freelancers for this project should be experienced in data mining and collection. You should be thorough and detail-oriented to ensure all information is accurate. Knowledge of Queensland's mining industry would be a plus.
I have a requirement for someone adept at data entry and proficiency in working with PDF documents and Excel. My project involves converting a PDF document into Excel format. Key Details: - Source Document: The source document is a PDF which needs to be copied verbatim into Excel. - Structure: The data should be displayed in the Excel document exactly as it appears in the PDF format. No need to segregate into different columns based on the type of data. - Special Handling: There are no specific requirements for handling or formatting any particular data in the PDF document. Ideal Skills: - Experience in data entry and manipulation - Proficiency in Microsoft Excel - Ability to work accurately with PDF documents If you have these key skill...
Hello there! I’m looking for a proficient programmer who can help me with a simulation task using R. The project involves creating a simulation code to estimate the expected number of draws needed to collect every type of coupon from a bag (Coupon Collector Problem), with various numbers of coupon types. Additionally, the task requires comparing the simulation results with a theoretical value and plotting them. Job Requirements: Develop an R simulation code. Run the simulation for coupon counts from 10 to 60. Plot the results and compare them with a given theoretical formula. Prepare a detailed report with observations on the accuracy of the approximation. This project is perfect for someone who enjoys statistical challenges and has a solid grip on R programmi...
I'm seeking a virtual assistant with a strong understanding of Excel. Your primary tasks will be managing and updating inventory data on a daily basis. Key Responsibilities: - Data Entry: Regularly update the Excel sheet with the latest inventory data. - Data Analysis: Analyze the inventory data to provide insights and trends. - Formula Creation: Develop and implement custom Excel formulas as needed to improve efficiency. Ideal Profile: - Proficient in Excel data entry, data analysis, and formula creation. - Experience with inventory management. - Able to deliver regular updates daily. - Careful attention to detail, as the handled data will be related to inventory. Your role is crucial for maintaining up-to-date inventory records and generating daily ...
I'm looking for an experienced Excel professional to help me set up a SUMIFS formula in an Excel spreadsheet with the following requirements: - The SUMIFS function needs to work with numeric matching criteria. - The source for the data is an Excel spreadsheet. - The most crucial aspect for this project is that the SUMIFS formula needs to be dynamic. It should update automatically as new data is added to the spreadsheet. Ideally, you should have: - Proven experience working with Excel SUMIFS functions, especially with numeric matching criteria. - The ability to create dynamic formulas that update with changes in the source data. - Strong attention to detail to ensure the formula is implemented correctly and efficiently. If you're confident in your ...
I'm on the hunt for a skilled Data Analyst who will work closely with our customer data, primarily formatted in Excel/CSV. The primary goal of this analysis is to identify trends and patterns that could aid our business processes. Key Responsibilities: - Deep analysis of customer data to identify patterns and trends - Create visually engaging and understandable reports Ideal Skills and Experience: - Proven track record as a Data Analyst - Comprehensive understanding of data analysis methodologies - Superior skills in Excel/CSV data processing - Ability to present complex information in an engaging and understandable manner. Your contribution will hugely impact our business decisions. I look forward to viewing your proposals. Please include samples of your previous...
I need a professional who's capable of modifying an existing Lua code. The successful candidate should be able to: - Understand and work with existing codes - Add an unincorporated parameter, specifically the 'tool tip radius coefficient,' into the current Lua code - Develop a method for analyzing gear size data to determine the aforementioned parameter Demonstrable experience in working with Lua language and proficiency in data analysis, specifically in gear size data, would be extremely beneficial in executing this task successfully. Strong understanding of gear parameters and a knack for intuitive problem-solving are greatly preferred.
...data with weekly remittances over a span of 2.5 years in Excel. This requires merging multiple remittance files into one cohesive dataset, and then cross-referencing the sales data with the remittance data using a unique identifier (e.g., order number). The goal is to ensure that each sale corresponds to an accurate payout in the remittance, identifying any discrepancies or missing payments. Project Tasks: Data Collection: Gather all sales data and remittance files spanning 2.5 years. Ensure each dataset includes a unique identifier (e.g., order number) for matching. Data Merging: Consolidate all remittance files into one master remittance dataset. Arrange the data in a structured format for ease of analysis. Data Reconciliation: Compare the sales data with the remitta...
I'm seeking a driven sales assistant well-versed in multitasking. Your main responsibilities will include cold calling, lead generation and sales follow-up. My business resides within the marketing industry. Having knowledge of different marketing channels like social media, email marketing, consulting, content production, and digital assets is preferred. To excel in this role, here's what you need: - A strong background in sales particularly cold calling and lead generation. - Good understanding of multiple marketing channels. - Excellent follow-up skills to ensure effective sales conversions. Apply if you're ready to help drive growth in an active marketing environment.
...completion and enhancement of a CSV file for upload to Square. This extensive project requires three core competencies: meticulous data extraction from our website, proficient data entry into an Excel form, and the creation of engaging service descriptions using AI tools. The ultimate goal is to craft a CSV file that not only meets but exceeds the requirements for Square's platform, ensuring a seamless upload process. Key Responsibilities: Data Extraction and Accuracy: Initiate the project by extracting data from specific sections of our website. This data must be accurately transcribed into an Excel form, adhering closely to the required fields. Attention to detail is paramount to ensure that the information captured is both precise and aligned with our needs. Cont...
...specialist who can help me with inputting text-based data from digital files into a spreadsheet. Key Requirements: - Data Entry: The core task involves taking text data from digital files and accurately entering it into a spreadsheet. The data is not overly complex and primarily consists of straightforward text entries. - Skill with Spreadsheets: Proficiency in using spreadsheet software like Excel or Google Sheets is essential. The ability to accurately organize and input data into these platforms is crucial. - Attention to Detail: Precision is paramount. I need someone who can enter the data with great accuracy, ensuring that each entry is correct and in the right place. - Efficiency: While accuracy is key, speed is a factor too. I'm looking for someone who can work ef...
I want to create Basic Vector Logo , A letter Head , And a Membership form FORM is in excel or PDF
...specialist who can help me with inputting text-based data from digital files into a spreadsheet. Key Requirements: - Data Entry: The core task involves taking text data from digital files and accurately entering it into a spreadsheet. The data is not overly complex and primarily consists of straightforward text entries. - Skill with Spreadsheets: Proficiency in using spreadsheet software like Excel or Google Sheets is essential. The ability to accurately organize and input data into these platforms is crucial. - Attention to Detail: Precision is paramount. I need someone who can enter the data with great accuracy, ensuring that each entry is correct and in the right place. - Efficiency: While accuracy is key, speed is a factor too. I'm looking for someone who can work ef...
I'm seeking a data aggregator for a unique AI training project. Key Tasks: - Gathering text content from official website/source of the particular product/entity. - Focusing specifically on product descriptions, specifications, price and other attributes. Ideal Skills: - Basic searching skills - Able to follow given format of data collection - MS Excel or Google Sheets This project requires precision, and the information gathered will contribute to an AI's learning process. Accuracy in aggregation is, therefore, key.
I need help from an Excel specialist who can help me identify who has opened a shared Excel document that is located on Onedrive. I am trying to see when an employee accessed it last. - You'll need to create a solution that can track and log users who access the file. - The document is accessed by 2-5 people. - It would be beneficial if you could also provide a report or dashboard that can show this access data in a clear and concise manner. Please provide examples of similar work you've done in the past, and any relevant experience that you have.
I'm seeking a skilled programmer adept at OfficeScript coding to undertake a simple to moderate project focused on data manipulation. The task will involve crafting a script dedicated to dynamically copying and pasting data from one worksheet to another with efficiency and accuracy. The ideal freelancer should possess the following skills and experience: - Expertise in data handling & manipulation utilizing OfficeScript - Proven experience in dynamic data processing between worksheets - Familiarity with the generation of customized scripts for specific tasks The goal is to streamline our internal data manipulation procedures, ensuring data integrity and reducing manual efforts. If you have the skills and experience to deliver, I'd love to hear your proposal.
I have an existing excel document that I would like to adapt to help with quotations & orders. Key Features: - The adapted document should automatically generate quotations, order forms, and perform the necessary calculations. - The excel file should have fields for product name, quantity, price, and customer information. Additionally, it should accommodate the inclusion of photos, and sizing information (a template image will be provided for reference). Calculations & Formulas: - The document should perform total price calculations, as well as tax calculations. Ideal Skills & Experience: - Proficiency in Excel - Experience with automated document generation - Exceptional skills in creating complex formulas - Attention to detail to ensure the documen...
Important: Project must be completed within 10 hours or less I have designed the attached company fact sheet in Excel. I would like help converting this to a Microsoft Word template. I need it to be flexible so that all the text and information can be changed and amended as needed, and I can change the charts. I have also attached the logos to be used.
I am seeking a proficient VBA developer to help me create a set of macros in Excel. The purpose of these macros is to automate the process of generating multiple files from a base Excel file, specifically for the task of data analysis. Key Requirements: - The macros should be designed to create multiple Excel files from a single base file. The output files should maintain the formulas, formats, and templates of the original file. - The macro should be designed to run on a monthly basis. - The output files can have the same format with different data. The ideal candidate should have: - Proficiency in VBA and Excel - Experience in creating macros for data analysis - Ability to deliver a reliable, efficient, and well-commented solution. I need this...
I'm currently on the lookout for an expert in Excel 2016, with a specialized focus on the creation of VBA. The end goal? Correct spelling mistakes across multiple worksheets in my data set. Given the language locale, proficiency in English (USA) is essential. In addition to this: - Strong attention to detail and accuracy skills are needed. - Proven experience of using Excel, especially dealing with multiple worksheets. - Experience in creating and executing VBAs effectively for similar problems. Do you believe that your expertise aligns with these requirements? If so, consider submitting a proposal.
...extract exam questions and answers from PDF files and organize them into an Excel spreadsheet. The extracted data should be structured such that each question is listed in one column, its corresponding answers are listed in subsequent columns, and each row represents a single question and its answers. Project Requirements: PDF/Doc Parsing: The software should be able to parse PDF/Doc files containing exam questions and answers. Extracted data should include the question text and its associated answers. Data Organization: Questions should be listed in the first column of the Excel spreadsheet. Answers should be organized in subsequent columns, with each answer corresponding to the respective question. The number of columns for answers may vary dependi...
I'm looking for a skilled professional who can create more than 10 bar charts for a PowerPoint presentation. Requirements: - Proficiency in Microsoft Excel - Experience in visualizing survey results - Strong understanding of chart design principles The charts will need to visually represent survey data in a way that's engaging and easy to understand. Your role will be crucial in transforming raw data into meaningful insights. Please include relevant experience in your bid, and share any similar projects you’ve worked on in the past.
...please don't make a proposal. **** Here is an example product: The description should be placed in our description tab. The other info, from Connections to Warranty should be entered in our Tech Specs tab, while retaining the formatting, including symbols. Note that the content is responsive on the manufacturer site (two columns turn into a single column when viewed on a narrow screen/browser). Need that responsive layout on my site, too. I will provide full URLs to each of the images in the tech specs. I do not want to link to their images. You will not need to do any image editing. I will provide limited access to the back end of our site, so you can paste and test the data you enter. I will ask you to do one product
We are academic researchers interested studying visit patterns to Museums, Aquariums, and Zoos, in the United States. We are seeking assistance in collecting reported visit counts for the year 2019 from 500 museums, 100 zoos, and 100 aquariums across the United States. We will send you an excel spreadsheet with the name and state of each location we would like visits counts for. Note that these ~700 locations have been pre-selected. Task: - Search the internet for reported visits to each location in 2019 - If you can find the number of visits, please enter that number in the "visits" column AND paste the link to the website / source from which you obtained that number in the "link" column - If you cannot find an official reported figure for 2019 after som...
I am in need of a freelancer who can swiftly handle two data entry projects. The tasks involved include: 1. Updating Gas Station Addresses: - The spreadsheet requires updating existing address data for about 80 gas stations based in Jamaica. - I have a specific format that I require this in, which I will share...creation of a comprehensive list of car makes and models, supplemented with brief, succinct descriptions of each car. - I have a list in word document, there may be some duplicates and there could also be more that I have not considered The successful freelancer need not have to be a subject matter expert, but should be able to undertake data entry tasks with accuracy and speed. Experience with Excel data manipulation and a keen eye for detail are ideal for...
I need help with a moderately complex data cleaning project. My spreadsheet data has missing elements that need addressing. What this entails: - Locating and dealing with missing data in the spreadsheets - Proposing solutions to prevent future missing data The perfect candidate would proficient in Excel or similar spreadsheet software, and have a keen eye for detail. Past experience with data cleaning would be advantageous.
I'm seeking a skilled individual to automate a series of tasks on Microsoft Excel, Sharepoint, Microsoft Teams and Email, using Pulover Macro and AHK where needed. Requirements include: - Automating a series of tasks in Microsoft Excel. This includes data manipulation, data analysis and reporting. The process is already mapped out and can be shared with you. - Using Pulover Macro and AHK, as well as VBA to facilitate the automation process. - Ensuring the automation process involves uploading files to Sharepoint, sending messages on Teams, and emails. The key deliverable for you is not just the completion of the automation process, but a clear and concise explanation of each step once the task is finished. This will be crucial for future troubleshooting and ind...
I have a C# project that I need translate to Delphi. The code is not too extensive but use SQLite. I will send the project source code if you send me a good proposal with you experience in c# and delphi. Please not send automatic proposals. thanks you!
I have a C# project that I need translate to Golang. The code is not too extensive but use SQLite. I will send the project source code if you send me a good proposal with you experience in c# and Golang. Please not send automatic proposals. thanks you!
We are looking for a highly skilled Technical Support Specialist to join our team remotely. As a Technical Support Specialist, you will be responsible for providing excellent customer service and technical assistance to our clients. Your main duties will include troubleshooting hardware and software issues, managing device configurations, and providing account support. To excel in this role, you should have a strong technical background, excellent problem-solving skills, and the ability to communicate effectively with customers. Skills required: - Technical troubleshooting - Device management - Account support - Customer service - Communication skills
I need an Excel sheet that can help me analyze customer information for trends and patterns. This will involve: - Basic Formulas and Functions: The data room should have basic formulas and functions that allow for the easy manipulation and analysis of customer data. - Data Room Design: The sheet should be designed to be user-friendly and intuitive, making it easy for me to analyze the data without getting lost in the spreadsheet. - Data Analysis: The main goal of this project is to analyze the customer data for trends. So, the ideal freelancer will have experience with data analysis and the ability to create custom formulas to uncover patterns. - Attention to Detail: Accuracy is key in this project. I need someone who is meticulous and can ensure that all the data is entered cor...
I'm currently struggling with a logic error related to file location mismatch in my Google Colab notebook. I'm attempting to train a neural network model, however, this recurring issue is hindering progress. To solve this problem, I am seeking an individual with the following skills and experience: - Proficiency in debugging and solving logic errors, specifically those related to file location mismatches - Thorough understanding and practical experience with neural network models - Familiarity with Google Colab Notebooks and how they manage files and directories - Proven ability to quickly identify and resolve issues affecting model training My aim is to have this issue corrected promptly so I can continue with my model training.
I am looking for a skilled Alteryx expert who can take on a project involving data blending from complex Excel spreadsheets. The project specifically involves: - Utilizing Alteryx for blending data from multiple sheets in Excel - Handling complex data structures within the Excel spreadsheets, including nested tables and formulas. Ideal candidates will have: - Proven experience with Alteryx, particularly in handling data blending tasks - Strong understanding of complex data structures, like those found in nested tables and formulas in Excel This project requires a high level of attention to detail and proficiency in data manipulation, so please only apply if you have the necessary expertise.
...years of technical business or functional analyst experience and demonstrated ability to see a project through from beginning to end including creation of business requirements and formal documentation during the solution development life cycle required ï‚· Strong emotional intelligence (EQ) and interpersonal skills required ï‚· Experience with workflow design required ï‚· Proficient in Microsoft Word, Excel, PowerPoint, Project, and Visio preferred Supervisory Responsibilities: None Travel: ï‚· Up to 20%, to include overnight stays, may include an annual software user conference Physical Requirements: ï‚· This role frequently communicates with others, must be able to exchange accurate information in these situations ï‚· This role routinely uses standard office equipment such as computers, p...
I'm in need of a savvy professional who appreciates the finer details of Major League Baseball (MLB). You'll be tasked with compiling a comprehensive sprea...should cover designated players and/or teams - the specifics of which I'll supply once you're on board. 3. Additional Factors: In keeping with the finer details, the spreadsheet should also cover the Date of Game, Team A vs Team B data, analysis on which pitcher is better, and predictions on which team will win. The ideal candidate will have a strong background in data manipulation, particularly in Excel or similar tools. But more than just your average data enthusiast, I'm specifically looking for someone with a deep understanding of baseball. If you can hit a home run with MLB stats and predictions, ...
I need a freelancer proficient with both Excel and Photoshop for two primary tasks. Excel Work: - Conduct data analysis and create visualizations, leveraging skills in updating and organizing data Photoshop Work: - Provide graphic design and photo editing services Ideal candidate should have solid experience in both platforms and a keen eye for details. Understanding my needs in data management and visual design will be a key success factor.
I am in urgent need of a skilled MySQL professional who can smoothly transition my old database into the new one for my website. There are some extra columns in certain tables in the new database, so understanding the essence of the project is pivotal. Here's what I need assistance with: 1. Importing Data: I have a detailed list of specific tables and columns which need to be brought into the new setup. Your work will heavily rely on this list. 2. Data Combination: While importing the data, some of it requires merging. I won't be able to guide you on how this should be done, so it will fall under your professional judgment. Your proven experience and innovative strategies will come into play here. I am hoping to find someone who has extensive experience in MyS...
We're looking to automate our timesheet comparison process. Our current timesheet data is in two online platforms and the automation workflow needs to run on a weekly basis and compare the 2 timesheets. Key Tasks and Requirements: - Create a data entry automation flow that will extract data from our current online platforms. - The data has to be extracted for 2 pay periods from platforms - 1st to 15th and 16th to End of Month for every month. - compare the 2 data sets by employee and date. if there is a mismatch, it needs to be flagged. - send email to the employee and reporting manager about the mismatch. - send highlevel email to operations head about all mismatches so that he can followup with the managers. - Schedule this automated process to run on a weekly b...
Hello All , I want you to design a small machine which will clearly show the power consumption of a hub bearing , when hub bearing is rotating at 300 rpm or less . The power consumption of the bearing can be shown through a digital meter or oscilloscope. I need to compare the power consumption of various hub bearings . In this , you can measure torque of hub bearing and that torque of hub bearing can be converted in to ampere or other which will clearly show the power consumption . For your reference I have attached herewith the hub bearing , which required to be tested ; in attached document. Hub bearings have two flanges . I want you to fix one flange by some method and rotate other flange at 300 rpm or less . Scope of the project : 1. Detailed component and assembly drawing of ...
Project Description: We are looking for a skilled Java developer with experience in Apache Flink (version 1.19) to create a data processing job that reads from parquet files...Description: We are looking for a skilled Java developer with experience in Apache Flink (version 1.19) to create a data processing job that reads from parquet files located on a Network File System (NFS) and sends selected data to a Kafka topic. Core Responsibilities: - Develop a Flink job using Java that can read parquet files from NFS. - Implement functionality to allow the selection of specific columns from the parquet files to be processed. - Ensure the selected data is published to a specified Kafka topic efficiently. - Manage dependencies and libraries required to execute the job without compatibili...
hello everyone we have a CRM which allows us to manage our customers, a CRM entirely coded by us in html php and javascript. we have started to integrate a function which allows us to insert customers into our CRM using an excel file, but I don't have the time to finish that. It must be ready before the end of the day, today! mandatory deadline. if we are satisfied we will entrust you with many other missions on this brand new CRM
I am in need of an individual with skills to assist with the migration of data from FS5 and .IDX files. My project involves: - files in FS5 or .IDXfiles that need to be migrated into a usable, readable CSV format that can be edited a - Handling text data specifically, and ensuring its integrity is maintained throughout the conversion. Potential freelancers need to have: - Knowledge of FS5 /.idx files. - Strong knowledge and understanding of text data management. - Excellent problem-solving aptitude, as the difficulty level can vary across files. I look forward to a thorough demonstration of your ability.
I'm looking for a skilled developer who can create a coupon code aggregator website similar to retailmenot.com. The key feature of this project is the integration of a web crawler that will search and gather coupon codes from various online sources. Key Requirements: - Development of a coupon code aggregator website - Integration of a web crawler that will search for coupon codes on a daily basis - A search bar where users can enter websites like they are browsing normally and coupon codes will be applied similar to how microsoft edge or Honey does it - The website should have the functionality to automatically apply coupon codes to a shopping cart - Ability for users to sign up and receive daily coupon codes and deals - Ability for the website admin to be able to add ...
I'm looking for an expert C# developer to create a software that can hash CDs for the purpose of file integrity. The primary use of this software will be to compare the hashed data with other CDs. Key Points: - The software should be designed to hash CDs at a speed that outperforms the hashing process in PowerShell, ensuring efficiency and time-saving - The primary focus of the hashing is to maintain the integrity of files on the CD, so I need a developer who understands the importance of this and can ensure the software is reliable in this regard - The software should be user-friendly, with a preference towards a fully automated process to make it as easy as possible for end-users. I'm looking for a skilled C# developer who has experience in creating high-speed hashing...
As a vendor, I have three excel sheets containing product numbers and corresponding data. Both sheets are error-free and completely filled in, but the second sheet has its entries in a mixed order. I need a freelancer who is adept in working with Excel to match the data in the sheets based on product I.D number using the product numbers and or product name (TRS Direct Sheet) to match the size dimensions in the other sheets as highlighted via colored columns (must match colors) Sheet format cannot be moved or changed or altered in the cells already published on the 2 sheets as listed only the DATA MASTA it effects the upload process. area highlight pink no information or changes to be made or added please scroll through to observe existing pink cells. Here's a det...
I'm in need of a proficient PHP developer to create a custom code for communicating with an Ingenico POS terminal via Ethernet. Here are the specifics of the project: - **Communication Method:** The primary method for the communication is through Ethernet. You need to be well-versed in this type of communication to tackle this task efficiently. - **Transaction Handling:** The main purpose of the code is to transmit the amount to the terminal and verify if the transaction can be successfully processed. **Requirements**: - experience in PHP - Prior experience with Ingenico POS terminals or similar devices is a plus Please note that this project is solely for the communication between the system and the terminal. There is no need for integration with the banking systems...
