Function excel vba jobs

...envisioning: - Email Targeting: The website should allow for the selection of any Hotmail email address. The purpose of this is to ensure that the site can pull messages from different accounts as needed. - Specific Message Retrieval: The core functionality will be to retrieve and display a specific message from the selected email account. That message is usually a temporary code from netflix. - Search Function: A search bar is necessary for sifting through emails quickly. - Auto-Refresh: I'm hoping the website can include an automated refreshing feature. This is highly important because the email containing the temporary code is from Netflix and it's time-sensitive. Skill Requirement: I'm seeking someone with experience in web development, API usage (specifical...

I'm looking to hire someone who can create an Excel VBA workbook to seamlessly integrate with my Zoho Desk setup. This workbook should be specifically engineered to perform the following: - Retrieve the required information from Zoho Desk tickets upon pressing a button inside Excel. Specifically, I need someone skilled in Excel VBA programming and API integration work to: - Design a user-friendly interface in the workbook where one can press a button to initiate the retrieval of ticket information. You should be able to retrieve the latest ticket, and then have two more buttons to go to next & previous tickets. - Implement secure API connections to Zoho Desk to enable the retrieval of ticket information usuing oauth. The fields I need are: Su...

I need emails from these companies of CEO ot anyone else working in financials, sales, or partnerships. Data scraping from rocketreach of the emails of the people that you can find with relevance from these companies in the image. Excel sheet with company name in the rows and in the 3 columns full name, email and position in the company

Data entry operator and my work very clear

I'm looking for an experienced professional in Excel to create a custom financial tracking template for me. Bonus if compatible with both google sheets and excel. Key Elements: - The template needs to include sections for tracking income and expenses. - Additionally, I need sections for debt repayment tracking and Year To Date (YTD) tracking. - The template should be designed in a way that it is easy to update monthly Ideal Skills: - Proficiency in Excel and experience in creating financial tracking templates. - Knowledge of financial principles and ability to design a user-friendly, visually appealing template. - Attention to detail and ability to customize the template to meet my specific requirements. Please include samples of similar work you've done ...

I need an experienced developer who can design and build a proof of concept(POC) within 2 months for marketplace app for both Android and iOS. This app should function seamlessly, being simple to use with users able to: - Filter searches - View listings - Interact via a messaging system - Execute secure payments - Utilize an AI-based search We do not need the scalability and storage aspect covered in POC phase. I just production ready UX. Ideal candidates have a proven track record in mobile app development, specifically with e-commerce platforms. Familiarity with AI integration is desirable. If you possess great UI/UX design skills and have the ability to create logical and intuitive navigation, I am interested to hear more about your work process and past projects.

I'm looking to create a detailed list in Excel from the website AND filtered by clicking on 'Hardware' under 'Products' which is on the left side in the 'Filter' section. The list should have two columns - the first for the Company Name and the second for the Description available on the website. Key Requirements: - Copy the Company Name into Column 1 and the Description into Column 2 of the Excel sheet. - Description should be directly copied from the provided URL. Ideal Skills and Experience: - Proficient in Excel and web scraping. - Attention to detail to ensure accurate data transfer. - Previous experience with similar projects would be advantageous.

I have a backend code for a pre-existing fully function website and mobile app. The backend code is currently all written in php. I need someone to convert this existing php code into fully functional python code which I can deploy.

Excel Chart Re-Design for University Work Allocation System We are looking for somebody to complete the development of an excel-based teaching allocation database for a relatively large university department (approx 100 teaching staff). We currently make use of an excel template that roughly cross-references university courses with teaching staff and allocated time commitments for specific tasks. This is quite a complex information array, however, with so many staff members and courses (approx. 120), especially where multiple staff members are co-teaching courses with different task responsibilities. While our current template achieves its desired information management purpose, in its present state its structure is relatively complex and not user-friendly or ...

Looking for an expert who can bring my educational content to life with vibrant, engaging 3D animations. The animations should be a blend of character-based and abstract to maintain viewer interest. Key Requirements: - Skilled storyteller through 3D animation. - Experience in character-based and abstract animation. - Excel in conveying complex information simply and clearly, ideally within an educational setting. - Ability to work collaboratively, ensuring your creations align with my vision. Enhance your bid with relevant work samples, especially animations used for educational purposes. I am excited to see your creativity at work!

