Macro recorderJobs
I have an Excel file where the preventive and corrective maintenance services of some equipment are r...equipment are registered. It is divided by team in Excel sheets, in the example there are 2 teams BU-001 and BU-002. By pressing the finish button at the top of the sheet, the macro must copy the existing data from the selected sheet to the BDD sheet table, and also delete the elements found in the BDD sheet table. sheet in progress (BU-001 in the example), in addition to setting the "MAN HOURS IN CURRENT MAINTENANCE" and "DAYS OUT OF SERVICE" fields to 0's. It is necessary that the macro works on the selected sheet, since the sheet will be duplicated to have one sheet per team, and when the sheet is duplicated, the macro does not lose func...
I need an Excel macro to move records between two sheets in the same workbook. Here's the challenging part: records should be relocated based upon logical condition within a certain range of values in designated columns. Time isn't a constraint but proficiency in scripting Excel macros and strong grasp of logical functions is mandatory. Clean and efficient code is valuable. Understanding of data management in Excel is also desirable. Patience needed to iterate and perfect the code. Please apply if you meet these criteria.
Cuento con un archivo de Excel donde se dan de alta los servicios de mantenimi...dividido por equipo en hojas de Excel, en el ejemplo existen 2 equipos BU-001 Y BU-002. Al presionar el botón finalizar que se encuentra en la parte alta de la hoja, la macro debe copiar los datos existentes de la hoja que se encuentre seleccionada a la tabla de la hoja BDD, además eliminar los elementos que se encuentran en la tabla de la hoja en curso (BU-001 en el ejemplo), además de poner en 0´s los campos "HORAS HOMBRE EN MANTENIMIENTO ACTUAL" y "DIAS FUERA DE SERVICIO". Es necesario que la macro funcione en la hoja seleccionada, ya que la hoja se duplicara para tener una hoja por equipo, y al momento de duplicar la hoja, la macro no p...
I have given Start time, Interval, End time in excel When i give start time(Ex:9:15), when that time reached E col data automatically copied in into G col, Next Interval is 10 Mins, When 9:25 reached E col data automatically copied in into H col, When 9:35 reached E col data automatically copied in into I col,When 9:45 reached E col data automatically copied in into J col, When 9:55 reached E col data automatically copied in into K col, When 10:05 reached E col data automatically copied in into L col, When 10:15 reached E col data automatically copied in into M col.(H col vale > G col, that cell is green, H col vale < G col, that cell is red, same process for all col) 9:15-9:25 is 1 10Mins during that time, how many time(count) E col value>G col value( Ascending not decending) ...
I'm in need of an Excel expert to Create Macros. I have two spreadsheets. On each spreadsheet i have an input form. When the form has been entered and the user clicks "Enter Asset" each of the filled out cells (as per the File - "Template Code Functions") should be transferred to the "Data Collection Spreadsheet". Just enter into the next unused row. When the asset has been added successfully the cells marked as "Yes" as per the "template code functions" for "Reset on data entry" shall be empty on the input form. There are two spreadsheets, they are slightly different from each other.
I am in need of an Excel Macro skilled professional, who can automate my manual work of generating operational data reports. My preferred output format for these reports is Excel spreadsheets. Key Responsibilities: - Design and create a macro in Excel for automatic report generation using operational data - Ensure the macro is accurate and efficient, cutting down the time spent on report creation Ideal Skills: - Excellent understanding of Excel Macros and VBA - Experience in creating automated report generation systems - Familiarity with handling operational data is preferable.
I am seeking a VBA expert with extensive experience in Excel for the creation of a custom macro. The specific task will involve designing a macro that can efficiently audit the financial records of a Trust. The audit should be conducted at a yearly level, ensuring accuracy and comprehensiveness in the review. Key tasks for the project include: - Building an automated audit tool: The macro should be capable of assessing financial records of the Trust with minimal manual intervention. - Ensuring high level of detail: The work is format based. Proper posting of the records should be done repeatedly year on year - Application in Excel: The macro should be fully functional in Excel, allowing for easy integration into the Trust's existing data management proces...
...these sheets eliminating redundancy. Key objectives: - The primary goal of this rework is to automate repetitive tasks. I'm looking for someone who can introduce VBA scripts and macros to help me achieve this. - The spreadsheets are both independent and share common data. It will be important to create a system that can handle both types of sheets. Ideal skills: - Proficiency in Excel, VBA, and Macro programming is a must - Experience with data manipulation and automation - Ability to understand and work with a mix of independent and shared data I'm open to discussing the project requirements in more detail. Please let me know if you're interested and if you need any further information. The attached (FIVERR) helped us with a lot of redundancy but I now sant ...
I am seeking a VBA expert with extensive experience in Excel for the creation of a custom macro. The specific task will involve designing a macro that can efficiently audit the financial records of a Trust. The audit should be conducted at a yearly level, ensuring accuracy and comprehensiveness in the review. Key tasks for the project include: - Building an automated audit tool: The macro should be capable of assessing financial records of the Trust with minimal manual intervention. - Ensuring high level of detail: The work is format based. Proper posting of the records should be done repeatedly year on year - Application in Excel: The macro should be fully functional in Excel, allowing for easy integration into the Trust's existing data management proces...
I'm seeking an academic writer with a strong understanding of economics, market structures, and legal disputes. This project requires: - Writing an economics paper focused on antitrust lawsuits against Apple. - Analysis and discussion should center on the economic impacts of these lawsuits. - The paper should delve into the potential macro and microeconomic consequences, including market effects, influenced by these legal actions. - Familiarity with economic principles and legal jargon is beneficial. - An objective perspective, academic referencing, and evidence-backed arguments should be adhered to. Please use 3 sources and cite them here are the requirements Apple Lawsuit Paper (Due 4/29) 4-5 Paragraphs 3+ Sources Topic: US Government vs. Apple lawsuit Intro - Summary...
I have to download everyday +- 3000 invoices (PDF files) from a server to my computer. I already have this task semi-automated in an Excel macro, but I want to do it easier. I need a tool (also in Excel/VB/Macro) where: - I'll write the day, month and year - I'll write the first invoice number and last invoice number that I want your tool to search - I'll hit a button "START" and your tool will search and download to my computer every invoices from that range that were issued on that specific day from an specific URL. The URL for these files is a standard URL. It's always an URL like this: The only part that changes is day, month, year and invoice number. Example: if I want to download any available invoices between numbers 5000
As an entrepreneur in the bo...be well-structured and contain all the necessary elements, including but not limited to executive summary, company description, market analysis, organization & management setup, product line, marketing & sales, and financial projections. Ideal Skills & Experience: - Proven track record in business plan writing - Knowledge or direct experience in boutique/retail industry - Understanding of both macro and micro market dynamics - Experience in structuring financial projections for businesses This business plan stands as the blueprint for our business operations and the document will likely be used to engage with future potential partners and stakeholders. The right candidate for this job will be able to articulate our vision and strategy cl...
I'm in need of an Excel expert who can assist me with data analysis, formulas, and data visualization. The project involves working with a dataset of medium size, s...should be very comfortable with advanced Excel formulas and calculations. - Data visualization skills: The ability to present data in an easily understandable and visually appealing way is crucial for this project. Specific functionalities and tools that need to be utilized include: - Pivot Tables: You will be required to create and manipulate pivot tables. - Macros: The project involves basic macro creation and execution. - Conditional Formatting: You should be able to apply conditional formatting to present data in a more user-friendly manner. If you believe you have the right skill set for this project, pleas...
EN Project with the intention of reducing the time for creating cutting files and eliminating errors in saving. Aplication Area: Engineering and manufacturing Automation of saving cutting files and manipulation of drawings, 1 - Save cutting files, considering the file type and correct naming. There is a file with several layers categorized in a standard way, these layers should be separated and saved in different files with specific names according to the layer. 2 - Save steel cutting files and possibly make changes/cuts (e.g., Slide). PT Projeto com intenção reduzir tempo de criação de arquivos de corte e eliminar erros no salvamento. Area: Engenharia e manufatura Automatização de salvamento de arquivos de corte e manipulaçã...
...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...
Hi Sir, I can create the macro as per instruction shared . Thanks Arun
I'm currently facing some issues with my Excel tracker. - The tracker contains a VBA macro file which seems to be causing formula errors and formatting issues. I'm unsure of the exact nature of these errors, but it's clear they are impacting the accuracy and usability of the tracker. I need a freelancer who can review and rectify these issues in the tracker. An ideal candidate would have strong experience with VBA and Excel, able to handle complex formulas and troubleshoot formatting problems swiftly. Your goal is to ensure that the tracker is fully functional and error-free. Experience with similar projects will be a plus.
2 excel files with VBA macro as per customer requirement
One excel file with macro as per the customer requirement
I have an existing simple Android app written in Kotlin. I have a need to make some minor adjustments to it. It interacts with a Google Firebase Realtime database. The app is a very simple Proof of Delivery recorder,. It loads a driver's "diary" from firebase and allows the driver to mark that he has arrived. The driver can capture some photographs of the delivery and then mark that he has finished. This data is then sent back to firebase. I need a few small enhancements: 1. mark a job as "completed" in a separate date/time field 2. allow the user to "scan" a document rather than taking a photo. This would then be stored as a PDF. a scanned document provides better clarity than a photograph. This would be mandatory and photos optional 3. ensure ...
I am urgently seeking a proficient macro developer to create a small, efficient macro capable of identifying and removing rows based on specific phrases present in multiple columns. Key Project Requirements: - The developed macro must target multiple columns in the sheet. - Deleted row criteria: rows with specific text present. - Must complete as soon as possible. Ideal Freelancer Skills and Experience: - Experience in macro development, particularly macros for Excel or similar programs. - Strong attention to detail and a proven ability to interpret and implement specific criteria. - An ability to work quickly and efficiently to deliver the project as soon as possible. Feel free to ask any questions that will assist you in accurately pricing your bid. I a...
As your client, I'm looking for an Excel VBA expert who can make my daily processes more efficient by creating an automated reporting solution for me. Key Tasks: - Design and implementation of a VBA macro in Excel to automate the generation of cost summary reports. - The automated reports should be populated by data from four different worksheets, namely Worksheet 1, Worksheet 2, Worksheet 3, and Worksheet 4. Ideal Skills and Experience: - Excel VBA Programming - Experience with automated reporting - Understanding of data manipulation in Excel. -Possible migration of Cost Summary data to Word contract. In your proposal, please share samples of previous automated reporting projects done with Excel VBA. Commitment to delivering high quality and defect-free output is imperat...
The purpose of this project is to create a detailed, technical drawing using SolidWorks 2022. The emphasis of the project is documentation of plastic parts, both on a macro and micro-level. Key Requirements: - Able to generate technical drawings that include overall dimensions, shapes, specific features, and tolerances of plastic parts. - SolidWorks 2022 ONLY!! - Extensive experience and understanding in documentation of manufacturing processes and components - Expertise in rendering intricate details of plastic parts - Must be able to abide by all requirements for precision-driven, technical documentation - Detailed and clear communication The ideal candidate will have a background in mechanical engineering or a related field, as well as experience in creating detailed, techni...
I need a seasoned VBA and Macro expert to assist me with the creation of an interactive dashboard for a small project. The main tasks include: - Development of VBA code to automate repetitive tasks. - Creation of custom functions to enhance the dashboard's functionality. - Ensuring the dashboard can generate reports effectively. I'm specifically looking for someone with: - Proficiency in VBA and Macro. - Previous experience in creating interactive dashboards. - Ability to generate reports through coding. - Good communication skills and attention to detail. If you're confident in your VBA skills and have a good eye for visualizing data, I'd love to discuss this project with you.
We have an excel with macro script which converts a PDF (FFE 1a, 2a, 3a) to EXCEL (FFE) that allows us to be able to read all information we need. Unfortunately it is not working due to some changes in PDF (FFE 1b, 2b, 3b) as an extra page in the front has been added, so we are looking to hire someone that can fix this issue, so that excel can ignore this extra page.
I'm seeking a skilled professional to create a web application which automates the extraction of simple tables from word documents and the transfer of this data into a macro-enabled Excel sheet. Key Requirements: - Extraction of simple tables from Word documents - Transferring the extracted table data directly to a macro-enabled Excel sheet - Ensuring the data transfer is accurate and error-free Ideal Skills & Experience: - Proficiency in Web App Development - Strong experience in data extraction and manipulation - Proficiency in working with Word and Excel documents - Familiarity with macro-enabled Excel sheets - Attention to detail to ensure data accuracy and error-free transfer The final product should be a user-friendly, efficient, and reliable web app...
I'm looking for a highly skilled macro coder to assist me with the development of advanced custom macros in Microsoft Excel. This project will require a deep understanding of VBA and prior experience with integrating macros with external databases or APIs. Key Requirements: - Develop advanced custom macros in Microsoft Excel - Implement integration with external databases or APIs - Ensure the macros are efficient, reliable and user-friendly Ideal Skills: - Proficient in VBA (Visual Basic for Applications) - Experience in developing advanced Excel macros - Knowledge in integrating with external databases or APIs I look forward to working with a professional who can deliver high-quality, efficient and effective macros.
...me automate several repetitive tasks. I am looking for an expert in MS Excel to develop a special MS Excel Macro which can be integrated to MS Excel environment, in order to generate an output file. This tool will allow us to transform a specific Input file into another Output file. • Input: catalog_product_option-YYYY-MM-DD • Output: The 2 files are attached, with a color mapping to recognize the columns in scope. In summary, we need to be capable to issue an export file in a specific format (see attached picture “”): • Specific Orders of the column (Green) • Suppress the duplicated values for some line items, on 3 fields. The macro allows to: • Generate the Output in a separate spreadsheet (which captures only the required fiel...
I need an Excel macro developed for my employee training tracking workbook. I want to have a feature that sends email notifications to both the new hire and their manager based on the completion date of each training module. Key Requirements: - Email Trigger: The macro should send emails based on the completion date of each training module, not just the hire date. - Email Recipients: The email notifications should be sent to both the new hire and their manager. - Email Content: The email should include the name and email of the new hire, along with a list of overdue training modules. Ideal Skills and Experience: - Proficient in VBA and Excel: You should have a strong background in developing macros and automating processes within Excel. - Familiarity with Employee Training...
...in creating, managing or implementing cloud-based robo calling systems and also conversational AI calls that is good with asian language, especially Bahasa Indonesia. the subject of the research must have : telephony (SIP/VOIP) a working AI model or open to integrations with AI Basic Telco Services features such as, Campaign Calls, scheduler, call recorder) Wide system integration capability Macro/logic/script editing(for robo caller,pre recorder or AI generated TTS) white label ready or not. KPI analysis The Goal of this research is to figure which or what is the best system/platform/Integration to use that gives the right combination so it result in cost effective, work effiency, best call per minute or per second tariff etc etc, feel free to do your own custo...
We are looking for 2 Thai Natives for a recording task! You need to record 65 prompts using phone recorder app in WAV format. pay is 10$. Must be able to finish today!!
As a business owner, I'm constantly confronted with the tedious tasks of data entry, data formatting, sorting, and filtering. I am looking to automate this process to save time and improve efficiency. Key Features Needed: -A VBA Macro for Excel to automate data entry and formatting of a text (.txt) file. -Automation of data sorting and filtering needs to be incorporated. Ideal Skills & Experience: -Strong proficiency in VBA and Excel. -Experience in automating data entry, sorting, and filtering via Macros. -Real-world experience dealing with text files in Excel. With your help, I envision a tool that ultimately makes my life easier and my workload manageable.
I am seeking a skilled female artist to create an online course teaching how to start only fans. It'll be non explicit and educational base. Face recording will be required. We have the outline but will share with those who are interested.
I require a programmer adept in software development, preferably with a solid understanding and experience in Excel data manipulation, to create an application tool that can efficiently compare two data sets. - The tool shou...organization’s payroll system. I need the tool to be capable of comparing and juxtaposing entries according to dates and times specifically. - The tool should also be configured to duly highlight or flag any discrepancies between the two data sets, along with matching the data accurately. A report generation functionality, for reference and record-keeping purposes, is also required. Knowledge in macro/VBA programming and expertise in data analysis would be a great advantage for this project. A background in creating payroll system tools would be a...
I require a programmer adept in software development, preferably with a solid understanding and experience in Excel data manipulation, to create an application tool that can efficiently compare two data sets. - The tool shou...organization’s payroll system. I need the tool to be capable of comparing and juxtaposing entries according to dates and times specifically. - The tool should also be configured to duly highlight or flag any discrepancies between the two data sets, along with matching the data accurately. A report generation functionality, for reference and record-keeping purposes, is also required. Knowledge in macro/VBA programming and expertise in data analysis would be a great advantage for this project. A background in creating payroll system tools would be a...
I'm looking for a skilled freelancer with a strong understanding of Excel, particularly in building macros for data import and operations. Here's what you'll need to do: - Implement an Excel macro that can smoothly import numerical decimal data from a text file. Our perfect freelancer for this task will have: - Proficiency in Excel and VBA programming - Strong knowledge and experience in creating Excel macros - Understanding of data import techniques for decimal numerical data - Experience in handling data input tasks using macros. If you have the necessary skills and have previously handled similar projects, I'd love to get your bid. Thank you.
I'm seeking a highly competent freelancer with proficiency in Excel to create a comprehensive system to track my restaurant's weekly expenses. Key Job Responsibilities: - Develop a basic expense tracking Excel sheet. Macro auto update - Structure the sheet to track various types of expenses including but not limited to food costs, employee wages, and utility bills - Design the sheet for weekly data updates The ideal candidate should have: - Proficiency in Excel - Understanding of restaurant operations - Experience in creating expense tracking systems or similar projects. I'm not looking for sophisticated features such as budget comparisons or data analysis at this moment, just a simple, clean, and easy-to-use design. However, the sheet should be crafted in a way ...
Potential freelancers: -Past experience in financial services industry (Recommended) -Skilled in running excel VBA/macros, automating excel data & display through line chart Project: (1) Display recent weekly data (2) For past 5 years Key Details: (1) Data source:
Hello, I have a xlsx file with 2 sheets (sheet 1: data; sheet 2: pivot table), I need a vba macro that do this: - Delete data from sheet 1; - Import a txt file (the user can select it) in sheet 1; - Update the pivot table without changing formatting. And will share you more details in via chat box. Thanks
I am looking for skilled programmers who have the expertise in converting Excel VBA macro codes into a cloud-based solution that can be run on MS Azure. Key Requirements: - Conversion of Excel VBA macro focusing on data analysis - Development of a scalable and secure MS Azure-based solution Ideal Skills and Experience: - Proficient in Excel VBA and cloud technologies - Experience in migrating Excel VBA macros to cloud-based platforms, especially MS Azure - Strong understanding of data analysis and cloud security - Proven track record in developing scalable cloud solutions
I want someone who can create a VBA macro to merge specified excel workbooks from different excel files in one click. More details: What specific tasks do you need the VBA Excel program to perform? Automate data entry What types of data will the VBA program need to handle while automating the data entry? Text data, Numeric data How will the VBA program receive the data that needs to be entered? Files
I am seeking a proficient HTML/Js coder with substantial experience in ZOHO Creator. The scope of the project requires the creation of an advanced Gantt chart with the following functionalities: - Drag and drop tasks: Make tasks movable, enhancing usability and adaptability. - Zoom in/out feature: An essential functionality to swiftly and seamlessly navigate between micro and macro views of the project timeline. - Task dependencies: Tasks should be linkable, illustrating the sequential or dependent nature of tasks. The Gantt chart should display task duration in 'Days'. Therefore, candidates with grasp of fine-tuned date and time handling in Js are preferred. Moreover, the chart should provide additional task details which include: - Assignment of tasks to specific t...
I am looking for a proficient Excel VBA developer to create a macro that can automate sending payslips to employees on a monthly basis. Key Requirements: - The VBA code should be able to extract the pay information from an Excel spreadsheet and generate a PDF file with the payslip. - The generated PDF file should then be attached to an email that is sent to the corresponding employee. Ideal Skills: - Proficiency in Excel VBA, including the ability to work with PDF files - Experience with automating email sending processes - Strong communication skills to ensure the solution meets our needs. Please note that this project is specifically for creating the VBA code for the payslip emailing system - the design and content of the payslips themselves are already established. Looki...
I am currently encountering an issue with a Python macro that is not performing as expected. I'm uncertain of the actual problem, but I believe it's a simple one. Despite no recent alterations made to the macro, it is not running properly and it's impacting the overall function of my program. - The Task: The primary task is to diagnose the specific issue troubling the proper functioning of this Python macro, and subsequently implement the necessary corrections. - Macro Function: Though I am uncertain of the exact problem, the macro's primary function is to perform data manipulation operations, which aren't being successfully executed now. Ideal Skills: - Proficiency in Python - Prior experience in diagnosing and fixing issues relate...
I need an Android app that combines video recording and geo-fencing functionalities. This app should: - Enable users to record videos and images - Allow definition of geo-fenced locations. - Record video and image only under defined geo fence location. - Determine the user's current location using both GPS and Wi-Fi. also it should detect if any mock location app is being used in mobile device -Dashboard Application for PC to view recorded video, images in a sustamatic manner - Deployment of software in server Ideal applicants have previous experience in developing similar apps, a solid understanding of GPS technology, Wi-Fi-based positioning, and geo-fencing techniques. Familiarity with Android OS is crucial too.
I have a excel of Maharashtra PT it has all macros and all i am able to use it but its outcome from excel the text file am not unable to find
I need a consultation recording tool that can transcribe and summarise veterinary visits. The tool should offer the following: - Background noise cancellation: The recording will take place in a potentially noisy environment, so this feature is required to ensure clarity and consistency. - Text transcription: All transcriptions should be generated in a text file format. The transcriptions should be clean, accurate, and easy to read. - Complete summary: The summary should outline the key health issues identified, any medication prescribed, instructions for follow-up care. It is to be structured in this format: History Exam Differential/working diagnosis Plan The ideal freelancer for this role would have experience in software development, voice recognition technology, and audio recor...
...time-sensitive task, requiring both speed and accuracy. Please, only serious and dedicated freelancers should consider this project. Job Description: There are 2 sets of tables, Soccer and Basketball for my analysis during my free time. 1. The links are in the spreadsheet highlighted in yellow. The script must also be easy to understand and allow me to add new tables in the future. 2. Create a macro that will extract the table from each of the links and into Excel. Because the table statistics change every day, currently, I copy and paste manually, so I want to automate it. 3. The details start from the R - Team row. 4. Compulsory for basketball to extract data in Columns B to J, and for Soccer Columns B to I 5. Only programmers with successful scraping demos will be consi...
