Macro jobs

I have an excel file with multiple sheets, i need to pull data from another excel file. Both have multiple sheets, so i need to reference according to sheet name, and then columns. I need a macro i can run and it does everything. Or something similar that will work.

...an expert to Add a specific code of ROC and AUC using Python (Pytorch) in Google Colab. My code is a multiclass classification for the histological images. The output must be structured into a comprehensive report print the plot of ROC and AUC for each class and the macro average then save it directly. **Requirements:** - Add the specific code of ROC and AUC ''I will send this code'' and run it in my code - Print the results of ROC and AUC with the class name, must include the percentages and plot for each class and the ''macro'' average for all classes - Save the results in the google drive directly **Ideal Freelancer:** - Proven Python & PyTorch expertise - Good understanding of data privacy for medical data The successf...

...perform complex or repetitive tasks efficiently. - Enhanced capabilities of existing pivot tables; * Effectively consolidate data from multiple sheets for more cohesive reporting. * Employ advanced calculations to extract deeper insights from datasets. What I'm expecting from you: - Proven expertise in Excel, especially with pivot tables and data analysis tools. - Strong background in VBA for macro development. - Keen eye for detail and a knack for data organization. - Ability to deliver a user-friendly interface that simplifies complex processes. - Creative problem-solving skills and an analytical mindset. Please provide examples of previous work with automation and pivot tables when you bid. Your expertise will help drive my project forward, ensuring more efficien...

I’m on the hunt for a skilled macro programmer, specifically one with a creative edge in level design for Maple Story games. Here’s what I need: - IDEAL CANDIDATE SHOULD HAVE: - Experience with Maple Story game mechanics. - Strong skills in a relevant programming language or game development tool. - Ability to collaborate effectively and bring innovative ideas to the table. - Organized, detail-oriented workflow. Timing and project milestones will be discussed once the suitable candidate is selected. Please provide your portfolio and any relevant experiences when bidding.

When clicking the “Save Button” the macro should: 1. Remove “Save Button” 2. Copy value from INVOICE!H11 to MISC!B1 3. Save PDF to path provided in MISC!B2 4. Filename should be INVOICE!A9_INV_INVOICE!H11 (i.e. KTS Group Limited_INV_13) 5. Close workbook

I am in need of an Excel expert to create a macro for Excel data replication automation. The main task is to automate data entry, data analysis, and reporting creation. It's crucial for the freelancer to: - Automate the features of copying and pasting data, updating formulas and references, and filtering and sorting data within Excel - Be proficient with Excel macros and have sound experience in automating data replication A professional with expertise in data analysis and a strong understanding of Excel functionalities would prove advantageous. The project needs to be completed within a week. Your ability to work under tight schedules while maintaining high-quality work is highly appreciated. Freelancer must be fluent in English. Files will be provided in chat only.

I am in need of an experienced macro programmer who is familiar with PC games, in particular, MapleStory Worlds. Your task will be to construct efficient macros to automate the following in-game processes: - Character leveling - Item farming - Mesos farming As a seasoned macro programmer, it's expected that you possess an in-depth understanding of the game's mechanics and the knowledge to create functional, accurate macros. Your proven experience working with similar PC games, especially in the role-playing genre, is highly desirable. I look forward to your expertise in making our MapleStory World's progression more efficient. and then We need a function that stops when a person comes to the map

I'm seeking an experienced Excel programmer to create a macro that enhances my workflow. This project involves automating the tedious task of formatting data within my spreadsheets. Ideal Skills and Experience: - Strong background in writing Excel macros - Excellent knowledge of VBA (Visual Basic for Applications) - Familiarity with advanced Excel formatting options - Ability to adhere to and apply existing style guidelines - Problem-solving skills and attention to detail Requirements: - Develop an Excel macro for text and number styling - Ensure macro aligns with pre-determined style guidelines already in place - Aim to increase efficiency and consistency in data presentation Objective: The goal is to streamline the formatting process, reducing manual input an...

