How to create a macro in excel 2016 jobs

I'm seeking an Excel expert to create a macro that automates repetitive tasks, specifically data formatting. The primary focus will be on automating conditional formatting. Ideal Skills and Experience: - Proficiency in Excel - Experience with creating macros - Understanding of data formatting - Expertise in conditional formatting - Ability to deliver a user-friendly solution Has a lot similar automation requests, looking for long term cooperation. Details： please see attached files- 1. Column K --> Cargo Control Party Name: Kmart 2. create Column V: Vsl Voy IB 3. match Column U: Outgoing SVVD --> Column V: Vsl Voy IB with the data in (columnA,B --> column C, F )

Hello, i would like for you to create a design of how our bathroom would look like. It has to be clean, modern, and very catchy since we want people to love taking pictures inside of it. We are a Mexican Restaurant. Picture 1.- The door. The design of the door needs to be more sober since it has to be harmonious with the current floor and walls. Picture 2.-Design for back wall, the second picture is a wall which is behind a mirror, so we would like something very catchy so that people love taking pictures in that area. Picture 3.- The inside of the bathroom walls, we also need a female and male design, but you can use that picture for both since they are identical. Picture 4.- Design for wh...

I'm looking for a creative professional to help me produce an Instagram reel that is centered around music and dance, with the primary goal of entertaining my followers. The video should use trending songs to capture attention and engage viewers. Key Requirements: - Experience in video production and editing for Instagram - Good understanding of current trending songs and dance moves - Creative and humorous approach to video content Please reach out if you can help me connect with my audience in a fun and engaging way.

Job description Role: Amazon Ecommerce Assistant Are you passionate about e-commerce and digital marketing? Do you have previous experience in managing Amazon accounts? We are a leading organisation in the industry, seeking a dynamic and results-driven individual to join their team as an Amazon Ecommerce Assistant. As the Amazon Account Executive, you will play a crucial role in supporting the management and development of our business relationship with Amazon. Your main focus will be to optimise content, manage the product catalogue, and implement effective promotional plans. If you are ready to take on this exciting challenge and work with a team of driven professionals, then this is the perfect opportunity for you...

I'm looking for a freelancer who can help me create a personalized fake Snapchat log for personal use. This log should include a comprehensive chat history, as well as a realistic friend list and snap streaks to enhance its authenticity. Key Requirements: - Design a fake Snapchat log that looks genuine - Incorporate a detailed chat history - Create a believable friend list - Include snap streaks Ideal Skills: - Proficiency in graphic design or similar fields - Understanding of Snapchat's interface and features - Creativity and attention to detail I need a specific script with specific bit mojis made off a Snapchat page

I need assistance to extract data from a PDF document into an Excel spreadsheet for 200 organisations. The data includes organisation names, emails, telephone numbers, and postal addresses. Key Requirements: - Proficient in data extraction and Excel - Previous experience working with PDF files - Attention to detail to ensure data is accurately transcribed It is essential for the freelancer to have the ability to carefully transcribe the information from the PDF to the Excel spreadsheet without errors.

I'm looking for an Excel expert to create a training management sheet for me. Features of the Excel sheet should include: - Tracking of employee details - Logging of training topics - Scheduling and recording of training dates The primary use of this Excel sheet will be monitoring progress of employees throughout their training. Therefore, the sheet should be designed in a way that makes it easy to track individual progress and overall training effectiveness. Ideal skills for this job include: - Advanced Excel skills (formulas, pivot tables, data validation) - Experience in creating training or attendance tracking sheets - Understanding of training program metrics

I'm looking for an experienced professional to assist with reconciling my business bank account using Microsoft Excel. This task involves reviewing deposits, withdrawals, and transfers. Key Responsibilities: - Bank Account Reconciliation: You will be responsible for ensuring all transactions are accurately recorded and accounted for. - Invoice

We need to have the 2024 Rate card converted to an Excel sheet. They have discounted rates by 12.5% for Platinum Winter and 15% for Gold Winter, as shown in a column.

Create a logo for "Horeca Club", an exclusive club for gastronomical restaurants. Black and white is preferred. We are open to explore all styles Name: Horeca Club Colors: Black and white Styles: Open to all Prize: Guaranteed to the winner

