Functions in excel vba code jobs

I'm in need of a thorough and reliable freelancer who can assist me with typing 1-5 columns of text-based data into an Excel sheet. Data will be provided in a digital format, like PDF or Word. Key Requirements: - Proficiency in Excel: You should be well-versed in using Excel, particularly in data entry tasks. - Accuracy: Attention to detail is crucial as any errors could affect the quality and integrity of the data. - Typing Speed: A fast and accurate typist will be highly preferred to get the task done efficiently. - Reliability: I'm looking for someone who can commit to delivering the work on time, as per the agreed-upon schedule. Please note that this project will be an ongoing one, with the possibility of more work if ...

...enclosure that needs to be brought up to code standards. It is currently made of wood and I would like to include windows as part of the design. Key Requirements: - The carport enclosure needs to be assessed and re-designed if necessary, ensuring it meets all relevant building codes. - Windows need to be incorporated into the design without compromising the structural integrity. - The use of wood as the primary material will need to be considered and any necessary adjustments proposed to ensure it's compliance with the code. - The enclosure must maintain its functionality as a carport while meeting all code requirements. I'm looking for a professional who has experience in architecture and compliance with building codes, with specific expertise ...

In search of a competent Excel specialist adept in Microsoft Access for multiple automation tasks. I need assistance with: - Macros Development: The main tasks include automation and creating tools. The proficient use of macros in daily operations is essential. - Report Generation: Specifically, the generation of technical proposal reports. Alongside this, the candidate should also be capable of automating the formula calculation process. Familiarity with financial, sales, and project status reports is an added advantage. - Tool Building: The capacity to build tools and other operations geared towards improving efficiency is crucial. Ideal skills include deep understanding of Excel functionalities, proficiency in Microsoft Access, extensive exper...

I need an Excel expert to build a tool that can automatically validate and correct any incorrect country codes in the file. Requirements: - Replace incorrect country codes: The tool should replace the incorrect country codes with the correct ones. - Predefined list: The correct country codes should be determined based on a predefined list. - Daily updates: The tool should be able to handle daily updates. Ideal Skills and Experience: - Advanced Excel skills: You should have a deep understanding of Excel functions and VBA programming. - Data validation: Experience with data validation and manipulation in Excel. - Attention to detail: It's crucial that the tool is accurate in identifying and correcting country codes. - T...

I am in need of an expert who can continuously build and manage MIS excel sheets pertaining to data analysis, sales forecasting, and expense tracking on a daily basis. Key tasks: - Establishing excel sheets to analyze a broad range of data - Constructing a sales forecasting model within the excel sheets - Regular tracking and management of expenses via the excel sheets Data sources would primarily be spreadsheets and databases. These excel sheets will require daily updates, enabling close monitoring of key metrics. Ideal skills: - Proficient in Microsoft Excel - Exemplary skills in data analysis and modeling - Good understanding of databases and how to extract data from them Experience in handling and managing ...

I urgently require a proficient web designer to create an engaging E-commerce website. While I have bypassed specific feature requirements, your expertise in essential E-commerce components will be of high importance. Key Responsibilities: - Design an intuitive, user-friendly website - Implement the latest E-commerce functions Ideal Experience and Skills: - Expert knowledge in E-commerce web design - Excellent understanding of the latest website features Please note, the project needs to be completed as soon as possible. Your dedication to timely project completion is essential.

I am looking for a professional illustrater who can create a clear mo...authors - Author profile pages - A section for featured articles Inspired by the solemn yet polished tone of sites like Off-Guardian, The Sun Magazine, and Hippocampus Magazine, I want to strike a balance between in-depth, meaningful content and sophisticated design. The aesthetic should be clean and minimalist, with an emphasis on readability, ease-of-navigation, and reflection of the literary aspect of the content. Experience in minimalist design is highly regarded. This project will not only require design skills but also an understanding of how a literary magazine website functions, and how to best present its contents to an audience. The ability to create a clear and impactful user journe...

I need an expert to migrate my products from an Excel file to my WooCommerce store. Key Requirements: - Migrate products from an Excel file to WooCommerce - Use attributes to define variations within a single product - Update existing product descriptions during the migration Ideal Skills and Experience: - Strong experience with WooCommerce and product migration - Proficiency in handling product variations using attributes - Attention to detail for updating and modifying product descriptions - Excellent knowledge of data import/export and product management on WooCommerce. - Ability to ensure a smooth and error-free migration process.

