Macro vbadela

I need an experienced Excel and VBA specialist to assist with a project that involves data cleaning and generating reports from a CSV file. This file contains dates and times against power usage for apartments and needs to be processed in Microsoft Excel. The job tasks include: - Fixing inconsistent data entries in the CSV file - Extracting time of usage for each apartment - Creating a repeatable VBA script for future use Ideal freelancers will have strong experience in: - Microsoft Excel for managing and manipulating CSV files - VBA for creating automated tasks related to data cleaning and report generation Your help will save me time and effort in terms of managing this CSV file and creating valuable reports in the future. Successful completion of this project co...

I am seeking a proficient Excel expert to enhance macros within an existing spreadsheet....re-scripting macros for performance enhancement. On top of this, the spreadheet needs to have its calculation functions updated in certain areas. Hence, the ideal candidate should be comfortable in tweaking and improving formulas for better functionality. I also anticipate that some redundant aspects of the macros may be stripped off as we progress to streamline performance. Required Skills: - Proven Macro scripting and implementation in Excel - Solid understanding and experience in complex formula manipulation - Ability to optimize spreadsheet for improved performance and efficiency. Note: Specific deliverables relating to the calculation changes will be shared during our one-on-one project d...

I have a task I need automated using an Excel macro. The specific function I need is data filtering from various sheets. - The Macro Task: The job involves creating a macro that filters data to different sheets. - Data Filtering: Notably, the filtering should be done based on specific criteria. I require a system that intelligently separates and filters information to various sheets. - Work Scope: I need the data filtered from multiple sheets, not limited to sheets 2, 3, or 4. The project might involve other sheets as well. Ideal freelancers for this job will have strong experience in Excel macros, data filtering, and automation scripts. Expertise in efficient data handling and manipulation are essential.

...advanced topics, including but not limited to Excel Macros. - For each topic, I need 5 well-thought-out lab exercises created with step-by-step answers. - The exercises must be suitably challenging for advanced-level Excel users. - Each exercise should come with a step-by-step questions and answers guide to aid understanding. IDEAL SKILLS: - Extensive knowledge of Excel, especially in Macros and VBA programming - Proven experience in developing training materials or lab exercises. - Familiarity with financial modeling and data analysis in Excel. - Ability to break down complex Excel operations into understandable steps. - Strong written communication skills. I will pay $30 for each topic (5 labs). I need exercises for 10 topics making a total of 50. You will be paid by each top...

Need to upgrade my existing excel macro, very simple project

In my pursuit to simplify and automate my Costing-related tasks, I need an Excel VBA utility that is able to perform calculations, specifically advanced financial modeling for cost using VBA & Macros. I require complex projections for various scenarios to be calculated through this utility. This tool should enable me to: - Efficiently perform cost calculation for a project and financial based on inputs - Efficiently calculate the cashflows automatically based on the inputs. - Generate advanced financial projections incorporating different scenarios. Ideally, the freelancer taking this project on would have a robust background in both financial analysis and Excel VBA programming. Proficiency in financial modeling (Including Project cost calculation) and a solid u...

macro based excel project with auto copy data and paste in chrome through selinium

I need an experienced Excel and VBA specialist to assist with a project that involves data cleaning and generating reports from a CSV file. This file contains dates and times against power usage for apartments and needs to be processed in Microsoft Excel. The job tasks include: - Fixing inconsistent data entries in the CSV file - Extracting time of usage for each apartment - Creating a repeatable VBA script for future use Ideal freelancers will have strong experience in: - Microsoft Excel for managing and manipulating CSV files - VBA for creating automated tasks related to data cleaning and report generation Your help will save me time and effort in terms of managing this CSV file and creating valuable reports in the future. Successful completion of this project co...