Create a Realistic Photo of Mother Holding Baby Description: I am looking for a skilled graphic designer to combine two separate photos—a mother and a baby—into one realistic image where the mother is holding the baby. The final result must look natural, with proper blending of lighting, shadows, and skin tones. Requirements: High-quality, realistic compositing Attention to detail for proportions and expressions Final output in high resolution (JPEG/PNG + editable file) I will provide the photos. Please share examples of similar work if possible. Looking forward to your bids!

I'm looking for a C# plugin for Power BI Desktop that can help me optimize my reports. The plugin should: - Detect unused columns in tables and create M queries to remove them. - Scan all open Power BI reports and list them in a combo box for selection. - Identify all measures in the selected report and provide optimized DAX code for each. A list of these measures should also be in a combo box. My primary data sources are SQL DB and Excel, so experience with these is crucial. The plugin needs to work with both imported data and DirectQuery modes.

I have ongoing work related to our previous project 'Create flyer for a self defense workshop in dutch'

was created by React Native Expo. We recently decided to remove expo in the project. 【Task】 You help us create a build package for the Web without using expo. You will be paid after the build package deployed to the remote server and tested. You have to work remotely on my computer via【AnyDesk】

I am in need of a freelancer that can assist me with copying data from a protected Excel worksheet to a new, unprotected spreadsheet. Details: - I do not have the password to the protected worksheet - I can edit the worksheet, but cannot remove the protection - I need all data transferred from the protected worksheet to the new spreadsheet Ideal skills for this job would include proficiency in Excel, data entry, and an understanding of data confidentiality. As I cannot remove the protection, the freelancer will need to handle this task with discretion and professionalism.

...identify trends in our QI project data. This will involve working with an Excel spreadsheet sourced from Redcap data. It is a NICU breast milk QI project. Data collection includes: Mother's age, mother's race, infant gestational age, insurance type, Breast pump useMilk volume at 3 different time points, volume goal of 500ml/day, Lactation clinic appointment. Scatter plot, run plot, effects of intervention: Yes/no lactation appointment attended, and does this correlate with milk volume. Key Responsibilities: - Analyze data to identify trends related to process improvements - Present findings in an accessible and clear manner Ideal Skills and Experience: - Proficiency in data analysis, particularly with Excel - Experien...

...Description I am looking for a detail-oriented and proactive Virtual Assistant to help me manage multiple projects related to the launch of a new outdoor gym on the beach in Belize and assist with other business initiatives. If you're organized, tech-savvy, and great at keeping tasks on track, I’d love to hear from you! Your Responsibilities 1. Gym Setup & Operations: Manage the development of a professional website that accepts online payments. Research and recommend a point-of-sale system for an outdoor, beachside setup. Assist with equipment research and project management to ensure gym construction stays on track. Help source and coordinate with contractors, designers, and vendors. 2. Branding & Ma...

...Expert for Excel Sheet Automation We are looking for a skilled AP Script Expert to help automate processes in Excel sheets for our business. The ideal candidate should have expertise in creating, editing, and debugging Google Apps Scripts to streamline data handling, calculations, and report generation. Requirements: Proven experience with Google Apps Script for Excel/Google Sheets automation. Ability to create custom scripts to automate repetitive tasks, manage data, and enhance productivity. Knowledge of integrating third-party APIs (if needed) with Google Sheets. Strong problem-solving and debugging skills. Effective communication and ability to meet deadlines. Scope of Work: Analyze the cur...

