Vba marcosงาน
Coding vba ให้คำนวนและรายงานผลลงในแถบ status bar ที่มุมจอ โค้ดทำงานได้กับทุกชีทในไฟล์ รายงานผลคล้ายค่า sum, average ที่โปรแกรมมีมาให้เดิม ทศนิยมสองตำแหน่ง เลือกเซลล์จากชีทไหนก็ได้ (เซลล์1จากชีทa เซลล์2จากชีท(n) 1. รายงานผลหาร เซลล์1/เซลล์2 2. รายงานผลลบ เซลล์1-เซลล์2 3. รายงานผลเปอร์เซ็นต์ เซลล์2/เซลล์1*100
1. ใส่ VBA ให้รายการที่ Tickแล้ว ย้ายจากtabแรกย้ายไปเก็บใน tab2 (done list) และให้วันที่ในtab2 เป็นวันที่ที่ย้าย 2. ใน tab ถ้าวันที่ในรายการ ไหน <3 วันให้ทั้งแถวเปลี่ยนเป็นสีแดง
Create excel sheet with data for best location of new factory to optimize cost of transportation using three different methods with all data required including VBA code
Innovation Company Product Manager seeks VBA developer for Excel app development Your resources • Windows 10/11 & MS Office (sorry MS Office MacOS has too many compatibility problems!) • Location with good acoustics, headphones, good internet (so we can have high quality meetings). ESSENTIAL - DO NOT IGNORE THIS! Your skills • Experienced with Excel and Excel VBA coding to professional standards • Good conversational Technical English • Touch typing (we do live meeting notes) • Python OO coding experience would be good Your Technical Knowledge and experience • VBA sufficient so that you can develop (or source and enhance) • Create a professional app/plugin • Create coding standards including trialling GITHUB integr...
I HAVE A WORD DOCUMENT THAT FEEDS VIA AN EXCEL SHEET VIA A COMPLEX VBA .. I need the following to addede: Split of Clients for Buys, Sells, Buy/Sell Spreads, Brokerage, Management Costs Currently, the Excel only allows the input of trades for one client, however, we’d like to have this broken up to at least 3 clients (I remarked client and partner in the meeting, however, we have some clients who have an account each, plus a joint-account).
I'm seeking a seasoned Excel VBA developer to create a script that will regularly manipulate data within my Excel sheets. I have vba code run each 5 hours to export my excel sheets as pdf photos, but the problem here is my pdf photo sometimes not shown correctly, and sometimes its shows correctly. here is my vba code: For i = 1 To 57 '54 ' = False sheetxx(i).Select (Now + TimeValue("0:00:05")) ' "({1068})", True 'DoEvents pdffilename = fname2 & "" & sheetxx(i).Name & ".pdf" jpegfilename = fname2 & "" & sheetxx(i).Name & ".jpg" Shell ("D:khalid savescreenshot " & jpegfilename) ' (Now + TimeValue("0:00:...
I'm seeking a talented developer with a solid understanding of Excel VBA and Python to develop a system that generates and runs Python code via a manual button within Excel. The Python code generated should have the capability to work with financial data specifically. Linguistic proficiency in Excel VBA and Python is required; knowledge in XLwings or a similar tool would be a significant advantage.
I need a professional adept at advanced Excel functions to create a spreadsheet, whi...The ability to input more than 20 workers' availability. - An advanced combination of automatic and manual assignment based on the available days of our workers considering part-timers. 2. Worker Ability: - A system to allow input about the worker's ability to cover specific sites, based on their previous experience. The ideal freelancer should have a high proficiency in Excel, including VBA, Macros, and writing complex formulas, balanced with an understanding of rota scheduling needs. Experience in the healthcare/pharmacy field would be a plus as well. Your understanding of our needs would help us make this project a success. Good work on this project could lead to more opportun...
I'm looking for a Virtual Assistant with solid experience in Python, JavaScript and VBA, particularly for handling scripting tasks. Ideal Skills and Experience: - Proficient in Python and JavaScript - Previous experience with scripting tasks - Excellent communication skills - Pro-active communication style Main Responsibilities: - Writing and implementing scripts in Python and JavaScript with APIs - Ensuring the smooth execution of various scripting tasks
...write: =GPT-Invoices("sum all Subtotal values of invoices of April 2024"). The output answer should be returned in the same cell (A1). Deliverables: A fully functional GPT-Invoices model that can analyze invoices from OneDrive folders and answer queries as described. A VBA (or other appropriate method) integration in Excel that allows calling the GPT-Invoices model and returning the response in the same cell. Skills Required: Experience with OpenAI GPT models and their customization. Strong understanding of Excel, including VBA or other scripting languages for Excel. Experience with integrating APIs with Excel. Familiarity with cloud storage solutions like OneDrive and handling file structures programmatically. Additional Information: Please provide examples o...
I'm seeking a...develop a Solidworks macro for specific tasks. Mainly, it's intended to import data from Excel to Solidworks, and automate several repetitive processes. Data to be incorporated from Excel will be primarily: - Dimensions and measurements - Material properties - Configuration properties part number convention The successful candidate should have prior experience working with Solidworks and Excel VBA, understanding how to adeptly make these two platforms talk to each other in an efficient and error-free manner. This project is required within a month. If you're able to work within this timeframe, and have the necessary skills, I would love to hear from you. I have an Excel sheet to automate PN and description creation already made. Can be used as refe...
Hi Debashish D., Let's see how many we can get in the Austin market. The major cities in this area are: Austin, Round Rock, Cedar Park, San Marcos, and Georgetown. These are all in the State of Texas. The positions/titles we want are: Owner, President, Franchisee, Executive Chef, CEO, COO, Chief Operating Officer, Founder, Partner
...consolidation to be automated instead of manual intervention. - Performance Optimization: Currently using Xlookup for the merging process, but it's slow due to the file size. I'm open to suggestions for more efficient alternatives. Skills and Experience: - Advanced Excel skills: The freelancer should be proficient in Excel and have experience working with large data sets. - VBA Scripting: Ability to write and implement VBA scripts or macros for data consolidation. - Performance Optimization: Experience in optimizing Excel for better speed and performance would be a big plus. - Attention to detail: The accuracy and integrity of data are crucial, so attention to detail is a must. - Communication: Regular updates and clear communication throughout the project a...
I'm seeking an expert in Excel macros with an advanced understanding of VBA to accomplish several tasks for my project: - Automate data entry processes. - Generate comprehensive reports. - Perform complex calculations. Key skills you should have: - An advanced understanding and experience of Microsoft Excel. - Proficiency in developing and implementing Excel Macros. - Advanced VBA coding skills. To be considered for this project, please include the following in your application: - Detailed project proposals, illustrating how you plan to achieve the tasks outlined above. Please note, this project is demanding and requires a high level of familiarity with Excel and VBA to be executed efficiently and effectively.
crear un instalador con cual pueda instalar selenium vba a computadoras de 32, 64 bits (debera poner el diriver chrome actualizado segun la arquitectura de la computadora), con sus driver Chrome actualizado segun la última version del navegador. - Agregar la librería de referencia de selenium vba a excel Todo esto de manera automática, sin presentar alguna interaccion por parte del usuario extra, aparte de la tipica instalacion selenium: Chromedriver:
...runtime error in my ChatGPT Excel VBA script, specifically during data analysis. I need an experienced VBA developer to help me identify and resolve the issue. Key aspects of the project: - Debug a runtime error: The issue is occurring during the data analysis process. You'll need to identify the root cause of the error and implement a solution to ensure the script runs smoothly. Ideal skills and experience: - Proficient in Excel VBA: You should have a strong command of Excel VBA, particularly in handling data analysis tasks. - Debugging experience: Prior experience in identifying and resolving runtime errors in VBA is essential. - Familiarity with ChatGPT integration: While not mandatory, previous experience with integrating GPT models int...
ChatGPT is generating VBA to automate Excel data manipulation and other actions. As a VBA EXPERT, you will debug the code when it doesn’t do exactly what it was asked to. The project is being built module by module. There are about 6 modules.
...various tasks within Excel, reducing manual work and minimizing errors. - **Data Visualization**: The software should also have the capability to visualize the data from my local files. The visualizations should be in the form of static charts and graphs. Ideal Skills and Experience: - Advanced Excel Skills: You should have extensive experience with Excel, including creating complex formulas, using VBA for automation, and chart creation. - Data Visualization Expertise: A strong understanding of data visualization techniques and tools will be beneficial. - Software Development: Experience in developing bespoke software within Excel would be advantageous. Please note that while the visualizations need to be created using Excel, I'm open to suggestions for automating spreadsh...
mình đang tìm dịch vụ support cho tự động hoá đọc dữ liệu ở Excel dùng VBA. bạn nào có thể giúp thì sẽ nói chuyện trực tiếp để giải thích thêm
I am creating a disruption tracking sheet for Disaster Recovery. I am in need of an Excel VBA expert who can create an efficient macro for me. Your task will be to create a macro that will primarily deal with: - Copying Affected systems from each incident, to the tracking page. - Sort tracking page maximum allowable disruption time - Need to add a manual entry for the time of the incident, and the maximum allowable outage time should have a countdown to how long until it is breached. - Macro should run automatically every 30s or so. If you have a good understanding and experience working on Excel VBA scripting, specifically in creating macros, this job is right for you. An in-depth knowledge of disaster recovery protocols and incident tracking will be a plus point. Please ...
...stock alert mechanisms to notify users when inventory levels fall below a certain threshold. - Alerts can be sent via email, SMS, or displayed within the software dashboard. This software solution would require a database backend to store all relevant data and a user-friendly interface for easy interaction. You could develop it using Microsoft Access, incorporating forms, queries, reports, and VBA (Visual Basic for Applications) for automation and customization. Consider consulting with stakeholders and users throughout the development process to ensure the software meets their specific needs and requirements. Additionally, thorough testing and refinement will be crucial to ensure the software operates smoothly in real-world scenarios. Key Features and Requirements: - Strea...
...necesitará conocer varios aspectos: Conocimientos básicos de Excel: Deben estar familiarizados con las funciones básicas de Excel, como la creación de hojas de cálculo, el formato de celdas, la creación de fórmulas, etc. Macros en Excel: Deben comprender qué son las macros en Excel y cómo funcionan. Esto incluye la capacidad de grabar y editar macros, así como comprender el lenguaje de programación VBA (Visual Basic for Applications) utilizado para escribir y modificar código de macros. Requisitos del documento: Deben comprender claramente los requisitos y objetivos del documento de Excel que se está creando, incluyendo las funciones específicas que se espera que realice y los datos...
Hi. I need help to setup the binding for a RichTextBox .NET Control so that data is retained. There may be use of VBA that is needed. This is within a FactoryTalk View SE version 14 application. I don't know .NET or VBA, I am a FactoryTalk guy though. Example use case: Lets say a factory has 100 valves. If a user opens popup for Valve #3, I need a text box field in that popup for the user to enter data, and then data is preserved/saved. That popup should be one common FTV display that references the Valve_# that was selected (using parameter files, or...). This example is the main objective. I need a simple and easy solution to this, and I need to understand how to do it myself afterwards. This is perhaps a 1 hour job. My name is Marc. I'm ready to s...
...- Model Versioning: Unlike other models that auto-update or create new versions, I require a plugin that allows me to manually select the version to work with. This ensures control and adaptability to changing needs or scenarios. The Ideal candidate has advanced knowledge not only in plugin development but also a deep understanding of financial data and its complexities. Proficiency in Excel, VBA, and data management are key, along with a keen attention to detail and a commitment to accuracy. Experience in financial modeling is a big plus. Your ability to meet these specific needs could make a significant difference in my work. - I would like to do quick interactions of the project and rapidly develop the final product. My design does not require any database connection. -...
As someone struggling with certain aspects of Excel 2016, I need an experienced VBA Developer who can assist in creating custom Excel functions and rectifying existing Excel errors. Key duties will include: - Macros programming to automate repetitive tasks - Troubleshooting and fixing inaccuracies in the current Excel functions, if any Despite my lack of specificity about the exact functions or errors, I expect the developer to have a strong understanding of Excel functions in general and to use this knowledge to identify any issues that may exist. Ideal candidates should: - Have significant experience in VBA development - Have a solid understanding of custom Excel functions - Be proficient in troubleshooting & error handling in Excel 2016 - Demonstrate flexibility a...
I'm looking for a VBA programmer to help me with creating custom functions and macros for data analysis in Excel. Key Tasks: - Creating Macros: The project involves developing macros that can automate repetitive tasks and facilitate data analysis. - Building Custom Functions: I need custom functions to aid in data cleaning and manipulation, as well as report generation. Ideal Skills: - Proven experience in VBA programming, especially in Excel. - Strong background in automating tasks and data analysis. - Ability to develop custom functions for data cleaning and report generation. Output: - The generated reports should be in an Excel spreadsheet format, as well as a PDF document. Please provide samples of your previous VBA work, specifically any projects rel...
...público. - Promover la innovación y la mejora continua para fortalecer el Estado. 3. Relaciones Laborales y Negociaciones Colectivas - Asistir y asesorar en las relaciones laborales y negociaciones colectivas paritarias. - Promover la transversalidad y federalización de políticas para el empleo público. 4. Regulación del Empleo Público - Diseñar marcos regulatorios que aseguren eficiencia, eficacia, ética y efectividad en el empleo público. - Agregar valor a los servicios que brinda el Estado a la ciudadanía. 5. Carrera Administrativa y Concursos - Mantener actualizada la carrera administrativa a través de programas de movi...
...ability to extract insights from complex data sets and present them clearly is crucial. - Macro Development: You will be responsible for automating repetitive tasks in Excel, including generating reports, automating data entry, and creating efficient formula calculations. Your macros should be user-friendly and easy to maintain. Ideal Skills: - Proficiency in Excel, including advanced functions and VBA programming - Strong background in data analysis and visualization - Experience in creating macros for automation - Excellent communication skills to understand the project requirements and translate them into effective solutions This project is a great opportunity for someone looking to enhance their skills in advanced Excel-based roles and gain hands-on experience in data analy...
I am seeking a proficient VBA developer to help me create a set of macros in Excel. The purpose of these macros is to automate the process of generating multiple files from a base Excel file, specifically for the task of data analysis. Key Requirements: - The macros should be designed to create multiple Excel files from a single base file. The output files should maintain the formulas, formats, and templates of the original file. - The macro should be designed to run on a monthly basis. - The output files can have the same format with different data. The ideal candidate should have: - Proficiency in VBA and Excel - Experience in creating macros for data analysis - Ability to deliver a reliable, efficient, and well-commented solution. I need this to be delivered in the next...
I'm seeking for an expert in Excel VBA with strong debugging and troubleshooting skills along with the ability to optimize the performance of existing macros. The key responsibilities would be: - Debugging and troubleshooting my created Excel VBA Macros - Enhancing the efficiency and performance of these Macros - Inclusion of new features as required - And finally be able to explain the code for each module. What I'd really value is a clear and concise explanation of what each module does, and this requirement would be fulfilled best by providing detailed comments in the code. This project is perfect for anyone with a deep understanding of Excel VBA, Macro functionality, and a passion for clear and enlightening code documentation.
...manipulation, data analysis and reporting. The process is already mapped out and can be shared with you. - Using Pulover Macro and AHK, as well as VBA to facilitate the automation process. - Ensuring the automation process involves uploading files to Sharepoint, sending messages on Teams, and emails. The key deliverable for you is not just the completion of the automation process, but a clear and concise explanation of each step once the task is finished. This will be crucial for future troubleshooting and independent management. Ideal skills and experience for this role would include: - Advanced and proven experience in Pulover Macro, AHK and VBA - Proficiency in automating tasks in Microsoft Excel, as well as working with Sharepoint, Microsoft Teams and Email - Excell...
I'm looking for an expert in VBA and macros to help streamline my processes in Excel. Key Requirements: Shifts: Defined two shifts in the "task tap": Morning: 6:00 to 15:30 Afternoon: 14:00 to 22:30 Quality: Updated the agreed-upon columns in the "quality tap." And remove the error code if there is no any number Delays: Ensured delays are reflected as discussed. Task Order: Arranged tasks in the "task tap" from oldest to newest. Please review the file and let me know if you have any questions or require further changes. Requirements: 1- Required an option in this file (Excel) that when the planner change the completion date of any task in column K in the TASKS tap, the color of the cell will be changed to yellow, and a not...
Transformasikan template google sheets saya dari VLOOKUP menjadi Apps Script/VBA
I'm in need of an experienced Excel professional to help me build a secure data management system. This system will be used to handle both financial and customer information. Key Requirements: - **Data Security**: A robust system that...customer data. - **User Management**: The system should be designed for 1-10 users, allowing them to access and input data securely. - **User Experience**: While the users are expected to have advanced Excel skills, the system should be designed with clear interfaces and user-friendly features. Ideal Candidate: - Proven experience in designing secure data management systems in Excel - Proficiency in VBA and Excel's advanced features - Strong understanding of data security and privacy - Excellent communication skills to understand and mee...
I'm looking for an experienced VBA coder who can focus on two main tasks. 1. **Fixing Existing Issues:** - My current VBA code has issues with execution errors and incorrect results. I need solutions to these two problems. 2. **Adding Modifications:** - I'm looking for someone who can add additional features to my existing VBA code. - Good user experience is important too so improvements on the user interface would be very beneficial. Ideal candidates will have an excellent understanding of VBA syntax, debugging, and error handling. Experience with user interface design is also appreciated. The aim here is to produce accurate calculations, formatted data or reports swiftly and easily.
I'm looking to hire someone who can create an Excel VBA workbook to seamlessly integrate with my Zoho Desk setup. This workbook should be specifically engineered to perform the following: - Retrieve the required information from Zoho Desk tickets upon pressing a button inside Excel. Specifically, I need someone skilled in Excel VBA programming and API integration work to: - Design a user-friendly interface in the workbook where one can press a button to initiate the retrieval of ticket information. You should be able to retrieve the latest ticket, and then have two more buttons to go to next & previous tickets. - Implement secure API connections to Zoho Desk to enable the retrieval of ticket information usuing oauth. The fields I need are: Subject Account Name: C...
Hi Marcos Ariel C., I noticed your profile and would like to offer you my project. We can discuss any details over chat.
I'm seeking a proficient Excel VBA coder to create a system that automates data entry from Excel files. The task involves: - Creating a VBA function that can input data automatically into my current system. - Implementing a data sorting feature as part of the data entry process to ensure that all data is easily read and interpreted. The ideal freelancer should have the following skills and experience: - Proficiency in Excel VBA - Experience with automated data entry - A solid understanding of data sorting techniques. This project requires precision and attention to detail. It should not only meet the needs listed above but also enhance data accuracy and save time.
I'm seeking an experienced Excel VBA expert to help me automate some basic, repetitive data entry and formatting tasks. Key Requirements: - Automate basic data entry and formatting tasks in Excel - Develop VBA script to ensure automation runs smoothly Ideal Skills and Experience: - Proven experience in developing VBA scripts for Excel - Strong understanding of Excel functions and data formatting - Ability to create automation systems that run seamlessly without user interaction Please note, no user interaction is required for this project. The VBA program should be designed to run automatically once set up. This task is relatively simple but needs to be executed precisely and efficiently. Looking forward to working with a professional who can deliver ...
I'm seeking an expert in Excel and VBA who can work on an an existing financial model. The primary tasks will involve optimizing formulas, macros, and implementing data validation. I am looking for an hourly regular working engagement where the person will sit with me from time to time online and solve for things one at a time. I cant share workbooks as I have some IP related restrictions so person will have to work on my system, remotely. For Faridabad, Haryana based freelancers, we can do it in physical mode too. Key areas of focus will be: - Refining Formulas and Calculations. - Improving Data Organization and Management - Managing , improving the existing VBAs
...automating the transfer of information between those departments: linking the data, defining "trigger" events, and processing data from various inputs into "smart" trackers. I have a clear outline of what I want to accomplish - what data I need, who I need it from, and how I want the tracking of the inputs to function. My "coding" ability is a limited working-knowledge of JavaScript PDF and Excel VBA. I need someone to provide council and advise on what is possible, what tools or platform would be best for the end product I want to develop, and to advise on any alternatives. Basically, I am in the early stages of a long development process and I need an expert coder to review my outline and provide advise for the best way to accomplish what I want. ...
โปรดลงทะเบียน หรือเข้าสู่ระบบ เพื่อดูรายละเอียด
I require a VBA Developer well-versed in automating repetitive tasks in Microsoft Excel. Your primary task is to automate my existing work functions to increase efficiency. Key Responsibilities: * Understand the current Excel operations and identify scope for improvement. * Develop VBA codes to automate basic standard operations. * Test the robustness and accuracy of the automation. * Combining 2 files into 1 pdf. 1st file is pdf and 2nd is excel(with selected sheets, and selected columns within sheets) Desired Skills & Experience: * Proficient in VBA, specifically for Microsoft Excel. * Experience in automating repetitive tasks. * Sharp problem-solving and debugging skills.
Seeking a proficient Excel VBA developer to aid in the centralization and automation of tasks in Excel 2010. Project requirements include: - Expertise in Excel latest version - Strong understanding of EXCEL VBA for automation purposes. Please note, specific tasks and functions to be automated in VBA have yet to be defined. Flexibility and broad knowledge in different Excel functions will be considered an asset.
...essential to be an expert. Anyone with generic database experience (with different databases) can also apply. Skills already acquired from previously doing this work: - Understand database schema - understand database structures - create database tables based on bespoke requirements (training included) - Working with relatively large sets of data - has exporting skills into SQL - Excel and VBA, - Has experience in different querying languages - Proficient in Microsoft SQL Server Management Studio - Familiarity with Windows OS - Experience in handling multiple databases with SQL - Strong troubleshooting skills I currently manage over 11 databases via Microsoft SQL Server Management Studio, and my system operates on Windows. You would be working an 8hr paid day in the Austr...
I'm seeking an expert in Excel and VBA who can work on an an existing financial model. The primary tasks will involve optimizing formulas, macros, and implementing data validation. I am looking for an hourly regular working engagement where the person will sit with me from time to time online and solve for things one at a time. I cant share workbooks as I have some IP related restrictions so person will have to work on my system, remotely. For Faridabad, Haryana based freelancers, we can do it in physical mode too. Key areas of focus will be: - Refining Formulas and Calculations. - Improving Data Organization and Management - Managing , improving the existing VBAs
I need a knowledgeable Excel VBA specialist, with a background in data manipulation and analysis, to create a custom macro for my spreadsheet. - The macro's primary function is to automate the creation of new rows based on certain numeric values, namely the ones found in columns E to L on a specific sheet in the workbook. - Upon row creation, data from columns A to D should be copied over to the corresponding new row on another sheet. - Additionally, the macro should automate the assignment of values in cells from L to Q based on the count of numbers in rows created. The assignment of values is to be done using a simple addition or subtraction formula. The ideal freelancer should have solid experience in creating advanced Excel VBA macros, and a strong understanding...
...experienced MS Access developer to assist with my form development tasks. The ideal candidate is proficient in VBA (Visual Basic for Applications) coding and has the ability to design and implement forms based on my specifications. Key Responsibilities: - Designing and developing database structures based on my project requirements - Implementing VBA code for basic functionalities such as form submissions and data entry automation - Creating forms in MS Access based on a specific design I have in mind - Ensuring the database and forms meet quality standards and are user-friendly Ideal Skills and Experience: - Proven experience in database design and development using MS Access - Proficiency in VBA coding, particularly for basic functionalities - Previous experienc...
I am interested in creating an Excel VBA macro that will allow me to import PDF invoices into line items and parse them. The objective of this project is to streamline the process of invoice data entry by automating the extraction of key information from incoming PDF invoices, namely Invoice number, Vendor name, Pricelist, and Detail. The successful freelancer for this project should have: - Demonstrated experience in creating VBA macros for Excel - A strong understanding of PDF parsing and data importation - Knowledge of accounting principles is a plus The imported data should ideally be formatted in Excel as: - Each PDF invoice should be translated into a single row - The extracted information should be available in separate columns for each piece of information.