...professional with expertise in Excel macros and VBA to help resolve this issue efficiently. **Core Challenges:** - Identifying and resolving the "Run-time error '1004'" in a specific Excel macro. - Ensuring that the macro runs smoothly without external software interactions. **What I Require:** - In-depth knowledge of Excel VBA and debugging techniques. - Experience in creating and troubleshooting Excel macros. - An understanding of Excel's limitations and workarounds for common issues. **Job Essentials:** - Diagnosis of the current macro error. - Correction of the faulty VBA script. - Validation of macro execution post-fix. Ideal candidates will have a proven track record of solving similar Excel VBA issues and the ability to com...

...create an advanced macro for GTA 5 RP on PC, specifically designed to enhance the fishing experience. Here's what I need: - Auto-casting the fishing rod to begin the fishing process - Auto-reeling as soon as a fish bites - An innovative feature to accurately press "E" in the blue area, which changes position randomly during the fishing mini-game - Randomization of the action timings to simulate human behavior and avoid pattern detection that could lead to account penalties The ideal freelancer will have: - Experience in game automation - Familiarity with GTA 5 RP mods and mechanics - Proficiency in scripting languages suitable for creating complex macros - A keen eye for detail and timing algorithms - Good communication skills and the ability to explain how to u...

I am seeking an experienced Excel Macro specialist who can assist with creating an automated system for my data. The ideal candidate will be expected to: - Design this Macro to draw its values from a specific reference table. - Implement a strategy for handling errors or unexpected inputs, given that this point was not detailed in the project requirements - suggestions are welcome! The freelancer should boast extensive excel and data manipulation knowledge, particularly with building and using Macros tied to reference tables. Your input on handling anomalies will be appreciated. Please bid based on your expertise and the value you will bring to streamlining our Excel data related processes.

I'm seeking an expert in DSGE models adept in Matlab. My goal is to dissect macro-economic policies, and for this task, I require: - Make changes in an already constructed DSGE model - Simulation runs using the model -Add shocks (eg. monetary , TFP, government shocks) -Define an optimized rule so as to replace the Taylor rule, and define the monetary policy endogenously. Ideal candidates will have: - Proven experience in DSGE model building and simulation - Extensive knowledge and practical skills in Matlab (dynare) - Strong background in macroeconomic theory, particularly policy analysis Please highlight your previous work with DSGE models and policy analysis when bidding. A high-quality portfolio can set you apart. This is a complex, yet very rewarding project for an eco...

...user-friendly macros and buttons that'll simplify my workflow. Here's what I envision: - Automating the insertion of a new row at the top of my sheet, each with a sequential number. - Ensuring this process is neatly formatted and aligns with the sheet's existing style for consistency and professionalism. For this task, a freelancer with the following qualifications would be ideal: - Strong Excel macro programming skills, preferably with VBA expertise. - Proven experience with Excel's formatting functions, ensuring neat and efficient automation. - Ability to work quickly and accurately, delivering a solution that's both effective and user-friendly. I'm aiming for a straightforward, easy-to-use system that makes my data management faster and more e...

I'm needing an Excel Macro that can help format my data. As I deal with a diverse set of data, the macro should be flexible and able to handle various types of data with ease. Your substantial experience in macros would be a definitive advantage. Specific formatting tasks may include, but are not limited to, text formatting and number formatting, with an understanding of conditional formatting being a bonus. If you've gotten an extensive background in Excel macros, I'd love to hear from you.

I'm in need of a skilled professional with experience in VBA and writing macros code. While the software used isn't Microsoft Excel or Access, the project involves simple tasks automation. Your role will involve: - Understanding the form and function of currently manual tasks. - Designing, developing, and implementing macros to a...used isn't Microsoft Excel or Access, the project involves simple tasks automation. Your role will involve: - Understanding the form and function of currently manual tasks. - Designing, developing, and implementing macros to automate these tasks. Ideal candidates will have a proven track record with VBA and a solid understanding of how to automate simple tasks efficiently. Experience with custom macro code in non-traditional applications wo...

