Run vba macro perlJobb

excel vba programming convert excel sheet function into VBA

...compatible macro for an Online 2D Pixel Art game. The macro needs to control a player and manage various tasks, including mining, fighting spiders, and handling mine collapses. Key Features of the Macro: - Control a player near the screen center - Mine a rock wall with varied inputs - Move to the side and repeat mining - Return to the original position after a few cycles - Handle random events like spiders appearing or mines collapsing - If a spider appears, swap weapons and attack it - If a mine collapses, quickly head to the exit, re-enter and return to original position - Implement dynamic movement patterns to avoid detection from anti-cheat systems/game Admins lurking. Detection Methods: - Use pixel color detection to identify events Additional Requirements: ...

I need a tailored Excel template to streamline my work checks. Currently, I have to manually copy and paste complicated formulas and use text replace functions to substitute keywords like LESS and PLUS with their mathematical counterparts. For examples sake, I want to put in "(25%LESS1/8LESS1/16 of 7/8) of 1/2 of 1/2 of 8/8" in A1, and have a Cell then automatically output...Excel template that can process long form mathematical expressions and return values automatically, saving me the tedious work. - Ensure the template can handle mixed operations including addition, subtraction, multiplication, and division. Ideal Skills: - Strong expertise in Excel, especially in creating custom templates. - Experience with mixed operation formulas. - Familiarity with Excel's macro...

I'm looking for an AutoHotKey, PowerAutomate,UIPath or Macro Express professional to create a script for simulating mouse and keyboard events. Key Requirements: 0- Create a simple dialogn box with a) Button Start/Stop mouse capture b) enter the name of target program (text box) 1- capture mouse events for 10 second and save in a file ( precisely , clicks, moves, click+move etc etc , with timestamps) 2- play all these mouse events save in a file on a target program (word, paint, canva, etc etc) target program will be specificed 3- The events recorded in file must play exactly on the target window . This is simple 1 hour job, and might be more next week.. use any tool of your choice

...day of each calendar year Correctly calculated annual interest Available credit line at the end of each year Technical Requirements: The spreadsheet must use formulas and/or VBA automation to ensure accurate and dynamic calculations. Must be fully functional on both Windows and Mac versions of Microsoft Excel without compatibility issues. Data should be structured for easy input and updates. The layout should be clear and user-friendly. The solution must handle different loan durations, interest rates, and varying payment schedules. Ideal Candidate: Expertise in Microsoft Excel, including formulas, pivot tables, and VBA (if needed). Strong understanding of financial calculations, especially loan interest computations. Experience ensuring cross-platform compatibility betwee...

...comments and descriptions, and export them to Dropbox as PDF files. No Play Store deployment—APK installation only. No user management or backend; Dropbox acts as storage. Key Features ✅ Report Management: Create, update reports. Each report generates a corresponding folder in Dropbox (e.g., "X-location-date"). ✅ PDF Generation: A single, predefined template for all reports (inspired by Report & Run). ✅ Dropbox Integration: Sync reports, images, and metadata (stored as a JSON file in the root folder). ✅ Basic UI: Functional, minimalistic interface with a home screen listing reports (sorted by date, filterable). ✅ Image Handling: View reports with attached images (ordered by date), and tap images to see details. ✅ Notifications (Optional): Explore OneSignal f...

Need to analysis current select columns using ChatGPT API

I'm in need of an Excel Macro specialist who can assist in extracting tables from multiple PDF files into Excel. Budget - 20 Max Key Requirements: - Expertise in Excel Macro development - Experience in data extraction from PDF files, particularly tables - Ability to deliver a quick turnaround Ideal Skills: - Proficient in Excel and Excel Macro - Skilled in handling and processing PDF files - Fast and reliable with a strong attention to detail. Please note, the task involves multiple PDF files, so the ability to handle bulk data and automate the process efficiently is crucial. I look forward to your bid and your proposed timeline for completion.