I'm in need of an Excel programmer who is proficient with VBA. The task involves creating a VBA scroll bar that changes values within a specific cell. The cell's contents should be adjusted in increments of 0.01 through the scrollbar's activities. - Proficiency in Excel and VBA is a must. - An understanding of user interface designs with Excel is ideal. - The candidate should be capable of testing and debugging functions within Excel. Your main goal is to create a VBA scroll bar that can accurately manipulate cell contents. Your work will be deemed successful when the scrolling alters the cell value as per the increment specified. Reach out if you have the necessary skills and can get this job done.

...wizard who is skilled in Visual Basic for Applications (VBA). Your primary tasks will include: - Leveraging VBA within microsoft excel to perform find and replace tasks on external files (.html files) - An excel spreadsheet placed in a folder will be able to... Macro 1 Will list all the files in the current directly in column A Macro 2 Will open and search the files in column A for strings listed in column B and confirm if they were found in Column C (Found or Not Found) Macro 3 Will open and find the string listed in column A and replace it with the new string listed in Column D Given the nature of the project, strong Excel and VBA proficiency is expected. Your skills should include but not be limited to creating macros, utilizing VBA...

I have a need for a VBA Microsoft Visio expert. The project primarily revolves around this specific task: - Automation of rectangle geometric shape creation. The detailed requirements include: - Developing a VBA code that can automate the creation of rectangles in Microsoft Visio. - The shapes must be created accurately and efficiently, with minimal margin for error. - Familiarity with geometrical shapes, especially rectangles, is a must. Also Add picture to shape , and grope . The ideal candidate for this project will possess a deep understanding of Microsoft Visio and Visual Basic for Applications. Experience in automating shape creation, specifically in dealing with geometric shapes in Visio, is crucial for successful completion of this project. This knowledge and ex...

I am in need of an expert Word VBA programmer to: - Develop custom macros for Word documents - Make these macros capable of converting Word files (.docx) to PDF, and vice versa (this PDF file -> .docx) using the (PDF to WORD Converter) website. The ideal freelancer for this project will: - Have in-depth knowledge and experience in Word VBA programming and macro development - Be familiar with file conversion resources such as - Be capable of thoroughly testing the macro to ensure it functions correctly, specifically for document conversion. The goal of this project is not only to automate document conversion, but also to enhance workflow efficiency. If you are keen on taking part in this project, kindly send in your bids.

I'm in need of a skilled VBA coder to help enhance the functionality of Microsoft Word. The specific functionalities required are: - Document automation - Text formatting and styling - Data extraction from documents The Word document essentially consists of tables. The tables have different numbers of rows and two columns. The first column should only contain text. There should be a checkbox in the second column. The checkboxes should initially be hidden. The checkboxes should only become visible when you activate the “Show all” function. If the check box is selected, the text in column 1 should have a specific target style assigned to it. If the check box is cleared, the text should be mapped to another style that is defined to have the text hidden. If I de...

We are seeking a skilled web designer to revamp the front end of our company website, IDIGITALPRENEUR, to align with our global expansion initiatives. The redesigned website should exude professionalism and incorporate modern design elements, including micro and macro animations, to enhance user engagement. Current Website - Key Requirements: - Redesign IDIGITALPRENEUR website to reflect a modern, global brand image. - Incorporate micro and macro animations to elevate user experience. - Maintain a professional aesthetic with a preference for a dark color theme, though light colors can be utilized as needed.

As a real estate owner, I need an ambitious Excel expert to develop a professional spreadsheet for managing my properties' rental income and expenses. With each listed property, manual entry will be utilized for inputting income and expense data. In this project, the focus is on tracking individual real estate assets and not t...categories for easy tracking and assessment. - Monthly/Yearly summary: It should provide a clear and concise picture of the monthly and yearly income and expenses, aiding in financial decision making. The ideal candidate for this job should be a seasoned Excel professional with a track record in financial management spreadsheets, particularly properties and real estate. If you have proficiency in VBA, that can elevate the spreadsheet to an even more o...

