Excel macro to merge cells based on condition jobs
...looking for an expert to assist in creating a dynamic Power Bi dashboard. This job should revolve around integrating data from Excel spreadsheets and designing a variety of data visualizations. Key Responsibilities: * Guide me in creating the dashboard on my company account. * Connect the Power Bi dashboard to Excel spreadsheets as the primary data source * Develop compelling data visualizations using pie charts, line graphs, and bar charts * Configure the dashboard to refresh data on a weekly basis Ideal Candidate: * Strong experience with Power Bi and data analysis * Proficient in handling Excel data * Expertise in creating different types of charts * Ability to work with time-based data refreshing schedules ...
Seeking freelancer in Portugal (preferably in the Arganil reg...in Portugal (preferably in the Arganil region) Are you a proactive multitasker based in Portugal, near Arganil, looking for flexible work opportunities? I am in search of a dynamic freelancer who is fluent in both Portuguese and English to assist with various tasks. Long term work, short tasks every now and then. Responsibilities include: Researching local companies and products Making phone calls Occasional site visits as required Stable internet connection for remote tasks Requirements: ✔ Fluency in Portuguese and English ✔ Reliable internet and phone communication ✔ Access to a car and a valid driver's license I offer a fixed hourly price of 8 euro per hour, but I am open to discuss ...
...transaction monitoring system that leverages AI technology to enhance my fraud detection capabilities. Key Features Required: - Real-time monitoring: The system must be capable of monitoring transactions as they occur, allowing for immediate action if unusual activity is detected. - Pattern recognition: The ability to identify and flag patterns of potential fraud in transactions. - Alert notifications: The system should send out alerts to designated parties when suspicious transactions are identified. - User authentication: Strong user authentication processes to ensure that the system is secure and only authorized personnel can access and modify it. - Dynamic profiling: The system should be able to create and modify dynamic profiles for each user ...
I am looking for a professional developer to create a comprehensive real estate website using React. As the client has not specified a particular function, it is anticipated that the website will provide common real estate features such as property searches, property listings, and a contact form. Moreover, the website would ideally cater to a range of purposes, from displaying property listings to generating leads and providing company information. Ideal Skills and Experience: - Proficiency in web development with React - Past experience in real estate website creation - Understanding of lead generation mechanisms - Strong aesthetic sense for creating intuitive, user-friendly design What to Include in your Application: - Samples of past work, especially of pr...
I need a proficient Python expert to scrape recipes from a designated website to an Excel sheet. The project needs to be completed as soon as possible. You can use this open-source working scraper Key requirements: - Scraping recipe information (name, ingredients, cooking instructions, nutrition facts) from a specific website. - Outputting the scraped data in a well-organized Excel sheet. Ideal skills for this project include: - Proficiency in Python for web scraping. - Familiarity with scraping data from websites. - Excellent organizational and data management skills for outputting the data in Excel. If you can deliver this quickly and efficiently, please feel free to bid.
...developer or development team to transform our Excel workbook into a dynamic subscription-based web application. This workbook is integral to the operations of multiple educational institutions, featuring data management, automated calculations, and reporting capabilities. Project Goals: Seamless Transition from Excel to Web: Convert all functionalities, including complex formulas and VBA macros, from the Excel workbook into a web-based application. Robust Subscription Management: Develop a modular subscription system that allows for easy updates and the addition of new features. Future-Proof Architecture: The application should be built with scalability in mind, allowing for easy modifications and enhancements without disrupting...
...into a dilapidated state and I am looking to completely transform it into a modern style while preserving its coastal charm. Key Renovation Aspects - Interior Remodeling: The interior space of the house, which stands at 1300 sq ft, requires a full overhaul to bring it up to modern standards. This includes but is not limited to, flooring, walls, ceilings, and fixtures. - Exterior Painting: The exterior of the house will need a fresh coat of paint to restore it to its former glory and protect it against the elements. - Kitchen Renovation: A complete modernization of the kitchen is necessary to make the space functional, efficient, and aesthetically pleasing. - Structural Repairs: The dilapidated condition of the home necessitates so...
We need to create a web-page for an FX Currency Exchange. Its very comfort because we dont have to link any API or use a hard coding skills. We need the project have very good visuals looking for atract clients. All its made via WORDPRESS We going to bring admins acces to the wordpress project to let the editors make any change as they want. Remember the base of the project has to be the same as the websites examples.. Some examples:
...in immediate need of a dedicated and dynamic Virtual Assistant to support my growing needs. The ideal candidate will be someone who thrives in managing multiple tasks efficiently and possesses a keen eye for detail. Your main responsibilities will include: The budget is 100 USD a month. ( 6 hours a day, 6 days a week ) - Managing my emails with the utmost discretion and organization. - Scheduling appointments, ensuring I never miss an important date. - Conducting data entry tasks with accuracy. - Performing internet surveys to gather valuable information for projects. - Preparing ad-hoc reports based on collected data and research. Required Skills and Experience: - Proficiency in Microsoft Office Suite, especially in Excel, Word, and PowerPoint. -...
I need an Excel expert to help me with my spreadsheet. My spreadsheet has some formula errors that need to be fixed. The spreadsheet is not very complex; it mainly contains simple formulas and calculations. Ideal skills for this job: - Strong understanding of Excel formulas - Experience in fixing formula errors - Attention to detail After the fixes, I plan to use the spreadsheet for daily operations. I need help to fix the column titled "Total Shifts" and the row titled "TOTAL" - Both of these are not calculating the correct numbers when a selection is made from the dropdown lists in the table. I also want a report creating which will tell me how many of each shift type in that week the employee has done i.e if they h...
I'm seeking a seasoned C++ programmer who can design an array-based heap effectively. The purpose of this project is to handle both max heap and min heap. Here are my specifications: - Implementation of the max heap and min heap within the same array-based heap structure. - The software should be able to execute both Insertion and Deletion operations. - It should facilitate Heapify operation, enabling the optimization of the heap structure. If you possess extensive knowledge and experience in heap data structures and can proficiently utilize this in C++, you are the right fit for this task.
...developer to create a mobile application tailored for airport transfer drivers. The primary function of this app is to assist our drivers in collecting proof of customer no-shows. The app must include the following features: - GPS location tagging: The app should be able to capture and store the precise location of the driver when a photo is taken. - Date and time stamping: Each photo taken should be automatically stamped with the current date and time. - Picture capture functionality: The app should provide an intuitive and user-friendly interface for capturing images. It is crucial that the app also includes a secondary functionality for flight tracking. The app should be able to link to flight schedules, write the time and date of a passenger'...
...an entrepreneur in the boutique industry, I'm looking for an experienced business plan writer to craft a comprehensive plan that appeals to a general audience. Specific knowledge or experience within the boutique or retail sector would be highly beneficial for this project. The business plan should be well-structured and contain all the necessary elements, including but not limited to executive summary, company description, market analysis, organization & management setup, product line, marketing & sales, and financial projections. Ideal Skills & Experience: - Proven track record in business plan writing - Knowledge or direct experience in boutique/retail industry - Understanding of both macro and micro market dynamics - Experience in stru...
...seasoned developer well-versed in C# and Selenium to create a bot to facilitate automation on Facebook Marketplace. The bot that I'm envisioning would need to perform the following tasks: - Can use multiple accounts, log into several accounts to enter automatic Facebook marketplace listings or Facebook group posts, logged in accounts are saved and can be opened without re-entering the password - Autopost Facebook Marketplace Create Product Title, product description, Product Category, Product Condition, location and product price range, Product Availability, Product Label / Keywords can be separated by commas, SKU Only We Can See. After inputting, you can automatically select a location, especially for the Indonesian region. - Can upload a...
...zeolite 13X. Scale up a CO2 capture system from a small-scale experimental study detailed in the attached research paper to an industrial application focusing on a flue gas stream solely made up of CO2 and N2. This comprehensive investigation can be based on specific equations, data, and parameters that will be provided from a relevant paper. Duties and Responsibilities: - Understand the Base Model: Analyze the experimental study to grasp foundational models and calculations. - Industrial Sensitivity Analysis: Utilize any effective method to scale up these findings to industrial levels. - Use MATLAB, Excel, or any other tool to conduct a detailed sensitivity analysis based on the equations given - Document ea...
Excel Automation of my project and data visualization
I'm in need of an Excel expert who can assist me with data analysis, formulas, and data visualization. The project involves working with a dataset of medium size, specifically, between 1,000 - 10,000 rows. Key requirements for this role include: - Strong understanding of data analysis: The ideal candidate should have a proven track record of analyzing data, preferably in a business context. - Proficient in formulas and calculations: You should be very comfortable with advanced Excel formulas and calculations. - Data visualization skills: The ability to present data in an easily understandable and visually appealing way is crucial for this project. Specific functionalities and tools that need to be utilized include: - Pivot Tables: You will be required ...
Need a solution A barcode app to print and track our inventory. (Barcode&QR desirable)Online - Webbased. ProductCode/SupplierCode/Category/SubCategory/Batch/Colour/Size/Expiry/Selling PriceA/X/X/X/X/X/XX/XX/XXXX/XXXXXX.00Item description must print on the lable More details: We wish to use this app to count our inventory using bar code scanners Also when items are placed in a box to transfer between two shops, we need it to be able to use the scanner and count accuracy. Is this project for business or personal use? For an existing business What information should successful freelancers include in their application? Experience How soon do you need your project completed? ASAP
I need assistance with a one-time data entry task into Microsoft Excel. The volume is less than 100 entries. Ideal Skills: - Proficient in Microsoft Excel - Attention to detail - Strong data entry skills Please note that the data needs to be accurately entered and organized in the Excel sheet. The project shouldn't take more than a few hours for someone with good data entry experience.
...data processing to build an automated pipeline for creating AI images. The successful candidate will be responsible for developing a complete solution that includes trend analysis, automated prompt generation, integration with image generation APIs (such as DALL-E, Stable diffusion and MidJourney), backend infrastructure setup, and frontend design. Responsibilities: Trend Analysis: Implement a system to analyze and extract trends from Google searches stored in an Excel file. Prompt Generation: Develop an automated system to convert trend data into creative prompts suitable for image generation APIs. API Integration: Connect with external APIs like DALL-E or MidJourney to generate images based on the automated prompts. Backend Development...
Physical testing is to automated where test paper to be conducted online on computer lab. a Software is to be required for this purpose which has following functionality : 1. Preparation of Question bank (MCQ as well as descriptive.) 2. Preparation of Question paper based on question bank (questions to be selected randomly according to the weightage, level of difficulty etc.) 3. Showing result of MCQ part. 4. result preparation etc.
...software developer to create a comprehensive solution for organizing and managing computer-based tests. Key Features Needed: - User Registration and Login: The software should allow for the creation and management of user accounts. - Question Bank Management: It needs to support the management of a database of test questions. - Test Scheduling and Timer: The software should also provide scheduling for tests and a timer feature for exam sessions. - Setting of Question Paper: The system should have a feature to set up question papers for each test. - Intuitive GUI for Examinee: A user-friendly graphical interface for test takers. - GUI for Result Preparation: Additionally, a graphical interface for staff to prepare and analyze results. Platform Compati...
...for a data expert to merge two sets of data from Excel spreadsheets. The combination should be based on a unique ID field that is generated using fields common in both datasets. Here are the key details: - Data Type: Both data sets are in Excel format. - Merging Output: The final result should be a new Excel spreadsheet. - Matching Fields: There are common fields present in the two datasets that should be used to generate a unique ID for matching. -Filter: There are records that will not be used, but they are easily identified by a unique, consistent value The ideal freelancer for this project should: - Be proficient in Excel and capable of handling small datasets. - Have experience in data merging, particularly based...
We need to create a plugin that will handle the matching of products with the specific types of cars. The types of cars are actually the combination of the following data: CarTypeId - Maker - Model - Year - RoofType Their relationship should be many-to-many, so we probably need a middle table that contains their combinations CarTypeId - ProductSKU The above is just a suggestion and additional columns or different implementations can be used. The plugin should implement the following: DATA Import: A way to import data from Excel file (example file attached). The import file might contain data for many SKUs and should overwrite the data of every specific SKU. As a result all the matching of Cars to SKUs is actually done in the Excel file. Products ...
I'm seeking a freelancer to assist me with entry-level data entry tasks in the comforts of my home. Key Responsibilities: - Handling simple data entry tasks. - Ensuring accuracy and attention to detail. Ideal Skills: - Basic understanding of data entry procedures and systems. - Familiarity with spreadsheets and online forms. - Excellent typing skills. Experience: - While I require a beginner level of experience, any past exposure to data entry tasks will be considered beneficial. Submission: - Your tasks will be submitted via email, so a good grasp of communication through this medium is important. This opportunity would be perfect for someone who's looking for an entry-level data entry role that can be completed from home.
I would like to add new features to excalidraw. When importing SVG, I would like to add a function that can accurately recognize SVG's paths and curves and change the color and border color of each object. excalidraw_official site
I'm searching for a professional well versed in Excel to help with lookup functions. I'm struggling with finding matching values and retrieving data from different worksheets in a text-based file. Key parts of this project: - Locating matching values across two worksheets - Retrieving needed text data from another worksheet The ideal candidate will have: - Strong proficiency in Excel lookup functions - Experience dealing with data across multiple worksheets - Understanding of text-based data within Excel
I have a website which requires a better pagespeed score. Right now its on 30 score for mobile and 60 for desktop. I want this to be 100 for both. Need someone that can do this with me either by modifying the website page or with plugins. I have some plugins installed but could not increase the score. Link will be shared in a seperate chat
...a. First develop a flow diagram of how the process works, from the reporting of a crime, to the eventual match/no match on the DNA database. b. Identify any conditional aspects of the process, for example if there are any stages of the process where resources only become available once the previous sample has been processed. c. Second, write out the relevant equations associated with each step of the process, and construct a formula for the overall time in system. d. Use relevant notation and write out equations using Equation Editor in Word. e. Note – the rule of thumb is that any reader can pick up your report and replicate your results by following the methods. 2. Use mean values of each parameter to construct an “average” solution. a. Unit of ...
...Registration': users should easily view and register for our classes. - 'Dance Tutorial Videos': Let our audience enjoy video content of dance tutorials from our studio. - 'Chat Room': A communication platform for users to discuss dance classes, schedules, or general queries. - 'Booking Studio Space': We have 2 dance studios for rent, users should be able to book them through the app. Registration Process: We require users to register for classes: - An Enrollment Form within the app itself - emailed to the Owner The preferred freelancer for this project must have the ability to merge these components into a cohesive, user-friendly experience. Previous experience in developing similar multi-functional applic...
I'm looking for a detail-oriented Excel expert to amend certain elements on my existing spreadsheet. Key tasks include: Data Entry Corrections: - Correcting inaccuracies in data entries. - Rectifying data location errors. Data Reorientation: - Shifting the format from a vertical to a horizontal layout specifically for data values. It would be ideal if you possess a keen eye for detail, advanced Excel skills including formulas, and a proven track record of spreadsheet data management. Experience in handling large copy-paste tasks will also be of great advantage. Due to the nature of this task, a meticulous and systematic approach will be required.
...need an expert in Excel to type data from various digital files into a spreadsheet, ensuring accuracy and efficiency. This data will be utilized for basic data analysis purposes, so it's important that the freelancer is comfortable with working on this type of data. Key Requirements: - Converting data from various digital files (PDF, Word, etc.) into an Excel sheet. - Proficient in using basic Excel formulas and functions to manipulate data for analysis. - Attention to detail and accuracy are critical for this task. Ideal Skills and Experience: - Proficiency in Excel - should be able to work with basic formulas and functions. - Prior experience in data entry or data analysis is a plus. - Strong attention to det...
I'm in need of a skilled developer to craft an AI-based firewall in a SaaS format. Features must include: - Real-time threat detection - Automated incident response - A user-friendly dashboard. The finished product will need to be hosted on a direct server. For security, it must meet these criteria: - Basic security measures - Advanced threat detection and prevention - Customizable security rules - DDOS attack prevention. Applicants with a strong background in AI, SaaS development, and cloud computing are desired, particularly those with experience in high-security IT projects.
I'm looking for a skilled developer to create a custom procurement spend analysis dashboard. This tool will help our procurement managers to efficiently track and manage our expenses. Key Data Sources: - Your primary task will be integrating data from Excel spreadsheets and purchasing data from our suppliers. This will provide a comprehensive view of our spending patterns. Key Metrics: - The dashboard should enable real-time tracking of our total spend by category. This will allow our procurement managers to identify areas where costs are higher than expected, enabling them to take immediate action. Primary Users: - The dashboard will be primarily used by our procurement managers. It should be user-friendly and intuitive, allowing for quick and ea...
I'm seeking a freelancer to assist me with entry-level data entry tasks in the comforts of my home. Key Responsibilities: - Handling simple data entry tasks. - Ensuring accuracy and attention to detail. Ideal Skills: - Basic understanding of data entry procedures and systems. - Familiarity with spreadsheets and online forms. - Excellent typing skills. Experience: - While I require a beginner level of experience, any past exposure to data entry tasks will be considered beneficial. Submission: - Your tasks will be submitted via email, so a good grasp of communication through this medium is important. This opportunity would be perfect for someone who's looking for an entry-level data entry role that can be completed from home.
Productcatalog for technical parts and for automobile car/truck parts (lighting) Do you have experience in technical parts product catalogs? Than let us know and send us via message a reference catalog from you and the price for the layout, optional add the price for automatic eding via a productlist from excel with photos to create the catalog. Send us a message with a reference catalog, maybe german language catalog or for europe with technical parts products.
Here's what I need in a potential candidate for the job: - Experience in data entry involving Text, Numbers, and Images. Adeptness in managing a wide array of data types is crucial for this project. - Proficiency in Excel. This project requires all data to be entered into a specific Excel template that I will provide. - Detail-oriented skills and accuracy are essential. The data entered should be free of errors and align with the format that I will provide. Please ensure your bid reflects your experience and capabilities in these areas. Looking forward to a fruitful collaboration!
I have an Excel sheet full of text data that I need typed up. The data is currently in a PDF file, so you'll have to extract it from there. Once the data is in the Excel sheet, it needs to be organized into tables. Key Requirements: - Data entry of text from a PDF into Excel - Organizing text data into tables in Excel Ideal Skills: - Proficiency in Excel - Fast and accurate typing - Attention to detail - Experience with data formatting in Excel Looking for someone who can complete this task in a timely and error-free manner.
I need expert help to increase the visibility of various cryptocurrency projects on social media platforms, specifically Twitter and Telegram. The ultimate target is to engage and attract between 1,000 and 10,000 new followers or members on each platform. • Job Requirements: - Developing and implementing a social media strategy tailored to cryptocurrencies. - Regular posting of engaging and informative content to attract new followers and stimulate member interaction. • Ideal Skills: - Extensive knowledge of the cryptocurrency sector. - Proven experience in social media marketing and audience growth. - Strong understanding of Twitter and Telegram, and their algorithms. - Excellent communication and content creation skills.
I'm seeking a skilled developer to create a Discord bot that interfaces with our subscription-based website. This project entails: - Assigning roles to our subscribers in our Discord server - Prompt verification of each member's subscription status - Instant removal (kicking out) of non-subscribers from the server Our website is already equipped with a subscription system. Ideally, the freelancer should possess experience in discord development and have a strong understanding of both Discord bot development and subscription-based systems. Your role will include creating a mechanism for real-time verification of subscription status to effectively manage our Discord community. Tight integration and flawless functionality are paramount to...
Do you want to convert any PDF, JPG, PNG, or image files Are you looking for any kind of document conversion or need editing in your documents, You are on the right gig. MY SERVICES: ✅ Data Entry ✅ Web research ✅ Data Conversion ✅ Copy Paste Work ✅ Excel Data Entry ✅ JPEG to Excel or Word ✅ PDF to Excel or Word ✅ Real Estate Data Entry ✅ Language Translator ✅ Microsoft Excel ✅ Microsoft Word ✅ Lead Generation If you still have any questions or want to discuss prices for a custom project, don't hesitate to contact me. WHY ORDER FROM ME?? Fast Delivery, Never Late ✔ Message me if you're unsure or have project-specific questions Thank you
I'm seeking an Excel expert to help me with data analysis, formulas, and pivot tables. I work with Excel 2019. Key Responsibilities: - I want to see the mode of payment according to date wise in report sheet according to datewise Ideal skills and experience: - Proficient in Excel 2019. - Expertise in data analysis, formulas, and pivot tables. - Experience in creating automated reports or dashboards (desirable but not mandatory). - Excellent communication and problem-solving skills.
...extract detailed information regarding the sellers on the Miravia website. Requirements: - Extracting Seller Data: The main purpose of this project is to gather information about the sellers on the Miravia platform (). This includes the shop_id shop_name Ivl1_cate_name product_number avg_price shipping_duration company_location phone_number email_address vat_number company_name shop_rating shipping_on_time % followers comments etc. I require 10,000 entries of data I require the data to be well-structured and organized into a CSV or Excel file for further analysis. Skills and Experience: - Proficiency in Web Scraping: The ideal candidate should have extensive experience in web scraping and data extraction. - Attention to Detail: Since the p...
I am in need of a simple company profile, with the key aim being marketing and promotion. My target audience are civil procurment engineers, hence placing a crucial emphasis on capturing their interest in our products and services. Your. Please merge creativity with a knack for business marketing. The profile should be more than just listing products, it should: - Clearly outline the benefits of our products and services - Illustrate why our prospects should choose us - Include compelling calls to action that will convert prospects into clients. Experience in creating company profiles and a portfolio to present would be highly advantageous.
In order to further our online presence, we’re on the hunt for an experienced SEO expert who can help us boost web traffic, improve our search engine rankings on Google, and ultimately generate more leads and sales. To give you an idea of where we're currently at, we've made minimal efforts in SEO, and we're eager to expand upon this. The desired candidate would: - Have a deep understanding of Google’s ranking algorithm - Be up-to-date on the latest SEO strategies and trends - Have proven experience in driving traffic, improving rankings, and generating leads/sales - Be based in or have expert knowledge of the Indonesian market. We're excited to see what you can bring to the tabl...
I'm in need of a professional and sophisticated text-based logo that would be suitable for both online and print usage for the brand: ESG Blueprint (our services cover all things in ESG for Businesses) search blueprint on web, click images use this as inspiration.. Key requirements: - Logo design should be primarily text-based. - The design should convey professionalism and sophistication, suiting a wide range of applications. - The final design should be versatile enough for use across both online and print mediums. Ideal skills/experience: - A proven track record in creating high-quality, professional logos. - Demonstrable experience in crafting text-based logos that are both visually appealing and versatile. - Understanding of the different design r...
I'm looking to have my utility token listed on Coin Market Cap. The token is built on the Binance Smart Chain, establishing its preeminent functionality. A complete whitepaper, illustrating the motive, design, and purpose of my token, is available for reference, conveying a clear project narrative. Ideal Skills: - Knowledge about cryptocurrency, specifically utility token - Understanding of the Binance Smart Chain - Experience in token listing on Coin Market Cap
...seeking a skilled Django developer to assist in building a SaaS platform using the SaaS Pegasus boilerplate. The platform will enable users to subscribe to and manage mobile proxies through integration with a third-party API. The core functionality will include user management, subscription handling via Stripe, and dynamic proxy management. Requirements: Strong Experience in Django: You should have proven experience with Django framework and building SaaS applications. Familiarity with SaaS Pegasus: Experience with the SaaS Pegasus boilerplate is highly preferred, as the project will be based on this framework. Stripe Integration Experience: Must have experience in integrating Stripe for handling subscriptions and billing processes. API Integration S...
I'm on the hunt for a skilled web developer to create an intuitive and captivating cab booking website using Google map embed api offering national coverage, in order to provide an unparalleled ride experience for our customers. Required features include: - Real-time tracking to enable users to monitor their rides in real-time. - An integration of multiple payment options for ease of transactions. - Prepaid solution for fraud protection. - A Review and rating system to obtain and show feedback from users. - Google map embed API for tracking , distance calculation, traffic status, ETA calculations. - Ability to handle complex fare calculations. - An automatic accept feature to streamline the booking processes. - Options to...