I'm currently using a Selenium driver via Excel VBA to scrape a website, but I'm running into some issues that I need help fixing. The project involves a scrollable table where the link element needs to come into view before data can be extracted. Key Problems: - Extracting data from the table consistently fails. - Many elements are not found when trying to scroll the table into view. Methods Tried: - I have attempted using Execute JavaScript to scroll the table into view. I am happy to share my current code and provide access to the website so that you can see the problem first hand. I am looking for a freelancer who has experience with Selenium and Excel VBA and can help me fix this quickly.

I'm currently using a Selenium driver via Excel VBA to scrape a website, but I'm running into some issues that I need help fixing. The project involves a scrollable table where the link element needs to come into view before data can be extracted. Key Problems: - Extracting data from the table consistently fails. - Many elements are not found when trying to scroll the table into view. Methods Tried: - I have attempted using Execute JavaScript to scroll the table into view. I am happy to share my current code and provide access to the website so that you can see the problem first hand. I am looking for a freelancer who has experience with Selenium and Excel VBA and can help me fix this quickly.

I'm looking for a skilled Excel Macro specialist to automate the importing of data from PDF files into my Excel spreadsheet. Fixed Pay - $20 Key Responsibilities: - Create an Excel Macro to automate data entry from PDF files into Excel. Ideal Skills and Experience: - Proven experience with Excel Macros. - Proficiency in data manipulation and automation. - Familiarity with importing data from PDF files. - Excellent problem-solving skills.

I'm looking for a professional Excel macro developer who can help me create a macro that extracts specific information from one Excel file and organizes it into another new Excel file. Key Requirements: - The Macro should be able to extract specific information from Sample A and make it into an organized Excel file exactly like Sample B. - NOTE: Sample A will have Comments on what specific information will be extracted and become Sample B. Hover over them to view the comments - NOTE 2: If some of the information in Sample A is Blank, then leave them blank for Sample B Ideal Skills: - Proficient in Excel, especially in creating and implementing macros. - Experience with data organization and manipulation in Excel. - Strong attention to detail to ensure data is a...

Vänligen Vänligen Registrera dig eller Logga in för att se mer information.

I'm looking for an Excel Macro expert to create a macro for me that will automate reporting from local Excel files on my Mac. I need this to enhance efficiency and accuracy in my data handling.

I'm looking for a skilled programmer who can help me convert my Perl code into Python. Key Requirements: - Expertise in both Perl and Python programming languages - Strong understanding of data processing, specifically with text data - Ability to translate algorithms and logic from Perl to Python - Experience in ensuring that the Python code replicates the functionality of the Perl code accurately. The current Perl code is used for processing text data. The source of the data is varied and can come from multiple formats. Your job will be to ensure that the new Python code can handle this with the same efficiency and accuracy as the existing Perl code. A keen attention to detail and a methodical approach to coding will be key to the succes...

I'm looking for a freelancer to create an Excel workbook that consolidates data from 7 source sheets into a main sheet. The solution should dynamically update in real-time as the data in the source sheets change. PLEASE SEE THE ATTACHED PDF FOR A BETTER UNDERSTANDING. Key requirements: - Use either Excel formulas or Power Query. VBA and Macros are not allowed. - Summarize totals for each unique combination of columns A-D from the source sheets. Note : data both sheets could go up to 1000 + rows. Deliverables: - A fully functional Excel file where the main sheet updates in real-time. - Clear documentation or a short instructional guide explaining how the solution works. Ideal skills and experience: - Strong Excel skills and expertise in using Power Query. - Good understan...

I have an Excel workbook with 7 source sheets and 1 LV (Landing View) sheet. The task is to automatically consolidate data from the 7 sheets into the Main sheet using either Excel formulas or Power Query (VBA and Macros are strictly off-limits). Requirements: - The solution needs to be dynamic, updating the LV sheet in real time as data in the 7 source sheets changes. Deliverables: - A fully functional Excel file where the LV sheet updates in real-time based on data from the 7 sheets. - Clear documentation, or a short instructional guide, explaining how the solution works. Ideally, the freelancer will have strong Excel skills, expertise in using Power Query, and a good understanding of data mapping. Experience with creating dynamic Excel solutions will be highly advantageous.