As the initiator of this project, I'm on the lookout for an intermediate-level VBA specialist. I am looking for someone who have Finance background, While the specific tasks were not laid out, the hired freelancer should be comfortable with various activities, including but not limited to automating data entry, generating reports, and creating macros. The key skills and experience required include: - Proficiency in Visual Basic for Applications (VBA) programming language. - Ability to automate tasks, create macros, and produce reports using VBA. - Demonstrated experience in a similar role or project. Please highlight your experience in your application. Remember, your ability to showcase your skills and past success in this area will significantly impact the...

VBA basics but no time to do it. I have already started the 1 step of the project () Can you please finish it ? Everything is explained on

I am looking for a freelancer who can make moderate changes to my VBA software in Excel. Here are the details of the project: Type of software: VBA in Excel Function or feature: I do not have a specific function or feature in mind for the software, but I am open to suggestions. Level of customization: Moderate changes are needed for the software. Ideal skills and experience: - Strong proficiency in VBA programming in Excel - Experience in customizing and modifying existing VBA software - Ability to suggest and implement improvements to enhance the software's functionality and usability

VBA basics but no time to do it. I have already started the 1 step of the project () Can you please finish it ? Everything is explained on

Primero, recibo los pedidos a través de WhatsApp. Luego, transcribo los nombres de los pedidos en un documento de Excel. Utilizo una macro VBA en Excel para generar archivos individuales para cada nombre listado en el documento. Estos archivos se crean a partir de una plantilla base llamada "libro ". Una vez generados los archivos, los protejo manualmente uno por uno utilizando un programa externo. Finalmente, adjunto cada libro de Excel protegido a los respectivos contactos de WhatsApp. Estoy interesado en automatizar este proceso y me gustaría explorar diferentes propuestas para lograrlo. Próximamente, compartiré un video detallando el proceso actual a través de un mensaje directo. puede ser web, que funcione tambien con el cel...

The main task will be to automate the process of downloading PDF files. The desired macro should: - Navigate to a specific URL - Download all PDFs - This includes navigating to the next page(s) until all PDFs downloaded. Do not use the "All" link, use the "Next page" link. The macro should do the downloads page by page. The page URL is All this can be done with the open-source version of (free!). Screenshot attached. We need this macro within a week. So please only bid if you can work on this now. In your bid, please mention "within-a-week". Sorry about that, we need that filter to avoid all the spam bids.

I'm looking for an individual with proficiency in Microsoft Excel and Microsoft Word to assist me in generating delivery notes. For this project, your tasks include: - Reading data from an Excel spreadsheet and populating it into a Word template for the delivery note. The data to be transferred includes: customer names and...descriptions, and quantities. - Automating this process for all entries in the spreadsheet in such a way that each entry generates a separate delivery note automatically. - Replicating this delivery note for all the 92 notes captured in the Excel spreadsheet. In addition, you will be creating a PDF copy of each finished delivery note. Possessing experience in visual basic for applications (VBA), data processing, and automation will be advantageous...

I urgently require an expert to lift protection from a VBA macro in my Excel 2007 document. A complex password (10+ characters, including symbols) protects the macro. Here's what's needed: - Thorough understanding of Excel 2007 and later - Proficiency in dealing with complex passwords - Demonstrable experience in unlocking protected VBA macros The document itself is not password-protected and remains accessible. However, the VBA macro within is locked. I am specifically looking for a problem-solver with a track record in removing complex macro passwords without affecting the functionality of the macro. Please only apply if you meet these criteria.

I need a freelancer adept at Excel and Visual Basic for Applications (VBA) to assist with a project that necessitates basic data manipulations and formulas. The application is primarily dealing with both numerical and textual data. The ideal candidate should possess: - Proficiency in Excel functionalities and VBA scripting. - Experience with handling diverse data types like texts and numbers in Excel. - Ability to quickly comprehend and effectively manipulate data structures using VBA. Kindly submit your bids if you meet these requirements and can efficiently solve complex data problems.

