Excel vba code optimis työt

I am looking for someone experienced in data entry, who can accurately transfer text, numbers, and dates from paper documents into an Excel file. The file contains less than 100 columns and rows, so attention to detail is essential. - Data Type: Text, Numbers, and Dates - Source: Paper Documents - Excel Capacity: Less than 100 rows and columns Ideal skills would be a fast typing speed, proficiency in Microsoft Excel, and previous experience in data entry from paper documents. Knowledge on handling and digitizing paper documents would be a significant advantage. Candidates who can ensure accuracy and efficiency in managing and formatting data are preferred.

I'm looking for an Excel expert to develop an algorithm for range breakouts trading. The specific breakout criteria will include price crossing above the high and below the low of a specified range. Even though no specific conditions or indicators to trigger the range breakout trade were indicated, I encourage you to apply your understanding of common trading triggers to offer suggestions on how to improve this system. The algorithm should also check for range breakout opportunities every minute. You might have the following skills and experience: - Extensive experience with Excel - Knowledge of algorithmic trading principles - Experience in programming Excel for algorithmic trading.

...currently looking for a freelancer with a strong understanding of molecular dynamics software, particularly LAMMPS, for a personal project. My main goal is to enhance an existing code by accurately implementing forces on particles within the LAMMPS framework. Here's what I'm looking for: - **Intermediate LAMMPS Skills**: You need to be comfortable with modifying and working on existing LAMMPS codes. Your task will involve accurately adding a reference to the forces acting on particles in a pre-existing code. - **Focus on Accuracy**: The most critical aspect of this project is ensuring that the forces implemented into the code are as accurate as possible. A thorough understanding of force fields and their application within LAMMPS is essential. - **Requi...

I'm seeking a professional with experience in bold and extravagant designs to help with my marketing and advertising project. Ideal Skills: - Experience in Marketing & Advertising design - Proven ability to create dynamic, out-of-the-box designs - Skills in produ...out-of-the-box designs - Skills in product oriented designing As the project requires a bold and extravagant style, I'd like applicants to showcase similar previous works. A strong track history in creating standout promotional materials will be highly regarded. Expectations: - Ability to work within deadlines - Open and active communication - Willingness to revise designs based on feedback If you excel in creating vivid and impactful designs, then this project is for you. Let's create some...

I'm seeking a highly skilled Excel enthusiast who can efficiently utilize its powerful data analysis functions. The focus here is specifically on basic descriptive statistics, not advanced predictive or inferential statistics. The project demands: - Proven expertise in Excel - A sound understanding of statistical analysis - At least intermediate experience in data analysis using Excel - Excellent attention to detail Responsibilities will include running statistical analyses on sets of data, interpreting and presenting results in a clear, comprehensible manner. I look forward to receiving bids from all suitably qualified freelancers. Thank you.

I'm in need of a proficient Excel expert who is well-versed in data analysis and creating complex formulas and functions. Key responsibilities: - Analyzing a medium-sized data set (100-1000 rows) - Managing and manipulating data, which involves creating intricate formulas and functions - Enhancing the data's ease of understanding and usability Ideal candidates should have: - A strong understanding and experience in Excel - Proficiency in data analysis, Excel formulas and functions - Excellent attention to detail and data accuracy - Capacity to handle medium-sized data sets - Ability to deliver results in a timely manner.

I'm encountering an "Allowed memory size exhausted" error in my PHP code and require assistance in resolving it. I will share the code with you so you can modify that and send us after making corrections. Requirements: - Proficiency in PHP programming - Understanding of memory allocation and management in PHP - Familiarity with server settings and access Specifics: - The error message: "Allowed memory size exhausted error" - Access to the server and its settings available - PHP version used: PHP 8 Please request the code via chat. Kindly mention in your bid that you've watched the video () so I can confirm. Please apply only if you possess the requisite skills and expertise to address this memory size issue.

I'm an advanced user looking for in-depth, personal tutoring in Excel and VBA. The tutoring should focus on, but not limited to: - Writing VBA scripts - Database management in Excel - Advanced Excel functions - Automation - Data Entry Form - Result Page Additionally, guidance should be provided on automation of tasks including: - Data import/export - Data manipulation - Report generation The ideal candidate will have an extensive background in VBA and Excel, with a specific emphasis in automation and data management. They must be skilled in conveying complex processes and concepts in a clear, understandable manner.