I require a detailed and accurate excel typist with a strong background in financial data analysis specifically in calculating profit margins. This person should: - Have strong excel typing skills for efficient data entry - Be knowledgeable in financial data analysis - Be able to interpret and analyze profit margins effectively - Have logical data organization skills to improve the overall workflow This role is essential for understanding and monitoring the profit margins of my business. Accurate analysis will aid in making strategic business decisions. Your expertise in handling financial data is highly valuable for this role.

Looking for a ...- Add fresh, engaging content to our landing page: The new contents need to be captivating, relevant to our services, and add value to our website. - Implement new features and fix prevailing bugs in our web app: I want our web application to be free of errors and add new functions that make it more user-friendly and efficient. The main goal of the landing page and the web app updates is to cater to 'software customizing’. I'm striving to make the entire user experience on both platforms smooth and seamless. Efficiency, speed, and an eye for aesthetics are crucial for this job. Strong skills in web development and a solid understanding of user experiential designs will be ideal for this project. Please ensure that you can meet the 23:0...

I have a significant amount of text that needs to be typed into Excel quickly. The data is in a simple text format, no complex formatting required. Key requirements: - Proficient in Excel and typing - Attention to detail - Ability to work under tight deadlines The data is straightforward text and requires no specific formatting or analysis. The ideal freelancer will be skilled in data entry and be able to commit to a quick turnaround time.

...on quality, I need the support of an experienced Python programmer who can take charge of the frontend aspect of my web development project. At the core of this project are the following requirements: - Full proficiency in Python as the main programming language for the task - Demonstrated experience in frontend web development using Python - Familiarity with the best practices in Python programming - Capacity to effectively communicate, provide regular updates and accept feedback The missing response for the third question won't be an issue — I am more interested in a Python programmer who can bring their own unique ideas and solutions. You are encouraged to showcase your creative problem-solving skills. Apply if you have the necessary skills...

I am seeking an Excel expert who can meticulously enter extensive amounts of text, numeric, and alphanumeric data into my spreadsheet. The task involves entering names, contact details, sales information, and inventory data. The size of the task is quite substantial, with up to 1,048,576 rows and 16,384 columns involved. The role requires a keen eye for detail, accuracy, and dedication. If you are efficient in Excel and possess experience with handling large data sets, your skills will be highly valuable for this project.

I'm looking for an expert in Excel data entry to assist me with a project. The job primarily involves: - Text data entry: Entering textual information into Excel. Accuracy is crucial, as even minor errors can greatly affect the output. - Data categorization: Organizing the entered data into different categories within the sheet. The ability to understand and sort data effectively is key. - Basic data visualization: I'd like the data to be presented visually. The freelancer should be able to create and include simple charts or graphs to represent the categorized data effectively. Ideal Skills: - Proficiency in Excel: A deep understanding of Excel and its functions is essential. - Data Entry: Previous experience in data entry...

I need a reliable freelancer to assist with data input. Here's a breakdown of the project: - **Task:** Your primary job will be to input data from online forms into either Microsoft Excel or Google Sheets. - **Experience Required:** It is necessary for you to have prior experience with both of these tools. This will ensure you're able to work efficiently and accurately. - **Attention to Detail:** Given the nature of the task, it's crucial that you have excellent attention to detail. Even the smallest mistake can have significant implications. If you have the experience and skills mentioned above, I would love to hear from you.

In moving forward with my business, my knowledge on Xero accounting software is at an intermediate level. I'm open to learning from a professional who can help me elevate my understanding particularly in Invoice Management. This one-on-one training session should cover best practices, tips, and crucial functions for efficient use of the Invoice Management feature in Xero. I'm looking to deepen my understanding of how to operate this system effectively, in order to streamline my operations and financial reporting. Freelancers interested in bidding for this project should have: - Extensive experience with the Xero Accounting Software - Proven expertise in training others to use the Invoice Management function - Strong communication...