...analyst-forecasted growth rate, and the expected industry P/E ratio. 2) Support work a) Well-structured and well-labeled worksheets and VBA code to support your presentation Questions to consider and take into account for the finished project Is the spreadsheet's broad purpose immediately obvious? Is the output of the spreadsheet AND its meaning clear to the user? Is your analysis correct? Are there any hard-coded numbers (other than numbers that would never change in the formulas? Can the user (or developer for some of the assumptions) change each assumption and see that the model adequately reflects changes to each assumption? Are all cells and the VBA code labeled appropriately? Does the spreadsheet look aesthetically pleasing? (Yes, colors matter...

Hi Need to send and receive e-Mail from G-Mail. Need to use oAuth2

check reference image, excel insert row & copy the value from above row

I am attaching a file that includes the current output with notes. You can see yellow highlights as to what needs to be corrected in the existing code. Then I need a second macro to output data into the DoD_merge template. I added notes to that docunment.

I am looking for someone who can transfer my current VBA code into GCP Big Query stored procedure. This basic VBA code is readily available for conversion. Primary Requirement: - Maintain the 'IF ELSE CONDITION' functionality of the current code during the conversion process. Ideal freelancer: - Experienced in converting VBA code into GCP Big Query stored procedures. - Skilled at preserving specified functions through the conversion process. - Good understanding of basic VBA code structures. - Excellent problem-solving skills in case any issues arise during the conversion process. Your expertise in this area will not only help in preserving the original functionality of my code but also enhance it using GCP Big Query's features.

I'm in need of a detail-oriented professional for a simple data entry job. The core of the work includes: - Transferring information from PDF files into an Excel spreadsheet - Ability to accurately input raw data without altering information Ideal skills and experience: - Proven experience in basic Excel data e...into an Excel spreadsheet - Ability to accurately input raw data without altering information Ideal skills and experience: - Proven experience in basic Excel data entry - Proficiency in handling PDF files - High attention to detail - Fast and accurate typing abilities Please note, this project doesn't call for intermediate or advanced Excel techniques like formulas, data sorting, pivot tables, or VBA. The successful freelancer will strictly be transferring dat...

I am looking for someone who can transfer my current VBA code into GCP Big Query stored procedure. This basic VBA code is readily available for conversion. Primary Requirement: - Maintain the 'IF ELSE CONDITION' functionality of the current code during the conversion process. Ideal freelancer: - Experienced in converting VBA code into GCP Big Query stored procedures. - Skilled at preserving specified functions through the conversion process. - Good understanding of basic VBA code structures. - Excellent problem-solving skills in case any issues arise during the conversion process. Your expertise in this area will not only help in preserving the original functionality of my code but also enhance it using GCP Big Query's features.

I am in need of a professional who has experience using VBA in MS Project to automate the process of generating project summary reports. Key tasks include: 1. Utilizing VBA to automate the generation of project summary reports. 2. These reports must provide a list of all tasks and their current status 3. in particular how to create a table of all tasks related to a Milestone - similar to Task path function for predecessors. The ideal freelancer for this project should possess strong skills in VBA and Microsoft Project. They should have a proven track record in automating and streamlining reporting processes. Previous experience in project management reporting is highly desirable. I'm looking for someone who understands project progress reporting and can deliv...

...affecting my code. Specifically, it is producing incorrect outputs when engaging with certain external systems. Key tasks include: - Identify the root cause of the output error - Troubleshoot and rectify the logic flaws causing these errors - Make sure code is efficient, secure, and maintainable The ideal candidate for this role will have: - Proven experience working with Lisp and Autolisp even VBA. - Troubleshooting and debugging expertise - A good communicator that can take my rudimentary directions. To make it short, I have a code that is used for underground drilling permits in the CAD environment. I have a LISP suite that stations a line by generating notes, that generates MLeaders when the subject of the permit crosses a utility lines and puts it on the layer automa...