As a busy professional, I am in need of a Python developer to take the lead in writing code for my project. Key Responsibilities: - Write clean, maintainable and efficient code - Identify and fix program errors Ideal Candidate: The right person for this job will be a Python professional with a keen attention to detail. Their primary task will be coding, so previous experience and a proven track record in this area are essential. Please note that the type of application or project for which the Python developer will be coding has not been specified at this stage. Also, I haven't set a deadline for the project completion, as I prioritize quality work over fast delivery.

I'm in need of an experienced freelancer who can quickly diagnose and fix an issue with my PHP code. The page holding the code isn't functioning as expected and I need a professional set of eyes to rectify the problem swiftly. While I'm not sure about the error type, I urge you to be equipped with a broad understanding of possible PHP code issues.

I'm seeking a flexible and experienced Android app developer to create an application whose specifications are not yet defined. Key potential features may include ...seeking a flexible and experienced Android app developer to create an application whose specifications are not yet defined. Key potential features may include user registration and login, push notifications, and in-app purchases. The main purpose and design are yet to be determined, thus, a resourceful and adaptable approach to development is necessary. This project may be suitable for developers who excel in creating social networking, e-commerce, or educational apps with a diverse range of design styles: minimalist, colorful, clean, and modern. The project specifics will be finalized in collaboration with the suc...

With this project, I'm specifically looking for a detail-oriented and meticulous individual experienced in online data entry, ideally in an Excel environment. The selected freelancer will be responsible for: - Performing online data entry tasks. - Entering all data into an Excel spreadsheet. - Sorting and organizing the data in alphabetical order. It's crucial you have experience with Excel and an understanding of data structuring. Error-free work is a must, as well as a keen eye for details, to ensure the data's integrity. I'm counting on your expertise to deliver accurate and reliable results.

...proficient Android developer who can transform my existing Excel-based userforms into an enticing Android application. Specifically, the tasks will involve: Functionalities and Features Development: - While I've nailed down some functionalities, I would appreciate some guidance in further enhancing the app's features. Your ingenious input on potentially beneficial features and functionalities, based off our Excel prototype, would be welcomed. Data Interaction: - The app should be designed for data input tasks solely. Users should find it convenient to input data on the go, directly from their Android devices. External Data Syncing: - A critical feature of this app would be its capability to sync data effortlessly to an external Excel sheet. Hence, exp...

I'm in need of an experienced professional to assist with Excel data typing. The focus of this project is data analysis, specifically: - Typing of financial data into Excel - Ensuring accuracy of data entered - Applying analysis metrics to predict future revenues To be successful in this role, you should have: - Proficient skill in Microsoft Excel - A strong background in data analysis - Ability to work with financial data - Proven experience with revenue projections Your expertise and attention to detail will be critical in helping the accuracy of projections. This project will empower our business decision-making process. Prior experience with financial data and revenue projections is highly desirable.

As a beginner in Excel and VBA Programming, I am actively seeking an experienced and knowledgeable tutor who can guide me on the journey to developing structural analysis software. I am reckoning on an efficient and in-depth learning experience tailored around my unique learning pace and style. Key Objectives: - Understand Basic to Advance VBA coding and its application in Excel - How to implement complex algorithms in VBA - Grasp of data analysis functions and graphical interface capabilities in VBA Ideal Tutor's Profile: - Qualified tutor with solid and demonstrable grasp of VBA and Excel - Proven experience teaching VBA with commendable patience and understanding - Proven experience developing structural analysis sof...

I require an QR code and automatically play a linked video immediately after detection. Just like this

...ability to paste content from a site/excel/word etc and the content to be formatted correctly for WordPress and strip any HTML from the source. Presently pasting text from a site etc adds the HTML from the source site. The goal is to be able to copy/paste to make content on the blog without having to format text, and for images to be saved to Media Folder without doing manually. Examples of need: - Table o Uses native format from CSS o Remove all bold and format so it just table with text (will bold etc manually after as I think is simpler right?) - Images o Paste and saves directly to media folder (no hot linking) o Use media image URL o (Note: I have Imagify to auto compress images) - Text o Uses native format from CSS o All HTML is removed so clean code o Remove ...