I'm seeking an experienced VBA coder for building a macro code in Excel. The primary purpose of the code will be the creation of an Image Paste tool. Significant experience in VBA and familiarity with Excel are both vital attributes. Any previous work involving Image tools using VBA would be advantageous to this project. Scenario is, we have input folder(eg. 1,2,3,4,5,6) for images that folder contains multiple subfolders(eg. For folder name 1 we have subfolders 1-01,1-02,1-03....,for folder name 2 we have 2-01,2-02.... Like that and so on for other folders also), so we have to paste this images in the worksheets which will be created according to folders (e.g. inside the workbook worksheets should be named like "name of input folder-name of subfolder" like 1-1-01, ...

Hi, we are looking for someone that can help us decide what technology we should use to make automation of our laser with Ezcad 2, the job will consist on providing information. The flow will be, from an internal tool we generate an svg file, then we will launch the macro and it has to enter Ezcad, load the svg, position it correctly, select the engraving preset and fire the laser. We tried to use a software to imitate the clicks on certain coordinates but we are looking if there will be something better. there will be 5 macros for 3 pieces to handle all the types of engraving: - Ring silver - Bracelet gold, silver - Bracelet black - Necklace golf, silver - Necklace black Only bid if you have experience with software automation on real productions. Thanks!

I require an experienced developer with proficiency in LibreOffice and macro creation. This project involves developing a macro that: - Can identify and replace multiple words within selected cells. I need the macro to delete "W's", replace "l" with "-", among others. Details will be discussed further once the project commences. - Capable of not only replacing the text but also reformatting the modified cells. The specifics of this reformatting will be provided. - Can move the changed text to different cells. The ideal freelancer will have prior experience in creating macros, especially for LibreOffice. A deep understanding of the software and adept skill in macro writing is crucial for success in this project. A keen attenti...

...day) Salary: 150 – 200 INR Per Hour Job Responsibilities : • Understanding Company requirements. • Understanding, consolidating and analyzing data from spreadsheets. • Creating dashboards, reports and charts in Analytics tools. • Working on financial and other types of modeling projects. • Having knowledge Dashboard Creation, Mainframe automation through VBA. • Good Technical knowledge of VBAs, Macro, MS Office skills to drive automation opportunities. • Well-versed with dynamic loops, data extraction from images. • Work with users and team members at all levels for performance improvement and suggestions. • Understand and prepare Ad hoc reports. • Identify the opportunities of automating reports, snapshots and dashboard...

I am searching for an Excel expert who possesses strong skills in Macro programming. I have different excel files organized in different directories with the same data structure. I need to create a main excel that contain all this data in only one sheet with an automation. (This process needs to be done every 15 days, so needs to be automated) What we do now is to enter to each sheet and copy the data into a main excel and its a lot of manual work. Some requeriments: 1) the row on each excel sheet needs to be added to the main file only when the column 2 ("Fecha de ingreso (dd/mm/aaaa)" is not empty, if not the row should be not consider. 2) There should not be empty rows in the "Main excel" 3) The titles should appear only once in the main excel, as the data s...

I'm experiencing some technical issues with the macros...hampering the overall efficiency of my workflow. Specifically, here are the key areas requiring attention: • Identify the existing issues with macros not functioning properly or delivering inconsistent results. • Rectify and streamline those problematic macros to ascertain seamless financial operations. The ideal freelancer for this task should have a strong understanding of Excel, especially its macro functionality. Previous experience in dealing with financial statements and troubleshooting Excel macros is an added advantage. Critical skills include: • Microsoft Excel proficiency, particularly Macros • Keen eye for detail to spot inconsistencies • Prior financial statement experience •...

As someone dealing with a crucial Excel project, I'm looking for a skilled VBA programmer to rectify two issues. The first one concerns a Macro that's not producing the expected results. Sadly, this malfunction is resulting in incorrect data processing. Secondly, I'm facing some formatting difficulties, needing an expert to resolve them. Both tasks are fairly straightforward, likely taking no more than 30 minutes. Ideal candidates should possess extensive knowledge of VBA and a keen eye for detail to ensure formatting accuracy.

