Macro jobs

I'm looking for an expert with proficiency in advanced Excel operations. The requirements include: • Mastery of Excel functionalities mainly formulas and calculations. • Comfort in dealing with complex operations without extensive guidance. • Having a knack for clear communication to provide occasional guidance as I am somewhat familiar with Excel macro and advanced automation. Prior experience in similar projects is desirable. Freelancers with good problem-solving abilities and an eagerness to assist with tasks will be highly valued. This task requires absolute precision and attention to detail in handling calculations and formulas.

I'm in need of a sophisticated macro tool built within the environment that enables manual initiation for downloading specific document types. This project is critical for streamlining my document acquisition process from various websites without the need for repetitive, manual efforts. The ideal candidate for this job would bring a strong background in automation, with specific experience in: - Designing and implementing macros within the platform - Handling document downloads, specifically formats like PDF and DOCX - Writing scripts that can interact with CSV files to dictate which documents to download - Operating within a Windows environment, ensuring compatibility and efficiency - Crafting user-initiated triggers that seamlessly start the download process This projec...

HI John u did some work on an excel macro for me a while ago- I would like to add a specific ' item number ' to the macro that you did- are you able to help and if so I will upload the excel macro. that you did for me- Thanks again Anthony

I'm looking for a professional who can use Chrome browser for web scraping and macro text insertion to find and purchase telephone numbers using a specifiic website. This project is aimed at optimizing our approach to locating and securing the right services for our needs. Summary To provide a new screen scraping program to look and feel like the existing one, to access a web site using the Chrome browser, login with a username and password (stored in a text file) and add some parameters such as a house number and postcode (stored in a text file) and then use numbers stored in a separate input txt file to search for these numbers and then work thorugh this list to buy numbers if available and allow the user to manually enter a call forward number and click [Submit] and then...

...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...

As a client, I need an experienced Visual Basic programmer for a unique project. I'm seeking to create a desktop application that excludes certain operations....software: * The software should be able to automate repetitive tasks. * A function to convert an excel sheet into a PDF, then have it sent to a specified email. Every sheet within the workbook is expected to have an email address. Desired Skills and Experience: * Strong knowledge and experience in Visual Basic. * Previous projects involving desktop application development. * Expertise in Excel macro automation and PDF generation. * Brilliant understanding of email sending functionalities. This job requires a detailed-oriented mindset and meticulous execution. Envisage a long-term relationship if the quality of wor...

I'm seeking a proficient developer to construct a programme centered around automation of specific tasks in intraday trading. This task-centric software should be capable of: - Executing repetitive assignments efficiently to streamline the trading process. A candidate with experience in not only progra...of intraday trading and financial markets would be ideal. A grasp of automation and its application in trading would be beneficial. This project requires an attention to detail and reliability. I look forward to working with a dedicated and knowledgeable freelancer. This is important - I am taking feed from agency in excel sheet ‘Nimble ‘ that need to fit in my logic in excel sheet . Basically Macro can do it . Data need to extract in excel sheet automatically aft...

I'm looking for a highly skilled Excel macro specialist to elevate my project to the next level with a focus on data entry automation, sophisticated formula and function integration, and detailed error management. The right freelancer will bring a blend of technical expertise, attention to detail, and problem-solving skills. **Key Tasks:** - Develop an Excel macro that automates data entry, reducing manual efforts. - Integrate complex formulas and functions to manage and analyze data seamlessly within Excel. - Implement an error handling mechanism that logs details of any unexpected inputs for later review, ensuring data integrity and accuracy. **Ideal Skills and Experience:** - Profound knowledge of Excel and VBA (Visual Basic for Applications). - Proven experience in...

...**Ideal Skills and Experience:** - Proficient in VBA, .NET Framework, or any relevant technology suitable for Excel add-in development. - Experience in developing subscription-based Softwares or SAAS (Software as a Service). - Strong background in creating Excel add-ins, with samples or a portfolio of similar projects. - Knowledge in automating tasks within Excel, including but not limited to macro creation, data processing, and workflow automation. - Understanding of Excel's back-end and API integration for a seamless user experience. - Excellent problem-solving skills and the ability to adapt to Excel's various versions' nuances. The perfect candidate would have a track record of developing productivity tools within the Microsoft Office Suite, especially Excel....

