Update vba excel project jobs
I'm in need of an Excel formula expert to help me with a specific task. I need a formula that will COUNT cells based on the following criteria: - I need to COUNT the number of cells in a range that are greater than -250 - The count should be done for the last 50 cells (ongoing) Your task will be to help me create a formula that dynamically counts the number of cells based on the above criteria. I need this formula to be able to adjust as new values are added to the range. The ideal Freelancer for this project should have: - Extensive experience with Excel functions and formulas - Strong understanding of dynamic range referencing in Excel - Excellent communication skills to explain the logic behind the formula in layman's terms Please include any r...
- Prestashop should receive a...photos. - Prestashop should receive all the customer (contact) data from Zoho. If the contact already exists on Prestashop update, but if not exists create. - If a new customer is registered into Prestashop, a new contact should be created on Zoho if not exists already. -- Every new sale made on Prestashop should update the inventory on Zoho. - Every new sale made on Zoho should update the inventory on Prestashop. - The sale information coming from Prestashop should be registered on Zoho. - One prestashop is in EUR currency and the other prestashop is in CZK currency. - The same products are on both eshops and they share the same EAN and SKU. - The inventory update should be bidirectiona (Prestashop to Zoho inventory an...
...a highly skilled programmer proficient in Excel macros and ODBC data connections to automate critical processes in my business. Specifically, your tasks will involve: - Automating order tracking, inventory management, and vendor communication processes. - Connecting to Excel files, SQL databases, and CSV files using ODBC. - Developing an automated procurement system capable of: - Generating purchase requisitions, - Aiding in vendor selection and negotiation, - Creating and tracking purchase orders. Proficiency in utilizing Excel macros is a must, and experience with ODBC data connections and related platforms is highly desirable. Knowledge of procurement systems and order logistics would be beneficial. Successful completion of this project requires s...
2 excel files with VBA macro as per customer requirement
...the pitch deck is small businesses. - I am seeking a creative and engaging style. - Need to update photos and beat the competition who as we have non exclusive rights to secure new clients Ideal Skills and Experience: - Excellent design and presentation skills, with a proven track record of creating engaging pitch decks. - A good understanding of the small business sector and what appeals to entrepreneurs in this field. - Creativity and the ability to think outside the box to ensure the pitch deck stands out. Please include samples of previous pitch decks you have created, particularly if they were for client acquisition projects. Your proposal should also outline how you plan to approach this project and your relevant experience. see Fashion DRAFT Ugo Mozie deck here a...
I'm looking to have my existing webpage refreshed. Specifically, I require: - A complete design update, revamping the layout for a contemporary and intuitive feel. Although I haven't specified a layout style, I'm open to suggestions. Creativity and a keen eye for design are crucial for this project. - Adding new functionalities that will improve the web page’s overall performance and efficiency. Expertise in advanced web development and understanding of the latest technologies is necessary. Your proposal should demonstrate your experience with web design and functionality improvements. In addition, portfolio samples showcasing similar projects would be highly beneficial. Overall, I'm seeking a freelancer capable of transforming the user experience...
I need an expert in Microsoft Excel to build an efficient spreadsheet to monitor potential lost revenue due to late service deliveries. The ideal candidate would possess a strong background in creating financial models and understanding of revenue tracking. Key Requirements: - Proficient in Microsoft Excel, with emphasis on creating advanced, clear, and highly-functional spreadsheets. - Experience in financial modelling and understanding of revenue tracking. - Ability to automate the process as much as possible to minimize manual tracking. Objective: - Create an intuitive and efficient Excel spreadsheet to replace the current manual method of tracking potential lost revenue due to late service. Skills Needed: - Microsoft Excel - Financial modelling - Adv...
I'm seeking a professional to diligently run through LinkedIn, identifying and documenting HR higher-u...Identifying: I'm targeting senior-level personnel only. Expertise in navigating LinkedIn search and understanding corporate hierarchies will be a plus point. 2. Documenting: I'd like the findings to be presented in a tabular form within an Excel document. Critical data points to be captured include the Company Name, individual's LinkedIn Profile link, and their Role. Your background in HR and corporate structures would be critical in understanding the perfect fit for my requirements. Strong organizational skills, meticulous attention to detail, and proficiency in Excel would be highly appreciated. Overall, a good grasp of LinkedIn-based research would...
I'm in need of a WordPress specialist who can help me in adjusting a few things on my raffle website. The project involves both layout and design changes as well as functionality enhancements. To give you a clearer picture, here are the specifics: - **Layout and Design Changes**: I'm looking to update the color scheme and integrate new fonts to the website. These changes are crucial in giving the site a fresh and visually appealing look. - **Functionality Enhancements**: Besides the aesthetics, I also require help in modifying the page structure. The goal is to make the site more user-friendly and engaging. Ideal candidates for this project should have: - Strong WordPress skills - A good eye for design and aesthetics - Experience in implementing functiona...
...should setup a language selector that corresponds with specific currencies just as it is on Footshop.pl. This will allow my website visitors to choose their preferred language and see prices in their local currencies. - **Currency Update Feature**: The currencies should be updated regularly to reflect the current exchange rates. You should be able to leverage both fixed, real-time, and custom conversion rates. - **G|Translate Service Integration**: I desire to have the translation service on my website powered by G|translate service. Ideal freelancers for this project should have strong experience in web development, API integrations, and preferably previous experience with language and currency conversion implementations. Understanding of different currency point conve...
I'm looking for a skilled freelancer to help me create a pivot table in Microsoft Excel that will be used to find pricing quicker Key Requirements: - The pivot table must be created in Microsoft Excel. - The purpose of the pivot table is to find pricing easier The data sources which the pivot table will be using are confidential, and will be shared with the selected freelancer.
I'm seeking a proficient individual to help with a data entry project. I have about 40 URLs, from which I need to extract the product names, prices, and descriptions. The goal is to collate this information in a pre-defined Excel template. Key Aspects: - Extract product names, prices and descriptions from 40 URLs. - Populate an Excel file with the gathered data.
I'm seeking a skilled individual with a strong command of Microsoft Excel and Word. The tasks at hand are primarily data entry, table creation in Excel and development of an instruction manual in Word. Key Responsibilities: - Efficiently perform data entry tasks in Excel. - Create tables in Excel to visually present the data. - Develop an instruction manual in Word. Ideal skills for this project include: - Advanced proficiency in Microsoft Excel, with a strong expertise in data entry and structuring information. - Proficiency in creating tables, and potentially pivot tables. - Strong experience in creating documents in Word, preferably instructional or informative content. - Attention to detail, as accurate data entry is vital. - Strong co...
I'm in need of a professional who can develop a website for me using Node.js. The website will be to trade Counterstrike game skins on our website. Please view our...skins on our website. Please view our two resources provided which is what i could find. We want to use and update this code and application to newer counterstrike 2 and maybe find new features and techniques to build the website. We need a developer that can assist us with designing, developing, improving and deploying the website to our server. Please have a look at the two references and go through it so we can discuss options to improve it and update it. Competitor website -
I'm in need of an Excel calendar for 2024 - 2025 that will be used for tracking school days off and special events. The calendar should feature the following: - Ability to add and modify events - Monthly view - Color-coded categories - Dates should be highlighted with background color Ideal skills: - Proficiency in Excel, including knowledge of advanced functions - Experience in creating and customizing calendars - Design proficiency to ensure aesthetic and functional layout Look at the Sample
●Platform Compatibility - Available on iOS and Android ●User Registration/Initial Setup - Users must set their Gender, Age, and City upon first launching the app ●W...week - Users have the entire week to respond to the questions - All responses are compiled and statistics are posted in the app every Monday ●App Sections - Section 1: Current Week's Questions - Section 2: Previous Week's Statistics - Includes a "Share" button to post statistics to Facebook, Instagram, Messenger, and other social media platforms - Section 3: Settings (allow users to update Gender, Age, City) ●Admin Features - Admin can input new questions each week for the users ●Notifications - Users receive weekly reminders to answer the questions - Notification when n...
I'm in need of a virtual assistant to help with a variety of tasks, specifically: data entry, email management, and conducting research. ...help with a variety of tasks, specifically: data entry, email management, and conducting research. Ideal Skills and Experience: - Proficient in Google Docs and Sheets - Experience in managing email inbox - Can attend video calls and meeting to write MOM with clients I'm looking for someone who can commit to more than 20 hours per week. The ideal candidate should have a basic understanding of Excel or Google Sheets. Your job will be to document data, answer emails effectively, and conduct research on various topics. I am looking for someone who is timely, organized, and detail-oriented. Please reach out if you think you are a goo...
I have a calculator form that needs some updates made. It allows the user to input measurements for an industrial hose to find out settings for crimping. Current form is here: Need to add an option for the user to calculate with Hose Wall Thickness OR Hose ID & OD. Here is a prototype sho...that needs some updates made. It allows the user to input measurements for an industrial hose to find out settings for crimping. Current form is here: Need to add an option for the user to calculate with Hose Wall Thickness OR Hose ID & OD. Here is a prototype showing how this will work: New page (needs some jQuery updates): Also have Excel with new formula
One excel file with macro as per the customer requirement
I'm seeking a skilled Swift developer who can assist with updating my iOS app. The task involves enhancing the app to meet current standards and potentially fixing any bugs identified in the current version. The successful candidate should have the following skills and experience: - Proficiency in Swift and familiarity with Firebase-iOS development. - Experience in updating and maintaining existing iOS applications. - Ability to identify and address bugs effectively. - Strong problem-solving skills and attention to detail. Please include your past work or any relevant experience in your application.
I am seeking an experienced freelancer who is proficient in data mining tasks in Excel. the analysis must done in excel by installing the data mining tools in excel The ideal applicant should be capable of installing and executing data mining tools in Excel. Unfortunately, I cannot specify what data mining tasks will be performed, nor the type of data provided for the analysis as these details are not available just yet. However, in order to be eligible for consideration, please include: - Detailed project proposal showcasing your approach to data mining tasks. Feel free to inquire if you need any more details. A strong understanding of data mining in Excel is essential for this task. Looking forward to your proposals.
As a business owner, I need a data entry operator who is proficient and experienced with Excel formulas. This is fairly urgent, and I am looking to make a quick hire for this role. The complexity of the task at hand includes: - Data entry with calculations - interpretations are not necessary - The project needs to be completed as soon as possible The ideal candidate for this job would possess: - Speed and accuracy for data entry tasks - Strong proficiency with Excel - A deep understanding of Excel formulas - The ability to work under tight deadlines I look forward to seeing your bids and working with you. Thanks!
I need a knowledgeable and experienced pivotchart expert in Excel, who can assist in creating a line chart to visualize my customer data. This chart should effectively illustrate the purchasing behavior of my customers over time. A deep understanding of customer trending and Excel pivotchart is essential. Key Requirements: - Expertise in Excel pivotchart (specifically line charts) - Ability to analyze and visual customer data - Experience in monitoring customer purchasing trends - Quick and efficient work pace - Attention to detail and accuracy - Excellent data visualization skills This role requires strong organizational and analytical skills. Previous experience in similar tasks is highly valued. I look forward to seeing your bids.
I'm looking for a skilled graphic designer who can create a 3D rendering for a real estate project. This rendering will be used for marketing materials. I need these renderings to be update to appear to be in a more rural area. Please see pictures of the actual lot in the attachment. These pictures will be used to presell this new construction home. Therefore I want these rendering to represent the area this home will be built in more accurately. Key Requirements: - The 3D rendering should primarily focus on the exterior view. - It should also include a detailed representation of the landscaping. Ideal Skills & Experience: - Proven experience in creating high-quality 3D renderings for real estate projects. - Strong understanding of design principles, particularly...
Update a set of CAD drawing to reflect 'As Built' and additional pending changes. Stamp for submission to local building department in NYC. Includes floorplans, electrical and plumbing plans.
I'm in need of a React expert who can build a front-end application. The application should be similar to the existing website, https://www.d-id.com. To do: - Update the existing React template. - Integration needed with Backend API developed. Please include React template of your previous work your skills. Looking forward an individual guy to discussing this project further with you!
We are in need of an experienced WordPress developer and designer to update our corporate website. A command of of WordPress is essential - but an equal eye for creative design is also essential. In summary, we are expecting to be impressed by your previous work. Our existing WP site is unloved and needs a refresh – the site is out of date and some of the functionality requires fixing. There will be some minor text-image edits along the journey. The site is quite small with less than 15 pages with the core contents of the website to remain. The only integration is mailchimp where users may register their email on our site. The suggested milestones are as follows: 1. Review the existing site and make any required updates and fixes. 2. Submit sample theme for approval 3....
I'm in search of a project coordinator with a background in team coordination and excel. The selected individual will be primarily responsible for planning and organizing a one time project, it will be plotting out some meetings and planninh some deadlines in excel. I'd like to ask them questions while they plan it out if possible! Key Requirements: - Strong Experience in Project Management: This is the most critical requirement. Experience in managing technology-related projects is highly preferred. - Strong Organizational and Time Management Skills: Ability to organize tasks efficiently and manage deadlines effectively. - Excellent Communication and Interpersonal Skills: Ability to communicate effectively with team members, stakeholders, and ...
... * **Chatbot Features** - The chatbot should be capable of handling customer support tasks, answering sales inquiries and tracking orders seamlessly. * **User Interaction** - The chatbot needs to be user-friendly for both Stone Crusher Owners and customers. * **Database Interaction** - The bot should interact with our MySQL database to extract data when needed. It doesn't need to update the database, just fetch necessary information when required. * **Skills and Experience** - Strong background in AI chatbot development. - Experience with Gen-AI platforms. - Proficiency in working with MySQL databases. - Knowledge about Stone Crusher operations would be a bonus. * **Sample QA** User: What is Address of my customer whose name is TechnoSystem. ChatB...
I'm seeking an experienced Wordpress developer to give my website a text content makeover. I have between 5 to 10 pages that require updating. Key Responsibilities: - Update existing textual content across the site - Ensure that new content is aligned with the overall website design and theme - Add multiple languages to the site, content will be provided. Ideal Skills: - Strong Wordpress experience - Expertise in content integration - Excellent attention to detail This project will require excellent understanding of Wordpress functionality and design and exceptional attention to detail. A keen eye for aesthetics and intuitive user experiences is vital. I look forward to your proposals.
You will get an application that automated extracts the data from any site web you need, cleans it, and presents it to you in an Excel folder or links it to the database, etc.1 - An application capable of extracting infiniti of data automatically without human intervention and in a short time2- You can choose any package you want according to your specific needs3 - After that, you will get rid of manual data extraction, which requires a lot of time and focus, etc. With the application, say goodbye to manual errors.
I need a proficient Excel expert to adapt my advanced financial models to reflect our current business strategies. The project involves: - Adapting advanced financial models: The existing models are highly complex, with intricate formulas and extensive use of macros. The ideal candidate should be comfortable working with such complexity. - Business strategy alignment: The primary goal is to ensure that these models accurately mirror our updated business strategies. This may involve tweaking existing formulas, adding new ones, and making the models more responsive to changing market conditions. Ideal Skills: - Advanced Excel Proficiency: A deep understanding of advanced Excel functionalities, including complex formulas, pivot tables, and macros is critical. - F...
I need a real estate development pro forma converted from a PDF to a functional excel file. One document is 18 pages and the other is 17 pages.
i want 3-5 minutes (both timeframe) candle data into excel sheet. data like date, time, open, high, close, volume of each candle. (check image for refrence) data should be updating in realtime, no delay, next candle data in new row. add instruction, so that i can edit code my self and chsnge stock symbol to get data for desired stock. easy to use and record all day data, even if i open excel at the day end or reopen thw whole day data should be recorded.
I'm urgently seeking for a Flutter developer with a minimum of 2 years experience to assist in a development project. Here's what I need: - Integration of Firebase Firestore in my app. If you've previously incorporated this database system into a Flutter application, you're likely the candidate we're seeking. - Incorporation of push notifications into the application. Specifically, I require system update notifications and user engagement reminders. Ideal candidate must have: - Proficiency in coding and working remotely (Anydesk or Teamviewer). - Experience in Flutter development specifically database integration and push notifications set-up. This project offers a full-time position with a monthly salary between 25k to 30k. Please apply i...
Looking for some simple finance-based calculations on a car-budget, some simple ratios and charts, by using MS-Excel. Also need a 650-words write up in 2 to 3 days
...comprehensive wedding website and app that will serve as a one-stop solution for all my wedding-related needs. Key Features: - RSVP Management: The app should be able to track and manage RSVPs from all invitees. - Wedding Countdown: A countdown feature to the wedding date. - Photo Gallery: A place to store and showcase the couple's photos and memories. - Guest Management: The app should have two excel sheets, one for the bride's guests and one for the groom's guests. - Dietary Preferences: A feature to collect and manage dietary preferences of guests. - Seating Charts: Ability to create and manage seating arrangements. - Communication: Integration with WhatsApp to create a community for confirmed guests. - Create an app for it so can log in via website or app. I...
...continuously scan and update its database of cryptocurrency projects, highlighting those that have significant pre-approved investor interest. - I require the bot to provide detailed information about each identified coin, including the number of pre-approved investors and relevant project details. **Technical Requirements:** - Utilize cryptocurrency APIs and blockchain data sources for real-time tracking and analysis. - Implement an efficient scanning algorithm to identify coins meeting the investor threshold. - Integrate with Telegram Bot API or Discord API for seamless message delivery and user interaction. If you have experience in blockchain development, bot creation, and integration with messaging platforms, please reach out to discuss the proj...
...week - Users have the entire week to respond to the questions - All responses are compiled and statistics are posted in the app every Monday ●App Sections - Section 1: Current Week's Questions - Section 2: Previous Week's Statistics - Includes a "Share" button to post statistics to Facebook, Instagram, Messenger, and other social media platforms - Section 3: Settings (allow users to update Gender, Age, City) ●Admin Features - Admin can input new questions each week for the users ●Notifications - Users receive weekly reminders to answer the questions - Notification when new statistics are posted Users are presented with 7 questions each week, each with multiple-choice answers ranging from 2 to 10 options, prepared by the admin Users have...
I'm in need of a talented frontend developer to create a robust and user-friendly search frontend for document base. The documents are already indexed in an Opensearch database with various custom fields (Speaker, Place, Theme, Keywords,... ) apart from the standard ones (document format, creation date, update date, size, link to document,...). So the frontend will be sending queries to opensearch and displaying the results. Key Features: - Filter Options: Users should be able to filter their searches based on multiple criteria, such as date, location, category, etc. - Sorting Options: The search results need to be able to be sorted by relevance, date, or other relevant parameters to enhance user experience. It should be possible to sort the documents by multiple parameters a...
I work for a security company. We needed a spreadsheet to track security units and track what they're doing. I have the code almost perfect, but it's buggy enough that it's hard to use. There's quite a bit of backend code and intermittent problems with it. I need someone who is great at project code to look at it, troubleshoot it and make it more user friendly.
...formats for video tutorial integration - Understanding of e-commerce if applicable to course payments - Ability to ensure smooth user-friendly course navigation design - Familiarity with creating dynamic, engaging course pages - Strong grasp of SEO tactics to attract traffic to the site - Ideally, experience in launching similar multi-disciplinary course platforms. Gemini was just updated. See update Conversation with Gemini profile picture I want to create a website In WordPress which will allow users to access a wide range of courses for employability and finding work. We will need a register LMS, user dashboards, ai application integration. Security, social media will need to be a part of the business. Your task is to create a plan for the various stages of work require...
...(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...
...modeling specialist to create a comprehensive financial model for a vending project. This one-time task involves analyzing various metrics, such as conversion rates, visitor traffic, and other relevant data to forecast the profitability and feasibility of the project. Responsibilities: - Create a financial model based on the specific requirements of the vending project - Analyze conversion rates, visitor traffic, and other key metrics to predict profit margins - Utilize advanced spreadsheet techniques to organize and present data effectively - Provide recommendations and insights based on the financial analysis Requirements: - Proven experience with financial modeling, preferably in the vending industry - Proficiency in Excel, Google Sheets, or other financ...
I am in need of a LinkedIn banner update to be completed as soon as possible. Can be based on the current banner - just need to change the words as a priority but other elements could also change. The key visual elements to be incorporated include our company logo, relevant product images, and a tagline that says Automated Financial Management. The color scheme of the design should primarily be purple and white to align with our current branding (previous Linkedin banner attached) Not a complex job - just looking for something clean and quick delivery
We're looking for multiple competent native English editors to help us improve English language usage in a big batch of Excel-related tutorials. Starting with a paid trial. Please bid $20.
...that updates customers and the admin on the status of their orders. - The website should have a secure payment gateway that requires OTP for added security and offers a refund option (My Fatoorah). - The website should should have an option to add header code for analytics and marketing purposes. - The website should have Yoast SEO configured to add structured data, auto-generate sitemaps, and update meta titles and descriptions for all products. - The website should have a WhatsApp Business icon for easy customer communication. - The website should have a new page for B2B enquiries for bulk orders. - The website should have a branch locator page with Google maps integration. All stores should be marked with a red pinpoint, and customers should be able to view store details...