I'm in need of an expert in VBA programming and Crystal Reports integration to enhance and extend the functionalities of an existing form in our program. - The form was created with VBA for the purpose of data entry. - The enhancement would involve adding more features to this existing form. - The extension requires integrating it with Crystal Reports for more efficient and agile reporting. - Moreover, I'm looking for someone who can provide ongoing support as needed. The ideal freelancer would have extensive experience in VBA programming, form design, and Crystal Reports. Your portfolio or a demonstration of a similar task you've completed would be much appreciated. A commitment to provide ongoing support on an as-needed basis would be a bonus.

I'm seeking assistance with my Microsoft Access project involving the creation of queries, forms, reports, and a comprehensive description of the databa...after project commencement) - Creation of 2 forms: A Main and a Subform. The main form is to be designed for data entry. - Devising 2 reports based on set requirements (to be disclosed upon project initiation). - Crafting a detailed written description of the entire database system using a provided template. Ideal assistance would come from someone with proven experience in Microsoft Access, SQL, VBA, and database development. A deep understanding of query development, form creation, and ensuring data integrity within Access databases is crucial. Your ability to communicate effectively to explain complex systems will also ...

I'm looking for a professional with Excel VBA expertise who can swiftly help in automating the process of printing specified worksheets from Excel to Word. Here's what's important: * Excel VBA proficiency: This task calls for specialized knowledge of Excel VBA, so your skills in this area will be pivotal. * Existing VBA: I will share the existing vba, the VBA has many tools including the print. * Enhancement required: the existing vba has print funtion where user can print specific sheets, we need to print or covert these sheet to a word file. * Quick Turnaround: I need this project completed ASAP, so ability to work under pressure and deliver on time are key. Please ensure you check the requirment carefully before bidding....

Prosimo, vpišite se ali se prijavite za več podrobnosti.

I have an Excel document that needs to be updated by reading data from a TXT file. The process must be automated via a script, filling in blank cells, distribute...within the excel document, in the required cells. 3. In the case of data discrepancies within the TXT file, enable an automated resolution by defaulting to a specific value. Leveraging your expertise in data extraction, manipulation, and Excel automation will be instrumental for this project. Ideally, you are proficient in scripts suitable for handling such tasks, debatably the likes of Python or VBA, contingent on your recommendation. Familiarity with Excel data structure is a must. Furthermore, being adept at handling data discrepancies and implementing default values coherently across diverse data entries will be b...

Seeking a skilled economist with experience in t...isn't pinpointed, a broad range of macroeconomic, financial modelling, and data analysis skills are suggested. The successful freelancer will show initiative by providing information about their past work, experience and their proposed approach. Please include these in your application: - A showcase of your previous token launches or similar projects - In-depth understanding and experience in macro economics and financial modelling - Demonstrated capability in data analysis - A detailed project proposal outlining your approach for market research, token valuation, and investor outreach The most suitable candidate will have experience in crypto or financial projects and will be comfortable working independently on this signi...

I'm seeking a proficient developer to create a macro screen recorder specifically for corporate websites. This tool should automate repetitive tasks majorly involving mouse clicks, and should also support recording of keyboard inputs. Key Requirements: - Proficient understanding of website functioning, especially corporate sites. - Strong skills in programming languages relevant to macro recorder development. - Capable of integrating both mouse click recording and keyboard input recording. - Ability to test and guarantee the functioning of the tool on corporate websites. Your primary focus should be reliability and efficient performance of the macro.

For the Macro program update work

I am looking for a script to automatically add 7 days to a date in a table. The date format is dd/mm/yyyy and the date is located in the column "Not done late +35D". The result should be a new column with the date + 7 days, called "Not done late +42D". Specifications: The script must work on Microsoft Word. The script must be easy to use and does not require any programming knowledge. The script must be compatible with recent versions of Word (2013 and above).

I have 2 unfinished Access/VBA projects. I need assistance to finish the projects. My estimation is 3 working days. Max budget : 100$ Please note that I m also a freelancer. Thanks for you bid