I am looking for a proficient app developer to create a TV application that will function on Android TV, TizenOS (Samsung), Fire TV (Amazon), and LG Smart TV. The ideal candidate for this job should be experienced in developing apps for multiple platforms. Description We're seeking a skilled freelancer to develop a TV app for Android (v5-13), TizenOS (Samsung 2012-2024, Tizen 1-8), Fire TV, and LG platforms. Skills required: - TV app development - Android - TizenOS - Fire TV - LG - User interface design - Performance optimization - Problem-solving - Strong communication skills App Features: Responsive UI for various screen sizes Displays Live, Series, and Movie content (data from web service) User favorites list (local & online storage) Playback resume from last positio...

Website on Wordpress License key generator with DB API for Excel Template connecting to DB for license key validation. Dashboard for administrator enter buyer/customer account credetials. The administrator must be able to enable and disablle accounts. Update Excel Template LicenseValidation code for connectiing to API/DB. I will privide this Excel Template code file.

Please Sign Up or Login to see details.

I need an Excel expert to update my spreadsheet. The main tasks include: - **Formulas and Calculations:** I require formulas to be implemented for various calculations. The freelancer should possess a strong understanding of Excel functions and be able to apply them accurately. - **Formatting:** The formatting of the spreadsheet needs to be updated. This includes: - **Font Styles and Sizes:** I need the text in the spreadsheet to be consistent and visually appealing. The freelancer should have a good sense of design and layout. - **Number Formats:** Incorrectly formatted numbers need to be corrected. The freelancer must be meticulous and detail-oriented in this aspect. - **Color Changes for Expired Dates:** An important part of the project is changing the color of cel...

I'm in need of a skilled website developer with prior experience in creating medical tourism websites. My goal is to create a platform that specifically focuses on facilitating the direct booking of various medical services for international patients. Key Features: - The primary function of the website should be enabling direct booking of medical services. - The website should be user-friendly and accessible for a diverse international audience. - Clear, concise and compelling content is essential. Experience in medical tourism website development is a huge plus. Your familiarity with the industry will help ensure that the design and functionality of the website are tailored to meet the needs and expectations of both medical providers and potential patients. Please provide ...

I'm looking for an experienced Excel and PineScript expert to create custom Excel formulas replicating my developed PineScript indicator. The indicator performs functions for Bollingerbands and Keltner Channels. The task will be to incorporate Open, High, Low, Close prices into the Excel formulas. Please note, data collection or data visualization is not required for this project. To give your best, you should possess an advanced understanding in: - PineScript - Creating complex Excel formulas Looking forward to your informed bid.

I need help with an Excel sheet that will be used for data analysis, specifically sales distribution. The sheet will include a mix of sales data, customer information, and product inventory. Key tasks: - Organizing and inputting the provided data correctly - Creating a system for sorting and analyzing the data - Developing a system for tracking sales distribution effectively - Potentially applying necessary calculations and formulas to enhance the data analysis Ideal Skills: - Proficient in Excel, including data analysis and financial functions - Experience with sales data and distribution analysis - Strong attention to detail and organizational skills - Ability to create formulas and calculations - Familiarity with customer information and product inventory management Ple...

...fields into an Excel (.xls) file. The database consists of approximately 150,000 entries. Each record includes data such as name, business name, contact information, date of foundation, etc. Ideal Skills: - Strong experience in Web Scraping - Proficiency in transferring data into .xls format - Attention to detail to ensure all available fields are captured Purpose and Deliverable: - The objective of this project is to use this information for data analysis. - The final output will be an Excel (.xls) formatted file containing each scraped database entry. Operation Specifics: - You would be required to locate and scrape the database by Zip codes. - A full export of all accessible information per entry is needed. Your expertise in internet research, data mining, and...

