Macro jobs

I'm looking for an experienced VBA developer to create a macro that can compare two worksheets within Excel and output the differences into a separate Excel file. Detailed requirements: - The macro should automate this repetitive task and be able to handle large data sets. - The comparison results should be exported into a separate Excel file. Skills and experiences: - Advanced knowledge in Excel and VBA Coding - Adept at handling large datasets - Previous experience with similar projects is a plus The completion of the project is urgent, so I'm looking for a freelancer who can start as soon as possible. Appreciate your interest and look forward to your proposals.

...content editing services. Here's what I need: - Editing and macro clean up of header, footer, table of contents and copy throughout - Installing section breaks where necessary and adding/deleting pages - copy and content editing - Editing macros for streamlined usage If you do a good job on the immediate task, I have a document library of about 20 other documents I need help with. Project ranges from creating documents from scratch using brand guide (graphic design work) and tweaking/editing already created word templates that have design issues. Since this project is urgent, I'm looking for someone who can start this assignment ASAP. Prior experience in graphic design with specific and expertise in Word template design, macro editing and content editing is e...

I need assistance in translating VBA code from a Windows version of Excel to the Mac version. The specifics are as follows: Excel Version - I am using Excel version 16.82 on my Mac. VBA Code Features - The Windows version uses worksheet formulas, conditional formatting, and data validation features. Compatibility Requirements - In the Mac version, I would love to ensure compatibility with a macro-enabled workbook, ActiveX controls, and external data sources. Ideal Skills and Experience - Excel Skilled, in-depth knowledge of VBA coding, especially in Microsoft Excel version 16.82 for Mac. - Previous experience in translating Excel VBA code between different operating systems. - Familiarity with macros, ActiveX controls, and working with external data sources is a must. The VBA ...

...primary duty of producing weekly research reports. NOT NEWS ARTICLES. As you now - macro's and narratives drive crypto. Tokens with high quality fundamentals in those macro narratives are the best performers. You must understand this, be able to find and research this, provide this in a well written research report. We are looking for someone who can produce deep dives or in-depth, highly researched reports with technical understanding. Covering important statistics, numbers, fundamentals, alpha, "out of the box" ideas and an understanding of what drives valuations and token prices. Additionally, you should know what key macro narratives are driving the markets, stay on top of this and want to find new emerging narratives or trends (be early). The in-...

Hi Hritik D. Please create macro that deletes header and rows required (also copies column A). Then prompts user to save as CSV. Will send example of original and complete file

I'm in need of an Excel VBA macro specialist to create a simple but effective tool for managing my CSV files. The main functions required for this macro are: - Delete specific rows and columns based on their index. I will specify which indexes to eliminate. - Automatically saving the updated file post deletion. The ideal candidate should have a strong know-how in VBA/macros and a distinct ability in solving problems with Excel. Someone who has a keen eye for details will be a good fit, as accuracy in eliminating the correct rows and columns is paramount. Please be ready to provide samples of previous macros you've created, specifically those that deal with CSV files. This insight into your past work will allow me to ensure you're the right fit for this proj...

I'm in need of a savvy and experienced freelancer conversant ...complex tasks such as: - Data analysis: I require help in analyzing a large dataset of over 100,000 rows. - Spreadsheet formatting: The vast data requires proper and neat arrangement for easy interpretation and understanding. - Macro development: To handle such extensive data, automated tasks need to be established. - VBA: Ideally, I would like to incorporate Visual Basic for Applications (VBA) for advanced manipulation of data and improved macro performance. So, if you're a pro in Excel, proficient particularly in data analysis, spreadsheet formatting, macro development, and VBA, you're just the one I need for this project. Your ability to handle bulky data will be a plus. Convince me ...

Column AY (PO) - XLOOKUP “Entries Invoice Lines Report“. If shipment number (column A) match with column F (job number) of “Entries Invoice Lines Report, pull the value from “Column H”. If the shipment number matches in different rows and invoice number “Column H” has different value, then pull the invoice numbers like invoice1, invoice2.

The macro is supposed to look up the item number and put everything with that part number in the Xref sheet into the green column in a table format and the same for the vehcil listing in the yellow colum.

Import file and compare (macro)