I'm in need of a proficient Excel macro developer who can automate a series of tasks for me. The primary objectives include: - Data Cleaning: Streamlining and organizing data to enhance its quality and usability. - Report Generation: Automating the process of report creation to save time and effort. - Complex Calculations: Building macros to perform intricate computations seamlessly. The macros will primarily interact with Excel files and Databases. As for triggering the macros, I would like to initiate them manually. Ideal skills and experience for this job: - Strong proficiency in Excel and VBA (Visual Basic for Applications). - Prior experience in developing macros for data cleaning, report generation and complex calculations. - Familiarity with databases and abil...

I'm looking for a skilled Excel VBA developer. I need a worksheet modification that will control data entry into cell H8 based on the status of cell D8, and enforce data type constraints. Requirements: - If cell D8 is BLANK: Allow user to enter data into cell H8. - If cell D8 IS NOT BLANK: Populate cell H8 with data from cell H12 and lock the cell from user changes. - Implement numeric-only validation for cell H8. Additional Information: - Cells D8, H8, H12 are unlocked and the sheet is password protected. - The functionality should persist for future users, even after data row 8 has been saved and cleared by an existing VBA script. Ideal skills include: - Proficiency in Excel and VBA - Experience with implementing data validation and conditional cell behavior ...

Create an excel file, with macros and forms (VBA development) to facilitate the folow up of work

I need an experienced Excel expert to rewrite my complex, formula-heavy and macro-utilizing XLSX file for use on a Mac M3 Sequoia. This project involves ensuring the formulas remain unlocked and adding filters to the spreadsheet. Key Tasks: - Convert the current XLSX file for compatibility with Mac - Ensure all complex formulas and macros are functional and unlocked - Implement filters into the file - Add Pivot tables as per the original file - Apply basic styles and colors for customized formatting Ideal Skills: - Extensive experience with Excel and XLSX files - Proficiency in creating and modifying Pivot tables - Strong understanding of basic Excel formatting - Familiar with Mac M3 Sequoia compatibility issues - Able to unlock formulas and add filters as required This project r...

I'm looking for a seasoned developer to create a web application using Perl and Python. The primary function of the app is for monitoring and logging. Key areas of focus include: - Automation Implementation: This is the most crucial aspect of the project. The ideal candidate should have extensive experience in implementing automation in web applications. - DevOps Pipeline: Experience with setting up a seamless DevOps pipeline is a must. The candidate should be able to integrate the application into a well-functioning DevOps pipeline. - Database Integration: The application will require MySQL for its database. Tasks will involve application development, so proficiency in schema design, data migration, and performance optimization is key. - Ansible Playbook & GitHub: The ...

I need a VBA script for Microsoft Word that will help me remove highlights from bullets and the space after in bulleted paragraph lists. The script should be manually executable by clicking a button. Ideal skills and experience for the job: - Proficiency in VBA (Visual Basic for Applications) - Strong understanding of Microsoft Word functionality - Prior experience creating Word scripts - Ability to write clear, user-friendly code Please note: The specific version of Microsoft Word this script will be used on has not been determined yet, so the script should be compatible with Microsoft Word 2016, 2019, and 365.

I'm looking for an AutoHotKey, PowerAutomate or Macro Express professional to create a script for simulating mouse and keyboard events. Key Requirements: The script should capture events from a foreground window and replicate them in a background window with a 10-second delay maximum. e,g - we have two ms paints running, we draw something on a ms paint in foreground, the same is automatically drawn on mspaint in background. - this can happen with 10second lag or less - both background and foreground windows are maximized. Ideal candidates should have significant experience with AutoHotKey, and ideally have previously developed similar scripts. Good understanding of Windows applications and ability to implement variable time delays is a must.