...error with my Excel sheet. An error message keeps popping up and the sheet becomes protected every time I enter a price. Ideally, instead of locking the entire sheet, only specific columns should be locked when a password is triggered by clicking a button. Key issues: - Error message arising upon entering a price - Automatic sheet protection following action Work Required: - Identify and fix the error triggering the message pop-up - Adjust VBA codes to lock specific columns upon password entry: - Columns A to L - Columns Y, Z to AK - Columns CW to DH - Columns DO to DS - Columns DT, DV, DX, DZ, EB, ED For this task, I need a freelancer proficient in VBA and Excel, specifically with experience with sheet protection issues. A thorough unde...

...compatible with Windows OS. Key Features: - Primarily 3D Modeling: The software should excel in 3D modeling capabilities, providing robust tools and functionalities for creating and editing 3D designs. - Compatibility: The software should be specifically designed to run seamlessly on Windows operating system, ensuring optimal performance and user experience. - File Format Support: The software should support importing and exporting of DWG files, for compatibility with AutoCAD files. Ideal Skills and Experience: - Proficient in C++: Extensive experience in C++ development, with a strong understanding of software architecture and design patterns. - CAD Software Development: Prior experience in developing CAD software, particularly with...

...am asking can actually be created in Excel 365 and used in Excel 365 Online. Please dont reply to this post without replying that it can or can't be done. If not, an alternative solution would be greatly appreciated. I need help creating an excel spreadsheet to track student progress in a course using 5 different options that also includes the date the option was selected. I can create the drop down list with the submission options, and apply color rules but I can not work out how to make the cell below change to the same color as the option selected and the date it was selected appear in the same cell. I need to include the date the option was selected selected and because you can't have two formulas in conditional ...

I am in need of a proficient Excel expert who can create a custom spreadsheet for me. This spreadsheet will help in calculating the overtime rates for my 6 employees on a monthly basis. Key Requirements: - The Excel sheet should calculate 3 types of overtime rates: standard (1x), holiday (2x), and evening/weekend (1.5x) - The formulae should be designed to take into account that an employee works a 40 hour basic week with typical overtime of between 1-20 hours. - The sheet should take into account that the employees are not paid for 30mins of travel time to and from work, the employees tell me what time they left home, arrived at site, left site and arrived home. - Standard hours are 08.30-17.00 Mon-Fri with a 0.5hour unpaid break and a 0.5 hour unpaid break if...

More details: What type of data do you need to type into the Excel sheet? Text What is the source of the data that will be typed into the Excel sheet? PDF documents Will the data need any kind of formatting or should it be entered as is in the source document? Enter as is

I require a highly skilled professional with dexterity in MS Excel and Video Editing. Tasks will encompass: For MS Excel: - Comprehensive data analysis - Detailed spreadsheet formatting - Advanced formula creation for profound financial analysis. For Video Editing: - Apt video trimming - Expert color correction - Adding text and graphics creatively to videos. Ideal candidate will have proven ability in both fields, demonstrating both attention to detail in data management, and creativity in video enhancement. Proficiency in financial analysis and data visualization is a major plus.

I'm seeking an expert in MS Power Automate, well-versed in implementing unique flows using different AI Chat APIs - particularly Chat GPT API and Cohere AI API. The primary task is to create a power flow capable of running batches of prompts effectively. Key expectations are: - Expertise in MS Power Automate, API integration, and AI-oriented applications. - Background in working with Chat GPT API and Cohere AI API. - Ability to deliver results on a web excel sheet. Please note that an understanding of additional AI Chat APIs is highly valuable for this project.

I need a seasoned VBA and Macro expert to assist me with the creation of an interactive dashboard for a small project. The main tasks include: - Development of VBA code to automate repetitive tasks. - Creation of custom functions to enhance the dashboard's functionality. - Ensuring the dashboard can generate reports effectively. I'm specifically looking for someone with: - Proficiency in VBA and Macro. - Previous experience in creating interactive dashboards. - Ability to generate reports through coding. - Good communication skills and attention to detail. If you're confident in your VBA skills and have a good eye for visualizing data, I'd love to discuss this project with you.

We're looking for multiple competent native English editors to help us improve English language usage in a big batch of Excel-related tutorials. No testing of tutorials has to be done as the technical aspect of the articles is fine but they've been put together by non-native speakers. Starting with a paid trial.