I am seeking a t...numbers for promoting my business. Key Features: - Bulk Phone Number Verification: The tool should be able to check multiple phone numbers at once. It should separate the active numbers from the inactive ones. - Whatssap Compatibility: The tool needs to connect with Whatssap API to confirm the activity of the numbers. Delivery: - Data Export: I require the verified numbers to be exported to an Excel spreadsheet for easy access and use or .txt file Skills & Experience: - Proven experience in API integration, specifically with Whatssap. - Strong programming and software development skills. - Experience in building phone number verification tools will be a plus. Please provide examples of similar projects you have worked on previously. Looking forward to y...

I'm looking for a freelancer with excellent attention to detail and proficiency in Microsoft Excel and Word. As part of this project, you will be required to manually enter data from Excel files into a Word document. Key Requirements: - Strong Microsoft Excel and Word skills - Proven experience in accurate, manual data entry - Ability to work with robust data sets Deliverables: A Word document with the data accurately entered from the provided Excel files. Your ability to deliver clean, accurately transcribed data is essential for the success of this job. Attention to detail is paramount. I look forward to working with detailed and skilled freelancers.

I need an assistive hand in a data extraction task that requires sharp focus and meticulous attention to detail. The task involves: - Extracting email addresses from an Excel spreadsheet - Maintaining accuracy and precision during the data entry process, ensuring no data is missed or inaccurately entered Proficiency in Microsoft Excel is a must for this task. Previous experience in data extraction or data entry is highly desirable. You should be adept at handling large volumes of data, have a keen eye for detail, and are able to keep track of your progress systematically. Let me know your capacity per day/week as this can be an ongoing project. Please dont negotiate on the price beyond the Bid provided

For my company, I need an expert with extensive experience in data consolidation and import to QuickBooks. - The project involves the migration of the company's financial data for the years 2022 and 2023 which is stored in Excel spreadsheets currently. - The data needs to be consolidated into a single file before importing into a new Quickbooks instance. As an ideal candidate, you should have: - Experience with Quickbooks data import - Excellent understanding of data consolidation - Proficiency with Excel spreadsheets - A keen eye for detail and the ability to maintain the integrity of financial data during the import process.

The Project Scope: - Implemented a cancel function button so that money does not decrease when the game is canceled. The update items are as follows. 1. If you lose a game, use the Cancel game button to prevent money from being reduced. The Key purpose: - Cancellation of betting events through specific game cancellation events Or I want to predict the result and proceed with the game.

...our Point of Sale (POS) system, and warehouse stock counts. Key responsibilities: - Regularly updating our inventory data with utmost accuracy - Ensuring all channels of data (supplier invoices, POS system, stock counts) are accurately reflected in our inventory records - Generating purchase orders based on the updated stock levels Your skills and experience should include: - Proficiency in Excel/ Google Sheets - Experience in inventory management/data entry - Attention to detail and accuracy - Ability to work independently and meet daily deadlines - Familiarity with purchase order generation is a plus. A successful candidate will not only update the inventory data accurately and promptly but will also be able to adapt to any changes in stock levels in real-time, ensuring ou...

I'm in need of an experienced Excel professional to help me build a secure data management system. This system will be used to handle both financial and customer information. Key Requirements: - **Data Security**: A robust system that ensures the privacy and integrity of the financial and customer data. - **User Management**: The system should be designed for 1-10 users, allowing them to access and input data securely. - **User Experience**: While the users are expected to have advanced Excel skills, the system should be designed with clear interfaces and user-friendly features. Ideal Candidate: - Proven experience in designing secure data management systems in Excel - Proficiency in VBA and Excel's advanced features - Strong understanding of data s...

I am looking for a WordPress expert to create a professional Real Estate website. Key Features: - The main function of this website will be as a platform to showcase property listings. It must have excellent search functionality for users to find the exact property they're looking for. - I will provide all the content for the website including property details, images, and text. Your role will be to organize this content effectively on the site. Ideal Skills: - Proficiency in WordPress - Experience in creating Real Estate websites - Ability to effectively organize and present large amounts of data Please note that while a blog section is not currently planned, I would be open to discussing its addition if you believe it would enhance the site.