...with Influencers on TikTok and Instergram. If you can supply account examples on TikTok and Instergram this will help you win the job. I’m looking for an influencer marketing expert to help promote my TikTok and Instagram account. The primary goal of this campaign is to increase my follower count through collaborations with Macro-influencers (100k-1M followers). Key Responsibilities: - Strategize and implement influencer marketing campaigns - Coordinate with Macro-influencers to create engaging lifestyle content - Assist in video and image editing to maintain a consistent and appealing aesthetic across all posts Skills and Experience Required: - Proven experience working with TikTok and Instagram influencers - Strong understanding of influencer marketing strategi...

...exe program but will need to be triggered using a Windows batch command or VBA. Original source txt file is built from an excel worksheet, so an alternate solution can be building files as described via excel VBA from existing excel spreadsheet as long as it includes a PUT command to the FTP location for all built files. Ideal skills for this project include: - Proficiency in writing Windows batch files. - Excel VBA. - Experience with file handling and FTP in a Windows environment. I have an FTP location and credentials ready. Files should retain the original filename with a numeric suffix (e.g., , ). Will supply example of full source file and/or original excel file for a VBA solution. The header in the source file is a single line. The batch file shoul...

My macros are not functioning on my Mac and I need an expert to troubleshoot this for me. Ideal candidates for this job should have: - Deep understanding of Excel VBA - Experience with Mac versions of Excel - Problem solving skills to troubleshoot why macros aren’t running and resolve code, where required branch code into mac or pc subs/functions.

I need a skilled Excel VBA programmer to assist in automating tasks in my Excel workbook. The primary task involves sending data from a user form to the relevant worksheet. Key Requirements: - Proficient in Excel VBA - Experience in Excel workbook automation - Ability to organize data by category in the relevant worksheet. The ideal freelancer for this project should have a strong background in automating tasks using Excel VBA and can efficiently categorize data in Excel worksheets.

I am seeking a skilled VBA developer to help automate the generation of financial reports in Excel. Ideal Skills and Experience: - Proficiency in VBA with extensive experience in Excel automation - Prior experience in automating financial report generation is a plus - Strong attention to detail and ability to understand complex financial data

I need a professional Excel expert with strong skills in data analysis, macros, and VBA. You will be required to create a sophisticated Excel spreadsheet for analyzing trading data. Key Responsibilities: - Create an advanced Excel spreadsheet for trading data analysis - Incorporate real-time data updates into the spreadsheet - Implement advanced charting and visualization techniques - Design automated trading signals within the spreadsheet Ideal Skills: - Excel: Advanced spreadsheet creation and optimization - Macros and VBA: Proven experience in automating tasks and enhancing workflow - Python: Familiarity with Python for data analysis and Excel integration would be a big plus. Payment: - The designer will be compensated on a daily basis, with payment based on the number...

I am looking for a VBA expert who can develop a solution for generating detailed reports from Excel files for my business case. The primary objective of this project is to automate the report generation process, making it more efficient and less time-consuming.

...psychological distress, particularly considering ultimate meaning struggles. Key Responsibilities: - Conduct assumption testing, descriptive and reliability analyses, bivariate correlations, and mediation analyses using SPSS and the PROCESS macro. - Perform subset analyses for both religious and agnostic/atheist groups. - Deliver a written report in an academic style with references, summarizing the results, along with an annotated SPSS output file and a final data file with clear documentation. Key Skills and Experience Required: - Proficiency in SPSS and the PROCESS macro. - Strong background in mediation analysis and psychological research. - Experience in conducting and interpreting statistical analyses. - Ability to write in an academic style with appropriate refer...

I'm looking for a COMSOL professional who can assist with a thermal behavior analysis of a lithium-ion battery with a surface crack. Key requirements: - Expertise in evaluating mechanical integrity within the context of thermal behavior. - Proficiency in a...professional who can assist with a thermal behavior analysis of a lithium-ion battery with a surface crack. Key requirements: - Expertise in evaluating mechanical integrity within the context of thermal behavior. - Proficiency in assessing charge/discharge cycles and their impact on electrochemical performance. - Experience in identifying and analyzing surface cracks, specifically micro-cracks, macro-cracks, and delamination. Your bid will be evaluated based on your relevant experience and ability to deliver a comprehe...

