Excel macro function jobs

I have 3 construction programs currently in Excel that I need to be converted into Microsoft Project. The programs are primarily focused on project scheduling and do not require resource management features. Key requirements: - Convert 3 construction programs from Excel to Microsoft Project - Create interactive Gantt charts with dependencies - No need for resource management features, just the scheduling aspect Ideal skills/experience for this project: - Proficiency in Microsoft Project - Experience in project scheduling and Gantt chart creation - Previous work in construction or similar industries would be beneficial Feel free to ask me if you need any further details.

I'm looking to have a website built that will serve as a platform to showcase our car inventory. This website is crucial for our business as it will be the central point for potential customers to peruse and get to know the cars we have on offer. Key Features: - The primary function of this platform is to showcase our car inventory. Therefore, the main focus should be on the design that will effectively showcase the cars in the best possible light. - I would like the website to have a user-friendly search and filter option. This is important as it will allow our clients to easily find the car they are looking for. - It's important that the site is designed to be responsive across various devices to ensure potential customers can access it no matter what device they are...

I'm looking for a detail-oriented researcher to help me gathe...charts can come later. Time is critical - ideally 24 hours. - Sector-wise breakdown: I am particularly interested in the finance/investment sector. Hence, your role will be to provide in-depth insights into the investment figures within this sector. Ideal candidate should have: - Strong research experience - Experience in economics or finance - Ability to analyze & interpret data - Proficient in Excel or data analysis tools - Access and experience with databases including Office for National Statistics (ONS) in the UK /EUROSTAT and STATISTA (paid) for the EU and Investment Association (UK) This project requires a detail-oriented, problem-solving researcher. The figures/charts should all be referenced with t...

I'm in urgent need of a seasoned expert in Microsoft Excel, particularly in creating financial models with emphasis on cash flow management. The ideal freelancer for this project should have proven experience in constructing similar tools for businesses. Key Areas of Focus: 1. Housemaid Cash Flow Tracker: This spreadsheet will facilitate tracking cash provided to our two housemaids and matching their submitted invoices. With three team members involved, it needs to be straightforward and efficient. 2. Monthly Household Budget Expenses: This spreadsheet will serve as a comprehensive monthly budget for all household expenses, including groceries, Amazon purchases, and payments to other suppliers. I envision a format where invoices and supplier names are listed vertically, with ...

...for an expert in Excel who can assist me with designing a functional cash flow budget. The primary aim of this tool will be to help me track and effectively manage two team members expenses. Key requirements for this project are: - Excellent proficiency in Excel, particularly in designing complex budgets and financial spreadsheets. - Experience creating automated functions within Excel, specifically for totalling expenses. - Ability to create a user-friendly and aesthetically pleasing interface that enables efficient data entry and report viewing. The freelancer would need to provide consistent updates and flexibility for potential adjustments during the process. This initiative is essential for my financial planning and needs to be done professionally. If you...

need a skilled freelancer who is an expert in creating financial formulas in Excel. You'll work exclusively with data I provide. Ideal candidate should have: * Expertise in Excel with a specific focus on financial formulas Ddata will be provided

Hi Sir, I can create the macro as per instruction shared . Thanks Arun

I'm looking to have a website built that will serve as a platform to showcase our car inventory. This website is crucial for our business as it will be the central point for potential customers to peruse and get to know the cars we have on offer. Key Features: - The primary function of this platform is to showcase our car inventory. Therefore, the main focus should be on the design that will effectively showcase the cars in the best possible light. - I would like the website to have a user-friendly search and filter option. This is important as it will allow our clients to easily find the car they are looking for. - It's important that the site is designed to be responsive across various devices to ensure potential customers can access it no matter what device they are...

I'm currently facing some issues with my Excel tracker. - The tracker contains a VBA macro file which seems to be causing formula errors and formatting issues. I'm unsure of the exact nature of these errors, but it's clear they are impacting the accuracy and usability of the tracker. I need a freelancer who can review and rectify these issues in the tracker. An ideal candidate would have strong experience with VBA and Excel, able to handle complex formulas and troubleshoot formatting problems swiftly. Your goal is to ensure that the tracker is fully functional and error-free. Experience with similar projects will be a plus.