I need a Python code developed for vehicle route optimization. - The code should include 3 algorithms for route optimization. - Successful freelancers should include past work in the application. Ideal Skills: - Proficiency in Python - Experience in developing route optimization algorithms - Strong background in data analysis, web scraping, and machine learning, as these functionalities will be required in the project.

I have several thousands PDFs that need to be read, interpreted and transcribed into a supplied spreadsheet format. It is important that you: 1) Have an existing team to help with a task that is estimated to take 2 weeks 2) Proficiency in PDF to Excel transcription 3) Ability to complete the task efficiently Applicants based in India only.

I have three separate Excel documents that need to be merged into a single, optimized sheet. In this new file, we should only pull specific data columns including Defect ID, Defect Type, Date Opened, Priority, Description, Reproduction Steps, Actual Result, Date Closed, Assigned To, and Comments. These columns must be combined while maintaining clarity and structure. After this task, a dynamic dashboard that displays the current state of the project is required. This dashboard should offer a variety of visualizations. We are particularly interested in bar charts, pie charts, and line charts to present the data in a clear and digestible manner. Ideal candidates for this project are those with: - In-depth expertise in Excel data management -...

...easy-to-navigate categories, filters, and search functions. - Shopping Cart: A seamless and secure shopping cart is essential, facilitating worry-free transactions. - Push Notifications: Ability to send targeted push notifications, informing our customers about our latest offers and updates. - Integrations: The app needs to smoothly integrate with Wishlist, loyalty schemes, and various social media channels. Platforms: The replacement app needs to be available on both iOS and Android platforms. Branding Requirement: A significant factor in this project is staying true to our brand identity. As such, we require the app to align with our existing design and branding requirements. Ideal Skills and Experience: The freelancer should have a solid background in Shop...

I have an existing VBA application that performs various calculations. I need to convert the VBA application to a Python-based desktop application. Key Requirements: - The converted application should perform the same calculations as the original VBA application. - The application should have a user-friendly GUI for easy input and output. - I am looking for a programmer with experience in both VBA and Python, to ensure a smooth and accurate conversion. Ideal Skills: - Strong proficiency in VBA and Python. - Experience in desktop application development. - Knowledge in creating user-friendly GUIs. - Ability to accurately replicate functionality from VBA to Python.

Hi Jay - been a long time since we interacted. But I want to let you know that we still use the excel file that you created for us way back in 2017. Its been our main stay. I have another Excel file which requires formula to effect colour change in cells under various conditions. Knowing you, it might be just a 10 or 15minute assignment. Would you be able to help. Thanks. Vish

I am looking for a skillful freelancer who can assist me in converting an Excel spreadsheet into a daily calendar schedule like this: Key Requirements: - You must have a firm understanding of Excel and calendar scheduling. - You must be capable of adjusting the Excel data to fit into a daily calendar layout. All data will be uploaded by an excel spreadsheet or .csv file

We are seeking an experienced PCB designer to develop a custom printed circuit board for a Raspberry Pi 4 Model B application. The project requires integrating specific co...components and ensuring the design can be enclosed within a standard industrial box. The successful applicant must have experience with power management and GPIO pin utilization. Key Requirements: - Experience with Raspberry Pi designs and GPIO pin functions. - Ability to integrate electronic components such as 5V relays into the PCB with high precision. - Familiarity with standard industrial connectors and terminals. This project aims to create a highly functional and reliable hardware system. Only applicants with a strong track record in custom PCB designs and the ability to work to exact specificati...

I need an Azure function to facilitate daily data transfer from Snowflake s3 storage to Azure blob storage. Key Requirements: - I have access to both the Snowflake s3 storage and the Azure blob storage. - The primary goal of this data migration is to integrate the data with other Azure services. - The data should be transferred on a daily basis. Ideal Freelancer: - Proficient in Azure Functions and Azure Blob Storage. - Previous experience working with Snowflake and its utility for data migration. - Strong understanding of real-time data transfer systems is an added advantage.

