Vba code cleaner excel 2016 jobs
I require assistance in converting a variety of file types including Word, Excel, and PowerPoint files, into PDF format. Here are some specifics about what I need: - I need the original formatting from the source files to be preserved during the conversion process. This will ensure that the PDF versions closely resemble the original documents, without any loss of visual integrity. - The files for conversion will be provided via a cloud storage link, such as Google Drive or Dropbox. I expect the freelancer to be proficient in accessing and handling files from these platforms. Ideal candidates for this project should have: - Proficient experience in converting different file types (e.g. Word, Excel, PowerPoint) into PDF format. - Strong attention to detail to ensure the prese...
I want someone who can create a database in Excel/Access for Invoices Log (tracking for already processed invoices) with the following features. 1- A list of all invoices (Master List) with the field names I will provide. 2- A list of all Contracts with the field names I will provide. 3- A list of all Purchase Orders. 4- A list of Approvers who is approving the invoices. 5- A list of Accounts. 5- All of these list should be linked with each other. The database should have a main page, with link to the above mentioned list pages plus Add Invoice, Search Invoice, Search Approver, Search Contract, Search PO, Search Account and Reports pages. For Add New Invoice page, I should be able to add an invoice details in it, and if it's related to a contract or purchase order, I should ...
I’m in need of an experienced Excel software engineer who specializes in automation. The project revolves around automating data entry tasks in Excel. We are an accounting firm and I am looking to automate my compliance practices. Tasks include 1) rolling forward previous year excel work papers 2) taking information from. Client data sheets (excel) and importing into new excel workpaper workbook 3) data analytics based on metrics 4) hyperlink to source data Ideal candidates should have: - Proven experience with Excel macro programming and automation - Ability to work with numeric and legal data - Strong attention to detail to ensure data accuracy This will be a valuable addition to our workflow. Looking forward to your proposals.
...optimize an existing codebase used for data analysis. Key Requirements: - Improve the speed of the code: The primary goal of this project is to significantly enhance the algorithm efficiency, thus resulting in a noticeable speed improvement. Ideal Skills and Experience: - Proficient in Python: You should have extensive experience working with Python and be able to recognize areas in the code that are causing performance bottlenecks. - Data Analysis Experience: Familiarity with data analysis practices would be beneficial as the code is part of this application. - Optimization: You should have a strong background in optimizing code for improved speed and efficiency. Additional Information: - The code is currently functional but is not running at t...
...need an Excel expert to create a comprehensive spreadsheet to track and calculate project costs, revenues, expenses, and profits. Specific calculations required include sum, average, percentage. The Excel sheet should track the following: - Project cost - Project revenue - Project expenses - Percentage of account receivable - Percentage of account paid - How the client paid after tax - Description for the costs - Percentage of the costs - Percentage of the profit before tax - Percentage of account receivable before tax - Date of payment The data presentation in the spreadsheet should be in the form of tables and graphs. Experience with financial data analysis and management is vital. Understanding of cost and profit calculations, as well as capability to implement adv...
I have an existing Excel macro that is predominantly used for handling formatting tasks within the Excel file. However, I need an expert who can assess and modify it to ensure compatibility with Excel for Mac 2019 or later. Key Requirements: - The existing macro primarily deals with formatting tasks within the Excel file. - The data in the Excel file is stored in both text and numerical formats. - The main change required is to update the formulas in the macro to ensure it functions smoothly on Excel for Mac 2019 or later. The ideal freelancer for this job would have prior experience with: - Excel macros and VBA - Formatting tasks in Excel - Updating or creating cross-platform Excel macros This project requires a me...
I'm seeking a professional to provide advanced technical support for my desktop software that runs exclusively on Windows. Specifically, 2016 windows office and current outlook, not recognizing Recent emails, calendars, and inbox sub folders Key Responsibilities: - Offering prompt and effective solutions for any software-related issues that may arise - Conducting in-depth troubleshooting and analysis to identify the root cause of the problems - Ensuring that the software runs smoothly, and that any potential technical challenges are preemptively addressed - Providing clear and concise instructions for users on how to resolve common issues Ideal Candidate: - Proven experience in providing technical support for Windows software - Strong knowledge of how desktop applications wor...
...file with over 50 pages of data in mixed formats - text, numbers, and tables. The task is to accurately transfer this data into an Excel spreadsheet in a tabular format. Key requirements: - Data entry from a PDF file into an Excel spreadsheet - The data is of moderate complexity, so a good understanding of Excel is needed - The output should be a well-organized and clean Excel spreadsheet Ideal skills for this job: - Proficiency in data entry and working with large data sets - Advanced Excel skills, including the ability to work with mixed data formats - Attention to detail and accuracy to ensure the data is correctly captured - Experience with PDF to Excel data conversions would be a plus Please note that while the task is to transfer data,...
I'm working on a school project that involves the development of a Coal Mining Security Alert System. I need someone who can code in Quarky to create this block code system. Unfortunately, I haven't gotten to the point of defining the complete scope of the project, but I'd like to start with the code development. I'm looking for someone who can: - Use Quarky to build a block code system - Understand and implement basic security alert functionalities - Be ready for subsequent feature additions and changes Key Features: = Face Detection: Implement face detection functionality to identify individuals within the mining area. = PPE Kit Verification: Utilize image processing techniques to ensure that miners are wearing proper PPE kits. The system...
--- ### Job Title: Excel Sheet Creation for Job Tracking and Payment Calculation **Description:** I need a custom Excel sheet to help me track jobs completed by my installers, including details about each job, such as dates, customer information, and payments. The sheet should be able to automatically calculate the total number of jobs done and the total payment owed to each installer. **Requirements:** 1. **Job Tracking:** - Columns for the date each job was completed. - Columns for the job details including customer address and account number. - Columns for the installer assigned to the job. 2. **Payment Calculation:** - Ability to input the payment rate per job. - Automatic calculation of the total number of jobs completed by each installer. - Automat...
Just a quick bit of help needed in excel macro writing. See attached before and after showing a piece of the original data. and what i neeed the macro to achieve. WHAT IM ASKING If two adjacent cells in column b are equal, then add cells adjacent column c cells, put the result in the first column c cell and remove the duplicate row. AEE ATTACHED png. I need a tailored solution for a data manipulation task within Excel. Specifically, I am looking for an Excel macro that can accurately merge cells based on their adjacency. Essential skills and experience should include: - Expert knowledge of Excel and its macro functionality - Prior experience with data manipulation tasks such as merging cells - Understanding the rules or criteria for merging specificall...
I am looking for an expert who can as...expert who can assess and modify an existing Excel macro for compatibility with Excel for Mac 2019 or later. The current macro mainly handles formatting tasks within the Excel file. Key Requirements: - Assess the current macro's compatibility with macOS - Modify the macro to ensure compatibility with Excel for Mac 2019 or later I don't have a strict deadline for this project, so you can work on it at your own pace. However, I am looking for someone who can get this done efficiently and effectively. Feel free to ask any questions for more information. Ideal Skills and Experience: - Proficient in Excel VBA and macros. - Extensive experience in adapting macros for cross-platform compatibility. - Kno...
I am seeking an experienced LT Spice expert to assist with the design and simulation of a half-bridge circuit to drive an ultrasonic cleaner load, 60W, 39kHz, and 10R impedance. I have an LT spice model that needs to be updated to meet the requirement. The floating side needs to show a square wave and the output to the load needs to be a sinewave. The main requirement is to update the values of the discrete component and use a much better MOSFET to meet the required output of 600V AC, 0.5A, 39kHz Responsibilities: - Improve the LT Spice model for the half-bridge circuit (no rectifier needed), Output is AC and not DC - Conduct detailed simulations to analyze performance - Optimize circuit design based on simulation results The MOSFET part number is SIHP24N80AE-GE3, The PWM con...
I'm in urgent need of a Google Pay redeem code valued at 1000 INR. I'm specifically looking for a code that can be used to purchase apps or games. While I'm not yet sure which applications or games I'll be purchasing, I'm highly motivated to get the code as quickly as possible. Ideal Skills: - Experience with online payments and redeem codes - Efficient and reliable service - Proven track record of fast delivery Please keep in mind that I need the code immediately.
I'm in need of a skilled Delphi developer who can quickly generate a program that can dive into the registry of a Windows machine and extract the names of all programs listed in the "Add/Remove Programs" section. Key Requirements: - The code should be written in Delphi. - It should effectively scan the registry. - Extracted program names should be displayed in a listbox. This is a simple task, but it's important that the code is efficient and free from bugs.
...AI assistant with a focus on language understanding and real-time conversation support. Key Features: - Cross-Platform: The app should be developed for both iOS and Android, ensuring a wide user base. - Page Translation: Users should be able to translate live any page on their phone. - AI Assistant: The AI assistant should have the ability to provide information on various topics and should excel in language understanding, helping users with translation in real-time conversations with others. - Live Translation: The app should provide a smooth live translation experience for conversations. Ideal Skills: - Proficiency in React Native for cross-platform development. - Experience in building apps with live translation capabilities. - Strong background in AI development, specifi...
I am in need of a freelancer who can accurately convert my PDF files into Excel. The materials consist mainly of printed, electronically generated text. Given the nature of the work, the ideal candidate should: - Be proficient in both PDF and Excel formats - Have an eye for detail to ensure accuracy - Have experience dealing with extensive text documents - Possess strong typing and data entry skills Please bid if you fully understand the tasks and feel capable to deliver high-quality results. Your attention to detail and commitment to accurately completing tasks would make you an ideal candidate for this project.
...The primary task is to ensure that new columns added to the database are correctly displayed in the Excel report generated by the application also fix some minor areas that will discuss in detail Key Responsibilities: - Troubleshoot and fix the issue of new columns not being displayed in the Excel report - Ensure that all relevant data is correctly fetched from the SQL Server 2019 database - Implement a seamless solution that does not affect the overall functionality of the application Ideal Skills and Experience: - Strong proficiency in C# programming language - Expert knowledge of SQL Server 2019, including stored procedures and functions - Prior experience with similar tasks involving Excel report generation from SQL data - Excellent problem-solving skills and ...
For my project, I'm looking for a highly detail-oriented professional with brilliant Excel skills. Key responsibilities include: - Managing and transferring both numerical and textual data in an Excel spreadsheet, ensuring the correct placement into columns marked by letters (A, B, C, etc). - You'll not be required to order the data in any specific way, just transfer into the appropriate columns. Skills & Experience: - Proven record in data entry tasks - Strong Excel skills - Ability to understand and interpret numerical and textual data Looking forward to your bids and kicking into this project soon!
I'm in need of an experienced data entry specialist who can assist in uploading 850 products onto my online store. You will be provided with the necessary product information (description, price, specifications) in the format of Excel/CSV files. Your tasks will include: - Accurate data input of all relevant product details - Verification and correction of any existing data entries - Ensuring all listings are in sync with their corresponding inventory Ideal Skills: - Experience in data entry, particularly e-commerce product listing is preferred - Proficiency in Excel - Attention to detail and accuracy are extremely essential - Fast typing speed with a keen eye for details. Please only bid if you have relevant experience, and can start work promptly.
I'm looking for a professional who can assist me with the typing of my novel manuscript. Your responsibilities will include: - Accurately typing out my novel - Formatting the typed content into an e-book format The ideal freelancer for this job would be experienced in: - Typing - MS Word - Excel calculations - E-book formatting Having an RS-CIT certificate would be a major plus. The ability to pay close attention to detail and produce error-free work is paramount. Experience in typing and formatting novel manuscripts is highly preferred. Finally, quick turnaround time is necessary for the successful completion of this project.
I'm looking for an experienced freelancer who can create an Excel calculator for historical cryptocurrency prices from Binance and Luno. The calculator should also include fiat exchange rates for major currencies such as ZAR/USD bank sell rates Key Requirements: - Retrieve historical price data from Binance and Luno - Incorporate USD, and ZAR exchange rates - Organize the data and create user-friendly interface - Ensure accuracy and reliability of the calculator - Prioritizing the preservation of data privacy Ideal Skills: - Proficiency in Excel and data manipulation - Familiarity with cryptocurrency exchange APIs - Knowledge of major fiat currency exchange rates - Strong analytical and problem-solving abilities Please include your relevant experience in your applicat...
...through OTP) c) GST Number (if available ) d) Google map location (if available) after successful registration customer can login and request quotations 3. All the products details like: Product Name, photo, description, features, pdf (data sheet), warranty information, stock (available quantity), sale prices etc. can be uploaded directly through portal and mobile app and also can be uploaded through excel sheet with serial number of all products. 4. Customer can see all the uploaded products and can request for quotation. There is no need to show the available quantity (stock) to customers. 5. Admin can see the requested quotes where the prices and quantity will be reflected of all the products in quotation. Admin can edit the prices manually and can share and download the requ...
I would like to see the result statistic in %. Important, when i refresh the excel i always want to see the last 5, last 10 and last 15 results.
As the project owner, I'm seeking a professional skilled in Pine Script with experience in retrieving code from private scripts on Trading view. The key objectives of this project include: - Extracting the Pine Script code from a specific invite-only script (the script name will be shared privately upon project commencement). Unfortunately, it's currently unknown which specific script to be used, but clarity will be provided as the project progresses. - Discern the implemented functions within the script. The functionalities mainly centered around recognizable trading indicators like Moving averages, Pivots, Fibonacci and MACD. - The code extraction should consider compatibility with variable timeframes. Whilst exact timeframes aren't specified yet, f...
I have an excel file, need add product categorie on a column - budget 100€
Implement Mac Filtering to allow specific Mac addresses to connect to a Windows Server 2016 and Windows 10 via Remote Desktop Protocol (RDP). Disable Right Click functionality for RDP users. Restrict Copy-Paste functionality (Ctrl+C, Ctrl+V) for RDP users. Implement measures to disable file transfer capabilities for RDP users.
...analyzing a small dataset in Microsoft Excel. Key Responsibilities: - Data Cleaning: The dataset includes multiple columns and rows that need to be checked for inconsistencies, errors, and duplicates. - Data Analysis: After cleaning, I need the freelancer to perform basic data analysis to extract meaningful insights from the dataset. Ideal Skills: - Proficiency in Microsoft Excel and experience with data cleaning and analysis. - Attention to detail to ensure the dataset is thoroughly cleaned. - Basic data analysis skills to interpret the dataset and present the findings in a clear manner. Please note that the project does not require any specific tools or methods for analysis, but any experience with Pivot Tables, Statistical Formulas, or Macros/VBA would be an...
I'm currently working with an existing Python code and need a professional to review and improve upon it. I'm not certain what version it is therefore freelancer with knowledge in both Python 2 and Python 3 is preferred. Ideal Skills: • Proficient in Python coding • Experience in code optimization • Excellent debugging skills Work Scope includes but not limited to: • Code review: Inspect existing Python scripts • Troubleshooting: Identify and fix any code errors • Optimization: Enhance code for better efficiency and performance The successful candidate should be able to work independently based on the existing code and requirements provided.
Hello, I need complet the Amazon categories catalogue excel in french
As an entrepreneur, I am seeking a proficient web developer to construct an innovative e-commerce website boasting a unique QR code feature and credit card processing capabilities. Experience in handling similar projects would be ideal. You need to: - Develop a user-friendly e-commerce website - Integrate a credit card processing system - Design an exclusive QR code feature to download the application If you are a creative problem solver with outstanding skills in web development and have a history of incorporating payment systems into platforms, your application would be strongly considered. Show me your track record of similar work, so I can foresee how successful our project can be.
I'm in need of a skilled programmer to create an automation code page for me. This code page will be focused on text processing, so a strong understanding of working with textual data is essential. Key Requirements: - Proficient in JavaScript: The automation code should be written in JavaScript to ensure compatibility with other platforms. - Automation Experience: The primary function of this code will be automating tasks. A proven track record in building automated processes is highly desirable. - Text Processing: The code must be able to accurately and efficiently process textual data. Experience in this field will be a huge advantage. If you have experience in JavaScript, a background in automation, and a strong familiarity with text processing...
I'm in need of a freelancer with a high level of proficiency in Microsoft Excel to use conditional formatting over different tabs to help visualize duplications in large sets of numerical data. Ideally, you should not only be skilled in Excel, but also possess a keen eye for patterns and detail. Your job will encompass: - Applying conditional formatting across multiple tabs. - Highlighting duplications in numerical data. - Ensuring easy readability and understanding of the data presented. An understanding of data visualisation techniques would give you a competitive edge for this project. This task will require a close attention to detail and a strong understanding of Excel's conditional formatting tools.
...Description I'm currently in a bit of a tight spot. A Windows Server 2016 web application () was recently moved from a US provider to the by a non-professional freelancer. Unfortunately, after less than a week, the system has stopped working. I found out recently he has installed the application in Centos 7 (Linux) instead of Windows against my guidelines. In light of this, I am seeking a highly skilled professional to help me reinstall the system from the copy to the Window Server 2016 environment. The job involves the following steps: 1) Change the OS from Linex to Windows Server 2016 or Higher Use the copies of the site and desktop (will be uploaded when you accept the job) 2) Download Windows Server 2016 II, Office 2019, , .NET Framework 4.7 or 4....
I have a small dataset of less than 1,000 rows that requires both data cleaning and formatting. Additionally, I need assistance with data analysis and visualization. This is a one-time project, and I am looking for a skilled individual to handle this for me. Ideal Skills and Experience for this project: - Proficiency in Excel is a must. - Experience with data cleaning and formatting. - Ability to perform data analysis and create visualizations. - Attention to detail and an eye for accuracy.
I have an Excel file with a macro that I need to be updated for compatibility with Excel for Mac 2019 or later. The current macro's compatibility with macOS is unknown to me, and I need an expert to assess and modify the code as needed. Key Requirements: - Update the existing macro for compatibility with Excel for Mac 2019 or later. - Ensure the modified macro functions correctly on a MacBook Pro 2018 intel OS Ventura. Ideal Skills and Experience: - Proficient in Excel VBA and macros. - Extensive experience in adapting macros for cross-platform compatibility. - Knowledge of macOS compatibility issues with Excel macros.
...payment methods to support user transactions. - Dynamic QR Code Generation: Feature to generate QR codes, enhancing user experience. Main Purpose of the Web Application: - The primary goal is to offer a platform where users can create and share memorial websites. - Additional functionalities like QR code generation are aimed at facilitating user interaction and experience. Preferred Design Style: - The design should be elegant and sophisticated, in line with the sensitive and emotional nature of the website's purpose. Ideal Skills and Experience: - Proficiency in Laravel framework is essential. - Previous experience in building CMS and user authentication systems. - Strong background in payment gateway integration. - Knowledge of QR code generation and impl...
I need a skilled Excel professional to create a comprehensive spreadsheet for financial tracking. - Data Type: The primary focus will be on financial data, so the spreadsheet must expertly handle these calculations and entries. - Data Organization: The data should be organized by project. This includes clear separation of financial data under different project heads, ensuring a clean and easily navigable interface. - Functionality: I am looking for an Excel expert to incorporate some key features to help make the data easier to understand, like conditional formatting. Ideal Skills: - Proficient in Excel, particularly in managing financial data - Experience in creating user-friendly and logically structured spreadsheets - Understanding of conditional formatting and ot...
I want to make a Incentive structure in the attached excel. I am paying incentive to my staff. I have different types of incentive policy Each Incentive calculation is starting from the month "m" It will be accumulated and the Incentives will be paid on every month of "n" The process will start again and will repeat again. This process will depend upon the value that I am putting in the cells of "m" and "n". You have to correct the formula I have given in the sample or you can make a new formula
I have a small project that requires the entry of structured text data. The project will involve: Ideal candidate would have a strong attention to detail, excellent organizational skills, and a background in data entry. Experience with structured data formats is a plus. This should be a fairly quick task, but accuracy is key. I will share you more details in via chat box. Thanks
I'm in need of someone to help with building a Java code for my project. The main task will be developing a code for input validation. Key Requirements: - Experience in Java programming - Proficiency in coding for input validation - Ability to work efficiently and deliver results in a timely manner This project will require someone with a good understanding of Java programming and the ability to create effective input validation. If you have a track record of successfully delivering such functionalities, I'd like to hear from you.
I'm looking for a skilled developer to assist with syncing an Excel file to my phpMyAdmin database. Key Requirements: - Real-Time Syncing: The sync should take place continuously in real-time. Any updates made to the Excel file should be reflected in my phpMyAdmin database instantly. Skills and Experience: - Proficient in Excel and phpMyAdmin - Experience in data syncing and database management - Familiarity with real-time data syncing No specific data validation or transformation is needed during the import process. The goal is to ensure that any changes made in the Excel file are accurately reflected in the existing database.
...industry, dealing with bathroom & kitchen products. I need freelancers who are based in Malaysia and based in City if Kuala Lumpur and Town of Cheras Key Responsibilities: - Data Entry & Report Writing: You would be handling data entry tasks & writing report and (you only need to direct report to me so simple communication) - Task Management: Utilizing software such as Trello, or Microsoft Excel to keep track of tasks and deadlines. Ideal Skills and Experience: - Experience as a virtual assistant or in administrative roles is a huge plus. -Experience in wiritng report will be added advantage - Proficiency with task management tools and software. - Excellent organizational and time-management skills. - Strong communication skills - you should be comfo...
I'm looking for a skilled Visual Basic 6 programmer to adjust functionality within my VB6 source code. The task primarily involves expanding reporting functions to include more tables. Ideal applicants should have: - Extensive experience in VB6 programming. - Previous work involving functionality adjustments, particularly in Reporting and Data Management. - A keen eye for detail to maintain existing code integrity while implementing changes. - Strong understanding of data management and manipulation in VB6. Your role will be solely focused on altering the existing VB6 code and ensuring the changes don't disrupt the software's operational flow. Familiarity with VB6 and past projects involving Reporting changes are crucial.
I am looking for a skilled and experienced professional who can render detailed plans and elevations for my residential construction project. Your task will involve: - Preparing construction drawings that effectively communicate design intent. Your work should be easy to understand and facilitate the building process. - Providing compreh...detailed drawings can be used for accurate cost estimation. Your background in architectural design or civil engineering, coupled with proficiency in CAD software, will be extremely beneficial. Experience in residential construction projects is a must. Please keep in mind the crucial role these drawings play in the project's execution and the importance of accuracy and attention to detail. If you excel at this, you might be the right fit ...
I'm seeking a proficient data analyst with strong statistical analysis capabilities. Your main responsibilities will be: -...incomplete records, duplicates or errors. - Statistical Analysis: You'll need to conduct a thorough statistical analysis of the data, utilizing regression analysis specifically. The project will involve various types of data including numerical, categorical, and textual data. Since we'll be working in a professional environment, knowledge and proficiency in MS Office is a must. This includes Excel, PowerPoint, and Word. Ideal candidates should be well-versed in data analysis and have a strong statistical background. Proficiency in using MS Office is also a key requirement. Previous experience handling numerical, categorical, and textual ...
I'm in need of an Excel macro expert who can help me with a data arrangement task. The task involves transferring sequences of cells data from one grouped workbook to multiple original workbooks and worksheets. The data transfer should be based on specific criteria. Key Requirements: - Data transfer based on a specific criteria: The macro should transfer data based on a specific criteria. This involves arranging the data from the grouped workbook into different cells in a column in the original workbooks based on predefined conditions. - Conditional Logic: The macro should include conditional logic. This means that the data transfer should not just be a simple copy-paste operation, but should involve logical conditions for accurate and efficient data arrangement. - Potential...
...Create preliminary design of the engine layout (drawings or sketches) - Develop preliminary design/placement of key components (e.g., pipe, valves, evaporator, condenser) Deliverables: First 10 hours: - Design Report (5-10 pages): - Overview of the design concept - Thermodynamic cycle analysis (calculations and spreadsheet; Excel/OpenOffice Calc) - Heat transfer calculations and assumptions (calculations and spreadsheet; Excel/OpenOffice Calc) - Fluid flow, power, and pressure drop (calculations) - Summary of Findings (1-2 pages) Second 10 hours: -CAD Drawings (2D or 3D): - Engine layout design - Key component designs (e.g., evaporator, condenser, piston) -Design Summary (2-3 pages): - Overview of the preliminar...
I'm looking for someone with demonstrable clago experience ( Must share previous work samples and also show me live evidence on a video call to be considered eligible) to code my indicator-based simple bot within 5 days. Anyone who quotes above budget will be disqualified immediately. Feel free to suggest if any of my requirements are difficult for your skill level and I can consider them. Those who don't reply to msgs for more than 15 minutes will not be eligible as they are not reliable to work with.