Project Summary: Request Management System Objective: Develop a simple, user-friendly online request management system to handle different types of requests, such as maintenance and purchase requests. The system should include role-based access control, approval workflows, and basic analytics. Key Functionalities: User Management & Authentication: Users can register and log in with roles: Requester (can submit requests) Department Manager (can approve/reject requests) Engineering Manager (final approval and assignment) Passwords should be securely stored (hashed). Session-based authentication to restrict access. Request Submission: Dynamic form with the following fields: Auto-filled: Requester Name, Department, Date & Time, Sequential Request Number (...

I am looking for a creative professional to develop 20 engaging, entertaining shorts targeted at an adult audience for YouTube.

I have a project which involves processing a spreadsheet of 4100 EANs. The primary task will be identifying the SKU and size from the data. The EANs are currently stored in an Excel (.xlsx) spreadsheet. - Skills Requirement: Proficiency in Excel and data mining is essential. Experience with SKU and size identification will be a significant advantage. - Task: Extract SKU and size information from the provided EANs data. Please note, the specific SKU and size information that needs to be extracted has not yet been defined. A flexible approach and readiness to adapt to evolving project requirements will be key.

I need assistance with an Excel file. The city name is currently located in the middle columns and needs to be moved to a different column. All of the data is in one sheet. The ideal freelancer for this project should have: - Proficient Excel skills - Attention to detail - Data management experience

I'm looking for an Excel expert to help with my homework focused on analyzing scientific data. The main goal is to conduct a thorough data analysis using various statistical techniques. Key Responsibilities: - Analyze provided scientific data using Excel - Apply various statistical analysis techniques Ideal Skills: - Proficient in Excel with strong data analysis skills - Experienced in conducting statistical analysis - Familiar with scientific data sets

...of operations do you want to focus on? - Balanced scorecard (BSC) of the given company based on template -> Which perspectives do you want to include in the balanced scorecard? - Financial, Customer, Internal processes, Learning and development perspective Extended description of the task: Describe the vision, mission, goals and strategies of in Excel 1. Describe the financial perspective of the company selected in point 1), taking into account the following indicators: profitability (2-3 indicators, e.g. ROA, ROE), debt (1-2 indicators, e.g. total debt ratio), liquidity (1-2 indicators, e.g. current liquidity), cash conversion period (1 indicator) and risk management (1-2 indicators). 2. Describe the perspective of the customer select...

