Macro Jobs

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

necesito una macro para modificar la estructura automaticamente una tabla de fox pro

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

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 am searching for an expert in Excel proficient in spreadsheet creation and formatting. Goals of the project include: - Work with the provided template layout to format the spreadsheet. - Incorporate complex functions and optimize the use of macros. The ideal candidate will have significant experience with Excel and its functions, with a special focus on macros. You...formatting. Goals of the project include: - Work with the provided template layout to format the spreadsheet. - Incorporate complex functions and optimize the use of macros. The ideal candidate will have significant experience with Excel and its functions, with a special focus on macros. You understand how to manipulate template layouts and drive optimization. Ability to understand and use macro functionality ...

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