...clients. - Responsibilities: - Filing GST returns - Filing TDS returns - Periodic accounting in tally for selected clients - Income tax return filing - Coordinating with clients on monthly basis for the documents The majority of my clients have less than 70 transactions per month and I use tally software, thus a good grasp of tally software and excel is necessary to handle the above tasks. - Skills and Experience: - Gst return filing experience - Proficient in tally software - Experience with handling multiple clients simultaneously - Knowledge of GST and TDS filing systems appeciated. This is an ongoing project and I am looking for a dedicated and reliable partner in this area as this will be an ongoing and long term project. The fee...

As the project owner, I urgently require a skilled developer to help integrate my WhatsApp system with a cloud. The integration needs to serve both...the project owner, I urgently require a skilled developer to help integrate my WhatsApp system with a cloud. The integration needs to serve both outbound and inbound functions, and it should be compatible with web platforms. The ideal developer will bring the following skills and experience to this project: - Familiarity and experience with WhatsApp and cloud integration - Strong knowledge in web-based platforms - Past experience in implementing the following functionalities: auto-responding to messages and CRM integration. This project is urgent, thus a quick turnaround time and reliability are key attributes I am look...

... and a passion for problem-solving. If you're culturally aligned, possess stellar marketing and sales prowess, and thrive in fast-paced environments, this is your opportunity to shine! Embrace the challenge, make your mark, and redefine excellence in real estate! - Uploading photos and descriptions of properties - Sorting listings by location and price - Providing regular updates on availability - Scheduling site visits for potential customers - Providing customer support to potential buyers For the lead generation aspect, you'll be targeting first-time home buyers, investors, rental property seekers, and end users. To excel in this role, you should have experience in real estate sales and understanding of different audience segments. Excel...

I need a website that functions as an e-commerce platform for my clothing brand. Key Features: - Shopping Cart: Customers should be able to add multiple items to a shopping cart before making a purchase. - Customer Reviews: Each product page should have an easily visible section for customer reviews. - Product Filters: The e-commerce site should have product filters based on categories like size, color, type, etc. For this project, experience in creating e-commerce websites is essential. Knowledge of integrating effective shopping carts, product filters, and customer review modules are the key skills required. The site will strictly be for the sale of physical products, therefore experience dealing with e-commerce platforms focused on physical product sales will also be ...

I'm in need of a professional data entry specialist to assist with entering numerical data into an Excel spreadsheet. The aim of this task is to organize the data in a clear, tabular format that can be easily read and interpreted. Skills & Experience: - Proficient in Excel - Strong attention to detail - Experience with numerical data entry The project demands precision in inputting the data, so only those who display meticulous attention to detail will be considered. An understanding of how to organize data in a tabular format is crucial. Please ensure you have relevant examples of similar tasks in your portfolio. Deliverables: - An Excel sheet filled with the provided numerical data, organized in a tab...

I am in need of an Excel professional with an intermediate level of proficiency to assist with various tasks on my project. The specifics of these tasks are open for discussion, therefore a degree of flexibility and adaptability is required. You should ideally have proven experience with data analysis, spreadsheet automation, and formula creation despite the fact these haven't been specified outright. An overview of your past relevant projects included in your bid would be highly appreciated. Convince me with your technical prowess and past success stories.

I'm seeking an experienced freelancer to conduct an in-depth research on the electric instant and storage water heater market in Bahrain. The task involves a comprehensive analysis of: Requirements (must live in Bahrain Manama): 1. Identify Top Retailers: List the top 5 major home appliance retailers in each country. 2. Document all Water Heater Brands in the store (focus on electric instant and storage water heaters): Visit 1x store (pick the biggest and most popular store) of each Major Retailer. Then compile a list of popular water heater brands, including pictures, prices, and key features. Highlight the most sought-after brands in each country. 3. Online Platforms: Document online platforms selling water heaters, providing links to their...

I need a proficient individual to assist with data entry into an Excel sheet. The data to be entered is purely textual, derived from printed documents and requires no complicated formatting. Key Responsibilities: - Transfer text data from printed documents to Excel - Ensure accuracy of data entered - Follow simple formatting guidelines Ideal Skills and Experience: - Proficiency in Microsoft Excel - Attention to detail - Experience with data entry - Fast typing speed - Experience working with printed documents This project is ideal for freelancers with a knack for accuracy and speed in data entry, particularly in Microsoft Excel. It involves simple one-word entries and familiarity with printed documents is advantageous.