Seeking a proficient writer for twice in a week engaging LinkedIn posts revolving around supply chain management, current macro economics, and people management. The ideal collaborator for this endeavor will understand these fields and be able to craft conversational, yet informative posts that work towards: - Building Professional Network: larger my contacts while creating meaningful engagement. - Sharing Industry Insights: creating a thought-leadership platform which showcases my knowledge and perspective of industry trends. - Promoting Personal Brand: establishing a unique voice that represents my professional identity well. Required skills: LinkedIn Content Creation, Content Writing, Knowledge in Supply Chain Management, Macroeconomics and People Management, Social Networking....

I am seeking a skilled photographer to capture a series of photos showcasing a glass of oil and water, with the aim of highlighting the gradient at the interface. The project requires the following: De...variations in distance from the glass. Macrozoom Level: - The maximum macrozoom level required is 30x or more, enabling a detailed view of the oil-water interface (if possible we should see the gradient) Ideal Skills and Experience: - Proficiency in macro photography and capturing intricate details. - Experience in photographing liquids and understanding their behavior. - Attention to detail to ensure the desired gradient effect is visible in the photos. Please provide a portfolio or samples of previous work demonstrating your expertise in macro photography and capturing...

I'm currently seeking a professional adept both in Excel and Java programming to take on an upcoming project. The main tasks will focus on: - Formula creation specific to Excel. - Macro development within Excel. An ideal candidate for this role will have: - High proficiency in Java programming. - Great knowledge of Excel, particularly in creating formulas and developing Macros. - Experience with report generation in Excel using formulas and macros. The end goal of this project is to leverage these skills to optimize my report generation process within Excel. This includes creating efficient formulas and macros that improve on the existing infrastructure. Having previous experience in similar projects will be a major plus.

...day) Salary: 150 – 200 INR Per Hour Job Responsibilities : • Understanding Company requirements. • Understanding, consolidating and analyzing data from spreadsheets. • Creating dashboards, reports and charts in Analytics tools. • Working on financial and other types of modeling projects. • Having knowledge Dashboard Creation, Mainframe automation through VBA. • Good Technical knowledge of VBAs, Macro, MS Office skills to drive automation opportunities. • Well-versed with dynamic loops, data extraction from images. • Work with users and team members at all levels for performance improvement and suggestions. • Understand and prepare Ad hoc reports. • Identify the opportunities of automating reports, snapshots and dashboard...

Build a PC application, Excel Macro / VC or python to send massive message via Whatsapp with a way to schedule the timing.

...dark blue/navy and gold colour scheme. I need this project to be completed within 2 business days. This newsletter is for a Global Investment Advisory firm and will be sent to professional investors. It's important that the design's aesthetic conveys a high level of sophistication and clarity. The newsletter should include: - Change in active allocations section - Actual allocations section - Macro analysis section The perfect freelancer for this job would have a strong understanding of modern and minimalistic design principles, a great eye for colour combinations, and professional typography skills. Previous experience designing newsletters for finance or investment firms would be an advantage. Their portfolio should display their ability to create clean, professi...

I'm seeking a proficient Excel expert to create a spreadsheet that calculates the future value of an annuity. This tool will be used for varying payment accumulation scenarios specifically: - Monthly payments - Annual payments -Can get an existing online template but customize to meet this project needs -NO VBA and NO Macro needed The payment periods for the annuity will span 10-50 periods. The spreadsheet should be intuitive, user-friendly, and accurate at determining future values. Ideal Skills and Experience: - Excel proficiency - Understanding of financial calculations - Previous experience in creating financial tools in Excel Please note, at this stage, no graphical representation like charts or graphs are needed for the calculation results. Attention to detail and a...

...will be calculated using the generated project attributes. The equation for NPV is given in the textbook, but you may also use Excel's built-in PV function:
worksheetfunction. PV(discountRate, lifetime, - cashFlow) - firstcost
Note that the cash flow should be negative when used in this function! 1. 2. Add VBA code to sort the generated projects by payback, NPV, and IRR. Use Excel's "record macro" function to generate VA code to perform a sort on the desired project attribute. After this code is generated, insert it into the indicated spot in your program and make the necessary adjustments so that projects are sorted within their years only. You do not want all projects across all years to be sorted! This sort will have to be repeated for all three sorting...