I'm in need of an Excel whizz who possesses a strong understanding of macros and familiarity with sales data to help me automate my report generation. The project requires: - Building a macro code that takes and copies weekly sales data from different salesperson sheet and pastes to a main sheet within a click of a button - Ensuring the macro works consistently and error-free - The final report should be in the format of an Excel spreadsheet, displaying insights in an organized manner in a dashboard Ideal candidate should have: - Proven experience with Excel macros - Knowledge of sales data and how to present its details in a comprehensive manner - Attention to detail and accuracy.

I require a proficient Excel macro designer to automate data calculations. This will maximize efficiency across my entire worksheet, eliminating the need for manual calculations. - Must possess expertise in search option inclusion, enabling the macro to locate data without restriction. - Superior knowledge in Excel macro creation is highly preferred. Experience with large data sets and competency in data management will be beneficial for this project. Ultimately, I am searching for a professional who can deliver a robust automated system for my data calculations within Excel.

I’m looking to transition my dynamic and functional macro-based Excel file into a sellable product. My file primarily focuses on simplifying tasks and automating them for efficiency. I wish to develop an application that potential users can access on both Windows and Web platforms. Crucial features for this application include: * User authentication: This is paramount to ensure only legitimate and paid users can access the services. * Subscription management: A built-in system to manage both monthly and annual subscriptions. * File encryption: This feature is necessary to secure the functionality of the application and prevent unauthorized usage or manipulation. Given these specifications, expert skills in application development and understanding of subscription-based mo...

I'm facing a challenge with my excel macro not functioning as expected. The specific issue I'm experiencing is the macro just not working anymore. What I need: * A seasoned Excel specialist to debug and repair the faulty macro. Ideal Skills: * Solid experience and expertise with Excel; past experience debugging and repairing macros would be beneficial. * Good problem-solving skills; the exact purpose of the macro was not documented. * Any experience automating common tasks, performing data analysis, or cleaning and organizing data could be relevant, as these are typical macro functions. Applying: * When applying, please briefly detail your prior experience with Excel macro repair, as well as any ideas you may have as to what might be c...