...who can assist me with a project focused on creating a specific web application. This involves using Visual Studio Code (VSC) and developing weekly content to complete the assignment. Key Responsibilities: - Collaborate with me in developing a web application using Java. - Implement features such as user authentication and database interaction. - Create engaging weekly content to facilitate the learning and development process. Ideal Skills: - Proficiency in Java and experience in web application development. - Familiarity with Visual Studio Code (VSC). - Experience in implementing user authentication and database interaction features. - Excellent content creation skills. - I have attached the assignment details (it...

I need a professional who can help me extract data from my Clover POS system on a daily basis. This data extraction will specifically focus on orders, with an emphasis on breaking out taxes and fees separately instead of having them lumped together as 'fees'. Key Requirements: - Data needs to be extracted daily and made available for download from a secure server. - The extracted data must be formatted in Excel. Ideal Skills and Experience: - Proficiency in data extraction from Clover POS system. - Expertise in Excel for data formatting. - Experience with secure server data handling. - Ability to meet daily deadlines. Please note, the goal is to have a detailed, clear and precise breakdown of e...

I need an Excel sheet specifically designed for conducting profit and loss analyses. The primary function of this sheet will be to facilitate financial calculations. Key Requirements: - Creation of an Excel sheet tailored for profit and loss analysis - Integration of functionalities for various financial calculations Data Entry: - All data will be entered manually, so the design should be user-friendly and intuitive for manual data input. Ideal Skills: - Proficiency in Excel - Experience in financial analysis - Ability to create user-friendly spreadsheets

...looking for a professional, engaging, and informative PowerPoint presentation on Saudi Arabian culture, targeted for a new American manager. The focus should primarily be on business interactions, but also touching on macro overview, religious customs, social norms, and other crucial aspects. The presentation should: - Be designed to fit within a 1 hour timeframe. - Incorporate infographics to make it visually appealing. - Include a selection of helpful videos at the end, providing further context and insight. I have provided some links to videos that can serve as a baseline for the content: - - - Ideal candidates for this project should have: - A deep understanding

- Using the Quincey theme, of which we have a licence for, we need 3 pages to be worked on. These are the High-level vacancies page, Individual Vacancies and Homepage. Full details of what is required for each page is included in the attachments. - We need a developer that can create a dynamic website that is not inflexible to our changing requirements. We need someone who is capable and experienced enough to understand when to hard code and when a WYSIWYG editor is the most suitable solution. - We don’t want a developer who exclusively uses WYSIWYG. - This is just a small part of the work involved to create the full website. If this work is acceptable more work will follow.

We are seeking a skilled and detail-oriented part-time Financial Analyst to assist in managing budgeting, forecasting, cash flow analysis, and cash management for our real estate and contracting business. The ideal candidate will have experience in the construction and real estate industry and be proficient in using Excel for financial modeling, reporting, and analysis. Key Responsibilities: Prepare and maintain annual budgets, revenue forecasts, and expense tracking using Excel. Analyze cash flow and ensure liquidity to meet operational needs. Assist in financial decision-making by providing insights and recommendations. Monitor project budgets and ensure financial alignment with company goals. Develop financial models to...

I'm looking for a professional tester to conduct thorough testing on my website before we go live. The testing should cover both the front-end and back-end, with all glitches and errors documented in an Excel sheet, categorized, and using Scrum methodology. Front-End Testing: - Usability testing: Assess the user experience and interface design. - Performance testing: Measure the responsiveness and stability. - Cross-browser testing: Ensure consistent functionality across multiple browsers, specifically Chrome, Firefox, and Safari. Back-End Testing: - Security testing: Identify any potential vulnerabilities. Ideal candidates for this project should have extensive experience in website testing, and be proficient in using Excel for docu...

I'm looking for someone who can create a personal blog for me with a film theme. The blog should have features similar to this: Key Features: - A comment section for viewer engagement - Social media integration for easy sharing and reaching out to a bigger audience The primary focus is to have a personal blog centered around films. The perfect candidate for this project should have a strong understanding of film, blogging, and web development. Please reach out to me if you can do this. Thank you.

I need assistance with finding product codes (SKU and size in either US or EUR and link for a proof) for 4100 EANs. The data should be sourced from Google or VERY easy because 2 /3 brands only Key Requirements: - Data processing and research skills - Experience with Excel/CSV - Ability to follow a specific format for data input I will provide the EANs in a spreadsheet (Excel/CSV) and I already have a format for the SKU and size. This is a straightforward project that requires basic data input and online research. Please be prepared to work meticulously and efficiently.

Combine meter billing and fixed monthly/yearly fee in stripe

...designer with a proven track record in creating outstanding Amazon content? We are looking for top-tier professionals who excel in designing as well as creating captivating product images and brand content, including A+ Content and Brand Stores. We are particularly interested in working with forward-thinking designers who use AI tools for bulk image generation like Midjourney, Dezgo, Adobe Firefly, and equivalents to create compelling, emotion-driven product visuals —without the need for complex photoshoots. Bonus points if you also have expertise in digitally creating product videos to enhance listings further. What we’re looking for: - Extensive experience in designing Amazon-specific content. -...

I need an expert in Excel 365 who can link two sheets for me. The first sheet should update the second in real-time. - Data Type: The data to be linked is mixed, consisting of both text and numerical data. - Version: The linking has to be done in Excel 365. Please only reach out if you're proficient in Excel and can ensure real-time data linking. Thank you.

I need a skilled Excel professional to clean up the formatting in my Excel document so that "amount" and "total" columns are formatted consistently (centered or justified to right) and ensure that existing formulas in "amount" columns calculate to amounts in "total" columns. Create formula for all "total" amounts to calculate and produce grand total at end of doc. The project involves adding new formulas ensuring that newly inserted data is added to "amount" colum that the numbers will automatically calculate and be added to the totals, similar to the setup at the beginning of the document. When in doubt please ask questions. T...

Job Title: Develop a Workflow for Scraping Global Mosque & Muslim-Based NGO Data with Detailed Documentation ________________________________________ Job Description: I am looking for a skilled automation expert to build a workflow that scrapes Google for global contact details of mosques and Muslim-based NGOs. The workflow must allow for targeted searches by category (e.g., society, charity, non-profit) and be optimized for credit efficiency in Make.com. The final system should produce structured data outputs and include clear, beginner-friendly documentation. ________________________________________ Scope of Work: 1. Automation Workflow: 1) Build a workflow to scrape Google for the following details: a. Organization Informati...

I'm seeking a talented graphic designer to create a cartoonish-style mascot for my company. The mascot should primarily convey a professional demeanor, despite the cartoonish design. The color scheme should predominantly feature cool colors such as blue, green, and purple. Ideal Skills: - Proficiency in graphic design - Experience in creating cartoonish characters - Strong understanding of color theory and professional design Please provide your portfolio showcasing similar projects you have worked on.

I have multiple Excel files that need to be consolidated into a single Excel workbook. Each file should be placed in a separate sheet named according to its original file name. No data transformations or cleaning are required. Ideal skills for this project include: - Proficiency in Microsoft Excel - Experience in data consolidation tasks - Attention to detail to ensure correct file placement and naming.

...Management System" The "Smart Company Management System" is an internet-based system that helps organizations manage all internal processes in an organized and efficient way. The system allows managers and employees to automatically track projects, tasks, reports, and progress, improving work processes and optimally allocating resources. To perform a full analysis of the system, we will review each step of the project, including a detailed description of Use Cases and system actions. In this guide, we will conduct a functional analysis for each of the processes in the Use Case for the "Smart Company Management System," describing the actions that a user will perform and the actions the system will ...