I need a big wordpress website 56BG moving from a slow reseller account to a VPS. No configuration necessary as keeping same domain name Current website is very slow and couldn't take a back up using updraftplus plugin I need all files and Database copying to new server and testing that it function OK I am in need of a specialist with broad experience in WordPress platform to move my website from its current location to a Virtual Private Server (VPS). Requirements: - Comprehensive knowledge of WordPress site architecture and components. - Extensive experience in website server migration, particularly to VPS hosting. - Ability to ensure that no data is lost during the migration process. - Skilled in backup creation and restoration. - Familiarity with DNS and IP configura...

I'm seeking a seasoned professional to assist me wi...com/ehoogeboom/multinomial_diffusion with a custom dataset. The work includes: - Understanding the model and its functionalities and writing a Jupyter script for training with a custom data set. - Custom data integration: figuring out the format required by running the example training on text8 dataset and then adapting the in-house dataset for the purpose of training. -Finally, write a custom function which given the trained model enables a spellcheck on masked tokens of the text as in Ideal skills for this project include: - Proven experience in using NLP models and diffusion models. - Proficiency in data integration and model training. -Make the code and implementation accessible to more low-level downstream users.

...main aim of this plan is to evaluate the profitability of my startup business. Key requirements: - Market Analysis: I need a comprehensive examination of the construction market, including competitors, demand, and trends. This will help to identify potential growth opportunities and risks. - Operational Strategy: I'm looking for a well-rounded operational plan that outlines how the business will function on a day-to-day basis. This should cover areas such as procurement, logistics, project management, and workforce planning. - Financial Projections: I need detailed, realistic financial forecasts that will help me understand how my business will perform over time. This includes cash flow projections, profit and loss statements, and balance sheets. The ideal freelancer for t...

As an individual currently managing a project with numerous details and a profit loss statement, I need assistance with daily tasks for our Excel sheets. This will include: - Data entry and organization to streamline workflow - Basic arithmetic calculations for accuracy - Statistical analysis to make informed decisions - Formatting and visual presentation for clarity This role requires proficiency in Excel, a keen eye for details, and strong analytical skills. Experience in financial or project management is a plus. The job will be ongoing and requires daily attention. If your expertise aligns with these needs, please apply.

I'm seeking a versatile freelancer to develop an object detection-based localization project. The primary aim is to identify, track, and precisely determine the location of a mobile robot, with a focus on real-time continuous tracking. - Key Tasks: - Develop an object detection tool for a mobile robot - Ensure a high degree of accuracy in real-time continuous tracking - The system will function in an indoor environment Ideal freelancer needs to have skills in robot motion algorithms, machine learning, and a deep understanding of complex robotics-related technologies. Experience in indoor robot localization is a must.

I'm seeking a skilled JavaScript developer to assist in the optimization and thorough testing of my code. Key Requirements: - Proficient in JavaScript, with a solid understanding of function testing and error handling. - Experience in identifying and optimizing performance issues in JavaScript code. - Ability to create and implement robust test cases. Your responsibilities: - Conduct in-depth testing for my existing functions. - Identify potential performance issues and suggest solutions. - Build upon the existing test cases to ensure a comprehensive coverage of the codebase. Ideal candidates will be able to enhance my code and ensure its reliability.

I'm in need of an experienced Solidworks user who can modify existing ports obtained from the GrabCAD library. Key requirements: - Resize the ports: The ports need to be made smaller to fit the specific requirements of the tool. - Customize the shape of the ports: The shape of the ports will need to be altered to meet the design specifications of the tool. The primary function of this tool will be for prototyping. The ideal candidate for this job will have strong experience in Solidworks and a background in designing tools for thermoforming. The final deliverable should be a set of ports that have been adjusted in size and shape, ready to be integrated into the tool for thermoforming. A deep understanding of the manufacturing process and the ability to plan for the tool&#...

I need an experienced developer to incorporate a "to-do" function within an existing iOS and Android Firebase chat application. The requirements are as follows: - Must work seamlessly on both iOS and Android platforms. - A design for the feature has already been prepared, which needs to be precisely implemented. - The feature should enable users to add and manage single tasks. The ideal candidate should have experience with Firebase, iOS and Android development, and a history of integrating new features into existing apps. Understanding user interface design would be a plus, to accurately implement the planned design.