Hola, necesito la macro para hacer esto: - Activador -> Contenido de la pantalla (use expresiones regulares para obtener texto) - Acciones -> Leer el contenido de la pantalla y guardarlo en el diccionario -> Establecer variable con valor de viaje -> Establecer variables de embarque y kilometraje de viaje - > Establecer variable con el valor del recorrido dividido por el kilometraje total -> Mostrar ventana emergente con el resultado de cuánto ganaré por km recorrido en esa carrera -> Tomar captura de pantalla. La macro tiene que funcionar leyendo el contenido de la pantalla en todas las situaciones, cuando la aplicación Uber Driver está abierta en primer plano y con la ventana emergente. Puede utilizar el [iniciar sesión...

I'm currently seeking a capable freelancer who is skilled in creating Google Sheets Macros for a timely project. Your task will include developing a Macro that sends email notifications through Gmail based on the date in a particular row of a Google Sheet. The email notification should be sent only when the cell value of the row matches today's date. Ideal Skills: - Proficiency in Google Sheets Macros - Strong knowledge of Gmail API for sending emails - Experience with scripts related to date-driven triggers Please note, completion of the project is needed as soon as possible. I am looking for serious bidders who can deliver within a tight timeframe. Your proven experience and ability to deliver promptly will be a definitive factor in the selection process. Bidders...

I'm looking for an experienced WordPress developer to create a recip...WordPress developer to create a recipe website that features a members-only access. Key tasks include: - Incorporating an extensive variety of recipe categories, exceeding 10 in total. - Building members-only access functionality. This should contain: 1. An exclusive recipe section 2. Member forums for interaction 3. Personalized recipe collections feature 4, Seo implementation. 5. Calorie macro counter and menu - Implementing a feature that permits members to add their own recipes with prior review and approval mechanism. Beneficial Skills: - Expertise in WordPress design and development - Experience with membership sites - Understanding of recipe websites - Familiarity with a review and ap...

I have a fully operational VB based M6 macro script for Mach3 which I'm looking to convert into a Lua based M6 macro script for Mach4. This project needs to be completed within a month. Here are the skills and experience you'll need for the job: - Expertise in both VB and Lua scripting - Experience with Mach3 and Mach4 - Proficiency in Windows operating systems - An understanding of data manipulation, user interface interaction, and hardware control is a plus Even though I've skipped the question about specifics functions of the VB script to be present in the Lua script, I would like everything in the VB script to function similarly in the Lua script once converted. The OS being used for Mach4 will be Windows.

...system which voters need to verify and confirm. 6. Voters will need to confirm again the artiste selected. 7. On confirmation, system will generate a "Thank You" message. 8. Voters will signed out. 9. Next voter will sign in at Step 3 above. 10. Organiser will restrict the number of votes based on same IP address identified. Requirements : 1. Create a Macro (Excel VBA) to auto the voting process; 2. Macro (VBA) to bypass or validate the OTP email if required; 3. Marco to bypass the "I am Not A Robot" or "Captcha" created by system. 4. Marco to bypass the restriction on numbers of votes based on same IP address. 5. To create another Marco to bypass requirements serial number 3 where only one account will be given unlimi...

I need a skilled expert in Excel VBA and macros, who can design a comprehensive operational data dashboard for me. The dashboard will focus on presenting data through interactive charts and graphs, also demonstrating robust data filtering and sorting capabilities. Key Responsibilities: - Design an efficient and visually appealing KPI dashboard for monthly reporting. - Create dynamic and interactive charts and graphs to accurately represent the data. - Implement functionalities for effective data filtering and sorting. Ideal candidate should have: - Proficiency in Excel Macros/VBA with advanced knowledge of dashboard design. - Experience handling operational data and transforming it into meaningful visualizations. - A keen eye for detail, accuracy and design aesthetics. This project re...

I am looking for a professional with solid Microsoft Excel skills to recreate an Excel page for my training guide. The job involves: - Organizing text-based content on to the Excel sheet. - Arranging the information by categories/subjects. The ideal freelancer for this project would have a strong understanding of...involves: - Organizing text-based content on to the Excel sheet. - Arranging the information by categories/subjects. The ideal freelancer for this project would have a strong understanding of Excel and be meticulous about accuracy and organization. Experience in crafting Excel-based training guides would be a bonus. This project does not require formulas, calculations, data validation, sorting, or macro automation. It’s purely about creating an organized, user-f...

I'm seeking a proficient Eplan specialist who can tailor-make my project's needs by developing specific electrical symbols and macros. Additionally, your expertise will refurbish template layouts, adding designated design structures to suit our project demands. Key Requirements: - Expertise in Eplan software - Proven experience in customizing Eplan templates - Strong capabilities in crafting electrical symbols and macros - A discerning eye for layout adjustments and the incorporation of specific design elements. Your active engagement and professional insights will contribute significantly to the advancement of our project, hence, a strong understanding of these functions is immensely crucial.

Hi Indra P., as discussed in our chat, need to create VBA macro to automate style application into a new docx

Need a simple macro script to show me missing numbers. Custom range. lets say between 1-80. Need to add a column of numbers. as an example. 60,20,51,50,26,40,8,33,55,41 71,24,12,75,80,45,63,44,5,54 24,65,19,55,1,59,36,29,51,25 43,21,31,8,46,7,52,29,12,55 9,17,53,64,69,52,43,51,72,22 3,20,26,30,39,42,49,56,61,66 The result should be displayed like this. All the missing numbers separated by a comma on one single line. 2,4,6,10,11,13,14,15,16,18,23,27,28,32,34,35,37,38,47,48,57,58,62,67,68,70,73,74,76,77,78,79

I'm seeking an experienced freelancer proficient in Jitbit Macro Recorder for a specific project focused on automating web navigation tasks within a Windows environment. **Core Requirements:** - In-depth knowledge of Jitbit Macro Recorder. - Strong background in automating tasks on Windows OS. - Experience with web navigation automation, particularly simple navigation and clicks. **Project Tasks:** -Auto clicker - Automate a series of web navigation routines to streamline repetitive browsing activities. - Ensure the automation is reliable and can handle typical web navigation tasks without constant supervision. **Ideal Skills and Experience:** - Proficiency in scripting for automation. - Previous experience with web-based automation projects. - Ability to troublesho...

...should work is that in the "G" column we have a link to the person, and in the "H" column there is a message attached to the invitation. And when I change the I column to "YES", the invitation is to be sent with this message. 2. I would like LinkedIn to return information whether a given person has accepted my invitation (you can also check whether we are currently friends). You can set a button (macro?) to check all rows. It doesn't have to be in real time. And the current status should be returned in the "J" column. 3. The last step is to send the message normally via LinkedIn (not with an invitation). The message is in field K, and if I mark "YES" in the L column, this message should be sent via LinkedIn to the contact in ...

Macro-enabled file as per instructions already received in Doc file.

Develop formula + macro to update column C

...of a well-structured Excel macro that will be responsible for manipulating my sheet's data. Specifically, the macro will focus on the task of data sorting. Here's the set of tasks that I'd like the macro to perform: - Data sorting based on respective values, systematically reordering the data to suit my specific requirements. The ideal freelancer for this project would have strong competency in Excel macros and VBA, with a proven track-record in executing data sorting through these means. An understanding of different data types and their unique behaviors is also important. Machine learning knowledge would be an added bonus, but not a must-have. I look forward to working with someone who has a strong eye for detail and organized code formatting to e...

...up. I am in dire need of a proficient Excel developer who can tackle a variety of tasks to enhance the functionality of my spreadsheets. My aim is threefold: 1. **Sophisticated Formulas and Functions** - Though I skipped detailing specific formulas or functions, my project will require in-depth knowledge and application of a wide range. Expertise in advanced functions is a must. 2. **VBA Macro Programming for Automation** - My primary focus here is on three critical areas: - **Data Entry Automation**: Streamlining the process of inputting information into the spreadsheet. - **Report Generation**: Crafting macros that can automatically generate comprehensive reports from the data. - **Data Validation and Cleaning**: Developing macros that will clean and va...

I'm seeking a skilled freelancer experienced in Excel VBA and, specifically, in doing macros. The task will involve developing a macro to manage crowded data labels in a Line chart and addressing a few automation related to a line chart in Excel.

I'm seeking a freelancer with a strong background in Excel VBA and payroll systems to update my payroll macro file crucially. This project involves enhancing the calculation formulas to adhere to the California prevailing wage requirements which are intricate and multifaceted. We already have a macro file that take timesheet and calculates regular pay/OT vs DBT per CA law **Key Updates Required:** - **Modification of Calculation Formulas:** The updates will specifically include adjustments to incorporate: - Different hourly wage rates. - Fringe benefits calculations. - Varied rates per job classifications. - Distinct holiday pay rates per job type. - Overtime (OT) calculation enhancements. **Ideal Skills and Experience:** - Proficiency in Excel ...

I'm looking for a talented developer to transform an existing Excel VBA macro, which is primarily focused on data manipulation, into a LibreOffice Calc macro. This macro is of intermediate complexity, incorporating loops and conditionals to analyse and manipulate data. Besides replicating the current functionalities, I also wish to introduce new features to enhance its capabilities. **Key Requirements:** - Strong experience in both Excel VBA and LibreOffice Calc macro development - Ability to understand and translate complex macro logic - Creative thinking to introduce new functionalities effectively - Proficiency in data manipulation and analysis **Project Goals:** - **Replication:** Accurately convert the existing macro from Excel VBA to L...

...should work is that in the "G" column we have a link to the person, and in the "H" column there is a message attached to the invitation. And when I change the I column to "YES", the invitation is to be sent with this message. 2. I would like LinkedIn to return information whether a given person has accepted my invitation (you can also check whether we are currently friends). You can set a button (macro?) to check all rows. It doesn't have to be in real time. And the current status should be returned in the "J" column. 3. The last step is to send the message normally via LinkedIn (not with an invitation). The message is in field K, and if I mark "YES" in the L column, this message should be sent via LinkedIn to the contact in ...

I'm seeking a freelancer with expertise in Microsoft Excel automation to develop a comprehensive solution for categorizing clients into low, medium, and high risk categories. The determination of the risk levels will be based on a variety of factors, including jurisdiction, industry, and media checks. This project will not only streamline our existing processes but significantly enhance our risk evaluation capabilities. **Scope of Work:** - Develop custom functions or macros in Microsoft Excel. - Automate the process of evaluating client risk based on predefined criteria (jurisdiction, industry, media checks). - Organize data efficiently to facilitate easy analysis and reporting. **Ideal Skills and Experience:** - Proficiency in Microsoft Excel, particularly in writing macros and cu...

...attached As I add additional "date: worksheets I want it to automatically flow into Email Worksheet tab. It can be either by a macro button or a formula. But needs to automatically add the data as I create new worksheets and add data. I'm seeking an experienced Excel professional to develop a macro or formula-based system to significantly enhance our data management and reporting processes. Our goal is to automate entry from existing Excel spreadsheets and to generate comprehensive reports on a daily basis. This system will serve as a critical tool for decision-making and operational efficiency within our organization. **Key Requirements:** - Develop a macro or utilize Excel formulas to automate data entry tasks, pulling information directly from our c...

I'm on the lookout for a strong Excel VBA developer to assist in several upcoming projects. **Ideal Skills & Experience:** - Proven expertise in Excel VBA development, specifically in Automation and Macro creation. - Strong understanding of data analysis principles that complement automation efforts. - Ability to not only execute tasks but also provide strategic recommendations for process improvements. **Responsibilities:** - Develop and implement custom macros to automate repetitive tasks, ensuring both accuracy and efficiency are improved. - Collaborate closely with our team to understand process bottlenecks and devise VBA-based solutions to address them. - Provide insights and suggestions on how to best leverage Excel VBA functionalities to meet our project objectives...

...values. Ironically the device data exists in a spread sheet before the start of the drawing. We want to create these pages with the least amount of work, our initial thoughts are as the devices macro is inserted the pages are also inserted with the default layout and then we tweak those few non standard pages/devices We seek help in a 3 phase approach 1) Review existing database and drawings and advise best approach going forward, (maybe macro or script, it is open) 2) Modify existing 2 drive example project to the design determined in 1 above 3) Assist our electrical engineer to make a similar macro for a similar. (training)...