Logo + Admin Panel + Multi DNS I'm in need of an expert in APK rebranding specifically for Tivimate IPTV. The chosen freelancer should have experience and proven capability in android platform development and APK rebranding. They should be able to; - Efficiently handle the task of rebranding our Tivimate IPTV APK into IBO player with a new logo. - Build a comprehensive Admin Panel integrating functions of User and Content management efficiently. Since the rebranded APK should be compatible with Android, a substantial level of expertise and experience with this platform is crucial. A successful application will demonstrate sufficient experience in similar projects.

I'm in urgent need of an experienced WordPress developer to make changes on my existing website and add new functions. - **Edit Content:** I require some changes to the existing content on my site. This might include updating text, adding new information and potentially some minor design tweaks. Specific details will be provided. - **Create Drop-down Menu:** I need an intuitive and clean drop-down menu added to my website. This should make navigation for the users easier and provide a professional feel to the site. I will provide the menu structure. - **Appointment Booking & Email Form:** A critical aspect of this project is the integration of an appointment booking system within the website. Users should be able to book appointments for my services through the ...

I'm looking for an IT engineer who has a solid understanding of ThingsBoard and CentOS7 Linux system. Requirements: - Dele...Requirements: - Delete some repeat file on the CentOS 7 server. - Configuration of ThingsBoard to cater to specific requirements. This includes setting up devices and ensuring that all device management functions are properly in place. - Install Mosquitto-clients. - install Curl Ideal Skills & Experience: - Proficient in CentOS7 Linux system installation. - Strong knowledge of ThingsBoard, with emphasis on device management. - Ability to customize ThingsBoard configuration based on specific requirements. - Prior experience in similar IT engineering projects would be beneficial. Please get in touch if you have the n...

...be able to format their blog posts before publishing. WordPress core and TinyMCE are too heavy and too expensive respectively. I want to implement the same functionality of TinyMCE 7 (free version) via custom code in my site. Requirements of the WYSIWYG Editor: - Support for bold, italics, underline, link insert, link remove, align, highlight, font size, font-family, tables, and more. - Support to format HTML tags automatically. Auto add/remove tags to make programmatic sense. Auto format text pasted from WordPress - Proper functions so that I can programmatically insert content in the editor. - Quickbar to show relevant tools, easily. Basic image manipulation like alignment and size. Preferably the toolbar is inline. - Support to have it as fullscreen wit...

I'm looking for a freelancer to conduct an in-depth market survey on electric instant and storage water heaters in Bangladesh. The focus will be the trifecta of evaluation - market demand, product features, and consumer needs. Requirements (Must live in Bangladesh Dhaka): 1. Identify Top Retailers: List the top 5 major home appliance retailers in each country. 2. Document all Water Heater Brands in the store (focus on electric instant and storage water heaters): Visit 1x store (pick the biggest and most popular store) of each Major Retailer. Then compile a list of popular water heater brands, including pictures, prices, and key features. Highlight the most sought-after brands in each country. 3. Online Platforms: Document online platforms s...

I'm looking for a skilled PHP developer to create a code editor plugin. The plugin should replicate the functionality of the Shopify code editor, offering Syntax Highlighting, Auto Complete, Error Detection, and supporting both HTML/CSS and PHP languages (PHP support is optional). The plugin is intended to be a standalone component, not embedded or replacing any existing editor. the editor should include a file search (to search through templates) - similar to shopify but as well as searching filenems it shoudl also search in contents The editor shoudl work with a master theme/child theme style system such that when a template is modified its auto-copied to the child theme Key requirements: - Develop a code editor plugin similar to Shopify's - Imple...

As the client for this project, I urgently require an expert in VBA.

I am in need of an expert in Excel data entry. The objective of this project is specifically for data entry purposes. The task involves keying in customer information into Excel. Familiarity with this type of data is a big bonus. Attention to detail, fast typing speed, and meticulousness are skills that are necessary to successfully complete the task. Additionally, extraction of specific information will be required. More specifically, identifying trends within a given period from the input data. Therefore, a keen eye for detail and an analytical mind are crucial for this job. In conclusion, if you have experience handling customer information, know your way around Excel, have a knack for finding patterns among data, and can type fast, ...