I'm seeking a skilled web developer to design and build a comprehensive e-commerce website for my business. Specifics of my needs are: - The platform will cater to an estimated range of 100 - 500 products. The type of products on the site is still to be disclosed. - A key requirement is incorporation of a search feature function to streamline user navigation. Ideal candidates will possess expert knowledge and experience in e-commerce website design, SEO, and product database management. Excellent skills in user experience optimization are also desired.

...have a droplist with all the variants of The Configurable Product but still keep the original texts and links for the Simple Product. The Configurable Products is hidden and we only want to show each Simple Product separately, but inside the Simple Product there should be a droplist with all variants. When you select a variant, we want you to be redirected to chosen Simple Product. So we need a function that checks if the product is linked to a Configurable Product but retrieve a list of links to all the interconnected Simple Products. We will need help with more things but we can start with these to move the project forward. Do not write to us if you have never worked with Hyvä and tailwind / before this is a requirement....

I am on the lookout for a proficient Wix mobile app developer, with an inherent creativity for a minimalistic yet engaging d...needed. - Push Notifications: This should be a fully implemented feature, keeping users informed about any updates or promotions. - In-app Purchases: An understanding of creating seamless in-app purchases will be of immense value for this project, to drive a smooth eCommerce experience. Aesthetic: - This project necessitates a minimalistic design, catering to users who value simplicity and function over decoration. Ideal Skills & Experience: - Significant experience with Wix mobile app development - Familiarity with eCommerce apps - Experience implementing user registration, login, push notifications, and in-app purchases - A good eye for minimalist...

I am seeking an exceptional iOS app and android developer who can bring my idea to life. The chosen developer should be capable of implementing the following features: - In-app purchases system - Login system - Real-time updates - Users Nearby function My preference is a design that is modern and minimalist. The ideal candidate will be able to provide creative input and suggestions while adhering to this design preference. Proficiency in Swift, knowledge of Apple's design principles and interface guidelines, and experience in designing seamless in-app purchases are essential for this project. Experience with geolocation services for the 'Users Nearby' feature is also a great plus. The app would basically entail user profiles, chat system, subscription, live Geo l...

I am in immediate need of a professional with proven experience in writing legal Partnership Agreements. Specifically: - Proficiency in drafting Partnership Agreements is crucial. - The agreement must excel in providing measures for protecting sensitive information. - Understanding of confidentiality and data protection is mandatory. I am expecting work that is thorough, legally sound and protects my interests optimally. It is not about just getting it done but getting it done right. Previous experience with such documentation is a solid advantage. Kindly share your portfolio when applying. Accuracy, attention to detail, and understanding complex legal terminology are the skills that I am looking for. NB: Experience with sensitive information protection will be a bonus.

I have excel file where I want to clean. Merge columns and make it simple. You have to be able to fix it within 30 min not more

I need a web-based contract management application with alerts system to remind me of contract termination dates. Key Features: - Contract Entry System: The application must allow for storage and retrieval of specific contract details which include the contract value, duration, name, start date and end...include the contract value, duration, name, start date and end date. - Sorting Functionality: A key requirement is for contracts to be sorted primarily by their end dates. - Alert Mechanism: The application should notify me noticeably in advance of each contract's expiry date. Ideal Freelancer: You should be a skilled application developer with experience in creating management systems with sort-function and notification features. Understanding of contract management would b...

I'm looking for an adept Javascript developer who is proficient with React to create a function for my custom web app. Here's what you'll be working on: - DOM Manipulation: Your main task will be form manipulation. The ability to handle dynamic content that may be loaded post initial load is crucial. - Autocomplete Function: For this role, prior experience with form manipulation, particularly in React, is essential. Knowledge in working with server APIs for autocompletion is also valuable. Your creativity and problem-solving skills will certainly be beneficial in addressing the dynamic content challenge.

I am seeking a professional website designer who can make an intuitive and engaging digital library for sustainable development goals (SDGs). This platform is intended to serve both students and the general public. The website functionality should include: - A powerful search function that makes it easy for users to find specific information. - An extensive collection of online reading materials related to each SDG. - Interactive quizzes to test user knowledge and engagement. - A curated drop-down list of book recommendations for each SDG. - A dedicated section for book reviews to create a community feedback loop and promote engagement with the content. - An "About Us" section highlighting the program, founders, and further relevant information. -We are also lookin...

