Vba projektPekerjaan
As a frequent user of Microsoft Excel, I'm looking for a skilled professional to design and implement a powerful goal ...of performing multiple cell goal seek operations. This means it should be able to iterate through several scenarios until a set of conditions are met. - **User Interface:** I prefer to trigger this macro through a button click within the spreadsheet. **Ideal Freelancer:** To successfully complete this project, you should have: - Proficiency in Microsoft Excel, including advanced knowledge of VBA and macros. - Previous experience with developing goal seek macros. - Strong attention to detail and a commitment to delivering a high-quality, error-free product. If you're confident in your ability to create a reliable, efficient macro for my needs, I'...
I am looking for a certified Excel and VBA expert to help me refine an existing financial model. I am looking for a two-days online working engagement where the person will sit with me online and solve for things one at a time. 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
Cześć! Szukam osoby do napisania pracy przejściowej, która będzie później w pewien sposób wykorzystywana w pracy inżynierskiej. Praca obejmuje np: projekt CAD osprzętu roboczego maszyny roboczej i obliczenia. Więcej info priv.
I need an expert to create a system where a rest hours sheet is integrated with a database within the same workbook in Microsoft Excel. Key requirements: - The integration should be made using VBA Macro or simple cell reference. - The database should store information about individuals, leaving out any date, hour or minute details. - The database requires no regular updates triggered by specific events. Ideal skills and experience: - Proficiency in Microsoft Excel - Experience in working with VBA Macros - Understanding of data management in Excel
I am in immediate need of a freelancer skilled in VBA & .net for the development of a yet disclosed project. The ideal candidate must be proficient in all aspects of VBA and have the ability to deliver quickly given the urgency of this project. Key Requirements Include: - An in-depth understanding of VBA - Proven track record of successful projects - Ability to work under tight deadlines Completion of the project needs to be as soon as possible. If you have extensive VBA experience and can work in a fast-paced environment, I enthusiastically encourage you to bid on this project.
...and warehousing: Proficiency in using AWS S3, Athena, Glue, and other analytical services - Data analysis and visualization: Delivering insights through efficient data analysis and visualization techniques Ideal candidates for this role should have: - Experience with MS Fabric, specifically working with Lakehouses, Warehouse, SQL Endpoint, Data Flows, and Notebook - Proficiency with SQL Server, VBA, and SAS - Previous work with AI/ML algorithms - Exceptional knowledge of AWS services, including S3, Athena, and Glue - Familiarity with GCP storage and Big Query - Competence in using Power Query for data manipulation and transformation Your skills and experiences will play a crucial role in ensuring the successful delivery of this project, so please be sure to highlight your previ...
...automatically format cell values. I will provide the existing format and the new format that I want. - It should be able to add text boxes to specific cells in the Excel file. The content of the text boxes will vary depending on the content of the respective cells. - The tool should allow me to delete specific columns based on the value in a particular cell. Ideal Skills: - Proficiency in Excel macros/VBA - Prior experience in customizing Excel files - Good communication to understand my needs and implement them accurately I have an excel sheet with production data, the file has extra data that i do not need, so i need Macros to delete certain columns, change column widths, change column names, wrap text if needed, add several text boxes that will appear on the output file if f...
Se realizará un script de python el cual permitirá automatizar un proceso de creación de libros de excel de acuerdo al flujo existente de unas macros, adicionalmente el programa debe ser capaz de ofuscar el código de vba e impedir la edición del mismo, El proyecto se realizará en google colab, de forma que pueda ser ejecutado desde cualquier dispositivo con conexión a internet y cuente con acceso al programa.
Musi być zrealizowany projekt dla pracy inżynierskiej. Filmik, w którym krok po kroku pokazują się etapy rekrutacji na uczelnię. Więcej już w priv. Example:
Hi Dhaval C., ich habe Ihr Profil gesehen und würde Ihnen gerne mein Projekt anbieten. Wir können alle Details über den Chat besprechen.
1) VBA script that creates the excel file you want, 2) Python scipt that does the whole webscraping procedure and saves the data in the excel file named "" in the "Downloads" folder.
Tengo macros vba para excel que quiero transformar a python (la macro crea copias de un archivo base a otros siguiendo una lista con nombres especificos), y este poder ejecutarlo en un servidor online, tambien requieor un offuscador que inhabilite el acceso al proyecto vba de los libros excel. xslm generados por el codigo. 01 primeramente el resultado final sera que el codigo python actue de la misma manera que la macro (per con archivos alojados en gdrive) 02 offuscador y proteccion a los archivos excel generados 03 - Implementar la ejecucion del codigo python de manera online
I need an expert in Excel VBA to help automate complex, repetitive tasks within my large sets of Excel data. Key Responsibilities: - Developing a VBA script to automate repetitive tasks in Microsoft Excel - Implementing PivotTables, Macros, and other advanced functions - Ensuring the automation is efficient, reliable, and error-free Ideal skills for this project include: - Advanced knowledge of Microsoft Excel - Extensive experience in VBA scripting, particularly with automation of complex tasks - Proficiency in creating and working with PivotTables - Strong understanding of Macro creation and modification Please bid on this project if you have the necessary experience, skillset, and can ensure the automation meets the required standards of efficiency and accuracy.
Hallo Claudia A., ich habe Ihr Profil gesehen und möchte Ihnen mein Projekt anbieten. Wir können alle Einzelheiten im Chat besprechen.
I have 1 unfinished Access/VBA project. I need assistance to finish the project. The project require the developement of Access forms, VBA code and Generation of reports. My estimation is 3 working days. Max budget : 100$ Thanks for you bid
...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...
In need of a skilled Microsoft Access VBA expert to establish various functionalities on an ongoing project. This will include, but not be limited to, creating data entry forms, generating reports, and maintaining the database. Ideal Skills: • Experience in MS Access and VBA is mandatory • Familiarity with creating user-friendly interfaces • Proficiency in designing and maintaining database structures • Expertise in automation of repetitive tasks and processes • Knowledge in data analysis using Access If you have any relevant past work or specific experience in the areas mentioned, feel free to include them in your application. In-depth project proposals are also welcome and will be beneficial in the selection process. The main purpose of the pro...
>> Nur Deutschsprachige, only German speaking Freelancer! Die TravelBroker suchen einen API Coder/Pr...server-side scripting (PHP) / XML Kommunikation für Hotel Raten, Verfügbarkeiten und übliche Buchungsdaten bei einer Hotelbuchung. Projekt Angaben: -API Doku in Englisch sauber und einfach vorhanden -Buchungskalender schon fertig im Standard -Überschaubare Anpassungen und Integration benötigt -Dauerhafte und langfristige Remote Zusammenarbeit via Mail, Trello od. Slack -Hohe IT und Coding Verständnis bei uns vorhanden, das erleichtert unsere Zusammenarbeit enorm! -Sie haben nur einen Ansprechpartner dauerhaft! Bitte kontaktieren Sie mich mit Ihrer Vita und ggf. Referenzen sowie Ihrem Stundensatz. Nach Ihrer Kontaktaufnahme erhalten Sie weite...
I am looking for an Excel VBA script coder to assist me with a project for generating tags for e-commerce products from the description. Products are car spare parts. Need to tag the products with names of make, model, variant. Specific requirements: - - Generate tags for e-commerce products in a excel sheet. The product description is saved in Column A and the tags should be generated by referring to the list of available tags. Please see the excel sheet attached here. _ One product can have multiple tags associated with it from the tags list, The VBA script should run and generate tags while referring to the data in other sheets for tag names. Please see the excel sheet attached. Ideal skills and experience: - Proficiency in Excel VBA script coding - Strong unders...
...systemu. 8. System reklamowy umożliwiający użytkownikiem umieszczanie reklam 9. System komentarzy umożliwiający wystawianie komentarzy firmom. 10. System NEWS oraz śledzenia nowości użytkownika 11. Opcje Social Media ( obserwujący, polubienia) 12. Panel administrator umożlwiający pełna kontrolę nad systemem Jak zacząć współpracę: 1 Zastanów się bardzo dokładnie czy jesteś w stanie wykonać ten projekt, jeżeli nie masz wystarczającego doświadczenie nie marnuj mojego oraz swojego czasu. 3. Jeżeli masz pytania niejasności skontaktuj się zemną na email lub telefonicznie ustalimy wszystkie nieścisłości, aby obie strony dokładnie wiedziały co trzeba zrobić. 4. 5. Bardzo mile widziana jest kreatywność, nie wszystkie funkcje mogłem wymyśleć, jeżeli uważasz że coś tr...
Develop VBA code to meet your requirements
I have a highly encrypted XLSM file that I urgently need help with. This specific project involves making VBA in the file visible. I need someone with advanced VBA skills and experience in cracking down highly encrypted XLSM files. Key requirements: - Expertise in VBA for Excel - Experience with highly encrypted XLSM files - Ability to make VBA visible in such files Please only apply if you have previous experience in this area and can start immediately. BID NOW!!! Serious freelancers only with the skills since it is ASAP!!
I am in need of a professional who has experience using VBA in MS Project to automate the process of generating project summary reports. So the person MUST have Ms Project experience to understand how project constructs data. 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 ESSENTIAL. I&...
I'm in need of an Excel VBA expert who can assist me with writing macros and automating data entry in my spreadsheets. The primary goal of these macros is to automate the data entry process and streamline the subsequent data analysis tasks. Key project requirements: - Building custom macros: I need help with building macros that can automate data entry tasks and facilitate data analysis. - Data analysis focus: The macros should be designed to support data analysis, particularly with a focus on data visualization. - Expertise in Excel VBA: Proficient in Excel VBA is a must, with a proven track record of designing and implementing complex, data-focused macros. - Understanding of data analysis: A strong understanding of data analysis is crucial to ensure the macros ...
I'm looking for a freelancer who can create a simple, yet effective, VBA macro to combine a set of between 10 to 50 small CSV files. These files all share the same column headers, and the macro should merge the data in these CSVs while maintaining the column sequence as provided. This task is straightforward and should not take much time for an experienced freelancer. A successful completion of this task will certainly result in a 10-star rating from me. See the uploaded document that details what needs to be done. I will provide the coder that I choose with several sample small csv files to combine.
I'm in need of a custom Excel workbook that can handle RFQ (Request for Quot...spreadsheets. - Automated Data Analysis: The tool should be designed to perform automated analysis of data imported. This will involve calculation of vendor prices, comparison and evaluation. - Generation of Reports: The tool should be able to automatically generate reports or dashboards based on the imported data. Ideal Skills: - Proficient in Excel: Advanced knowledge of Excel functionalities and VBA is a must. - Experience in RFQ Analysis: A background in Request for Quotation analysis and purchasing would be highly beneficial. - Data Management Skills: The ability to manage and analyze large datasets is crucial for the success of this project. I look forward to receiving proposals from qualif...
I am in need of an expert data professional to handle distinct tasks pertaining to Excel spreadsheets. Here is a rundown of what you'll be required to do: - Upload numerous Excel files - Expertise in Excel VBA, Macros and VB Capabilities - Analyze data professionally, using descriptive statistics The ideal candidate for the project would be well-versed in using Excel to analyze data and create descriptive statistics. Familiarity with data cleaning and visualization techniques would be a bonus. I look forward to your submissions.
Silakan Daftar atau Login tuntuk melihat rincian.
I have an excel SS that I need some quick formula help with. No VBA please. Table with expenses, then another table dividing up. I need the expense categories divided over months as per quantaty of time it is used. Explained in the SS attached. I need this done ASAP. Your responsibilities: - Understand the project financials and structure the Excel to match - Create a Gantt style tallies that captures my project expenses effectively Skills and Experience: - Solid expertise in advanced Excel functions - Experience in financial tracking, preferably in project management - Ability to work fast and deliver quickly Note: I didn't specify the expense categories so it should be customizable to accommodate any kind of expense. However, quick delivery is of utmost priority.
I am in need of an Excel Macro skilled professional, who can automate my manual work of generating operational data reports. My preferred output format for these reports is Excel spreadsheets. Key Responsibilities: - Design and create a macro in Excel for automatic rep...automate my manual work of generating operational data reports. My preferred output format for these reports is Excel spreadsheets. Key Responsibilities: - Design and create a macro in Excel for automatic report generation using operational data - Ensure the macro is accurate and efficient, cutting down the time spent on report creation Ideal Skills: - Excellent understanding of Excel Macros and VBA - Experience in creating automated report generation systems - Familiarity with handling operational data is p...
I am seeking a VBA expert with extensive experience in Excel for the creation of a custom macro. The specific task will involve designing a macro that can efficiently audit the financial records of a Trust. The audit should be conducted at a yearly level, ensuring accuracy and comprehensiveness in the review. Key tasks for the project include: - Building an automated audit tool: The macro should be capable of assessing financial records of the Trust with minimal manual intervention. - Ensuring high level of detail: The work is format based. Proper posting of the records should be done repeatedly year on year - Application in Excel: The macro should be fully functional in Excel, allowing for easy integration into the Trust's existing data management processes. Ideal skills an...
...less than 10 excel spreadsheets that I use for various purposes. I'm looking for a talented professional who can re-work these sheets eliminating redundancy. Key objectives: - The primary goal of this rework is to automate repetitive tasks. I'm looking for someone who can introduce VBA scripts and macros to help me achieve this. - The spreadsheets are both independent and share common data. It will be important to create a system that can handle both types of sheets. Ideal skills: - Proficiency in Excel, VBA, and Macro programming is a must - Experience with data manipulation and automation - Ability to understand and work with a mix of independent and shared data I'm open to discussing the project requirements in more detail. Please let me know if you&#...
I am seeking a VBA expert with extensive experience in Excel for the creation of a custom macro. The specific task will involve designing a macro that can efficiently audit the financial records of a Trust. The audit should be conducted at a yearly level, ensuring accuracy and comprehensiveness in the review. Key tasks for the project include: - Building an automated audit tool: The macro should be capable of assessing financial records of the Trust with minimal manual intervention. - Ensuring high level of detail: The work is format based. Proper posting of the records should be done repeatedly year on year - Application in Excel: The macro should be fully functional in Excel, allowing for easy integration into the Trust's existing data management processes. Ideal skills an...
need to websrapp amazon , flipkart and get current prices of sa list of laptop models on an excel sheet
Saludos, busco un experto en vba excel para la solución o complementación de un proyecto. Adjunto dejo una imagen del userform que funcionará cómo buscador y modificador de una base de datos en excel, la principal necesidad es lograr que el listbox genere la data con sus respectivas columnheads cómo se muestra en imagen, y que a su vez en el apartado del buscador, se pueda filtrar por el campo requerido y se genere correctamente la nueva fuente de datos. El error que se me ha presentado es que por usar el método .rowsource para mantener los encabezados, no me permite utilizar el método .additem.
Develop new sheet with vba automation, as per requirement, in addition to some modifications in previous sheets
I am seeking a professional with strong expertise in Python, Excel VBA, and API integration. The primary task is to extract specific data from the API response, and populate it into a designated column in an Excel file. Key Requirements: - Experience in Python programming - Proficiency in Excel VBA - Demonstrable experience with API integration - Ability to parse specific data from an API response from Google Server - Good understanding of automating tasks in Excel Further Details: - The primary purpose of the project is to send API requests with image URLs listed in column A of the Excel file. Upon receiving the API response, the relevant data should be extracted and placed in column D and B/C/E to be populated. - The setup should be easy to execute when needed by click o...
I'm in need of an Excel VBA expert to assist me in my project. I require assistance in writing new code, as well as debugging existing code. Specifically, the VBA code is intended for various purposes: - Automating repetitive tasks - Performing data analysis and manipulation - Creating custom functions and macros I specifically have to macros that I've started working on and need debugging: - Replacing references to cell/range addresses in formulas by their name - Implementing Montecarlo simulations (with automatic creation of histograms and data output) The ideal freelancer would have proven expertise in Excel VBA, with a strong track record of writing efficient, maintainable code. It's crucial that the code is robust, error-free, and easy to under...
I am in need of a highly proficient Excel VBA developer who can implement and automate complex data analysis, and generate reports from large volumes of data. Key Tasks: - Implementing intricate data analysis using Excel VBA scripts. - Automating repetitive data management tasks. - Designing and developing report generation tools. This program will be used by a mix of both internal and external users. Therefore, the created solution should be intuitive, user-friendly and reliable. Essential skills: - Proven experience in Excel VBA programming, dealing with large complex sets of data. - Strong understanding of data analysis techniques. - Capable of designing user-friendly interfaces for report generation. This is a challenging and vital project that requires a c...
I need a logo designed for my upcoming construction company. The logo must embody a professional and elegant vibe. There are specific requirements for this task: company name “VBA Construction” - Primary Colors: Blue and Gray should be the main colors for the design. These colors should be used in a balanced way that conveys a sense of class and sophistication. - Additional Designs: Beyond the logo, I'll need a few related designs for social media and web posting. These should carry the same stylistic theme as the main logo. - Timeline: I'm in a hurry. The design should be completed ASAP. Ideal candidates for this job are experienced in creating professional logos that work well across different platforms. They should have a good understanding of balance and...
...talented web developer or development team to transform our Excel workbook into a dynamic subscription-based web application. This workbook is integral to the operations of multiple educational institutions, featuring data management, automated calculations, and reporting capabilities. Project Goals: Seamless Transition from Excel to Web: Convert all functionalities, including complex formulas and VBA macros, from the Excel workbook into a web-based application. Robust Subscription Management: Develop a modular subscription system that allows for easy updates and the addition of new features. Future-Proof Architecture: The application should be built with scalability in mind, allowing for easy modifications and enhancements without disrupting existing functionalities. Key Featu...
Interesuje mnie logo w stylu obrazka poniżej.
Wir möchten auf unserem Online Shop ein Spiel Bogenschießen einfügen. Wir verkaufen Bogensportprodukte. Das Spiel soll ein Konzept beinhalten das dem Kunden die Möglichkeit gibt spezielle Produkte aus unserem Portfolio einzusetzen, Preise zu gewinnen, Meisterschaften zu simulieren. Es soll kein gewöhnliches Shooti...Möglichkeit gibt spezielle Produkte aus unserem Portfolio einzusetzen, Preise zu gewinnen, Meisterschaften zu simulieren. Es soll kein gewöhnliches Shooting Game sein, sondern spielerisch technische Veränderungen einfließen zu lassen. Regel und Rahmenbedingungen werden von World Archery, bzw. IFAA Federation vorgegeben. Eine Vorstellung über den zeitlichen und preislichen Aufwand über solch ein Projekt wäre h...
Hi Berk B., ich habe Ihr Profil gesehen und würde Ihnen gerne mein Projekt anbieten. Wir können alle Details über den Chat besprechen.
Hi Ajaykumar P., ich habe Ihr Profil gesehen und würde Ihnen gerne mein Projekt anbieten. Wir können alle Details über den Chat besprechen.
Hi Shamshad K., ich habe Ihr Profil gesehen und würde Ihnen gerne mein Projekt anbieten. Wir können alle Details über den Chat besprechen.
I need an Excel 365 PowerQuery or VBA script that can fetch daily market data and handle potential data source interruptions or changes. Google Shhets example =INDEX(IMPORTXML("" & C31, "//span[@class='mod-ui-data-list__value']"), 1, 1). <Where C31 = Cell containing the Stock eg GB00B8XYYQ86, LU1033663649 or GB00B0CNH163 I need an identical function in MS365 Excel - either with PowerQuery OR VBA (preferable) Ideal skills: - Proficiency in Excel 365 and PowerQuery and VBA - Experience in web scraping and handling dynamic data sources. I am after a fixed quote for this project.
Dough one Sources is looking candidates for Senior Business Analyst – VBA, Advance Excel. Job Role: Senior Business Analyst Job Location: Remote Experience: 4 + Years as Business Analyst – VBA , Advance Excel 3+ years of experience is required in creating dashboards in Manufacturing, Banking, Retail Industry. Working Hour: 3 hour per day (per day) Salary: 150 – 200 INR Per Hour Job Responsibilities : • Understanding Company requirements. • Understanding, consolidating and analyzing data from spreadsheets. • Creating dashboards, reports and charts in Analytics tools. • Working on financial and other types of modeling projects. • Having knowledge Dashboard Creation, Mainframe automation through VBA. • Good Technical kno...
I require a skilled Excel VBA developer to create a dynamic system in Excel. The process should work as follows: - The system will generate a new CSV file when I hit a specific button. - The new CSV file should contain 'item data'. The item data will include: - Item name - Item description - Item price The CSV file should be structured in a simple, easy-to-read format, with each item's data on a separate row. I need this system to be easily maintainable in the future, so please ensure that the code is well-commented and organised. Ideal Skills and Experience: - Proficient in Excel VBA - Experience in dynamically creating CSV files - Attention to detail for correct data formatting - Ability to create user-friendly interfaces for Excel.