I'm on the lookout for a proficient virtual assistant having adeptness in data entry and Google Maps. Main responsibilities include: - Data entry tasks - Gathering information from Google Maps This assignment is not time-bound but based on a rate of pay per 100 data entries. It's a heavy workload; as I require over 500 entries, so strong a...responsibilities include: - Data entry tasks - Gathering information from Google Maps This assignment is not time-bound but based on a rate of pay per 100 data entries. It's a heavy workload; as I require over 500 entries, so strong attention to detail & consistency are imperative. Ideal Skills: - Strong data entry proficiency - Mastery of Google Maps - Dedicated & detail-oriented If you excel in these areas...

I am searching for an Excel expert who can assist me with a moderate volume of data entries (100-1000). Tasks include: - Data Entry: You will input and organize both numerical and text data. Accuracy and attention to detail are crucial since the data will be mixed. - Data Organization: Categories and hierarchies within the spreadsheet need to be established for efficient use, so a strong understanding of Excel's organizational tools is essential. Ideal candidates will have extensive experience with Excel and data entry, particularly with mixed data types. Knowledge in creating effective organizational systems within spreadsheets will also be appreciated.

...of utilized and unused code. The file is part of a larger project that interacts with Google Firestore for database operations. While the code is currently functional, its extensive size and lack of organization present significant challenges for further development and maintenance. Primary Objective: The main goal is to clean up and refactor this TypeScript file to improve readability, maintainability, and scalability. Specific Requirements: Code Cleanup: Identify and remove any unused or redundant code segments. Ensure all deprecated methods or practices are updated to current Angular standards. Refactoring: Break down the large file into smaller, more manageable components or services, following Angular best practices. Improve readability by organizing...

As a respected tutoring business, I'm seeking the services of a skilled and knowledgeable marketing professional who can help increase awareness for the subjects I offer - Accountancy, Commerce, Economics, Computer Science, English and Tamil. Key Responsibilities: - Target high school students effectively through savvy and persuasive social media strategies. - Impleme...social media and email marketing platforms. - Knowledge and understanding of the high school student market. - Ability to promote educational services persuasively and impactfully. - Strong skills in creating educational content are a plus. Your work is instrumental in promoting my tutoring services to the right audience and driving the growth of my business. Let's help more high school students excel ...

I'm looking for a skilled Java developer who can add an essential feature to my existing web client. Here are my specific needs: - Add a small piece of code to introduce a text input field on my web client. Your past experience in web development using Java will serve well for this project. An understanding of integrating new features into an existing Java code is essential. I'll appreciate if you can make this modification without disturbing the existing functionalities. Perfect for those adept in web front-end development and proficient in coding with Java.

...using Excel. As an experienced expert, your responsibility entails: - Data analysis: Your role involves interpreting complex data sets, looking for trends and patterns that could be beneficial for decision-making processes. - Pivot tables: You should create pivot tables to summarise, analyse, explore, and present a summary of the data. - Formulas and functions: You must possess an in-depth knowledge of Excel formulas and functions, and be able to apply them appropriately in a variety of contexts. - Financial model: In terms of financial modeling, the goal here is to build a model for financial forecasting purposes. Visualization of the analysis should be communicated effectively using: - Pie charts - Bar graphs - Line graphs Skills and experience needed: - Proficienc...

I am in need of an expert who has a solid grip on Excel, able to arrange numerical data into tables for me. To make my work simpler: - The main task will involve averages, mean calculations, as well as frequency and distribution analysis. Past experience with these functions is essential. - I am looking for someone who can efficiently sort the data in ascending order. Demonstrated ability with sorting functions in Excel is preferred. In summary, a flawless understanding of Excel and a keen eye for detail will be crucial for this project.

you will use a cache simulator to analyze the performance (hit rate) of three cache designs. You will do this in an analysis paper which should answer the following questions: How does the performance of a cache change with its associativity? (e.g. direct mapped vs n-way associative vs fully associative) How does the performance of a cache change with cache size? How does the performance change with replacement policy? How does the performance change with the line size? Important Information The format of the memory trace file is the following: The first field is “l” or “s” depending on whether the processor is loading from or storing to memory. You don't need to do anything differently for load or store. The second field is a 32-bit memory address. The thir...