... The measurement is fast, based on the analysis of whole blood and allows for a differentiated and comprehensive analysis of platelet function. You do not need to worry about the availability of web domains, or any optical design of the logo. Just focus on the text. We might anyway modify your proposal. Therefore simple proposals by text are appreciated. We appreciate any proposal, and if there is a meaning to it, let us know. The name can be based on any language. Of course please do not propose anything that is offensive

...comprehensive and engaging video explanation of all functionalities on our website, Paysavo.com. The video will be around 10 minutes long. The video will need to cover, in detail, the following: - An introduction to - A Functionality overview - The Deposit and withdrawal process - How to use our Crypto exchange - Our International money transfer services - The Multi-currency wallet function -Currency conversion functions -Various currencies supported. -Various Payment method. - Conclusion Also provide short videos for a Help page outlining each functions per outline While there isn't a stringent outline set in place, the above will serve as a flexible guideline for the flow of the explanation. Our target audience for this video are general public, potential investors ...

I am looking for a seasoned app developer who has skills and experience in creating cross-platform applications for both iOS and Android. The primary function of this app will be E-commerce. Key Requirements: - Develop a hybrid app that can operate seamlessly on both iOS and Android platforms. - The app should be user-friendly, responsive, and able to handle e-commerce transactions efficiently. - Ensure that the app integrates with payment gateways such as RazorPay, PhonePe, and PayU, in addition to other expected e-commerce functionalities. Ideal Skills: - Proficiency in hybrid app development for iOS and Android platforms. - Previous experience in developing E-commerce apps. - Expertise in integrating payment gateways, especially RazorPay, PhonePe, and PayU. - Strong problem-so...

... The information required includes details on the CEO, senior management, and email addresses. The data should be compiled into a spreadsheet, such as Excel or Google Sheets, with separate columns for each piece of information. Key Responsibilities: - Researching and collecting information on the CEO, senior management, and email addresses of around 80 councils. - Ensuring the accuracy and relevancy of the data collected. - Organizing the data neatly into a spreadsheet, in a format suitable for subsequent upload to a CRM tool like Pipedrive. Ideal Skills and Experience: - Experience in data research and entry. - Proficiency in using Excel or Google Sheets. - Familiarity with CRM tools, particularly Pipedrive, is a plus. - Attention to detail and the ability to maintain d...

I'm looking for an experienced VBA coder who can focus on two main tasks. 1. **Fixing Existing Issues:** - My current VBA code has issues with execution errors and incorrect results. I need solutions to these two problems. 2. **Adding Modifications:** - I'm looking for someone who can add additional features to my existing VBA code. - Good user experience is important too so improvements on the user interface would be very beneficial. Ideal candidates will have an excellent understanding of VBA syntax, debugging, and error handling. Experience with user interface design is also appreciated. The aim here is to produce accurate calculations, formatted data or reports swiftly and easily.

Hello, I am in need of a developer capable of creating an Excel tool (.xls format) for efficient management of large amounts of data. The tool should have the following features: Storage of large datasets: The tool should enable storing a large quantity of data. Duplication removal: It should be possible to remove duplicates in Excel files to maintain a clean and organized database. Standardization of French numbers: All French phone numbers in the files need to be modified and put into the correct format, such as +33781462503. Editing and export: Users should be able to edit data in the Excel file and export the changes made. Archiving: Once the data is used, it should be possible to upload it to an archive for future reference. I would greatly appreciate it if you co...

Overview: We require the replication of our existing website, or , onto new domains: in German and in Italian. The freelancer will be responsible for creating a duplicate site in the respective language, utilizing a provided template, and cust...Tasks: -Duplicate or onto and freighttrade.it. -Translate all content into German for [] and Italian for []. -Customize the template to ensure a seamless integration of translated content. -Populate pages with industry-specific keywords to optimize search engine rankings. -Ensure all links, forms, and interactive elements function correctly in the new language versions. Note: The template will be provided by us.