I need an expert in Solana blockchain technology who understands the dynamics of DEXs to implement a Telegram-based snipe bot. Its primary function will be to quickly execute buy orders for new tokens listed on Solana DEXs. I am flexible regarding the choice of DEXs the bot will operate on. Key Responsibilities: - Design and implement a robust, reliable snipe bot that can efficiently place buy orders on Solana DEXs. - The bot should be controlled via Telegram. - Develop a system within the bot to follow certain criteria for selecting the tokens to buy. Skills & Experience: - Proven experience in Solana blockchain, including creating and using bots. - Proficiency in integrating Telegram bots. - Capable of developing complex selection criteria algorithms for tokens...

I'm in need of a highly-skilled developer who can successfully build an indoor navigation system using ibeacon. This system will utilize three Bluetooth ibeacon gateways or an nRF mobile app to precisely track movement. Key Features: - Platform: Android. - Primary Function: Route Guidance. Empowering users to navigate effortlessly within a building is an indispensable part of the project. - Precision: 1 Metre. The navigation system must offer an accuracy of within 1 metre, providing highly precise tracking. Ideal skills for this job include: - Proficiency in working with ibeacon and nRF mobile app. - Demonstrated experience in building navigation systems specifically for Android platform. - Deep understanding of GPS and navigation software. - Strong skills in writing p...

I need an Excel VBA code that can perform exact word matching within an Excel spreadsheet. - The code should generate a list of matched words.

I'm looking for an expert in Excel to assist with a project involving data entry and analysis. The Excel sheet you'll be working on has more than 50 columns and rows and will contain a mix of text, numbers, and dates. You'll be responsible for the following: - Accurate and timely entry of the data provided - Ensuring the data is appropriately formatted and organized - Conducting thorough data analysis, including but not limited to trends, comparisons, and any other insights that can be drawn from the data The ideal candidate for this project should have: - Proficiency in Excel and experience with large data sets - Strong attention to detail - Ability to perform data analysis and present insights - Good communication skills to provide regular updates a...

I'm on the lookout for a talented virtual assistant who thrives on lengthy hours of work and enjoys every second of it! This isn't your usual VA role, though - I'm seeking someone who can confidently handle the following responsibilities: - Social Media Management: More specifically, I need someone adept at Instagram. You'll be responsible for handling and managin...our audience. Ideal Skills and Experience: - Clear understanding of the Instagram platform and how to optimally engage audience in it - Skills in crafting Instagram worthy content - visuals, captions, and stories - Experience in managing professional instagram account is a plus - Must be organized, communicative, and able to handle long hours of work If this sounds like the sort of work you'd exc...

...seamlessly combine front-end and back-end capacities will be crucial to the success of this project. The project encompases 3+ websites, new logo design, testing, and hosting capabilities. Key Requirements: - Mastery of Wordpress or similar. - A minimum of 5 years experience in full stack development. - Expert in UX/UI. - Integration of chat function. - Integration of ticketing system. - Integration of chat function. - Integration of advertising banner function. - A proven record in deploying and maintaining functional, secure and high-quality applications. - Experience in building a forum or blog. Ideal candidates should detail their extensive experience with similar projects. Please highlight any accolades, milestone achievements, or particularly challenging u...

I need a desktop application for Windows that will primarily function as a driver updater. The application should: - Be specifically designed for Windows operating system. - Focus on ensuring all drivers are up-to-date for the user's system, and where necessary, provide options for updating the drivers. - Offer an intuitive and easy-to-understand user interface. Ideal freelancer: - Proven experience in developing Windows desktop applications. - Solid expertise in developing software that interfaces with drivers. - Proficiency in creating user-friendly interfaces. - Demonstrate an understanding of the importance of security in software of this nature.

Please Sign Up or Login to see details.

For this project, I require an expert who can efficiently extract text content from two distinct webpages and input my data into an Excel file organized by rows. Given that all types of data hold equal importance to me, of essence is for the professional to: - Accurately scrape all text content from the specified webpages - Ensure no data is skewed or omitted during this process - Neatly organize the data by rows in the Excel file The ideal candidate for this job should be proficient in web scraping tools and techniques, possesses an acute attention to detail, and is experienced in using Excel to ensure data is properly formatted and easy to analyze. Please note that minimizing errors during this process is critical, as the data collected will directly influence fur...

