Sortere data efter dato med vbapekerjaan
Saya memerlukan servis untuk designkan interface system. System ini menggunakan microsoft excel VBA. Cod Macro sudah ada, just untuk tukar design sahaja
...الرَّحِيم السَّلاَمُ عَلَيْكُمْ وَرَحْمَةُ اللهِ وَبَرَكَاتُهُ "Dan di antara tanda-tanda kebesaran Allah itu bahawa Dia jadikan bagi kamu pasangan hidup agar kamu mendapatkan ketenangan/kebahagiaan bersamanya. Kemudian Allah ciptakan di antara kamu berdua mawaddah dan rahmah." (Surah Ar-Rum, ayat 21) Dengan rasa hormat dan penuh rasa kesyukuran ke hadrat Allah S.W.T saya sekeluarga ingin menjemput Dato’/Datin/Tuan/Puan/Encik/Cik seisi keluarga ke majlis perkahwinan saya dan pasangan, HAZUANI ❤️ FAKHRUDDIN Pada ketetapan berikut ; Ahad l 12 December 2021 bertempat di : Lot 889,Kg Atas Tol,21070,Kuala Terengganu,Terengganu ⏰9am - 4:00pm Kami sekeluarga memohon maaf kerana tidak dapat memanjangkan jemputan kerana situa...
Membuat dokumen list kertas A3 Membuat template dokumen laporan harian Menggunakan kertas ncr Membuat template dokumen laporan mingguan kertas legal Membuat tenplate dokumen laporan bulanan / rekap kertas legal Membuat template dokumen RAP Membuat template curva s Intinya membuat template dokumen Antara sheet dan sheet terhubung antara 1 dan lainnya menggunakan rumus atau vba dan menggunakan pivot
125k canada - Toronto + Ottawa 125k Malaysia - Kuala Lumpur Bukit Jalil Golf and Country Resort Parts of Bangsar, Dato Keramat, Hartamas Damansara, Ampang TAR non duplicate records.
Melakukan sejumlah pekerjaan Excel Mampu mengoperasikan Ms Excel Mampu mengoperasikan Ms Word Mampu mengoperasikan Adobe Photoshop ++Design Grafis,membuat logo pada Adobe Photoshop dan Corel Draw ++mengoperasikan Ms Excel dan menguasai VBA project dan formula pada excel.
Membuat aplikasi VBA- excell untuk tracking portofolio saham dengan ketentuan sbb: 1. Menggunakan Real time data (1-5 min) 2. Update data saham secara otomatis ke portofolio saham 3. Dapat melakukan penambahan dan pengurangan transaksi saham pada portfolio 4. Dapat melaklukan sorting berdasarkan Nama saham, keuntungan (jumlah atau %), berdasarkan tanggal masuk 5. Record data tiap transaksi pada portofolio
...Requirements: Platform: Microsoft Excel and Outlook. Preferred Methodology: VBA for seamless integration with Microsoft Office suite. Other suggestions are welcome if they provide a better solution. Deliverables: Automated Excel Workbook: An Excel file with VBA scripts to automate data entry, courier selection, and order form generation (if chosen methodology). VBA scripts to automate sending and receiving emails via Outlook (if chosen methodology). Documentation: Detailed documentation on how the automation works, including instructions for use and troubleshooting. Testing and Support: Initial testing of the automated system and support for any issues that arise during the first month of operation. Skills Required: Proficiency in VBA for Excel and...
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
...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 integration &...
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(&quo...
Necesito generar deshboard y gráficos en Power bi desde 4 bases de datos • 1 base de dato en postgresql corporativa en aws • 1 base de datos en sqlserver en un servidor local • Google Analytics • Zendesk Son aproximadamente 50 gráficos personalizados con los que necesitamos hacer algunos dashboard de gestión. Es importante dejar documentado el trabajo y respaldadas las consultas en sql. Indispensable: • Dominio de Power BI • Experiencia previa en la creación de paneles para ejecutivos • Capacidad para integrar datos de bases de datos Indicar los accesos requeridos y los requerimientos tecnológicos para desarrollar el proyecto
I'm seeking a bilingual English/Chinese speaker to assist in corresponding with a pharmaceutical supplier in China. Your primary role is to facilitate Ideal Skills and Experience: - Fluent in English and Mandarin - - Great understanding of international trade and regulations surrounding medication procurement.
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.
in need of a skilled photoshop designer who can create Facebook and Google ad sets for my med spa. The main goal of these campaigns is to generate leads. Please upload as samples for each treatment below and making sure all ads would be compliant to Facebook and google guidelines I will need 1 ad per treatment for our med spa for the following services. Once hired we will need 5 color variations for each ad. Key Treatments: - The ad sets will focus on a range of treatments, including Morpheus8, tri-Lift, Vampire Facials, and PRF Microneedling. - The ads should highlight the benefits of these treatments and why they are the perfect solution for anti-aging. Target Audience: - The target audience for these ads are individuals looking for anti-aging solutions. - They ar...
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...
...en el pasado). aqui una referencia de lo que hablo: Y responda por favor a las siguientes preguntas al enviar su oferta: 1: ¿Que programas necesitamos ambos para ejecutar el programa? 2: ¿Cuanto es el cobro total por tu trabajo en dolares? 3: ¿Puedes poner una opcion que me permita darle feedback al chatbot? ¿Y puedes ponerle "memoria"? 4: ¿Algun dato que deba saber sobre este contenido/tema? 5: Si tiene una pregunta especifica sobre el proyecto comentela en este punto. 6: ¿En que tiempo finalizas el trabajo? Las funciones son en ingles pero los mensajes que emite al "hablar" son en español (al menos lo basico). I don't really know anything about programming but I can at least understand some concep...
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...
Behöver få till de sista tekniska bitarna på denna mobil App innan vi låter en grupp testköra den. Har flera kunder som är intresserade men vill vara helt klar med slutgiltig produkt och tester innan marknadsföringen. Är du den person som får tekniken slutgiltigt på plats får du vara med på resan och erbjuds del i företaget.
Need a banner recreated. immediately. Top I need my logo under logo I need my QR code Under QR Code i need it to say No Med Card Needed under tihs i need an arrow pointing left under the arrow i need a phone number under phone number i need all my social icons and social tag
I'm seeking a skilled professional to develo...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 b...
...need them consolidated based on a unique index number. The task involves the following: - Data consolidation: Retrieve name and email information from several Excel sheets using a base index number from a primary data file. - Automation: I need this 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 Optimi...
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.
Sila Dafter atau Log masuk untuk melihat butiran.
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 integ...
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.
...for me. The software should primarily focus on automating spreadsheet tasks and presenting data in a visual manner. Key Requirements: - **Spreadsheet Automation**: I'm seeking a solution that can automate 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 wi...
Job Title: Social Media Video Editor for Med Spa Job Overview: We are a dynamic Med Spa seeking a creative and experienced Social Media Video Editor to produce compelling reels that capture the essence of our brand and engage our audience. This role requires editing approximately 3-5 videos per week, with the goal of creating viral content to enhance our online presence. Each video will range from 10-60 seconds, and a custom cover photo will need to be designed for each video. We will provide raw footage and examples to guide the editing process. Responsibilities: Edit 3-5 short videos per week to create engaging and visually appealing content for social media platforms, particularly Instagram Reels and TikTok. Create captivating cover photos for each video to attract view...
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 ...
Jag önskar en logotyp till min nya restaurang. Restaurangen heter Pargolan och ligger vid havet med fransk inriktning, på restaurangen serveras franska viner och maträtter. Det ska vara en cool och modern logotyp, ingen flagga. Restaurang Pargolan är en dotterbolag till Bistro Casper, jag bifogar Bistro Caspers logotyp här. Vektoriserad logotyp Tack.
...material usage, stock alerts, etc. 10. **Stock Alerts:** - Implement 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 ...
...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....
As the client, I am looking for a reliable professional to build a customized Excel plugin that will enhance my financial data management. Key Features: - Automatic Calculations: The plugin should be capable of performing automatic calculations, saving time, and minimizing any possible errors. - Data Validation: Ensuring data accuracy is crucial, thus the plugin should include data validation steps that help identify and correct any inaccuracies promptly. - Customizable Formatting: To enable smoother navigation and interpretation, the plugin should allow for customizable formatting tailored to my data and personal preferences. - Model Versioning: Unlike other models that auto-update or create new versions, I require a plugin that allows me to manu...
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 ...
Necesito combinar un archivo excel que lo extraigo de un programa extranjero (1r archivo), y que debe añadir de otro archivo (plantilla proveedores) un dato para obtener una excel final (plantilla). El programa debe permitir insertar el archivo inicial, que consulte otro excel para añadir su CIF (el software es extranjero i no lo incluye) i transformarlo en el final (plantilla). Lo suyo sería, inserte archivo inicial, para extraer el archivo final
...can help me with two specific aspects of my project: performing advanced data analysis and creating macros to automate repetitive tasks. Key Requirements: - Data Analysis: You should be well-versed in data visualization, statistical analysis, and data cleaning and manipulation. Your 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...
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 ...
Si eres experto en una de estas áreas, en varias o idealmente en todas, quiero saber de ti. Envíame una propuesta con información relevante, tu experiencia, conocimiento y expertise y cualquier dato de interés que pueda servirme para saber más sobre ti.
...detail-oriented professional to help me create a comprehensive menu for my new med spa. The ideal candidate should have a good understanding of the med spa industry and have experience in menu creation. Key deliverables include: - Inclusion of these services: Facials, Body treatments, Lasers, Injectables - Incorporating specific types of facials: Hydrating, Anti-aging, and Acne treatment - Designing and explaining specific types of body treatments: Cellulite treatments The project involves understanding my med spa's target market and ensuring the menu is attractive and informative for potential clients. Ideal skills and experience for this job include: - Previous experience in med spa menu creation - Knowledge of the med spa industry - Strong...
I am in need of appointment setters/customer service ag...telemarketing. Key Responsibilities: - Making cold calls: You'll be reaching out to potential clients to promote our med spa services. - Scheduling appointments: You'll need to have a good sense of our availability and be able to assist clients in booking appointments. - Answering customer inquiries: You'll be the first point of contact for many clients, so you'll need to be able to answer their questions and provide information about our services. The ideal candidate will have: - Proven experience in telemarketing or cold calling - Strong communication skills, especially over the phone - A good understanding of customer service principles - Prior experience in the med spa industry is a big plu...
...vivo (no grabados) serán entre las 15:30h y las 17:30h (horario español) para compatibilizarlo con colaboradores del continente americano. IMPORTANTE: todo interesado debe contactar indicándonos claramente: a - Su experiencia en los campos solicitados b - Su tarifa c - Su disponibilidad (comienzo, dedicación diaria/mensual, duración de la colaboración) d - Cualquier dato que pueda aportar interés para nuestra empresa (recomendamos visiten previamente nuestro portal ) NOTAS ADICIONALES: - Se admiten tanto equipos ya configurados de trabajo o freelancers independientes - Comienzo de los seminarios de manera inminente - Es una oportunidad excelente para freelancers que quieran tener un tr...
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.
...include: - Automating a series of tasks in Microsoft Excel. This includes data 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 tas...
I'm seeking a talented graphic designer with a strong grasp of Canva to craft an appealing and interactive e-book template targeted at university students studying medicine. Key Requirements: - Sections: The e-book should include sections on Study tips, Note-taking techniques, medical pneumonics, and a daily planner. Each of these should be clearly demarcated and designed to be visually engaging. - Length: The e-book template should have approximately between 10-20 pages. The goal is to provide comprehensive yet easy-to-digest content. - Interactivity: The e-book should not be a static document. I need it to be interactive like a workbook, featuring elements like fillable text fields, clickable links, and checkboxes for task completion. The interactive elements should be well-i...