I'm experiencing an issue with my VBA code not running as expected on my Mac with Office 365 version of Excel. I am also receiving error messages when attempting to run the code. I'm in need of a freelancer with a strong background in: - VBA Programming - Excel - Debugging - MacOS, specifically the Office 365 version of Excel Your task will be to inspect my code, identify the issue causing it to malfunction, provide fixes, and guide me through the process to avoid such problems in the future. Your debugging skills will be paramount and your ability to communicate clearly is desired. I expect prompt resolution of this issue, without any loss of original functionality. Please ensure you have the specified skills before making a bid.

...sheet) Botón "Entregar": Debe haber un botón "Entregar" en el sistema. Al presionarlo, se deben activar acciones automatizadas relacionadas con la gestión del pedido. Integración con Excel: El sistema debe poder asignar automáticamente las credenciales y detalles del pedido a un libro de Excel. Esto incluye información como el nombre del cliente y el código del pedido. Automatización con VBA: Ya que utilizo VBA en Excel para manejar estos procesos, el sistema debe ser compatible o integrar esta automatización para facilitar la transición y el mantenimiento. Subida Automática a Google Drive: El sistema debe ser capaz de subir automáticamente el libro de Excel generado...

I'm seeking an expert in VBA coding, financial dashboard design, and crafting Power BI presentations. This project's focus is to: 1. Develop VBA coding 2. Design interactive and dynamic financial dashboards 3. Create an engaging Power BI presentation The ultimate goal of the dashboard and presentation is to: • Thoroughly analyze financial data • Visualize the company's financial performance in a compelling manner • Present clear and concise financial insights The types of financial data that will be included in the dashboard and presentation encompass: • Revenue • Expenses • Profit/Loss • Cash flow • Budget Ideal candidates possess in-depth experience with VBA, financial dashboards, Power BI, and prove...

For convenience I divide the illustration of the project into 2 different parts. PART1: I have an excel file with an "CEL ANNUALE" sheet which shows some personal data and some characteristics of the users of a service. The data is entered into the sheet through a userform called "userform1". The data entered through userform 1 are always recorded in the main "CEL ANNUALE" sheet Among these data are: - an "insertion date" field which concerns the date on which a user was added to the service. - a "resignation date" field which reports the date on which a user concluded the service. In addition to the "CEL ANNUALE" sheet there are 12 other sheets called "CEL 01-24" (which refers to the service status as of January 2024...

necesito una macro que sea capaz de hacer una tarea sencilla: volver el menu de un juego (sería el boton de atrás), darle a "Jugar" y a "aceptar". Esta tarea la debe hacer presionando un botón flotante.

I need a skilled IT professional to handle my network hub and server management issues. Your responsibilities would include: - Server management: Delve into the intricate details of server operation, configuration, and routine maintenance, focusing on a Windows operating system. - Network hub management: Macro-level management of the network hub, ensuring seamless interconnectivity and performance. - Troubleshooting & maintenance: Prompt identification and resolution of issues related to the server and network hub, ensuring optimal uptime and reliability. - Security enhancement: Develop and implement strategies to fortify the security of my servers and network hubs preventing unauthorised access or potential attacks. Key skills include extensive experience in Windows server...

I'm in need of an expert in VBA programming and thermodynamics to create a VBA code for vapor-liquid diagrams compatible with Microsoft Excel. The code should be flexible enough to work with any two components. The following skills and experience are required: - Proficient in VBA code in Excel - In-depth understanding of Thermodynamics Key requirements include: - Usage of the Wagner equation - equation for the saturated pressure : p_i^* (T)=exp⁡((Aτ+Bτ^1.5+C^2.5+D^5)/(1-τ))×P_c. - bull point equation P= 1/(y_a/(p_a^* (T_pr))+((1-y_(a)))/(p_b^* (T_pr))) - dew point equation P= x_a p_a^* (T_pb )+(1-x_a)p_b^* (T_pb) - Ridders method to find the right temperature for dew point and bull point - The code must be compatible with Microsoft E...