...(tariff payment and number of contacts). You need to make sure that these fields are also displayed in the mobile version of the site and add statement generation for these fields. * Set up the generation of a report (pdf file, form will be provided), which displays information about which users did not pay the bills of the previous month * On the 1st day of each month, files must be generated in Excel and XML-Format with the bank data entered by the contractor during registration and the amount to be paid from the account. One file for all users (form will be provided). * Fix the code when sending an E-Mail to the user at the time of invoice generation. Now email is sent many times in a row per day, it should be 1 time * Add one more page to the artist registration form, whe...

I require a freelancer to type text data into an Excel sheet from printed documents. Scope of work: - Convert printed text documents into digital format via Excel - Ensure data is accurately entered The project does require specific formatting: - Data should be arranged in rows Ideal candidate: - Must have proficient Excel skills - Experience with data entry - Attention to detail, to ensure accuracy in work - Able to follow specific instructions for data organization

I'm searching for a creative graphic designer to craft a medium complexity logo for a hospital. This logo should predominately feature the color blue, evoking feelings of comfort and safety. Key requirements for the project are: • Proven experience in graphic design, specifically in logo creation. • Ability to create a medium complexity design that harmoniously merges form and function. • High proficiency in using design elements to evoke specific emotions - in this case, comfort and safety. • Proficiency in color theory, particularly with the use of blue. If you are a responsive and attentive communicator with a knack for understanding and translating brand feelings into visuals, I would love to hear from you. Please provide examples of your past work, p...

...tenure, salary and location of our employees. Your ability to structure and organize these aspects will be key. - Creating an Excel-based system: I'm looking for a dashboard that's easy to dissect and understand. As such, I'd like the final product to be in Excel spreadsheet format. This means you should be very proficient in Excel, knowing how to integrate formulas, tables and other relevant features. - Monthly updates: The dashboard should be designed to be updated monthly. You should be dedicated to ensuring that the data is up-to-date and accurately represented. Ideal freelancer should have: - Proven experience in HR analytics and dashboards - Excellent Excel skills - Ability to present complex data in a clear and concise manner - Strong...

I have an excel sheet with intermediate complexity data, including formulas and charts. I need someone to transfer this data into tables, with the primary goal of organizing the information for better clarity and ease of understanding. Key Tasks: - Type the data into tables: This needs to be done with meticulous attention to detail to ensure accuracy and integrity of the data. - Apply borders and shading: To enhance the visibility of the tables and make them aesthetically pleasing. - Utilize headers: Rows and columns should have appropriate headers to aid in quick data navigation. Ideal Freelancer: - Proficient in Excel: Ability to work with intermediate level of data such as formulas and charts. - Strong attention to detail: Critical for ensuring that data is entered accur...

...looking for an Excel expert who can create a comprehensive sales target tracking spreadsheet for my customers. This spreadsheet should have several key functionalities. Features Needed: - Customer Information: It should contain a section where I can input and maintain all my customer's details. - Sales Tracking: The spreadsheet should enable me to track my sales targets daily and provide a detailed analysis of my performance. - Target Achievement: The spreadsheet should also be able to analyze the achievement or shortfall of selected items target completion by each customer. Analysis Required: - I would love to have a feature that shows how well sales targets are being achieved as per defined targets. Ideal candidate should have great attention to detail, proficiency...

I need an organized mind to help with research and data entry of a list of companies in a specific industry. Your main responsibility will be organizing this data. While basic Excel skills are a must, experience with data organization, particularly in a business context, would be highly beneficial. The data will be divided into 4 separate categories, so whoever takes on this task needs to have a keen attention to detail and an understanding of categorization. This project is perfect for an individual who thrives in organizing and systematizing data.

**Tour Costing Sheet Structure** 1. **Tour Details** - Tour Name - Tour Code - Duration - Destinations 2. **Client Information** - Client Name - Number of Adults/Children - Contact Information 3. **Accommodation** - Hotel Name - Room Type - Meal Plan - Cost per Night - Total Nights - Total Cost 4. **Transportation** - Vehicle Type - Distance - Cost per Kilometer - Total Cost 5. **Sightseeing and Activities** - Activity Name - Per Person Cost - Number of Persons - Total Cost 6. **Miscellaneous Expenses** - Guide Fees - Entrance Fees - Other Expenses 7. **Pricing** - Subtotal (Sum of all costs) - Markup Percentage - GST (Goods and Services Tax) - Final Price 8. **Payment Details** - Deposit Require...