I need an Excel macro expert to incorporate functions in a grade spreadsheet template to enable automatic data filling in a summary worksheet from pre-filled worksheets (see attached screenshot). An ideal candidate would have extensive experience with Excel macros and functions, particularly index-match functions. This job will need completing within 2hrs from posting.

I'm in need of an Excel expert well versed with Excel 2016. The key tasks for this project entail: - Advanced data analysis: Ability to examine large datasets, draw meaningful conclusions and present data-driven insights in an accessible manner. - Formulas and calculations: Extensive knowledge in applying complex Excel formulas and calculations to analyze and interpret data. - Macro automation: Proficiency in creating and running Excel Macros for automating repetitive tasks, thereby increasing efficiency and accuracy. The suitable freelancer should have advanced level proficiency in Excel. Prior experience in handling similar tasks is a bonus. If you have excellent problem-solving skills and a knack for data interpretation, you'd be a perfect fit for this project.

I need a person that know VBA. In the attached file you'll find the TAB with input and the TAB with output I need the macro use data from input TAB to automatically generate info on TAB output. I will use output in another software so we have to respect the requested structure of data. If you are able to manage, please contact me

Goal setting - Set goals for agents - Add a whatsapp help chat on bottom right of the page Dashboard - Include AI - On the expired invoice page add a button to print ...than 60 bottles - Put a default expire date of 10 days for every new order. Then cancel it automatically if not transformed in invoice within 10 days. Price list - Need to add a fixed pdf page at the beginning. - Put better graphics and logo for each producer - Put date of print of the pdf in each page - Put a summary - Put a button to download our catalogue and also a link CRM - Add another macro section with these pages - Map (Add a map where an agent can see all clients) Client statistics - Show last time that a client ordered - Show the average days between each order of each client - Suggest client visits A...

I am seeking an Excel Macro Expert who can assist me with creating advanced custom formulas. The ideal candidate should have experience in developing complex formulas in Excel. This project does not have a strict deadline, as the timeframe is flexible. Skills and Experience Required: - Proficiency in Excel macros and VBA programming - Strong understanding of advanced formulas in Excel - Ability to automate data entry and generate reports using Excel macros - Attention to detail and ability to deliver accurate and efficient solutions

Project: We are developing a financial product inc...financial product including Europe's largest debt exchange and financial forecasting. Main job: - extending and updating the data set while meeting product targets - creating data flow diagrams Skills we are looking for: - Data Science, Big Data, Statistics, Business Analysis - Quantitative and qualitative research - Cartography&MapApps, Spatial data analytics. - Programming (Excel macro, Delphi, SPSS, Python (Jupiter Notebook)) - Statistical analysis - SPSS, Python, Excel. - Business analysis - Forecasts, ML, DSS, SEM. - Databases development (SQL, MySql, Access, VBA). - Data flows schemes Nice to have: - work with financial products nice to have - work with registry data nice to have - social and...

I'm in need of an experienced VBA specialist to create a macro for automating reporting tasks. This project involves: - Crafting a macro for reporting automation - Working with Excel files You would be manipulating multiple sets of data, sourced from Excel, and automating the process for maximum efficiency. Proficiency in VBA and a strong understanding of Excel are crucial for this task. A background in data manipulation and managing complex spreadsheets would be advantageous.

I'm seeking an Excel expert with proficiency in creating Macros. The main task for this project revolves around creating a Macro that will divide a report based on a Destination Zipcode, which has previously been chosen as the main parameter. Key Responsibilities: - Develop an Excel macro focusing on 'Address Information.' - If Destination Zipcode is unavailable, use Origin Zipcode; if both unavailable, label as 'Third Party.' - Further categorize the address information under Destination Zipcode based on the 'State/Province.' Ideal Skills and Experience: - Proficiency in Microsoft Excel - Prior experience working with macros - Understanding of postal codes, especially in the context of address information - Ability to categorize and or...

