Excel vba error işler
Desenvolvi uma planilha de excel mas estou a necessitar de ajuda para criar duas novas formulas.
I have 3 construction programs currently in Excel that I need to be converted into Microsoft Project. The programs are primarily focused on project scheduling and do not require resource management features. Key requirements: - Convert 3 construction programs from Excel to Microsoft Project - Create interactive Gantt charts with dependencies - No need for resource management features, just the scheduling aspect Ideal skills/experience for this project: - Proficiency in Microsoft Project - Experience in project scheduling and Gantt chart creation - Previous work in construction or similar industries would be beneficial Feel free to ask me if you need any further details.
I'm in search of a highly skilled Service Now API developer to help me integrate my Service Now platform with external APIs. Key Responsibilities: - Integrate Service Now with selected external APIs - Salesforce, Jira, and Slack - Ensure seamless data flow between the service management system and the external platforms - Develop robust communication and error handling protocols between Service Now and the external APIs The ideal candidate for this project should be well-versed in Service Now API and have a solid track record in integrating with external APIs. Experience with Salesforce, Jira, and Slack APIs is a definite plus. Strong communication and problem-solving skills will be essential for this project.
I'm looking for a detail-oriented researcher to help me gathe...charts can come later. Time is critical - ideally 24 hours. - Sector-wise breakdown: I am particularly interested in the finance/investment sector. Hence, your role will be to provide in-depth insights into the investment figures within this sector. Ideal candidate should have: - Strong research experience - Experience in economics or finance - Ability to analyze & interpret data - Proficient in Excel or data analysis tools - Access and experience with databases including Office for National Statistics (ONS) in the UK /EUROSTAT and STATISTA (paid) for the EU and Investment Association (UK) This project requires a detail-oriented, problem-solving researcher. The figures/charts should all be referenced with t...
I'm in urgent need of a seasoned expert in Microsoft Excel, particularly in creating financial models with emphasis on cash flow management. The ideal freelancer for this project should have proven experience in constructing similar tools for businesses. Key Areas of Focus: 1. Housemaid Cash Flow Tracker: This spreadsheet will facilitate tracking cash provided to our two housemaids and matching their submitted invoices. With three team members involved, it needs to be straightforward and efficient. 2. Monthly Household Budget Expenses: This spreadsheet will serve as a comprehensive monthly budget for all household expenses, including groceries, Amazon purchases, and payments to other suppliers. I envision a format where invoices and supplier names are listed vertically, with ...
...for an expert in Excel who can assist me with designing a functional cash flow budget. The primary aim of this tool will be to help me track and effectively manage two team members expenses. Key requirements for this project are: - Excellent proficiency in Excel, particularly in designing complex budgets and financial spreadsheets. - Experience creating automated functions within Excel, specifically for totalling expenses. - Ability to create a user-friendly and aesthetically pleasing interface that enables efficient data entry and report viewing. The freelancer would need to provide consistent updates and flexibility for potential adjustments during the process. This initiative is essential for my financial planning and needs to be done professionally. If you...
need a skilled freelancer who is an expert in creating financial formulas in Excel. You'll work exclusively with data I provide. Ideal candidate should have: * Expertise in Excel with a specific focus on financial formulas Ddata will be provided
I am currently experiencing an unknown error during the checkout process of my Magento 1 website. The error occurs specifically while customers are entering their payment details. Unfortunately, the error message or codes that would normally help troubleshoot this problem are not visible. Ideally, the successful freelancer will possess: - Deep understanding of Magento 1 platform - Proven problem-solving skills, especially within the context of the checkout process - Ability to identify the cause of unknown errors - Experience servicing e-commerce businesses, dealing with payment processing issues. Your task will be to investigate this issue, identify the cause, and rectify the problem so our customers can complete their purchases successfully.
WHMCS Registar Module Bug Fix expert needed. In the TzNIC Register Module, System Error (3) needs to be fixed.
I'm currently facing some issues with my Excel tracker. - The tracker contains a VBA macro file which seems to be causing formula errors and formatting issues. I'm unsure of the exact nature of these errors, but it's clear they are impacting the accuracy and usability of the tracker. I need a freelancer who can review and rectify these issues in the tracker. An ideal candidate would have strong experience with VBA and Excel, able to handle complex formulas and troubleshoot formatting problems swiftly. Your goal is to ensure that the tracker is fully functional and error-free. Experience with similar projects will be a plus.
As an individual currently managing a project with numerous details and a profit loss statement, I need assistance with daily tasks for our Excel sheets. This will include: - Data entry and organization to streamline workflow - Basic arithmetic calculations for accuracy - Statistical analysis to make informed decisions - Formatting and visual presentation for clarity This role requires proficiency in Excel, a keen eye for details, and strong analytical skills. Experience in financial or project management is a plus. The job will be ongoing and requires daily attention. If your expertise aligns with these needs, please apply.
I'm looking to develop a 4-tier agency commission calculation system ...should be clearly defined and adjustable by an administrator. - **Daily NAV Calculation:** The daily NAV should be calculated based on historical data. This data should be accurate and reliable, and the calculations should be precise. - **Automation:** The system should automatically trigger commission calculations at the end of each business day. This ensures that the process is efficient and error-free. The ideal freelancer for this project should have: - Proficiency in designing and developing commission systems - Advanced skills in historical data analysis - Experience in building automated systems If you have the expertise and experience in the above-mentioned areas, I'd be eager to discuss th...
I'm seeking a skilled JavaScript developer to assist in the optimization and thorough testing of my code. Key Requirements: - Proficient in JavaScript, with a solid understanding of function testing and error handling. - Experience in identifying and optimizing performance issues in JavaScript code. - Ability to create and implement robust test cases. Your responsibilities: - Conduct in-depth testing for my existing functions. - Identify potential performance issues and suggest solutions. - Build upon the existing test cases to ensure a comprehensive coverage of the codebase. Ideal candidates will be able to enhance my code and ensure its reliability.
I need the file upload functionality from our public area to be copied to our backoffice. This will allow the backoffice to upload files for users in the public area. Key Requirements: - Transfer file upload feature from backoffice to public section - Support for the following file types: pdf - Visual feedback of the upload process with a success/error message - Backoffice should be able to both delete and replace files after an upload Ideal Skills: - Proficiency in Xano and WeWeb platforms - Experience with file upload feature implementation - Ability to create a visually appealing and informative upload process - Understanding of user and content management systems This project involves integrating and mirroring an existing feature, so familiarity with Xano and WeWeb is crucial...
I'm looking for an expert who can create a comprehensive dashboard using Splunk for analyzing my website logs. The dashboard needs to clearly visualize data using pie charts. Fetch only specific error logs from cloudwatch and create on dashboard. If there is error on cloudwatch regarding node group, target group and autoscaling group, pod failed it should create alert . For exmple if something goes down it should create alert and also should give cause of issue. Also create dashoboard which will show how many Number nodes in node groups , instances and pod in the autoscaling group, also ram and cpu utilization of pods and nodes. Your responsibilities will include: - Analyzing website logs to understand and visualize the CPU and RAM utilization - Creating intui...
I need an Excel VBA code that can perform exact word matching within an Excel spreadsheet. - The code should generate a list of matched words.
I'm looking for an expert in Excel to assist with a project involving data entry and analysis. The Excel sheet you'll be working on has more than 50 columns and rows and will contain a mix of text, numbers, and dates. You'll be responsible for the following: - Accurate and timely entry of the data provided - Ensuring the data is appropriately formatted and organized - Conducting thorough data analysis, including but not limited to trends, comparisons, and any other insights that can be drawn from the data The ideal candidate for this project should have: - Proficiency in Excel and experience with large data sets - Strong attention to detail - Ability to perform data analysis and present insights - Good communication skills to provide regular updates a...
I'm on the lookout for a talented virtual assistant who thrives on lengthy hours of work and enjoys every second of it! This isn't your usual VA role, though - I'm seeking someone who can confidently handle the following responsibilities: - Social Media Management: More specifically, I need someone adept at Instagram. You'll be responsible for handling and managin...our audience. Ideal Skills and Experience: - Clear understanding of the Instagram platform and how to optimally engage audience in it - Skills in crafting Instagram worthy content - visuals, captions, and stories - Experience in managing professional instagram account is a plus - Must be organized, communicative, and able to handle long hours of work If this sounds like the sort of work you'd exc...
I need assistance with my WordPress site that's experiencing theme compatibility issues with Elementor. The specific problem that needs to be addressed involves error messages that prevent optimal website functionality. Ideal candidate should: - Have extensive experience in WordPress and Elementor - Be able to identify and fix theme compatibility issues - Be proficient in troubleshooting WordPress error messages - Be capable of ensuring the site is functioning optimally post-fix - Be responsive, with excellent communication skills.
For this project, I require an expert who can efficiently extract text content from two distinct webpages and input my data into an Excel file organized by rows. Given that all types of data hold equal importance to me, of essence is for the professional to: - Accurately scrape all text content from the specified webpages - Ensure no data is skewed or omitted during this process - Neatly organize the data by rows in the Excel file The ideal candidate for this job should be proficient in web scraping tools and techniques, possesses an acute attention to detail, and is experienced in using Excel to ensure data is properly formatted and easy to analyze. Please note that minimizing errors during this process is critical, as the data collected will directly influence fur...
I'm facing an issue with my UTM tag, which, unfortunately, is not being recognized in real-time on Google Analytics. Instead of indicating the source outlined in the tag, the traffic is showing up as (direct). I need a skilled freelancer who can identify and rectify this error for me, ensuring that the UTM tag accurately reflects the source of my traffic. This is crucial because I primarily use UTM tags for tracking my marketing campaigns targeted on paid ad platforms. The ideal freelancer for this task should have: - In-depth understanding of UTM tagging and its mechanics - Proficiency in Google Analytics - Experience with business websites and paid ad platforms - Proven problem-solving skills including past success with similar tagging issues Your task would revolve around...
...(tariff payment and number of contacts). You need to make sure that these fields are also displayed in the mobile version of the site and add statement generation for these fields. * Set up the generation of a report (pdf file, form will be provided), which displays information about which users did not pay the bills of the previous month * On the 1st day of each month, files must be generated in Excel and XML-Format with the bank data entered by the contractor during registration and the amount to be paid from the account. One file for all users (form will be provided). * Fix the code when sending an E-Mail to the user at the time of invoice generation. Now email is sent many times in a row per day, it should be 1 time * Add one more page to the artist registration form, whe...
I require a freelancer to type text data into an Excel sheet from printed documents. Scope of work: - Convert printed text documents into digital format via Excel - Ensure data is accurately entered The project does require specific formatting: - Data should be arranged in rows Ideal candidate: - Must have proficient Excel skills - Experience with data entry - Attention to detail, to ensure accuracy in work - Able to follow specific instructions for data organization
...tenure, salary and location of our employees. Your ability to structure and organize these aspects will be key. - Creating an Excel-based system: I'm looking for a dashboard that's easy to dissect and understand. As such, I'd like the final product to be in Excel spreadsheet format. This means you should be very proficient in Excel, knowing how to integrate formulas, tables and other relevant features. - Monthly updates: The dashboard should be designed to be updated monthly. You should be dedicated to ensuring that the data is up-to-date and accurately represented. Ideal freelancer should have: - Proven experience in HR analytics and dashboards - Excellent Excel skills - Ability to present complex data in a clear and concise manner - Strong...
I have an excel sheet with intermediate complexity data, including formulas and charts. I need someone to transfer this data into tables, with the primary goal of organizing the information for better clarity and ease of understanding. Key Tasks: - Type the data into tables: This needs to be done with meticulous attention to detail to ensure accuracy and integrity of the data. - Apply borders and shading: To enhance the visibility of the tables and make them aesthetically pleasing. - Utilize headers: Rows and columns should have appropriate headers to aid in quick data navigation. Ideal Freelancer: - Proficient in Excel: Ability to work with intermediate level of data such as formulas and charts. - Strong attention to detail: Critical for ensuring that data is entered accur...
Finding Someone Who can Solve this error (One site is sending me callbacks and in 10 callbacks theyre getting this response in 5 callbacks and rest 5 callbacks are working fine) <?xml version='1.0' ?> <env:Envelope xmlns:env=''> <env:Body> <env:Fault> <faultcode>env:Client</faultcode> <faultstring>Internal Error</faultstring> </env:Fault> </env:Body> </env:Envelope
...looking for an Excel expert who can create a comprehensive sales target tracking spreadsheet for my customers. This spreadsheet should have several key functionalities. Features Needed: - Customer Information: It should contain a section where I can input and maintain all my customer's details. - Sales Tracking: The spreadsheet should enable me to track my sales targets daily and provide a detailed analysis of my performance. - Target Achievement: The spreadsheet should also be able to analyze the achievement or shortfall of selected items target completion by each customer. Analysis Required: - I would love to have a feature that shows how well sales targets are being achieved as per defined targets. Ideal candidate should have great attention to detail, proficiency...
I need an organized mind to help with research and data entry of a list of companies in a specific industry. Your main responsibility will be organizing this data. While basic Excel skills are a must, experience with data organization, particularly in a business context, would be highly beneficial. The data will be divided into 4 separate categories, so whoever takes on this task needs to have a keen attention to detail and an understanding of categorization. This project is perfect for an individual who thrives in organizing and systematizing data.
**Tour Costing Sheet Structure** 1. **Tour Details** - Tour Name - Tour Code - Duration - Destinations 2. **Client Information** - Client Name - Number of Adults/Children - Contact Information 3. **Accommodation** - Hotel Name - Room Type - Meal Plan - Cost per Night - Total Nights - Total Cost 4. **Transportation** - Vehicle Type - Distance - Cost per Kilometer - Total Cost 5. **Sightseeing and Activities** - Activity Name - Per Person Cost - Number of Persons - Total Cost 6. **Miscellaneous Expenses** - Guide Fees - Entrance Fees - Other Expenses 7. **Pricing** - Subtotal (Sum of all costs) - Markup Percentage - GST (Goods and Services Tax) - Final Price 8. **Payment Details** - Deposit Require...
I am currently struggling with a proble...simulation. Throughout the simulation process, I'm unable to solve the setup entirely. Even though no recent changes have been made to my computer software that could potentially interfere with the Ansys mechanical simulation, the problems persist. Also, there are specific error messages and warnings during the attempts to solve the setup. Required Skillset: - Expertise in Ansys mechanical simulation. - Adequate experience in debugging and resolving software errors. - Ability to understand and decipher specific software error messages. The primary task for this project would be to identify, understand and adequately solve the setup issues causing interruptions in the simulation, aiming at a smooth and successful Ansys mechanic...
I'm experiencing a "Forbidden: You don't have permission to access this resource" error on my entire WordPress website. It happened after I made some updates to the site, and now it's completely inaccessible. Ideal candidate for this job would: - Be an experienced WordPress specialist - Have previous case studies of successfully handling similar issues - Be skilled in troubleshooting and rectifying website errors Key Tasks: - Investigate and diagnose the problem causing the forbidden error - Implement a solution to rectify this problem and restore full access to the website - Verify the solution to ensure the error doesn't recur. Your responsibilities would include making sure the error is permanently fixed and ensuring th...
I'm looking for a freelancer to help with a simple Excel data entry task, as well as some basic formula work. I have a spreadsheet that primarily contains numbers. Your role would be to accurately type this data into the sheet, ensuring that every entry is correct and in the right format. This task is meant for particular record-keeping purposes, so precision and attention to detail are crucial. In addition to the data typing, I need some basic Excel formulas applied. Experience with Excel and knowledge of formulas is essential to ensure the data is well-organized and easy to work with. This task is not overly complex but will require someone who is proficient with Excel's formula functions.
...return to its original focus to be ready to select one of the two keys. Ideal Skills and Experience: - Proficiency in Python and experience with PyAutoGUI. - Strong understanding of web interactions and experience with browser automation. - Ability to design and implement accurate keyboard inputs. - Experience in handling focus switching between applications. The script is not required to include error handling for instances where the Firefox browser is not open or the specified page is not loaded. The primary focus of the script is on accurately interacting with the designated elements on the Firefox web page at regular intervals. We are seeking a skilled Python developer to create a script using PyAutoGUI to automate specific keyboard interactions within a Firefox browser. T...
... I'm facing an issue with my WHM/CPanel, where mails are frozen in the mail queue. I'm receiving error messages stating Status: 5.0.0. This technical glitch isn't just confined to a single user account, it's affecting numerous ones. I am seeking a skilled server administrator who has comprehensive understanding of WHM/CPanel, specifically around email configurations and troubleshooting. Key skills needed: - Extensive experience in WHM/CPanel - Proficiency in diagnosing and resolving server connectivity issues - Sound knowledge of email server delivery processes - A methodical approach to problem solving with attention to detail Your role will involve identifying the root of this error and implementing a reliable solution. Please only bid if you...
I'm currently seeking a skilled backend developer who has proven expertise in Python, Java, and Ruby. I need someone who can guide me through whether to use the current source code or start from scratch, a decision that we can make together as the project evolves. As our project's main responsibility is to handle authentication and server configuration, the perfect candidate should ...managing, and sustaining server configurations - Handling various authentication tasks - Expertise in Python, Java, and Ruby - Decision-making skills concerning source code development This project will be rewarding for someone who enjoys tackling unique challenges and has a flair for problem-solving. If you're up to the task, please don’t hesitate to bid. See the attached files - we ...
I am currently working on a project that requires the integration of Excel with a PostgreSQL database. As such, I am in need of a freelancer who is proficient in both Excel and PostgreSQL. The primary tasks to accomplish include: 1. Exporting data from Excel to SQL 2. Updating PostgreSQL data using Excel You will be working with various kinds of data as we aim to streamline our operations in a more efficient manner. Ideal skills and experience include: - Solid understanding of PostgreSQL - Expert skills in Excel - Previous experience with SQL data exporting and updating The success of this project highly relies on a flawless data transfer between Excel and PostgreSQL. Your expertise will be extremely valuable to our project's completi...
I'm in need of an expert to assist with the cleanup of our Medicine database. The goal of this project is to accurately remove all duplicate entries improving the overall accuracy of the data. Ideal Skills & Experience: - Strong background in Database / Excel /CSV management, specifically in the medical field. - Proven track record of similar past work. In your application, please include details of similar projects you've worked on. Efficiency and precision are pivotal for this task. Looking forward to a neat and streamlined database!
Request for development of initial version of mobil...order 1 List of development function definition requirements (organization of conversation documents involving developers and planners) 2 Flow chart (professional planner) 3 UI UX screen design (professional planner) 4 designs (professional designs) 5 Developers (professional developers) 6 QA error checking (professional error checker) 7 Server Settings (Professional Developer) 8 QA error checking (professional error checker) 9 Business begins 10 If a problem occurs during the developer runtime, the error is immediately corrected. Please contact only teams that can perform the above 10 tasks. If you cannot follow the above 10 steps, please do not apply. And only contact companies that strictly keep...
I have a channel where I make EXCEL educational videos, I upload 12 videos a month, between 5 to 7 minutes each. YOU MUST BE ABLE TO : - Have experience in editing videos for YouTube. - Have basic knowledge of Microsoft Office, to be able to edit the videos better. - Be able to edit 10- 12 videos consistently every week (Some will be only 1 minute long). IF YOU WANT TO STAND OUT FROM THE REST SEND US YOUR PORTFOLIO
I need a word document translated from English to Russian as soon as possible. The file has 800 words. Need high quality human translation only. Google/AI or automatic software works are not allowed and will be rejected. Need the translation back in word document format maintaining the formatting and layout of the source file. I would also need an excel sheet prepared, with source texts in column A and translation column B. Need this to be done within 5-6 hours of awarding the project. Bid only if you are available to do it now. Price: 12 CAD fixed. Deadline: 5-6 hours max Don't bid if you don't agree the price and timeframe. Thanks!
...should contain data from the MySQL database, calculations or summaries of data, visualizations or charts, and be structured as a paginated report, using SQL language. The report should be designed to be accessed as a printable PDF document. It is not required to be interactive, as a static report is sufficient for my needs. Key Requirements: - Proficiency in Microsoft Access, MySQL, VBA, PDF, Python, and Excel - Competency in SQL language for data manipulation - Experience in designing paginated reports The ideal candidate should have a proven track record of creating similar reports, with the skills and knowledge necessary to work with the specified technologies. Your ability to deliver a professional, well-structured, and visually appealing report within the given fr...
I need a word document translated from English to Simplified Chinese as soon as possible. The file has 800 words. Need high quality human translation only. Google/AI or automatic software works are not allowed and will be rejected. Need the translation back in word document format maintaining the formatting and layout of the source file. I would also need an excel sheet prepared, with source texts in column A and translation column B. Need this to be done within 5-6 hours of awarding the project. Bid only if you are available to do it now. Price: 12 CAD fixed. Deadline: 5-6 hours max Don't bid if you don't agree the price and timeframe. Thanks!
I am in need of a specialist to optimize my Amazon product listings for coloring books. The key focus will be enhancing visibility and maximizing customer engagement for my book collection. Here's what I am looking for in a freelancer: - I need you to know more about KDP marketing than I do. I only know the basics. I need an advanced skilled...listing. - Suggesting effective marketing strategies tailored to coloring books. - Execute strategies once approved. - Expertise in Amazon's A9 algorithm to optimize listings. Through these efforts, the ultimate goal is to increase the visibility of my coloring books on Amazon, targeting a better ranking in search results, and thereby improving sales. If you have the skills and experience to excel in this role, I would be thrill...
...hours, amounting to $960 USD. Initially, I will bill for 24 hours. Upon completion of the work, I will bill the remaining 24 hours. Date of completion:- 24-04-2024 You have to be set for the high standards for each module to ensure the project is exemplary and ready for public showcasing: Module 1: Idea to Well-Crafted Invention - Patent Draft Report Generation All reports should be polished, error-free, include high-definition visuals, and provide accurate, dynamic, contextually appropriate prompts & responses. Module 2: Quick Search IPC, Scopes The functionality for identifying IPC codes and defining scopes must be quick, efficient, and precise. Module 3: Document In-depth Analysis This module offers detailed feedback on patent drafts and drawings, addressing all paten...
Lütfen detayları görmek için Kaydolun ya da Giriş Yapın.
As a professional with high-volume data, I'm seeking a highly skilled Excel expert. You should have proficiency in: - Data analysis - Data visualization - Excel formulas, functions and macros - Visual Basics Application (VBA) I'm dealing with more than seven datasets, each one having high complexity (many columns and over 5000 rows). I will need your expertise in managing and understanding this data. Ability to quickly comprehend and adjust to new data structures would be advantageous. Proven experience with large data sets and advanced Excel usage is a must for this project. Please include examples of previous similar work in your proposal.
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 relevant...
I'm seeking 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 req...
2 excel files with VBA macro as per customer requirement