...mailmerge and further use power automate to apply a macro to all papers generated through mailmerge. Task 1. From excel sheet generate a set of veterinary case-papers. The task is mostly done. It requires that certain section of each of the 1000s of pages is selected and then a macro is invoked to change the font of that particular selection. Task 2 Friom Excel Sheet create mailmerge sheets but It should pick up data only of certain date and mail-merge it with the form example all entries of 12/1/2014 should be mailmerged on the form and data of no other date should appear on the form. And a total number of entries with male and female should be auto populated in the appropriate colums. After the forms are generated with mailmerge. The macro of ctrl-alt-s shoul...

i need the macro coder needed for multiple jobs. Details will be discussed.

...to update live when I change numbers in each of the columns. This must be done in a script format so that as I change number, the calculations update (or a button is pressed to update the calculations). This should take a programmer about 1 hour to script. - **Custom Formulas**: Crafting formulas tailored to manipulate numerical data, ensuring calculations are streamlined and precise. - **Macro Development**: Building powerful, automated macros to process dates and numbers, enhancing efficiency and reliability. **Data Types**: - Our primary focus will be on enhancing the handling and manipulation of numerical data and dates, ensuring a seamless workflow. **Timeline**: The project needs completion within a month, demanding a dedicated and efficient approach. **Ideal Skill...