I have a project that requires a lot of data to be run through 3 calculator to create approximately 2000+ reports. By way of background: - Approximately 1200 schools have had their lighting upgraded. - Each school has approximately 50-100 "rooms". - Each room typically has 1 type of light, but may have multiple types of light. - I will shortly have a spreadsheet which contains approx. 120,000 rows of data. - Each line of data has approx. 10 variables - space name, floor area, wattage of lamps, use type etc. - I need the data for each school (~1200) to be run through the IPD Calculator, CLCT Calculator and EVI reports. - For each school, I require a stand alone Excel file with the data completed and the name of the school in the file name - for eg "IPD Report - Carlton Publi...

Dear, We need a macro script to Update, rebuild and maintain our CAD assemblies in our PDM Vault. The script will be run from SW PDM and through workflow The macro language is preffered in VBA but C is accepted The Macro scope is highlighted bellow, i will provide detailled requirement after our first contact. Best Regards, Macro Scope : This macro is mainly here to update, rebuild and make sure all our components settings and configuration are correct, from graphical properties, values of Custom properties, sheet template update, Unit and digit choice etc. Bellow are a list of actions to be performed with some details and screenshots of what we need. 1. **Rebuild and Configuration Management:* - **Automatic Rebuild for every configuration...

We need a macro script to be run in Solidworks PDM. The Macro script will be inserted as a Task in the PDM and will be run on Solidworks Parts of our Vault. The trigger will be either through Workflows or through user input, this is configured in PDM. VBA is preffered for the language but C can be considered if more efficient here The macro need to do the following : -Check OUT ( with admin credentials) -Edit the Weldement features(scan the part from multiple if needed) exisiting inside the part to update it s Cut List Properties ( need to run for all configuration as As machined and As Welded configurations are created) ( The Weldment profiles of the library have seen their Custom Properties updated, we need to update all the project parts using these weldmeent...

Modify macro to include more data

-Urgent- Let us know if you are available today I need a VBA Macro code to create a Quantity calculation function for our Bill Of Material. The problem is rather simple, we have list of Components in a hierarchized structure, the structure is expressed with a Level column formatted like 1.1.2 or 1.2.12 etc. We need the ability to calculate the total quantity of each child of the structure based on it’s level and parent quantity. This means we need a CumulQty column for the level 1.x, but also a column for the CumulQty for the Level 1.x.x and 1.x.x.x The solution can be done in Excel (VBA) , through Power Pivot or through Access. Regardless, we need a CumulQty Column for each level to be created in our structure. BOM example : Level Flat Level VER_ID Qty 1 1 Vpr-100054...

...who can create a comprehensive macro for my unique needs. I want a macro specifically targeting leave tracking for employees. This macro will be responsible for automating several tasks: - Data Entry: Ensuring seamless input of employee names, leave balances, and leave types into our system. - Data Analysis: Reviewing, assessing, and interpreting the entered information. - Formatting: Making sure the data is always well-organized and easy to understand. Our spreadsheet will function as an employee leave tracker, monitoring a few key points: - Employee names: We need to attach the relevant leave data to particular individuals. - Leave balance: It's imperative that the system tracks the number of leave days remaining for each employee. - Leave types: The ...

I'm seeking an experienced professional capable of converting a 32bit Microsoft Word macro to 64bit. Understanding the potential challenges of this conversion and having relevant experience are fundamentally important. Ideal Skills and Experience: - Extensive experience with MS word macros - Proven track record of successful conversion from 32bit to 64bit - Deep understanding of Microsoft Word functionalities and capabilities - Prior work that is relevant to the current project

...on the hunt for a proficient freelancer who can help me convert an intermediate level MATLAB project into VBA macro for excel. I haven't begin the conversion process myself, so you would be starting from scratch, thus requiring meticulous work and accuracy. You need to have matlab kr octive to execute this project. KEY RESPONSIBILITIES: . To be specific I need a excel vba macro which has same functionality of system_03_part_2.m along with all the supporting files. The outcome is a vba code which shows exactly same results as matlab code. You are welcome to use chatGPT but manual work is required to make it work. • Accurate conversion of existing MATLAB scripts to excel vba macro. • Maintaining original functionality throughout the conversion process...

I am in urgent need of a specialist to automate important tasks in Excel. Here's what I'm looking for: - Develop a robust Excel macro that streamlines repetitive tasks. - Should be capable of handling various automation without manual input. - Quick turnaround is crucial, availability to start immediately is preferred. Ideal Skills: - Proven Excel VBA expertise - Strong problem-solving skills - Excellent communication and fast delivery Experience Needed: - Previous experience with creating automated systems in Excel - Portfolio showcasing efficiency improvements - References or testimonials from past clients Your prompt response would be greatly appreciated, as immediate commencement is key for this project.

Replicate Power Query with a macro and add a couple of steps as discussed.

I'm seeking a talented freelance Excel expert to create a macro that simplifies my sales reporting process. Here’s what I need: - Macro creation for automated sales reporting - Analyze and report daily sales transactions - Develop pie charts to visualize sales data by product category The ideal candidate should have: - Profound expertise in Excel macro development - Strong experience in data analysis and visualization - Ability to create intuitive and dynamic pie charts - Keen understanding of sales reporting processes - Excellent attention to detail and accuracy If you possess these skills, I would love to see your bid for this project!

Please Sign Up or Login to see details.

i want a short academic report for my economy class ( 1500 words minimum) on a docx format, the topic should be related to the economy of Saudi Arabia. I want it tomorrow before 1 pm 05/02/2024 Saudi time +3 my university is Here's what I'm looking for in a freelancer: - Proficiency in Economic Theories: A deep understanding of both macro and microeconomic principles. - Research Skills: Ability to conduct thorough research using credible sources. - Analytical Abilities: Can analyze economic data and provide insights. - Writing Expertise: Strong writing skills with the ability to explain complex concepts clearly. - Timeliness: Must meet a tight deadline without compromising on quality. - Original Content: Must ensure the report is plagiarism-free. Successful completion

Seeking a data-driven Excel wizard to create a dynamic and visually impactful dashboard, tailored to efficiently track and analyze my company's project risk metrics. Your expertise will transform how we digest crucial data. Using the attached EXCEL file as a source. Please also include any extra ideas and suggestions to improve it's operation. Including the possibility of a macro to simplify data entry. **Core Objectives:** - Custom dashboard for data analysis and tracking progress of project risk - Visualize risk metrics including project impact analysis. **Data Integration:** - Sync with spreadsheet **Key Deliverables:** - Interactive, user-friendly dashboard design - Real-time visualization of key performance indicators (KPIs) - Simplified reporting tools for n...

I'm looking for a skilled freelancer to create a VBA macro that efficiently create a z-scores matrix of spread daily changes. The data comes from a sql query and are organised in dynamic arrays (horizontal and vertical). Macro needs to find the correct length of array, calculate every possibile combination between 2 columns, compute daily changes, populate a matrix of daily changes zscore for the period and formatting the results by using graded color scale as backgroud. Outputs the results into a new Excel workbook. Ideal candidate will have: - Strong proficiency in VBA and Excel - Experience with statistical functions - Knowledge of error handling in macros - Ability to deliver clean, commented code Looking forward to finding the right expert to help streamline ...

I'm in need of a highly skilled excel macro handler capable of handling complex formulas and data. This role involves creating a program where we will upload excel files consistently formatted in their structure. This program must be designed to extract data from entire sheets and apply predetermined complex formulas to this data. It will then need to generate an output file with the results. If you're an expert with excel macros and have a solid understanding of working with complex data, this project is for you. Ideal skills would include: - Expert knowledge of Excel macros - Knowledge of complex formulas - Strong understanding and experience with data extraction from Excel files. - Experience in generating output files from input data. Please provide examples of simi...

...Excel macro developer to automate my business's workflow and order monitoring system. My aim is to streamline efficiency and maintain comprehensive oversight by implementing a dynamic tracking solution. - Key Requirements: - Develop macros for workflow management. - Create a system to manage order status updates. - Automate report generation and formatting. - Desired Workflow Features: - Task assignment automation. - Approval processes integration. - Document tracking and notifications. - Essential Order Tracking Elements: - Capture and display order numbers. - Record and track order dates. - Reflect current status (e.g., in progress, completed). - Incorporate customer names as a reference. - Ideal Candidate: - Proficient in advanced Excel feature...

I'm searching for an Excel virtuoso who can craft a macro to streamline my reporting workflow. I have heaps of raw data and need the macro to transform this into well-organized tables in a report format. Here's what's essential: - Develop a user-friendly macro to format raw data. - Create easy-to-read tables for the final report. - Incorporate prompts for manual review if data deviates from the expected format. Ideal Candidate: - Expert in Excel VBA and macro creation. - Strong grasp of data presentation in Excel. - Detail-oriented with a knack for identifying data inconsistencies. - Problem-solving mindset with the ability to create intuitive prompts for manual data review. - Great communication skills to understand and implement specific requi...

I require a highly-skilled VBA macro developer to write a custom script for PowerPoint 2016. My primary need is for this macro to reference slide numbers within a text-box. To elaborate: - The macro needs to automatically update the referenced slide number whenever slides are added or deleted. - It should function seamlessly within PowerPoint 2016 Windows & Mac An ideal freelancer for this project would be proficient in Microsoft Office Suite, particularly PowerPoint, and have extensive knowledge and experience in programming VBA macros. This expertise will be critical in ensuring the macro functions as intended, improving the efficiency and accuracy of my PowerPoint presentation flow.

...create a custom macro focused on data automation. My main objective is to automatically generate performance metrics reports. This task would require proficient Excel skills, specifically with macros, with a strong understanding of VBA. This Excel macro will significantly streamline report generation, so timeliness and reliability are paramount. I will be using this macro with very large files. If you possess the right skills and experience, I'd be thrilled to discuss this project with you further. Take a look at this existing macro: There will be an initial Excel file similar to the file in the example above....but very large. I need 2 macros: One macro that adds a sheet

Hi Milan S., I noticed your profile and would like to offer you my project. We can discuss any details over chat.

I'm searching for an Excel virtuoso who can craft a macro to streamline my reporting workflow. I have heaps of raw data and need the macro to transform this into well-organized tables in a report format. Here's what's essential: - Develop a user-friendly macro to format raw data. - Create easy-to-read tables for the final report. - Incorporate prompts for manual review if data deviates from the expected format. Ideal Candidate: - Expert in Excel VBA and macro creation. - Strong grasp of data presentation in Excel. - Detail-oriented with a knack for identifying data inconsistencies. - Problem-solving mindset with the ability to create intuitive prompts for manual data review. - Great communication skills to understand and implement specific requi...

I'm seeking an expert to develop a macro that efficiently extracts specific data from government websites. Initially, the macro will target Florida and California for public records related to businesses. Key Requirements: - Extract filed business records, including company name and address, EIN, and years in operation. - Save data in a structured format, suitable for PDF creation via Adobe Acrobat. - Ensure accuracy and reliability of the scraped data. - Design the macro with scalability in mind for potential future expansion to other states. Ideal Skills: - Proficiency in data scraping techniques and tools. - Experience with macro creation, especially for PDFs in Adobe Acrobat. - Strong understanding of handling public records data. - Ability to impleme...

I'm in need of a highly skilled excel macro handler capable of handling complex formulas and data. This role involves creating a program where we will upload excel files consistently formatted in their structure. This program must be designed to extract data from entire sheets and apply predetermined complex formulas to this data. It will then need to generate an output file with the results. If you're an expert with excel macros and have a solid understanding of working with complex data, this project is for you. Ideal skills would include: - Expert knowledge of Excel macros - Knowledge of complex formulas - Strong understanding and experience with data extraction from Excel files. - Experience in generating output files from input data. Please provide examples of simi...

I'm in need of an Excel specialist who can accurately and diligently handle the development of a macro that streamlines my data analysis process. Project Overview: This project is to help automate the compiling of two separate spreadsheets into one and adding minor formatting and analysis to the combined audit spreadsheet. We do this step for 7 different locations, thus in total there are 14 near identical spreadsheets which are combined into 7 final output files. This includes: - Consolidating two Excel spreadsheets into one composite document. Mastery of Excel is mandatory for this task. - Handling comparative data analysis on the combined spreadsheet. Past experience with analyzing data trends and making comparisons is crucial. - Further enhancing the readability of this...

I'm in need of an Excel specialist who can accurately and diligently handle the development of a macro that streamlines my data analysis process. Project Overview: This project is to help automate the compiling of two separate spreadsheets into one and adding minor formatting and analysis to the combined audit spreadsheet. We do this step for 7 different locations, thus in total there are 14 near identical spreadsheets which are combined into 7 final output files. This includes: - Consolidating two Excel spreadsheets into one composite document. Mastery of Excel is mandatory for this task. - Handling comparative data analysis on the combined spreadsheet. Past experience with analyzing data trends and making comparisons is crucial. - Further enhancing the readability of this...

I am seeking a specialist to develop an Excel macro that expedites and streamlines my data utilization needs. OVERVIEW: This project is to help automate the compiling of two separate spreadsheet types into one and adding minor formatting and analysis to the combined spreadsheet. This analysis is done to determine which locations > days > or cashiers are having the most sales adjustments. High sales adjustments like voided transactions, line cancellations, or discounts indicate that a cashier may be making errors or possibly stealing. This report is used by management to investigate said locations, days, or cashiers which are causing the high adjustments. The macro must be able to perform the following tasks: - Carry out calculations and formula automation. - Perform...

I'm seeking a skilled developer to create a macro that automates data extraction specifically from the Sunbiz website. Here's what I need: - A macro that targets - Must extract the following for a single company: - Name - Address - EIN number - Years filed with the state Ideal Freelancer Qualifications: - Proficiency in data extraction and web scraping - Familiarity with automation macro creation - Ability to format extracted data into a PDF - Experience with scripting languages such as Python or JavaScript This project demands attention to detail and a knack for precision, as the data extracted will be used for official purposes. The macro should be robust, secure, and reliable to ensure accurate data handling.

I have an excel table and a word document. I'm Italian so my files contains words in italian language. I want the contents of some cells to be copied into a new word file based on my template and automatically this word file is also exported to pdf. This has to work row by row. I mean that in sheet 1 of Excel there mus...of column S red: if the value of the cell is "avvio" or "avvio in nuova azienda", in the word file, corresponding to the placeholder "#avvio/proroga" the word "inizierà" must appear. If the cell value is "proroga" "proseguirà" must appear in the "#avvio/proroga" placeholder. As you can see from the attached Excel file I have already tried to write a macro which unfortunately doe...

I have an excel table and a word document. I want the contents of some cells to be copied into a new word file based on my template and automatically this word file is also exported to pdf. This has to work row by row. I mean that in sheet 1 of Excel there must be a button that brings up a window that allows you to cho...of column S red: if the value of the cell is "avvio" or "avvio in nuova azienda", in the word file, corresponding to the placeholder "#avvio/proroga" the word "inizierà" must appear. If the cell value is "proroga" "proseguirà" must appear in the "#avvio/proroga" placeholder. As you can see from the attached Excel file I have already tried to write a macro which unfortunately doesn�...

Hello, for our group of customers we need to create Excel template which will enable them to order our goods. We chose this method of ordering because the customer needs the solution by the end of this week and also that they are used to ordering via Excel template. The excel will contain macro which will control minimum order quantity and other conditions and if fulfilled, will enable to click on button which will create the output file (xml or csv). **IMPORTANT** We need the solution by the end of this week. Details in the attachment - pls. view it before asking questions. Thank you

I am looking for excel macro expert who could deliver a tool for creating a supply plan and a production plan based on demand input, current inventory and safety stock targets and production line capacity constraints.

I'm seeking a talented individual who can transform my vision of an Excel dashboard into reality. Thi...automatically retrieve data from Azure Release Pipelines. - Implementation of error notifications and alerts to promptly address issues. - Integration of VBA code to approve release pipelines efficiently. - Adherence to our company's branding guidelines for a cohesive aesthetic. Ideal Freelancer Qualities: - Proven experience with Excel dashboard creation. - Strong knowledge of VBA and macro programming. - Familiarity with Azure services and their APIs. - Aesthetic sensitivity to match our brand's design ethos. - Ability to communicate clearly and deliver within deadlines. Looking forward to collaborating with someone who shares my passion for efficien...

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...