I need a proficient React Native developer who can deftly convert an existing Android App source code to work with React Native. The converted app needs to be compatible with both Android and iOS devices. Since details about the needed features and functionality were not provided, I would require the developer to ensure that the functionalities of the current Android app are fully intact and operational in the converted React Native version. Skills & Experience: * Cross-platform mobile app development using React Native * Knowledge of Android source code * Ability to work fast and meet deadlines Please apply if you can deliver this project urgently as I need it completed ASAP.

I'm in need of a professional who has mastered the Excel 2016 with a strong focus on VBA scripting. The individual should have: - Proficiency in financial modelling using VBA. -Option Future calculations P&L of portfolio.

I require a quick and precise assist in compiling sales leads data from the New York Suppliers Day Exhibitor List. Your tasks will involve: ... Note: *ONLY 'RAW MATERIALS' EXHIBITORS REQUIRED* The first one is already done for you here: Given the urgency, applicants should have: - Proven data entry abilities, with strong attention to details. - Proficiency in Excel or similar spreadsheet tools. - Able to deliver as quickly as possible. Candidates who have background in lead generation or sales data analysis are preferred. This task is pivotal in analyzing our potential sales leads, thus accuracy is paramount.

...include profound knowledge of both Android and iOS platforms, extensive experience in app development, and an understanding of the intricacies involved in creating music applications. Ability to infuse apps with user-friendly features while keeping the aesthetic appeal is a definite plus. Take note, there is no time limit to this project, but maintaining quality is of utmost importance. So, if you excel in precision and have a knack for creating robust applications, you're the right fit for this job....

Transitioning from Excel to Looker has been quite a hurdle. I need a professional who is an expert in building new Looker explores and can also provide guidance and answer specific queries on dashboard building. Here are the specifics I'm looking for: - Looker Expertise: Help us transition from our existing Excel methodology. Your task would not just be to visualize the data but also come up with insights that aid business growth. - Interactions: You would be closely interacting with our team. Hence good interpersonal skills are a must. - Data Source: Proven experience in connecting and analyzing data from Google Sheets through Looker is vital. In short, we need someone who can take the lead in ushering us from the Excel era into Looker while ensuring mini...

...to monitor our stock levels and analyze our order trends effectively. Ideally, freelancers would have prior experience in web application development, with a particular emphasis on order and inventory management solutions. Some knowledge of CSV file manipulation and report generation would be a definite plus. Major Task which we need to accomplish with this system. 1- Upload daily order files - EXCEL/CSV. 2. Update daily orders , quanity, status (avaiable/not avaiable, when avaiable with dates) etc. 3- Genarate procurement orders sheet to market 4- Genarate adress sheet to feed into shipping software 5- Upload shipping software sheet into system. 6- generate order sheet with tracking number to feed into external system. 7- Should be able to view pending, fullfillment orders on a...

...individual who can proficiently lend a hand in some aspects of my Computer Science course, specifically labs and exams that utilize Excel and Microsoft Access. Here's what I'm grappling with: - Database design, query writing, and forms and reports design. - Comprehending lab instructions. - Applying theoretical knowledge in practical tests. - Interpreting results accurately. Although I possess intermediate knowledge about Microsoft Excel and Access, these topics are giving me a hard time. The ideal person for this role would be someone who can expertly guide me to enhance my understanding and application of these areas. You would need strong, practical experience in Excel and Microsoft Access, including proficiency in database, forms and reports design, ...

【 overview 】 This time, we would like to ask you to develop a tool that automatically searches for landline phone numbers on Google and checks business hours. [Request details] ・Development details: Please develop a business hours search automation tool system on Google. - Desired function: System image ①Import an Excel file or CSV file containing only phone numbers to the system ② The system automatically searches Google and searches for the information you want, such as business hours search * Desired information → "Business hours", "Closed days", "Reviews" *There are some patterns that Google doesn't have, so I'd like you to add a flag for those cases as well. ③ After the search is complete, the information will be listed in the cell ...