As a client seeking a reliable professional, my focus is on finding someone with intermediate level experience in macro programming. The exact daily tasks will be discussed at further length, though the freelancer should be prepared to handle routine operations, potentially including data entry, report generation, and data analysis. Preferred applications will include: - Detailed accounts of past experience in performing macro tasks of varying natures - Proof of intermediate level expertise in macro programming This project represents an opportunity for regular work and a potentially long-term relationship for the freelancer able to demonstrate the appropriate commitment to quality and timeliness.

More details: What is the main issue you are facing with your current workflow? Time-consuming process, fear VBA Word Mac will not continue to be supported, seems buggy Which platform do you prefer for the new solution? Mac Desktop application Do you require the new solution to automatically format the text and photos according to a specific set of rules? Yes Aspose looks interesting to me if anyone has experience with it.

...AI-powered Nutrition Analyzer catering to fitness enthusiasts. This software should be not only cutting-edge but also user-friendly, translating complex information into understandable insights. Key features should include: * Meal tracking: It should facilitate logging and monitoring of food intake. * Calorie calculation: The ability to estimate caloric value of the Client's meals is necessary. * Macro nutrient analysis: Should evaluate the breakdown of proteins, carbs, and fats in the Client's meals. Deployment should be on: * Web and Desktop platforms. As for appearance, I'm envisioning a modern and sleek design that maintains professionalism while being attractive to users. The ideal candidate for this opportunity has a strong working knowledge of AI a...