More details: What specific tasks do you want the macro to perform? Data analysis, Data formatting Do you need the macro to run automatically under certain conditions? No, I'll run it manually What level of user interaction do you foresee with the macro? Simple prompts and inputs

I need an experienced Excel VBA programmer to modify my VBA Code macros. The job involves enhancing an Excel form and including a 'modify' function. Modify "Agency" file to be like "Testttt" file and include the Modify button. Key requirements: - Modify an existing Excel form - Include a 'modify' function in the form - Improve the overall performance of the form The ideal freelancer would have: - Extensive experience in Excel and VBA - Ability to optimize data modification processes - Skills in designing user-friendly forms The project also involves changing some aspects of the form's appearance: - Removing some fields from the form - Changing the layout of the form The successful freelancer will be able to deliver a w...

I'm seeking an Excel expert to create a macro that automates repetitive tasks, specifically data formatting. The primary focus will be on automating conditional formatting. Ideal Skills and Experience: - Proficiency in Excel - Experience with creating macros - Understanding of data formatting - Expertise in conditional formatting - Ability to deliver a user-friendly solution Has a lot similar automation requests, looking for long term cooperation. Details： please see attached files- 1. Column K --> Cargo Control Party Name: Kmart 2. create Column V: Vsl Voy IB 3. match Column U: Outgoing SVVD --> Column V: Vsl Voy IB with the data in (columnA,B --> column C, F )

I'm in need of a proficient VBA CorelDRAW programmer for the 2024 version. My project involves creating a VBA script that generates QR codes within a specific template of a certain size. The script should also arrange these QR codes for printing on various printer sizes, specifically a custom size of 48x96 inches. Ideal candidate should be skilled in: - CorelDRAW and VBA - Understanding of QR code generation - Experience with custom printer size arrangements - Ability to work with specific size templates (small, medium, large)

I'm looking for a professional, engaging, and informative PowerPoint presentation on Saudi Arabian culture, targeted for a new American manager. The focus should primarily be on business interactions, but also touching on macro overview, religious customs, social norms, and other crucial aspects. The presentation should: - Be designed to fit within a 1 hour timeframe. - Incorporate infographics to make it visually appealing. - Include a selection of helpful videos at the end, providing further context and insight. I have provided some links to videos that can serve as a baseline for the content: - - - Ideal candidates for this project should have: - A deep understanding

I'm seeking a proficient Excel VBA programmer to create a script for my Purchase Order workbook. This project involves both an existing workbook and the creation of a new one. The VBA script should be triggered automatically when the workbook opens. Key Tasks: 1. Implement filters at the top of the worksheet. 2. Adjust the width of Column C (Products). 3. Insert new columns with specified modifications: a. After Column I: Discrepancy (using formula: =I2-H2) b. After Column J: Reason (with a dropdown list sourced from the next sheet) c. After Column K: Notes (a free text column) 4. Apply specific formatting to the columns: a. Column A: 40 points b. Column B: 10 points c. Column C: 60 points d. Column D: 35 points e. Columns E-J: 15 points f. Co...

Necesito un macro para uber para que me muestre cuanto gano por km recorrido en total para saber si me sale a cuenta o no el viaje

...A clean, polished, and user-friendly design that reflects our credibility and expertise. Service Pages: Clear and detailed sections to highlight our Web3 and fintech legal services, tailored for businesses, startups, and individuals. Jurisdictional Guides: Interactive, easy-to-navigate guides on digital asset regulations across different regions, helping visitors quickly find what they need. Macro Legal Compliance: A dedicated section that explains broader global compliance requirements in simple, digestible terms. Insights and Analysis: A blog-like section with articles and deep dives into fintech topics like ICOs, cryptocurrencies, and other key trends. News and Updates: Regularly updated news and insights on legal changes and developments in the industry. Media and Publi...