I need it urgently, Hi, I will share more details only selected candidate in via chat box. Thanks

I am looking for an expert in MS Excel to develop a special .csv file generator as per the attached BRD and .xlsx spreadsheet prototype. This tool will allow us to maintain static content in various locales inside our Magento 2 CMS. Skills and experience required: - Expert in MS Access VBA and Macro. - Advanced knowledge on the coding functions. - Ability to challenge or question the BRD in a constructive manner - Potentially propose functional amendment/solutions which serve the ultimate goal. - Ability to work with provided designs or suggest design recommendations - Strong communication skills to discuss additional features. - Ability to align with project lead and other developpers under the project. - Access to Trello Dashboard and MS TEAMS for collaboration purposes. The fo...

I am looking for an Excel specialist to help me with a project. If you have expertise in Excel and this sounds like something you can help with, please let me know.

I'm seeking a proficient freelancer with expertise in Excel macro development. The primary goal of the project is to automate the data entry for direct user input. Skills and Experience Required: - Advanced Excel skills, especially in creating macros - Experience in developing macros for data entry automation - Understanding and experience in handling direct user entered data This project will require you to create an Excel macro that will reduce the manual labor and speed up the process of entering data received directly from users. Please bid if you have a strong background in these skills.

I have one requirement in sas programming . We are attaching multiple files while sending email by calling sendmail_multiple_attachment macro. So I want to skip those file whichever is greater than 50 mb

I am looking for a VBA expert who can assist with automating tasks for my project. Specifically, I need help with automation pricing for my ecommerce website. Using Web Service calls for pricing to suppliers that I already have setup within Excel Macro. This needs to be optimized to go faster. I already have an existing VBA code that needs to be optimized. The timeline for this project is short-term, within a week. Ideal Skills and Experience: - Proficient in VBA programming - Strong understanding of automation techniques - Experience in optimizing VBA code - Ability to work within tight deadlines - Attention to detail and problem-solving skills.

I am interested in making a macro to see more clearly the information that I export from an app in Excel. It includes conditions, summations, not taking into account empty cells, sums of cells with the same color or content, and detailed content of fields.

I'm looking for a seasoned Excel macro expert who can minimize tedious tasks and streamline our processes by designing an automated system for sales report generation. The professional skills and experience required for this job include: - Exceptional knowledge in Excel macro construction - Proven experience in data analysis and visualization - Proficiency in creating automated systems for repetitive tasks - Ability to translate data into insightful reports Your core responsibility will be to build a macro that generates regular sales reports. The automation process should consequently free up time spent on repetitive tasks such as sorting and analyzing data. Please note that the specific elements to be included in the sales report will be discussed further u...

Please Sign Up or Login to see details.

I am looking for an Excel macro expert who can automate repetitive tasks for me. The tasks are moderately complex and I need the macro to be completed within a week. The specific tasks that need to be performed include populating data from one workbook to another. The ideal candidate should have strong skills in Excel macros and be able to create custom functions and formulas.

I'm in need of an expert in Excel macros to design and automate processes within financial analysis spreadsheets that I work with. The work would mainly involve: - Automating data analysis with specific focus on comparative data analysis. - Automating the calculation processes within the spreadsheet. A strong background in financial data analysis and proven experience with Excel macro programming will be crucial for this job. Understanding of financial ratios would be added advantages. The chosen freelancer should deliver a streamlined, automated system that reduces manual input and increases efficiency in our comparative financial analysis. This job requires a person with an eye for detail who can neatly implement instructions into the macros and provide clear guidelines on ...

I'm looking for a seasoned Excel macro expert who can minimize tedious tasks and streamline our processes by designing an automated system for sales report generation. The professional skills and experience required for this job include: - Exceptional knowledge in Excel macro construction - Proven experience in data analysis and visualization - Proficiency in creating automated systems for repetitive tasks - Ability to translate data into insightful reports Your core responsibility will be to build a macro that generates regular sales reports. The automation process should consequently free up time spent on repetitive tasks such as sorting and analyzing data. Please note that the specific elements to be included in the sales report will be discussed further u...