Just a quick bit of help needed in excel macro writing. See attached before and after showing a piece of the original data. and what i neeed the macro to achieve. WHAT IM ASKING If two adjacent cells in column b are equal, then add cells adjacent column c cells, put the result in the first column c cell and remove the duplicate row. AEE ATTACHED png. I need a tailored solution for a data manipulation task within Excel. Specifically, I am looking for an Excel macro that can accurately merge cells based on their adjacency. Essential skills and experience should include: - Expert knowledge of Excel and its macro functionality - Prior experience with data manipulation tasks such as merging cells - Understanding the rules or criteria for merging specificall...
I am looking for an expert who can as...expert who can assess and modify an existing Excel macro for compatibility with Excel for Mac 2019 or later. The current macro mainly handles formatting tasks within the Excel file. Key Requirements: - Assess the current macro's compatibility with macOS - Modify the macro to ensure compatibility with Excel for Mac 2019 or later I don't have a strict deadline for this project, so you can work on it at your own pace. However, I am looking for someone who can get this done efficiently and effectively. Feel free to ask any questions for more information. Ideal Skills and Experience: - Proficient in Excel VBA and macros. - Extensive experience in adapting macros for cross-platform compatibility. - Kno...
I am searching for a proficient web developer who also has experience managing eCommerce platforms such as Flipkart and Amazon. The primary task is creating a website from scratch intended for product sales, with clear and appealing design, optimised for conversions and customer ease of use. Key Tasks: - Design and construct a new website for product sales from scratch. - Optimize for user-friendly navigation, SEO, and product presentation. The ideal freelancer for this job will have: - Proven experience in creating successful eCommerce websites. - Strong knowledge of site design, user experience, and SEO principles. - Previous experience managing Flipkart or Amazon product listings is beneficial. - Understanding of inventory management on eCommerce platforms. Make your bid if you ar...
I'm looking for a skilled developer to create a robust mobile application that offers real-time translation capabilities and includes an AI assistant with a focus on language understanding and real-time conversation support. Key Features: - Cross-Platform: The app should be developed for both iOS and Android, ensuring a wide user base. - Page Translation: Users should be able to translate live any page on their phone. - AI Assistant: The AI assistant should have the ability to provide information on various topics and should excel in language understanding, helping users with translation in real-time conversations with others. - Live Translation: The app should provide a smooth live translation experience for conversations. Ideal Skills: - Proficiency in React Nativ...
I am in need of a freelancer who can accurately convert my PDF files into Excel. The materials consist mainly of printed, electronically generated text. Given the nature of the work, the ideal candidate should: - Be proficient in both PDF and Excel formats - Have an eye for detail to ensure accuracy - Have experience dealing with extensive text documents - Possess strong typing and data entry skills Please bid if you fully understand the tasks and feel capable to deliver high-quality results. Your attention to detail and commitment to accurately completing tasks would make you an ideal candidate for this project.
I need you to go into my Clickfunnels account and make a simple video landing page. However i need to have a purchase button that drops down at a particular time point in my video. You must have extensive experience in Clickfunnels because i will utilize you in the future for more complicated pages within Clickfunnels
I'm in the process of developing a new power electronics product for industrial use. The current stage of development is in the prototype phase. For this project, I need a skilled professional who can help me with the following: - PCB Prototyping: I require assistance with the creation of the PCB for this new product. This includes the manufacturing of the board itself. - Creation of Test Plans: I need an expert who can help me create comprehensive test plans for this new product. This includes both hardware and software testing. Experience in creating test plans for electronics, would be highly beneficial. - Final Testing & Validation: Once the PCBs are produced and the test plans are in place, I would need a professional who can assist me in the final testing ...
...The primary task is to ensure that new columns added to the database are correctly displayed in the Excel report generated by the application also fix some minor areas that will discuss in detail Key Responsibilities: - Troubleshoot and fix the issue of new columns not being displayed in the Excel report - Ensure that all relevant data is correctly fetched from the SQL Server 2019 database - Implement a seamless solution that does not affect the overall functionality of the application Ideal Skills and Experience: - Strong proficiency in C# programming language - Expert knowledge of SQL Server 2019, including stored procedures and functions - Prior experience with similar tasks involving Excel report generation from SQL data - Excellent problem-solving skills and ...
For my project, I'm looking for a highly detail-oriented professional with brilliant Excel skills. Key responsibilities include: - Managing and transferring both numerical and textual data in an Excel spreadsheet, ensuring the correct placement into columns marked by letters (A, B, C, etc). - You'll not be required to order the data in any specific way, just transfer into the appropriate columns. Skills & Experience: - Proven record in data entry tasks - Strong Excel skills - Ability to understand and interpret numerical and textual data Looking forward to your bids and kicking into this project soon!
We are seeking a talented animator to create a captivating 1-minute video showcasing our innovative transportation solution. This project involves animating a shuttle moving through a tube, aiming to revolutionize how people and goods travel. The animation will serve as an introduction to our invention to the general public, highlighting its unique features and benefits. *Requirements:* - Experience in creating engaging animations, preferably with a portfolio showcasing similar projects. - Proficiency in Blender, as the models for the shuttle and environment are pre-designed and available in Blender format. - Ability to convey the concept of futuristic transportation vividly and convincingly to a general audience. - Creativity in animation to ensure the final video is intri...
...User Dashboard templates. Key requirements: - Installation of Laravel + Vue app: As I've already purchased the app from CodeCanyon, I need help with setting it up on my hosting. This includes ensuring all necessary files are correctly placed and the app is running smoothly. - Admin & User Dashboard Setup: The Laravel + Vue app comes with pre-built dashboard templates for both admins and users. I need these templates to be fully functional and integrated with the app. In addition, I might need to make some basic modifications to the dashboard layouts. Ideal skills and experience: - Proficient in Laravel & Vue.js: Strong knowledge of these frameworks is essential for setting up and customizing the app. - Experience with dashboard template...
I'm in need of an experienced data entry specialist who can assist in uploading 850 products onto my online store. You will be provided with the necessary product information (description, price, specifications) in the format of Excel/CSV files. Your tasks will include: - Accurate data input of all relevant product details - Verification and correction of any existing data entries - Ensuring all listings are in sync with their corresponding inventory Ideal Skills: - Experience in data entry, particularly e-commerce product listing is preferred - Proficiency in Excel - Attention to detail and accuracy are extremely essential - Fast typing speed with a keen eye for details. Please only bid if you have relevant experience, and can start work promptly.
I'm looking for a professional who can assist me with the typing of my novel manuscript. Your responsibilities will include: - Accurately typing out my novel - Formatting the typed content into an e-book format The ideal ...my novel manuscript. Your responsibilities will include: - Accurately typing out my novel - Formatting the typed content into an e-book format The ideal freelancer for this job would be experienced in: - Typing - MS Word - Excel calculations - E-book formatting Having an RS-CIT certificate would be a major plus. The ability to pay close attention to detail and produce error-free work is paramount. Experience in typing and formatting novel manuscripts is highly preferred. Finally, quick turnaround time is necessary for the successful completion o...
Project Overview: I am seeking to have a custom Google Sheets system created for a group within a GTA V roleplay server. Our group imports special items for other groups, and we need an efficient way to manage these transactions. Requirements: Main Sheet: Buttons: Treasury Deposit/Withdrawal: A button that, when clicked, presents a dialog or an input field directly on the sheet to enter the deposit or withdrawal amount. Shipment: A button that allows users to input the following details: gangName memberName itemOrdered itemQuantity weightUsed currentWeight weightAfter orderedBy Automatic calculation of the total weight and price for each item (a list of items, their prices, and weights will be provided). TreasuryDB: A dedicated sheet to track all deposit and withdrawal transac...
I'm looking for an experienced freelancer who can create an Excel calculator for historical cryptocurrency prices from Binance and Luno. The calculator should also include fiat exchange rates for major currencies such as ZAR/USD bank sell rates Key Requirements: - Retrieve historical price data from Binance and Luno - Incorporate USD, and ZAR exchange rates - Organize the data and create user-friendly interface - Ensure accuracy and reliability of the calculator - Prioritizing the preservation of data privacy Ideal Skills: - Proficiency in Excel and data manipulation - Familiarity with cryptocurrency exchange APIs - Knowledge of major fiat currency exchange rates - Strong analytical and problem-solving abilities Please include your relevant experience in...
... features, pdf (data sheet), warranty information, stock (available quantity), sale prices etc. can be uploaded directly through portal and mobile app and also can be uploaded through excel sheet with serial number of all products. 4. Customer can see all the uploaded products and can request for quotation. There is no need to show the available quantity (stock) to customers. 5. Admin can see the requested quotes where the prices and quantity will be reflected of all the products in quotation. Admin can edit the prices manually and can share and download the requested quotation to anyone. 6. Admin can create multiple sub admins and can assign different rights to them as he wants. 7. After approval of the quotation of the customer, he can place the order and unique order i...
I would like to see the result statistic in %. Important, when i refresh the excel i always want to see the last 5, last 10 and last 15 results.
I have an excel file, need add product categorie on a column - budget 100€
Project Description: We are seeking a skilled Java developer to contribute to the development of an e-commerce platform (basic) with the following key features: User Management: Implementation of user accounts with basic profile information (name, email, password). Product Management: Creation of a product listing functionality with basic product details (name, description, price, category, etc.). Inclusion of at least 100 sample products for demonstration. recommendation system: Generate recommendations based on simple rules and user behavior. For example, you can recommend products that are popular among other users, products in the same category as the ones the user has viewed, or products with similar price ranges. Store and update user view history in the database. Display rec...
Hello, Looking for someone to create video ads from a mobile game, you will need to play the game, get footage from and then give me 5 horizontal video and 5 vertical ads each video needs to be between 15-30 seconds long If you understand that you need to create everything from scratch and can do it in a short time frame please type GREEN at the beginning of your proposal. Proposals without it will be ignored.
...Microsoft Excel. Key Responsibilities: - Data Cleaning: The dataset includes multiple columns and rows that need to be checked for inconsistencies, errors, and duplicates. - Data Analysis: After cleaning, I need the freelancer to perform basic data analysis to extract meaningful insights from the dataset. Ideal Skills: - Proficiency in Microsoft Excel and experience with data cleaning and analysis. - Attention to detail to ensure the dataset is thoroughly cleaned. - Basic data analysis skills to interpret the dataset and present the findings in a clear manner. Please note that the project does not require any specific tools or methods for analysis, but any experience with Pivot Tables, Statistical Formulas, or Macros/VBA would be an added advantage. If you ar...
I need a website dashboard centered around trip/job logging. Key requirements include: - Bootstrap 5.3+ - Integration with OEMServer (Digital matter) - Vehicle tracking and historical route logging Beyond this, the dashboard must have a comprehensive vehicle tracking system. It must leverage GPS tracking, have the option to provide real-time location, and be capable of mapping and storing historical route, vehicle and client information to a database. The ideal freelancer for this role should have strong experience in GPS technologies, and real-time data feed implementation and developing historical route tracking and storing. The aim is for a responsive, user-friendly, and efficient website dashboard that fulfills these roles effectively.
I'm looking for a skilled machine learning professional who can help me create a simple web-based dashboard for data analysis using Python. Key Requirements: - Utilize Python for data visualization - Data to be visualized is categorical - Proficient in machine learning for data analysis Ideal Skills: - Proficiency in Python for data visualization - Experience in creating dashboards for data analysis - Knowledge in machine learning for understanding the data The dashboard should be user-friendly and easy to understand, and should be hosted on a web server for easy access. Experience in similar projects would be a definite advantage.
Project Description: We are seeking a skilled Java developer to contribute to the development of an e-commerce platform ( A BASIC DESIGN ) with the following key features: User Management: Implementation of user accounts with basic profile information (name, email, password). Product Management: Creation of a product listing functionality with basic product details (name, description, price, category, etc.). Inclusion of at least 100 sample products for demonstration. recommendation system: Generate recommendations based on simple rules and user behavior. For example, you can recommend products that are popular among other users, products in the same category as the ones the user has viewed, or products with similar price ranges. Store and update user view history in the database....
fichier sur Excel reproduire le même identique sur Excel avec calcul automatique
Hello, I need complet the Amazon categories catalogue excel in french
...multiple choices for the boxes. Parents can select the school and timings through dropdown menus. We receive the details on our dashboard and print stickers to be pasted on the boxes. Currently, we are facing issues with obtaining accurate order details, leading to mismanagement and manual intervention. We also want to integrate a monthly subscription feature for parents. The ideal candidate should have a strong understanding of PHP and be able to create clean, efficient, and scalable code. As a PHP Developer, you will be responsible for implementing new features, improving existing functionality, and ensuring seamless integration. This is a fixed-price project with a very tight deadline and budget. We need someone who can complete the work within 3 days. You will...
Our project aims to enhance the Django website running on Ubuntu by addressing several key issues. We will streamline Google registration, fix email registration to avoid redundant data requests, and update the logo. We'll verify email confirmation, resolve logout errors, and ensure the machine names display fully. We'll adjust font sizes, reorganize dashboard boxes, correct console errors, and fix icon colors. Additionally, we'll refine machine information display, adjust button states, and update dropdown menu functionality. Finally, we'll correct API settings visibility and fix data display issues on the profile page and other sections.
I'm in need of a freelancer with a high level of proficiency in Microsoft Excel to use conditional formatting over different tabs to help visualize duplications in large sets of numerical data. Ideally, you should not only be skilled in Excel, but also possess a keen eye for patterns and detail. Your job will encompass: - Applying conditional formatting across multiple tabs. - Highlighting duplications in numerical data. - Ensuring easy readability and understanding of the data presented. An understanding of data visualisation techniques would give you a competitive edge for this project. This task will require a close attention to detail and a strong understanding of Excel's conditional formatting tools.
I have a small dataset of less than 1,000 rows that requires both data cleaning and formatting. Additionally, I need assistance with data analysis and visualization. This is a one-time project, and I am looking for a skilled individual to handle this for me. Ideal Skills and Experience for this project: - Proficiency in Excel is a must. - Experience with data cleaning and formatting. - Ability to perform data analysis and create visualizations. - Attention to detail and an eye for accuracy.
I have an Excel file with a macro that I need to be updated for compatibility with Excel for Mac 2019 or later. The current macro's compatibility with macOS is unknown to me, and I need an expert to assess and modify the code as needed. Key Requirements: - Update the existing macro for compatibility with Excel for Mac 2019 or later. - Ensure the modified macro functions correctly on a MacBook Pro 2018 intel OS Ventura. Ideal Skills and Experience: - Proficient in Excel VBA and macros. - Extensive experience in adapting macros for cross-platform compatibility. - Knowledge of macOS compatibility issues with Excel macros.
I want to make a Incentive structure in the attached excel. I am paying incentive to my staff. I have different types of incentive policy Each Incentive calculation is starting from the month "m" It will be accumulated and the Incentives will be paid on every month of "n" The process will start again and will repeat again. This process will depend upon the value that I am putting in the cells of "m" and "n". You have to correct the formula I have given in the sample or you can make a new formula
I have a small project that requires the entry of structured text data. The project will involve: Ideal candidate would have a strong attention to detail, excellent organizational skills, and a background in data entry. Experience with structured data formats is a plus. This should be a fairly quick task, but accuracy is key. I will share you more details in via chat box. Thanks
I'm looking for a skilled developer to assist with syncing an Excel file to my phpMyAdmin database. Key Requirements: - Real-Time Syncing: The sync should take place continuously in real-time. Any updates made to the Excel file should be reflected in my phpMyAdmin database instantly. Skills and Experience: - Proficient in Excel and phpMyAdmin - Experience in data syncing and database management - Familiarity with real-time data syncing No specific data validation or transformation is needed during the import process. The goal is to ensure that any changes made in the Excel file are accurately reflected in the existing database.
We have diagrams for the cars. We want someone who can create a database of where we can find the analog fuel sensor wire under the dashboard. Project is for 1000 cars and can be long term.
...industry, dealing with bathroom & kitchen products. I need freelancers who are based in Malaysia and based in City if Kuala Lumpur and Town of Cheras Key Responsibilities: - Data Entry & Report Writing: You would be handling data entry tasks & writing report and (you only need to direct report to me so simple communication) - Task Management: Utilizing software such as Trello, or Microsoft Excel to keep track of tasks and deadlines. Ideal Skills and Experience: - Experience as a virtual assistant or in administrative roles is a huge plus. -Experience in wiritng report will be added advantage - Proficiency with task management tools and software. - Excellent organizational and time-management skills. - Strong communication skills - you should be comfo...
...developer to create an admin dashboard for an e-commerce site. This will involve managing callback values for various e-commerce events such as sales, cancellations, and renewals. These values need to be stored in a MySQL database. Additionally, email notifications need to be sent to both the admin and users, triggered by specific e-commerce events. Key Requirements: - Develop an admin dashboard for managing callback values - Utilize a MySQL database for storing the callback values - Implement a system for automated email notifications upon e-commerce event triggers Skills & Experience: - Strong proficiency in MySQL - Extensive experience in e-commerce site development - Proficient in creating admin dashboards - Skilled in implementing automated email notific...
I am looking for a skilled and experienced professional who can render detailed plans and elevations for my residential construction project. Your task will involve: - Preparing construction drawings that effectively communicate design intent. Your work should be easy to understand and facilitate the building process. - Providing comprehensive plans that can be used for obtaining necessary permits. Your understanding of local building codes and regulations will significantly contribute to the project's success. - Ensuring these detailed drawings can be used for accurate cost estimation. Your background in architectural design or civil engineering, coupled with proficiency in CAD software, will be extremely beneficial. Experience in residential construction projects is a must...
I'm looking for a talented graphic designer to help me establish my brand with a minimalist approach. The project involves creating a logo and designing a matching theme for my upcoming website. Our website domain is - not yet online. The business is going to be called Daily Brewers. We will sell high end boutique coffee equipment. Key Deliverables: - A unique, memorable logo that embodies my brand - A website theme that complements the logo and reflects the minimalist style Things to Consider: - Please note that I have not finalized a color scheme. I'm open to hearing your suggestions on colors that could enhance the minimalist style. - I'm particularly interested in a modern and minimalist aesthetic for both the logo and the website theme. So, your portfolio sho...
I'm seeking a prof...main responsibilities will be: - Data Cleaning & Preparation: This includes cleansing the data from any incomplete records, duplicates or errors. - Statistical Analysis: You'll need to conduct a thorough statistical analysis of the data, utilizing regression analysis specifically. The project will involve various types of data including numerical, categorical, and textual data. Since we'll be working in a professional environment, knowledge and proficiency in MS Office is a must. This includes Excel, PowerPoint, and Word. Ideal candidates should be well-versed in data analysis and have a strong statistical background. Proficiency in using MS Office is also a key requirement. Previous experience handling numerical, categorical, a...
I'm in need of an Excel macro expert who can help me with a data arrangement task. The task involves transferring sequences of cells data from one grouped workbook to multiple original workbooks and worksheets. The data transfer should be based on specific criteria. Key Requirements: - Data transfer based on a specific criteria: The macro should transfer data based on a specific criteria. This involves arranging the data from the grouped workbook into different cells in a column in the original workbooks based on predefined conditions. - Conditional Logic: The macro should include conditional logic. This means that the data transfer should not just be a simple copy-paste operation, but should involve logical conditions for accurate and efficient data arrangement. - Potential...
...design and analysis - Conduct initial thermodynamic analysis, heat transfer, and 3kW power calculations - Identify key components and materials Second 10 hours: - Create preliminary design of the engine layout (drawings or sketches) - Develop preliminary design/placement of key components (e.g., pipe, valves, evaporator, condenser) Deliverables: First 10 hours: - Design Report (5-10 pages): - Overview of the design concept - Thermodynamic cycle analysis (calculations and spreadsheet; Excel/OpenOffice Calc) - Heat transfer calculations and assumptions (calculations and spreadsheet; Excel/OpenOffice Calc) - Fluid flow, power, and pressure drop (calculations) - Summary of Findings (1-2 pages) Second 10 hours: -CAD...
Provide: 1. French and 2. German translations for the static strings used on a website. I've compiled a list of all the static strings on a website. A native French speaker and a native German speaker are needed to update the Excel file attached with the translations from: 1. English to French and 2. English to German Thank you!
...designer with a knack for crafting captivating online experiences? Join us in shaping the future of Rush Rooms! **About Rush Rooms:** Rush Rooms is a cutting-edge platform revolutionizing the rental industry, offering seamless experiences for renters and hosts alike. Our mission is to provide a modern, convenient, and trustworthy platform for anyone seeking or offering rental accommodations. **Project Overview:** We are seeking a talented freelance web designer to develop dynamic landing pages for Rush Rooms. These landing pages will serve as the gateway to our platform, showcasing its features, benefits, and offerings in an engaging and visually appealing manner Also ability to contact us. Key Requirements: - Stunning Design:Create visually stunning landing pages wit...
...professional who help finish a custom Tableau dashboard. Key Requirements: - The dashboard will display custom data. - The dashboard should have data filters that allow users to interact with the data, specifically in the form of dropdown menus. - Charts should be easy to understand and navigate. Ideal Skills and Experience: - Proficiency in Tableau: The ideal candidate should have a strong background in creating Tableau dashboards with complex data sets and interactive elements. - Data Visualization: A good understanding of how to present data in a visually appealing way is crucial. The ability to communicate complex data effectively is a plus. - User Experience (UX) Design: A good understanding of how the end user will interact with the dashboard is key....
I'm looking for an experienced full-stack developer to build a custom admin dashboard for a Flutter app backed by Firebase. The dashboard should have a clean, minimalist design and robust functionality to manage the platform. Core Features: - Firebase Integration - Comprehensive Data Visualization - Content Management (Articles, Quizzes, Categories) - Feedback Management - Notification System (In-App, Push) Other Key Features: - Secure Admin Authentication - User Management (Roles, Permissions) - Content Packaging & Distribution - Content Localization - Import & Export Functionality - Settings & Integrations - Security & Compliance - Performance Monitoring & Optimization The ideal candidate should have: - Proven experience developing admin dash...
I have a project that entails exporting contacts from one database and merging them in a particular manner. Here's what I need: • Transferring data between databases -- changing to a new program • Combining the Excel rows into a single cell. Only the address, city, state, zip into one cell. Name, phone, email will stay separate. • The final format for the merged data should be in CSV. Ideal skills and experience required for this project include extensive knowledge about Excel functionalities, CSV formats, and database management. Previous experience with contact data transfer and merging will be highly appreciated. Let me know if you've done similar jobs in the past.
I have a project that entails exporting contacts from one database and merging them in a particular manner. Here's what I need: • Transferring data between databases -- changing to a new program • Combining the Excel rows into a single cell. Only the address, city, state, zip into one cell. Name, phone, email will stay separate. • The final format for the merged data should be in CSV. Ideal skills and experience required for this project include extensive knowledge about Excel functionalities, CSV formats, and database management. Previous experience with contact data transfer and merging will be highly appreciated. Let me know if you've done similar jobs in the past.
...current process excel files will be given aswell as the detailed process) Request Submission: Teams within the company fill out an Excel file with transport details, including pickup location, destination, size, and weight of the shipment. Courier Selection: The logistician identifies 3 or 4 potential couriers from a database based on the transport's distance, size, and location. The logistician contacts these couriers via Outlook to inquire about availability and pricing. Selection and Confirmation: Upon receiving responses, the logistician selects the best courier based on price and availability. The logistician fills out an order form in Excel, converts it to PDF, and sends it to the chosen courier to confirm the shipment. Automate File Transfer Based on...