...Design - Graphic Design - UX / UI Design - SEO optimized content Pertinent Features: - My website will house detailed resource guides, so proficiency in organizing and categorizing large volumes of information is essential. - A clean, user-friendly navigation menu to direct users to the relevant guides. - It should be mobile and desktop friendly. This is a great opportunity for designers who excel in developing educational or resource-based platforms....

In my financial business project, I'm looking for a professional to help me schedule 10 to 15 online meetings per week with investors. Key responsibilities include: - Make a list of investor names/emails in Excel; - Collect emails that are actually valid; - Contact investors to collect email addresses. This would be a great opportunity, especially for those who do not have any skills developed to their full potential. If I close a deal with a client who comes to you, you will receive a commission (ranging from US$90, US$180, US$270 or US$360). Are you ready to join my financial journey? Your efforts can lead to fruitful rewards!

Estudiante avanzado o recibido Para realizar las tareas será indispensable contar con: Excel avanzado Disponibilidad horaria para conectarse Conocimientos en plan de cuentas, de gastos, uso se software contable, etc.) Algunas tareas: Tareas fiscales para DGI Contabilidad interna Pasado de comprobantes de compras y gastos Análisis financieros

I need to create an automatic functions to split the data in Excel. Can be created in Excel Macros or VBA

Looking for someone well-versed in Excel for efficient and accurate data entry of quantitative data. Skilled data entry specialists who can handle basic computations will be preferred. Knowledge in Excel formulas or functions might be necessary, but I'm not entirely certain at the moment. - Proficient in Excel - Demonstrable experience in data entry - Ability to perform computations - Knowledge of Excel formulas/functions a plus

...UX/UI design. - Web3 infrastructure will be built using Thirdweb, an open-source web3 development platform ([Thirdweb]()). Additional Notes: - Applicants should have expertise in React development and familiarity with Web3 technologies. - Previous experience with similar projects or familiarity with finance-related applications is advantageous. - We prioritize clean, efficient code and a user-centric approach to development. - Strong communication skills and the ability to work collaboratively in a remote team environment are essential. Additional details you should know: Seeking an expert React developer capable of infusing Ethereum into the development of a Web3 App. We insist on someone who possesses: - Proficiency in Ethereum and deep understanding of its interaction

Auditor Appointment & Filing of Form ADT - 01 (Auditor Appointment). Preparation & Filing of Form INC - 20A (Declaration of Commencement of Business). Preparation & Filing of Balance Sheet, P & L Accounts, Audit Report, Director's Report. Preparation & Filing of Extract of Annual Returns & Financial Statements (0-100 transactions) if provided in Excel sheet. Preparation & Filing of Annual Returns Form AOC 04 (Financials Related Annual Return). Preparation & Filing of Annual Returns Form MGT 07 (Management Related Annual Return). Preparation & Filing of Minutes of 04 Board Meeting & Minutes of AGM. Preparation & Filing of Income Tax Returns (Company). FY 24-25 Preparation of Share Certificates (For All Shareholders). Preparation & ...

What I need is a Telegram user account that can send controllable dice emoticons within a designated group. NOTE: This is not a Telegram bot, but a personal Telegram account. As far as I know, the above requirements can be communicated with telegram API through telehin library. Using the message sending function provided by the Telegram API, you can send Dice emoticons with a specified number of points to a specified chat room. The other members of the group will not be aware that the dice have been controlled.

I need a skilled professional to update my website's stock prices in real-time using excel. The project primarily involves: - Updating numerical data on my website - Ensuring accuracy and real-time updates - Using excel as the data source Ideal candidates will have: - Experience in data updating on websites - Proficiency in excel and data management - A good understanding of stock prices and real-time data management The goal of this project is to enhance the user experience on my website by providing accurate and real-time stock prices.

I'm in need of a defold code expert to rectify multiple issues I'm experiencing with my current project. These issues include syntax errors, performance hitches, and implementation mistakes. The code is primarily being used for game development and UI design for an action game I'm working on. However, these persistent errors have halted progress, making expertise crucial at this point. Key Tasks: Identifying and fixing syntax errors Improving performance related issues Correcting implementation errors Implementing some new ideas Ideal Skills and Experience: Proficient in defold framework Experience in game development and UI design Strong debugging and problem-solving abilities Please place your bid with due consideration of the tasks and skill...