As a part of our website's live chat feature, I'm seeking a professional with a solid background in Zoho Salesiq to build and integrate a custom chat interface widget. Key Project Details: -...controller - Integration with Zoho CRM and Zoho Creator Ideal Skills and Experience: - Proficiency in Zoho Salesiq and Zoho Creator - Strong experience in widget development for chat interfaces - Familiarity with Zoho CRM and its integration methodologies - Ability to handle data transfer and update processes within the chat interface Your role will be crucial in ensuring that our live chat function is not only seamlessly integrated into our website but also synchronized with our Zoho CRM and Creator systems. If you have the experience and skills required for this project, I'...

Please Sign Up or Login to see details.

I'm looking for a freelancer to help with a simple Excel data entry task, as well as some basic formula work. I have a spreadsheet that primarily contains numbers. Your role would be to accurately type this data into the sheet, ensuring that every entry is correct and in the right format. This task is meant for particular record-keeping purposes, so precision and attention to detail are crucial. In addition to the data typing, I need some basic Excel formulas applied. Experience with Excel and knowledge of formulas is essential to ensure the data is well-organized and easy to work with. This task is not overly complex but will require someone who is proficient with Excel's formula functions.

...you give me the code. So branch one will have different tabs frequency than the other branch. The UI should reflect that. 3. Maybe it would be easier if it records the exact keystrokes I make and then plays them back(no Mouse) a. So I can just do my routine over and over and then a macro records that specific pattern and plays it back by pressing an assigned hotkey. I am open to creative ideas on how to do this differently then I have described below. Key Requirements: This is basically like a macro, or autohotkey, (if you do a gui then I can determine the winner as soon as whoever finishes first with working code, wins. The gui for the python code is up to you but maybe it could work well if I can have section one establish focus on right scrolling panel and igno...

Two-Month Requirement List • APP User Login o User Registration: Users register their accounts independently, set passwords, and provide relevant email addresses. o User Login/Logout: Users log in and out by entering their passwords, and support login via TG accounts. o Permission Setting: Set user function permissions, menu permissions, button permissions, data permissions, etc., and set related user roles and user levels. o User Instructions: User agreement and privacy policy. • User Profile and Settings o Personal Profile Management: Users can create and edit personal profiles, including nicknames, avatars, and personal signatures. Set personal privacy options to control who can view their profiles. o Account Security: Provide strong password policies ...

I am currently working on a project that requires the integration of Excel with a PostgreSQL database. As such, I am in need of a freelancer who is proficient in both Excel and PostgreSQL. The primary tasks to accomplish include: 1. Exporting data from Excel to SQL 2. Updating PostgreSQL data using Excel You will be working with various kinds of data as we aim to streamline our operations in a more efficient manner. Ideal skills and experience include: - Solid understanding of PostgreSQL - Expert skills in Excel - Previous experience with SQL data exporting and updating The success of this project highly relies on a flawless data transfer between Excel and PostgreSQL. Your expertise will be extremely valuable to our project's completi...

I'm in need of a skilled engineer to design a hinge mechanism for a new electronic product I'm developing. The primary function of this hinge is fold on a daily basis (possibly more). The ideal professional for this job should have experience in electronics design and mechanical engineering with manufacturing in mind, specifically in creating hinge mechanisms for electronic devices. Key Responsibilities: - Design a hinge mechanism that allows smooth, reliable folding - Ensure the mechanism is suitable for electronics Ideal Skills: - Electronics Design - Mechanical Engineering - Product Development - Experience in small batch production The initial production volume is small, under 100 units. This is a crucial project for my product, so attention to detail and a collab...

I'm in need of an expert to assist with the cleanup of our Medicine database. The goal of this project is to accurately remove all duplicate entries improving the overall accuracy of the data. Ideal Skills & Experience: - Strong background in Database / Excel /CSV management, specifically in the medical field. - Proven track record of similar past work. In your application, please include details of similar projects you've worked on. Efficiency and precision are pivotal for this task. Looking forward to a neat and streamlined database!

I'm in need of an Arduino ESP32 BLE Beacon that can help me locate my position. Its key function will be to triangulate its position based on three central beacons in an indoor environment. Key Requirements: - The main goal of this project is to create a beacon that allows me to know my position inside indoor spaces, such as offices and warehouses. - The system should be designed to provide a medium level of precision in position tracking, with an accuracy of up to 5 meters. Ideal Skills and Experience: - Proficiency in Arduino and ESP32, with a strong understanding of BLE (Bluetooth Low Energy) protocols. - Prior experience in designing and developing beacon systems for positioning. - A solid understanding of indoor positioning systems and the challenges they may pose. - ...

...the job done quickly. There are a total of 3 development projects and many more. 1 SNS ad matching website / development budget $350 2 it development matching website / development budget $350 3 QR meal ticket management and attendance management site / development budget $400 All are website environments and have a smartphone shortcut icon push function. Supported by browsers. Development progress order 1 List of development function definition requirements (organization of conversation documents involving developers and planners) 2 Flow chart (professional planner) 3 UI UX screen design (professional planner) 4 designs (professional designs) 5 Developers (professional developers) 6 QA error checking (professional error checker) 7 Server Settings (Professional Dev...

I have a channel where I make EXCEL educational videos, I upload 12 videos a month, between 5 to 7 minutes each. YOU MUST BE ABLE TO : - Have experience in editing videos for YouTube. - Have basic knowledge of Microsoft Office, to be able to edit the videos better. - Be able to edit 10- 12 videos consistently every week (Some will be only 1 minute long). IF YOU WANT TO STAND OUT FROM THE REST SEND US YOUR PORTFOLIO

PLEASE...bidding. I'm in need of a skilled React Native developer to help me design and build a social networking app. The app should be compatible with both iOS and Android operating systems. Expected no of screens to be developed: 25 Key Requirements: - Extensive experience with React Native - Previous work on social networking apps - Proficiency in both iOS and Android platforms The app's primary function is to facilitate social networking, so it should be built with user engagement in mind. I aim for it to be a seamless, intuitive and user-friendly environment for social interaction. Backend APIs are developed using Django. Those will be provided. Job in scope 1. Design the UI 2. Develop the front end Your bid must include 1. Examples of past projects 2. Cost 3. ...

I need a word document translated from English to Russian as soon as possible. The file has 800 words. Need high quality human translation only. Google/AI or automatic software works are not allowed and will be rejected. Need the translation back in word document format maintaining the formatting and layout of the source file. I would also need an excel sheet prepared, with source texts in column A and translation column B. Need this to be done within 5-6 hours of awarding the project. Bid only if you are available to do it now. Price: 12 CAD fixed. Deadline: 5-6 hours max Don't bid if you don't agree the price and timeframe. Thanks!

I need a word document translated from English to Simplified Chinese as soon as possible. The file has 800 words. Need high quality human translation only. Google/AI or automatic software works are not allowed and will be rejected. Need the translation back in word document format maintaining the formatting and layout of the source file. I would also need an excel sheet prepared, with source texts in column A and translation column B. Need this to be done within 5-6 hours of awarding the project. Bid only if you are available to do it now. Price: 12 CAD fixed. Deadline: 5-6 hours max Don't bid if you don't agree the price and timeframe. Thanks!

...serve as a platform for managing and tracking services. The website will primarily target business clients, and as such, must be professional and user-friendly. Key Features: - User Registration and Management: The website should allow for easy registration and management of user accounts. It should have a secure login system and options for account customization. - Service Management: The core function of the website will be to manage and track services. This will involve the ability to add, edit, and view services in a clear and organized manner. - Tracking and Reporting: The website will need to have features that allow for the tracking and reporting of customer service activities. This is vital for both our internal processes and for providing transparency to our clients. S...

I'm looking for an experienced Opencart 3.0.3.9 developer to customize my equipment rental business website. Specific tasks include: - Adding a date range picker to the shopping cart. This function is crucial as the total price of the product and the price of the cart must adjust live according to the selected date range (ie. the days they want to rent out each product) - Familiarity with different date range picker plugins or libraries is essential. However, the priority is on functionality rather than specific plugin usage. The date range needs to be selected before the customer can proceed to the checkout process. It needs to be responsive and fit the look of the site. Ideal skills include: - Strong Opencart 3.0 knowledge and experience - Proficient in PHP, HTML, CSS and...