...would come back to Sheet 2 and be displayed in the same column under where the data was entered (B12-B15, C12-C15, etc). I'd like the results to update live when I change numbers in each of the columns. This should take a programmer about 1 hour to script. - **Custom Formulas**: Crafting formulas tailored to manipulate numerical data, ensuring calculations are streamlined and precise. - **Macro Development**: Building powerful, automated macros to process dates and numbers, enhancing efficiency and reliability. **Data Types**: - Our primary focus will be on enhancing the handling and manipulation of numerical data and dates, ensuring a seamless workflow. **Timeline**: The project needs completion within a month, demanding a dedicated and efficient approach. **Ideal...

I am seeking a skilled freelancer to create a multifunctional Excel spreadsheet designed to manage my employees more efficiently. The ideal candidate will possess strong skills in Excel, including formula creation, macro programming, and a basic understanding of encryption, although high-level security measures are not required at this stage. Requirements: - Develop an Excel spreadsheet where each employee has a separate tab including their basic contact information. - Include a section within each tab for tracking Paid Time Off (PTO) and sick time. This section needs to support both manual updates (which I can undertake as the owner) and the capability for automatic calculations or updates based on certain inputs. - A dedicated area for recording usernames and passwords related to...

Need a macro that breaks out a text data field into 3 other fields. The first 50 rows of the attached file show samples of the data that has been broken out. The macro should convert the remaining rows of the file by executing the macro one time. The delivery would include the converted data and the macro so it can be run on different data files with the same structure. Note that any time the source data contains the word "(loss)", the percentage should be changed to a negative number. There may be a few rows with anomalous data that will not convert. It is ok if the macro doesn't convert these, as long as the macro runs through all of the data.

I am in need of a proficient VBA programmer with extensive experience in Excel. The selected freelancer is expected to: - Effectively perform data manipulation and analysis. - Program and implement custom macros to enhance productivity. - Integrate data sorting and filtering functionalities into the macros. I need a macro written to take a bunch of foreign exchange buys (ordered by date) and a bunch of sells (ordered by date) and calculate profit and loss based on FIFO method. It will need to allow for future entries. It will also need to keep a running balance of which line item has been exhausted to zero and what still has a non zero balance. For example, 1/1/23 bought 100,000 USD/GBP at 1.20 5/3/23 bought 25,000 USD/GBP at 1.22 4/9/23 sold 30,000 USD/GBP at 1.21 ...

...guidelines in nutrition. - **Engaging Writing Style**: Ability to write in an engaging, clear, and motivational tone that can capture the reader's interest and encourage them to make positive changes. - **Expertise in Nutrition**: Ideally, you should have a background in dietetics, nutrition science, or a related field. Familiarity with current nutrition trends, basic diet planning, the role of macro and micronutrients, and the ability to debunk common nutrition myths are crucial. - **Understanding of Target Audience**: The book is aimed at the general public, so it's important to avoid overly technical language. Instead, focus on making the content relatable and easy to implement into daily life. **Content Structure:** - Introduction to basic nutrition principles - T...

I require a professional who can convert a data set into a catalogue. The catalogue should include images, items, descriptions, and prices, all keying off a SKU. The data set will indicate that not all items will be available in all styles and sizes. An Excel spreads...within a month. Ideal Skills: - Experience in catalog creation - Proficiency in extracting and interpreting data from Excel - Strong layout and design skills - Demonstrated ability to work within a deadline Think it will need to be like a mail merge but open to other suggestions. The catalog will need to change order of items based on the order of the data. Does not need to be LIVE can be a macro to update. Would love it to ultimately be something that could be PDF'd into a form that could be filled out and...