I need a fluent Arabic speaker who is proficient in Power BI to help convert an existing Excel file into a dashboard for performance tracking purposes. - KEY RESPONSIBILITIES: The practitioner will be proficient enough in Power BI to translate raw data into accessible and meaningful dashboard visualizations. Highlighting and tracking key performance indicators for strategic planning follow-up is a must for this role. - REQUIRED SKILLS: Understanding of Microsoft Power BI, an eye for design to ensure the visualization is as seamless as possible, and fluency in Arabic. Experience with Excel to Power BI conversions and strategic planning will be considered favorably. - IDEAL CANDIDATE: The freelancer should have a strong background in data analysis and a portfolio or examp...

I'm in need of a talented No-code developer who is skilled in using Webflow. The primary task will be to create a custom web application. However, since I missed detailing specific features and functionalities I desire in the application, it would be beneficial if you can interpret basic functionalities such as user management, data visualization, and payment integration. Your job will be a success if: • You masterfully craft functional, custom web applications using Webflow. • Adaptability and problem-solving skills are part of your skill set. • You can interpret and implement basic functionalities in the absence of specific instructions. Ideal skills would include proficiency in Webflow, a knack for creating custom web applications, and a keen eye for integra...

We need to create an Excel Spreadsheet to track Cash income and expenses. We will begin with a specified amount of cash. First priority is to be able to know at any given time how much cash should be in the petty cash account. Would like to have a space for a weekly balance in order to identify losses or un recorded income/expense in a timely manner. At the end of each week, the keeper of the account will enter the actual amount of cash on hand. This should be subtracted from the recorded expenses and income and a + or - sum generated. (This allows us to catch and correct possible typo's and/or unrecorded income/expense in a timely manner) We want it to generate monthly totals to include Total Cash income Total Cash expenses. The cash expenses should be subdivided...

I require an experienced R developer to retrieve and analyze specific financial indicators. Your role will encompass: - Code development using R to retrieve and implement financial data. - Deep understanding and familiarity with financial indicators, particularly with HPI (Housing Price Index), GDP (Gross Domestic Product), IR (Interest Rates), FDI (Foreign Direct Investment), CPI (Consumer Price Index) and REER (Real Effective Exchange Rate). - Advanced statistical analysis of retrieved data. - Delivery of comprehensible reports explaining the data analysis. - We need to extract the above mentioned data for India. The data will need to be processed, either on a quarterly or monthly basis. (Monthly is preferred). Run all the required tests on the data (autocorrelation, heteroskeda...

I'm in need of a freelance bookkeeper fluent in German for approximately 20 hours per week. Key responsibilities will include document research and debtor/creditor management. - Software Proficiency: You should have experience in Excel and a solid grasp of basic accounting principles. - Responsibilities: Duties will involve expense tracking, invoicing, and bank reconciliations. A keen, meticulous eye for detail is a requisite as well as outstanding organizational skills. A flexible, freelancer approach is ideal for this project. This role will suit someone who enjoys piecing together information and has excellent problem-solving abilities. Experience in a similar role would be a great advantage.

I am looking for an experienced Photoshop specialist to accomplish a small task that will take less than two minutes. Your main task will be to modify the content of the text within an image. The modification will involve replacing the existing text with a specific phrase provided upon project initiation. To excel in this job, you need to have a keen eye for detail to ensure precision in text modification and a good command of Photoshop. Fast turn-around would be much appreciated.

I'm seeking a skilled freelancer experienced in data entry and Excel to enter and transform a medium-sized set of customer records and product details. Key Responsibilities: - Accurately enter data, including customer records and product details into Excel templates - Transform raw data into more useful formats and ensure data integrity - Double-check entries for accuracy and fix any discrepancies Skills and Experience: - Expertise in data entry and Excel - Proficiency in transforming and structuring data - Previous experience handling equivalent tasks related to customer records and product details. Your expertise and attention to detail will be critical to ensure the accuracy and usefulness of the resulting data.