For loop vbaproiecte
Suntem o companie multinationala care presteaza servicii in industria automotive si cautam ingineri pe teritoriul Romaniei pentru testarea soft-ului auto. Se va lucra remote dupa perioada de training. Cunoasterea limbii germane este obligatorie, iar engleza reprezinta un plus. De preferat sa aiba cunostinte de Matlab / Simulink, VBA or Python.
Se da urmatorul scenariu: Incazari in data de x,y sau z la locatia x, y sau z cu un echipaj variabil de 1, 2, 3 sau mai multi. Am nevoie sa extrag(copiez) informatia si sa o pun la fiecare om din echipaj in sheet separat. am incercat cu filtre si macro dar imi copiaza doar informatia de la prima coloana de echipaj. se poate cu alta formula sau cu VBA (cod)
Am nevoie sa modific / imbunatatesc cateva fise Excel pe care le folosim zi de zi in munca noastra. Am nevoie de cineva cu cunaostinte foarte bune de programare in Excel sau VBA
problema pagina login.php. dupa logare face loop si trimite pe nu in admin.
Dezvoltare Aplicatie Excel/VBA prin dezvoltarea unor module noi conectabile la aplicatia deja existenta. Aplicatia in cauza gestioneaza activitatea de comenzi, pregatire, expediere si facturare marfa, intr-o companie mica.
I am Shubheem here given to you work Dezvoltare aplixatie -Excel- VBA pentru optimizarea, activitatii ,depozitare,gestiune see transport here work is Vrem sa optimizam si sa dezvoltam in continuare o aplicatie pe care of folosim pentru optimizarea activitatii in firma
Vrem sa optimizam si sa dezvoltam in continuare o aplicatie pe care o folosim pentru optimizarea activitatii in firma. Avem de nevoie de o persoana cu cunostinte de programare VBA . Aplicatia pe care o folosim lucreaza in tandem cu aplicatia WinMentor asa ca sunt necesare si anumite cunostinte despre acesta din urma.
Vreau sa creez o funcție (VBA) care sa convertească un fișier txt în Excel la apasarea unui buton. (function)In acelasi timp sa se poata Introduce manual calea de unde se ia fisierul txt respectiv, unde va pune fisierul excel, anumite informatii adaugate manual. Am anexat mai jos cum arata fisierele text (2 tipuri de format) si de asemenea cum trebuie sa arate pentru fiecare (example 1 si 2).
Buna ziua. Am un proiect personal, care implica realizarea unui tabel excel complex, (1000linii) si as dori sa filtrez aceste date, conform cerintelor mele. Se vor folosi macros si vba, deci am nevoie de cineva care chiar stie sa lucreze in excel. Cei care stiti sa faceti o comparare intre doua coloane, dar asemanarea sa fie de 85%, puteti sa ma contactati.
Salut Sergiu, Am gasit profilul tau pe Freelancer si am vazut la sectiunea Skills ca stii VBA si Excel. Am un proiect despre care as vrea sa discut cu tine. Ma poti contacta la adresa de email @
Buna ziua. Am un proiect personal, care implica realizarea unui tabel excel complex, (1000linii) si as dori sa filtrez aceste date, conform cerintelor mele. Se vor folosi macros si vba, deci am nevoie de cineva care chiar stie sa lucreze in excel. Cei care stiti sa faceti o comparare intre doua coloane, dar asemanarea sa fie de 85% ca si caractere, puteti sa ma contactati.
cod vba excel , sa copii valoare din pagina 2 in pagina 1 cu indeplinirea 3 criteri , vezi imaginele atasate
Am nevoie de cineva care sa ma ajute sa transcriu o problema de mecanica in VBA. Multumesc.
Am un site finalizat si functional wordpress care din nu stiu ce motive da eroare Loop Detected si se opreste. Am nevoie de cineva care sa verifice daca nu cumva vreunul din plugin-uri provoaca aceasta eroare
Am nevoie de o persoana care sa stie bine Linux si platformele de email marketing Interspire si/sau Oempro plus PowerMTA. Trebuie sa stie sa seteze/configureze : - DKIM - SPF - rDNS - Feedback Loop - IP rotate - Multiple MTA (Mass Transfer Agent) - PowerMTA Management - IP Reputation Management, etc. Pe scurt, trebuie sa stie sa faca în asa fel încât sa trimitem cat mai multe email-uri în inbox :)
Am un proiect neterminat, am nevoie de cineva care stie VBA Excel sa il poata incheia. Liciteaza doar daca ai experienta in VBA, proiectul nu este chiar usor de inteles si realizat, pentru cine are experienta insa dureaza f putin de incheiat.
te rog sa ma anunti daca esti disponibil in a ma ajuta intr-un project excel vba. e un singur elgoritm de corectat. chstie de cateva minute. mersi
Am un proiect aproape terminat si abandonat. Nu este foarte amplu, Am nevoie de cineva care il poate incheia. Este in Excel VBA si voi trimite specificatii pe mail celui interesat. Multumesc!
Locatia de realizare a proiectului: Brasov la sediu firmei Consultanta si suport pentru: Migrare aplicatie realizata din VBA in C# Migrare de la lucru cu tabele excel la tabele Access si SQL Realizare Interfata Profesionala in C# Realizare legatura intre Interfata relaizata in C# si tabele realizate in Access sau SQL Realizare strucura logica de organizare interna a datelelor din tabelele in Cccess sau SQL Relizarea "Relationships" intre tabele in access Teste
...septic tank. We want to go with a Horizontal ground closed loop for the geothermal heat and AC. - We are thinking more of removing dirt on the high side to make a more level area for the house but are good with supports for the down hill side of the house - I need floor plans, blueprints, and if reasonable a material list - Just for clarity downhill is from the back of the property towards the road and after we cut some trees it is a beautiful view. If looking at the property from the road, the driveway will need to be along the left side of the property. Key requirements: - Design a single-floor barn-dominium style house - Prioritize an open interior, characteristic of barn-dominiums - Ensure the design is structurally sound for the sloped...
...Store Inventory Management System. It's crucial for the system to streamline inventory tracking, significantly enhance order processing efficiency, and provide robust reporting capabilities. To create a custom inventory software tailored to the requirements of a folding and sliding door manufacturer workshop, you'll need to develop a comprehensive solution that encompasses the entire workflow. Here's a breakdown of how you could approach each step: 1. **Job Order Management:** - Allow users to create job orders with reference numbers for each project. - Capture project details such as customer information, project specifications, deadlines, etc. 2. **Requisition to Store:** - Enable users to create requisitions for materials needed for...
...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 que debe m...
...in operation for more than 5 years and recently experienced a failure leading to no cooling and ultimately, the breakdown of the heat exchanger. Key Tasks: - Conduct a thorough evaluation of the chiller system - Identify the root cause of the failure that led to no cooling - Investigate and pinpoint the specific issue with the heat exchanger Your expertise in HVAC and chiller systems will be essential to resolving this issue. Previous experience with such evaluations and maintenance in industrial or commercial settings is highly preferred. Note the evaluation must be done through evaluation of history and notes as the failed system has been replaced and no longer available. This project is to offer an expert opinion on the failure in attempts to dispute an insurance claim ...
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 manually select the versi...
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, specific...
As an advanced Excel user, I'm looking for a professional who 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 - Stron...
As the client, I need a Photoshop expert to artistically add turf behind and in front of the pool please. The final image should be an angled view, showcasing the newly added turf in the most effective wa...should bring to the table: - Proven experience in Photoshop editing, specifically in outdoor makeovers or landscape improvements. - An understanding of angles and perspectives in photography, to create the requested angled view convincingly. - Attention to detail meticulously, ensuring the turf appears organic, not just copy-pasted. - Prompt communication, keeping me in the loop with the progress. Photographers with a knack for editing will be highly appreciated, but the decision will come down to the quality of your portfolio and the ability to provide a quick and effe...
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 deliver...
...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 - Excellent communication skills, as the explanation of each step will be vital for...
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 documentat...
...additional pages for custom post types. The first page is an Archive page & the second page is the Search Results Page, both only for a certain post type, as described below. Archive page: This is only to show custom post type = fs_ski_resorts. There should be 10 results per page and there should be pagination at the bottom. At the top of the page, there should be a search bar. The search bar should only return custom post type = fs_ski_resorts. The layout is to be per the attachment. Search Results Page: This should by a separate search results page as it should only return custom post type = fs_ski_resorts. The layout should be the same as per above. The search results page should have a search bar at the top of the page and be populated with what text the...
I'm a beginner in Ableton Live, seeking a private tutor who's experienced with both this DAW and the Arturia synthesizers and it's Plug-Ins, as well as the Boss RC-202 loop station. My main goal is to learn how to produce electronic, ambient music, house music and alternative music. Key Requirements: - Proficiency in Ableton Live: You must be an expert in using Ableton Live and be able to teach it effectively to a beginner. - Experience with Arturia Synthesizers: Ideally, you should have hands-on experience with the Arturia range of synthesizers. - Familiarity with Boss RC-202: Knowledge of the Boss RC-202 loop station is a must, as I'd like to incorporate it into my production process. Your Responsibilities: - Assisting me in understanding Ablet...
...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 no...
Instructions: 1. Create Video Card a) Change your video editing software Resolution settings to 576x896 before you start b) You may chop up the video, reverse it, loop it, or my favorite thing to do: Let it play, duplicate it, reverse the duplicate, so the video is double the length. c) Ask CHAT#$% for a list of scary/demonic/terrifying/spooky/weird names, try a few different names 2. Animate the writing and Dice.... if you think it looks good, possibly add cool effects/Ai tools/Ai animation/Video enhancement. Do whatever you think is best 3. Add sound (****Please use ONLY 100% Vector copyright free sounds and FX (full commercial use only)(No Attribution required) (Same with the Ai) 4. Add moving watermark or seal entry 5. Upload final work as .mp4 Dice:
Transformasikan template google sheets saya dari VLOOKUP menjadi Apps Script/VBA
Instructions: 1. Create Video Card a) Change your video editing software Resolution settings to 576x896 before you start b) You may chop up the video, reverse it, loop it, or my favorite thing to do: Let it play, duplicate it, reverse the duplicate, so the video is double the length. c) Ask CHAT#$% for a list of scary/demonic/terrifying/spooky/weird names, try a few different names 2. Animate the writing and Dice.... if you think it looks good, possibly add cool effects/Ai tools/Ai animation/Video enhancement. Do whatever you think is best 3. Add sound (****Please use ONLY 100% Vector copyright free sounds and FX (full commercial use only)(No Attribution required) (Same with the Ai) 4. Add moving watermark or seal entry 5. Upload final work as .mp4 Dice:
Instructions: 1. Create Video Card a) Change your video editing software Resolution settings to 576x896 before you start b) You may chop up the video, reverse it, loop it, or my favorite thing to do: Let it play, duplicate it, reverse the duplicate, so the video is double the length. c) Ask CHAT#$% for a list of scary/demonic/terrifying/spooky/weird names, try a few different names 2. Animate the writing and Dice.... if you think it looks good, possibly add cool effects/Ai tools/Ai animation/Video enhancement. Do whatever you think is best 3. Add sound (****Please use ONLY 100% Vector copyright free sounds and FX (full commercial use only)(No Attribution required) (Same with the Ai) 4. Add moving watermark or seal entry 5. Upload final work as .mp4 Dice:
Instructions: 1. Create Video Card a) Change your video editing software Resolution settings to 576x896 before you start b) You may chop up the video, reverse it, loop it, or my favorite thing to do: Let it play, duplicate it, reverse the duplicate, so the video is double the length. c) Ask CHAT#$% for a list of scary/demonic/terrifying/spooky/weird names, try a few different names 2. Animate the writing and Dice.... if you think it looks good, possibly add cool effects/Ai tools/Ai animation/Video enhancement. Do whatever you think is best 3. Add sound (****Please use ONLY 100% Vector copyright free sounds and FX (full commercial use only)(No Attribution required) (Same with the Ai) 4. Add moving watermark or seal entry 5. Upload final work as .mp4 Dice:
Instructions: 1. Create Video Card a) Change your video editing software Resolution settings to 576x896 before you start b) You may chop up the video, reverse it, loop it, or my favorite thing to do: Let it play, duplicate it, reverse the duplicate, so the video is double the length. c) Ask CHAT#$% for a list of scary/demonic/terrifying/spooky/weird names, try a few different names 2. Animate the writing and Dice.... if you think it looks good, possibly add cool effects/Ai tools/Ai animation/Video enhancement. Do whatever you think is best 3. Add sound (****Please use ONLY 100% Vector copyright free sounds and FX (full commercial use only)(No Attribution required) (Same with the Ai) 4. Add moving watermark or seal entry 5. Upload final work as .mp4 Dice:
Instructions: 1. Create Video Card a) Change your video editing software Resolution settings to 576x896 before you start b) You may chop up the video, reverse it, loop it, or my favorite thing to do: Let it play, duplicate it, reverse the duplicate, so the video is double the length. c) Ask CHAT#$% for a list of scary/demonic/terrifying/spooky/weird names, try a few different names 2. Animate the writing and Dice.... if you think it looks good, possibly add cool effects/Ai tools/Ai animation/Video enhancement. Do whatever you think is best 3. Add sound (****Please use ONLY 100% Vector copyright free sounds and FX (full commercial use only)(No Attribution required) (Same with the Ai) 4. Try to seal Entries so nobody can see your work, add moving watermark 5. Upload fina...
Instructions: 1. Create Video Card a) Change your video editing software Resolution settings to 576x896 before you start b) You may chop up the video, reverse it, loop it, or my favorite thing to do: Let it play, duplicate it, reverse the duplicate, so the video is double the length. c) Ask CHAT#$% for a list of scary/demonic/terrifying/spooky/weird names, try a few different names 2. Animate the writing and Dice.... if you think it looks good, possibly add cool effects/Ai tools/Ai animation/Video enhancement. Do whatever you think is best 3. Add sound (****Please use ONLY 100% Vector copyright free sounds and FX (full commercial use only)(No Attribution required) (Same with the Ai) 4. Try to seal Entries so nobody can see your work 5. Upload final work as .mp4 Dice:
I'm in need of an experienced Excel professional to help me build a sec...handle both financial and customer information. Key Requirements: - **Data Security**: A robust system that ensures the privacy and integrity of the financial and 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 ...
I am seeking a professional website designer who can make an intuitive and engaging digital library for sustainable development goals (SDGs). This platform is intended to serve both students and the general public. The website functionality should include: - A powerful search function that makes it easy for users to find specific information. - An extensive collection of online reading materials related to each SDG. - Interactive quizzes to test user knowledge and engagement. - A curated drop-down list of book recommendations for each SDG. - A dedicated section for book reviews to create a community feedback loop and promote engagement with the content. - An "About Us" section highlighting the program, founders, and further relevant infor...
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.
...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: Contact Name: Date Created: Ticket Number: The...
Need to recount the stock quantity based on approve order (Write script to run it) Loop all the orders one time to get latest remaining value. Able to work with ftp. Laravel work. (Not amend source code, or bugs) Start immediately.