I'm seeking a skilled Excel programmer to create a macro. This macro should compile various employee data from different sheets into a new Excel sheet. The task involves data cleaning, analysis, and report generation. Key Requirements: - Experience in Excel macro development - Understanding of data cleaning and analysis - Ability to generate summary reports, pivot tables, charts and graphs - Familiarity with handling employee data Please note, the goal is to create a macro that can automate this process, saving time and ensuring consistency in data compilation.

I'm seeking a professional photographer who specializes in macro/detail shots to capture my handmade bags. The primary purpose of these photos will be for my social media platforms. The ideal candidate will have: - A portfolio demonstrating experience with product photography, particularly with fashion items. - An eye for detail and ability to capture the intricate features of the bags. - Understanding of how to create engaging, high-quality images suitable for social media. Please include examples of your previous work with similar products in your proposal.

My name is Koid, and I am interested in purchasing the Run Tracker app (regular license) for use with my team. I have downloaded and tested the app, and I would like to customize it for a "flyer delivery" application to enhance my current operations. I currently have an older app that is outdated, and I now use third-party apps for live GPS tracking. However, these solutions lack some of the functionality I need, such as photo uploads. Below is a detailed list of the customizations I would require for the app: 1. Live GPS Tracking: Enable real-time tracking of workers in the field. 2. Photo Upload with Geotags: Add functionality for users to take and upload geo-tagged, timestamped photos as proof of work. 3. Offline Mode: Ensure the app works offline and syncs data (li...

I am looking for a macro developer for PC that can help me automate the process of "opening" gifts in Hypixel Skyblock in Minecraft. Ideal Skills: - Experience with creating macros for PC games - Extensive understanding of Minecraft gameplay and mechanics, particularly Hypixel Skyblock - Proficiency in programming languages suitable for macro development - Knowledge of PC gaming hardware and software The macro needs to be efficient and unobtrusive, allowing for smooth gameplay without drawing attention.

I'm looking for a skilled Visual Basic programmer who can help me develop an Excel macro. This macro needs to automate data entry tasks in a spreadsheet. Key Responsibilities: - Develop an Excel macro using Visual Basic. - The macro should be capable of automating repetitive data entry tasks. - Ensure the macro is user-friendly and efficient. Ideal Skills: - Proficiency in Visual Basic, particularly in creating Excel macros. - Experience with data entry automation. - Excellent problem-solving skills and attention to detail.

We are seeking a skilled freelancer to help transfer and configure macros from one computer to another. The macros are fully operational on the original machine, and we need assistance ensuring they work seamlessly on the new setup. Ideal skills and experience for the job include: - Proficiency in Excel, specifically with macro creation and implementation. - Experience with data manipulation, report generation and task automation. - Ability to troubleshoot and optimize existing macros for efficiency.

I'm seeking a skilled game developer to help create Bunker Run, an action horror game. Key requirements: - The game is designed from a first-person perspective and incorporates survival elements typical of action horror games. - The game is intended for PC, Console, and Mobile platforms, so cross-platform development experience is crucial. - Familiarity with horror game mechanics and entities will be a plus, as the game currently features 4 entities. Your expertise will ensure this project becomes an engaging, spine-tingling experience for players.

...all extracted data is neatly organized and formatted for easy access within Excel. Provide clear, user-friendly functionality to paste or upload listings and automatically trigger the data extraction process. Skills Required: Strong experience with web scraping or API integration to pull data from Zillow, Redfin, StreetEasy, and other platforms. Proficiency in Excel automation, preferably with VBA or Python (pandas, openpyxl) to integrate the data extraction functionality. Familiarity with Zola NYC and NYC Open Portal to access zoning and building-related data. Knowledge of real estate terminologies and zoning regulations in NYC. Experience with data validation to ensure accurate and reliable data extraction. Ability to work autonomously and deliver high-quality, maintainable co...

Vänligen Vänligen Registrera dig eller Logga in för att se mer information.