Hello, I have experience in Python, web scraping, and data extraction using tools like Scrapy, Pandas, and Selenium. I can quickly debug your script and ensure it meets all your requirements. Here’s how I plan to help you: 1. Fix bugs in your script within 2-3 hours. 2. Add functionality to match conditions and extract data as per your requirements. 3. Provide an easy-to-use script for future use. I will deliver the output in the required Excel format. Looking forward to your response so we can start immediately! Budget: $8 (as per your project description). Timeframe: First phase within 2-3 hours. Thank you,

...using my Resume # Job Description: I am looking for a reliable freelancer to submit job applications on my behalf using my resume on various platforms, like Linkedin, Workday and Indeed. Your task will involve searching for relevant job postings that match my qualifications, and submitting my resume for each opportunity. # Responsibilities: - Search for job postings on Linkedin, Glassdoor, Workday and Indeed that match my experience and skills. - Submit my resume to the job listings - Ensure each application is relevant to my background and experience. - Track and report the total number of applications submitted using MS Excel or Google Sheets # Requirements: - Strong attention to detail and understanding of different job roles. - Ability ...

I'm seeking a proficient Excel VBA programmer to create a script for my Purchase Order workbook. This project involves both an existing workbook and the creation of a new one. The VBA script should be triggered automatically when the workbook opens. Key Tasks: 1. Implement filters at the top of the worksheet. 2. Adjust the width of Column C (Products). 3. Insert new columns with specified modifications: a. After Column I: Discrepancy (using formula: =I2-H2) b. After Column J: Reason (with a dropdown list sourced from the next sheet) c. After Column K: Notes (a free text column) 4. Apply specific formatting to the columns: a. Column A: 40 points b. Column B: 10 points c. Column C: 60 ...

...experienced web developer to help us build a modern, professional, and easy-to-use website for our legal firm. We specialize in digital asset and fintech regulations, and the site will serve as both a resource hub and a showcase of our expertise. What We’re Looking For: Professional Design: A clean, polished, and user-friendly design that reflects our credibility and expertise. Service Pages: Clear and detailed sections to highlight our Web3 and fintech legal services, tailored for businesses, startups, and individuals. Jurisdictional Guides: Interactive, easy-to-navigate guides on digital asset regulations across different regions, helping visitors quickly find what they need. Macro Legal Compliance: A...

I'm seeking a skilled Excel programmer to create a macro. This macro should compile various employee data from different sheets into a new Excel sheet. The task involves data cleaning, analysis, and report generation. Key Requirements: - Experience in Excel macro development - Understanding of data cleaning and analysis - Ability to generate summary reports, pivot tables, charts and graphs - Familiarity with handling employee data Please note, the goal is to create a macro that can automate this process, saving time and ensuring consistency in data compilation.

I'm looking for someone to create several spreadsheets that display various financial metrics related to shipments of multiple grades across different countries. The sheets should track specific details for each shipment and highlight key insights. Ideal Skills: - Proficient in Excel or equivalent spreadsheet software - Strong understanding of financial data - Ability to visualize data clearly and concisely Specific Requirements: - Track shipment dates - Monitor product grades - Keep a record of destination countries - Provide an overview of which grade has moved the maximum - Include quantities and other relevant data - Need charts and graphs to represent the data as well - Pivot tables and more. These spreadsheets will be i...

I'm seeking a professional with extensive experience in cybersecurity and data analysis to build a consolidated vulnerability report and accompanying dashboard. Requirements: - The report should encompass network, application, and database vulnerabilities. - The final report should be delivered in Excel format. - The dashboard should visualize: - Vulnerability trends over time - Severity of vulnerabilities - Overview of affected systems Ideal Candidates: - Proven experience in cybersecurity. - Proficient in data analysis and Excel. - Previous work with creating security dashboards is a plus.

I need a skilled Excel expert to perform a Chi-Square Analysis on my survey data for a school statistics project. The main focus of this project is data analysis. Please have a strong background in statistics and Excel, with prior experience working with survey data. Your understanding of Chi-Square Analysis is crucial for the success of this project.

I need a skilled Excel expert to perform a Chi-Square Analysis on my survey data for a school statistics project. The main focus of this project is data analysis. Please have a strong background in statistics and Excel, with prior experience working with survey data. Your understanding of Chi-Square Analysis is crucial for the success of this project.