I'm in need of a Pivot table in Excel to analyze my sales data. This will help me track and understand key metrics like units sold and profit margins. Key Project Details: - Data: Primarily sales data - Metrics: Primarily interested in tracking units sold and profit margins - Organization: The data should be organized by product and region Ideal Skills & Experience: - Advanced Excel proficiency, particularly with Pivot Tables - Strong analytical skills for identifying key metrics - Experience working with sales data is a plus - Ability to understand and visualize data in a meaningful way.

I need a freelancer to help convert my scanned PDF document into Excel format. The Excel should have the same layout as the original document in the PDF: - Expert in scanned document conversion to Excel is required as the document isn't text-based. - Advanced knowledge in layout replication is necessary because the converted Excel file needs to have the same structure as the original PDF. - Since the PDF contains unknown special data types, ability to deal with potential complexities (like images, graphs, complex tables) would be a plus. The ideal freelancer for this project should have a proven track record in PDF to Excel conversions and dealing with scanned documents. Bonus points for experience with complex data types.

I am in need of a proficient freelancer with expertise in data cleaning and data analytics to handle an upcoming project involving Excel. Specifically, the tasks will involve: - Removing duplicate entries, - Correcting inaccuracies in data as needed, - Formatting data to enhance its visual interpretation. The next part of the project involves data analysis, where the focus is on: - Creating data visualizations, particularly concerning the sales trends in our dataset. A background in Excel-based data correction and visualization is essential. Ideally, you've had previous exposure to sales data and are capable of understanding and predicting trends. Your bid should reflect your ability to accurately complete these tasks in a timely fashion.

I'm looking to set up an e-commerce website on WordPress. The main purpose of this website is to both showcase and sell physical goods. Key Project Requirements: - **E-Commerce Functionality**: The website needs to have a comprehensive e-commerce system, suitable for selling physical goods. - **Product Showcasing**: The site should also be visually appealing and function as a showcase for my products. - **Inventory and Shipping**: While I'm not yet sure if I'll be managing inventory and shipping myself, I'm open to suggestions on the best approach. Ideal Skills and Experience: - **WordPress Expertise**: Proficiency in WordPress is a must, as the website will be built on this platform. - **E-Commerce Experience**: A proven track record in developing e-commerce ...

...confident in my ability to drive engagement and elevate your online presence effectively. Throughout my career, I have honed my skills in creating compelling content, implementing strategic campaigns, and fostering meaningful connections with audiences across various platforms. My experience extends to crafting tailored strategies based on analytics insights, ensuring optimal performance and ROI. I excel in staying abreast of emerging trends and algorithm updates, enabling me to adapt strategies swiftly and capitalize on growth opportunities. Moreover, my strong communication skills and a keen eye for detail empower me to maintain brand consistency and uphold the highest standards of quality in all content produced. I am particularly drawn to this role because of [specific rea...

I urgently need to extract the emails from Excel and place each one in a separate cell. In the image, you have an example of what I want.

1. Develop a function that copies specific fields from Account records into corresponding Ticket fields automatically. 2. Develop a function that auto-fills multiple Ticket fields based on the input from a manually entered field. This function should dynamically pull data from the account database and populate the ticket fields according to the values entered. It is important that we have a solution that is directly usable with no modifications needed apart from inserting our specific IDs for fields/modules etc. If your work meets our expectations, we may be interested in an ongoing collaboration for future projects across various Zoho applications (Desk, CRM, Campaigns, Projects).

...environment. We have already implemented the capability to handle formation flights and a top-down view of multiple aircraft. However, I need assistance in improving the frame rate and optimizing the updateFlightView function. Project Requirements: -Frame Rate Optimization: Enhance the application to ensure a stable frame rate of over 30 FPS, particularly when visualizing multiple aircraft in formation. -Optimization of Existing Features: The current implementation of formation flights and the top view visualization needs performance enhancement. -The updateFlightView function, responsible for updating the views, must be optimized to use a single CesiumJS viewer with two distinct views (main and top) on separate viewports. -Performance and Compatibility: Address any perf...