Vba projects for beginnersmunkák

SAP-bol auto-exportalt xls adatfajlokhoz kellene vba makrokat szerkeszteni melyek szinten automatizaltan lennenek futtatva. Mintafajl mukodo makroval rendelkezesre all egy bizonyos celra mar, a metodustendszert kell duplikalni mas adatokra. Szoval nem nullarol kell kitlalnod az egeszet. Nem kell durvan erteni a makrok irasahoz. ha record funkcioval, es belenyulkalassal eligazodsz, az mar eleg lehet - en is igy irtam az eddigieket. ~Muveletek: fajlok nyitasa, mentese, zarasa, munkalapok valtasa, kepletezes, ezek lehuzasa, filter, adattipusok es stilus formazasa, vlookup xls fajlok kozott, chart frissites. Ennel sokkal bonyolultabb dolgokkal nem kell nagyon számolni. 4 fo elemunk van: 1, adatfajl letrehozasa es formazasa friss sap adatexport alapjan, kepletezes, osszegzes 2...

Adott egy FÉLKÉSZ Access DB-re ültetett Excel VBA ügyfél nyilvántartó, projektkövető rendszer. A cégünk mérőeszköz kereskedéssel foglalkozik, 10-15 beszállítóval, 2-300 partnerrel és 2-3000 ügyféllel dolgozunk. Professzionális Access és VBA tudással rendelkező szakit keresünk, Magyarországon.

Szia! Van szabad kapacitásod? Lenne egy sürgős munka, aminek lényege az, hogy egy meglévő VBA kódot kellene módosítani az elképzeléseimnek megfelelően. Kérlek jelezz vissza, ha érdekel és akkor mondom a részleteket! Üdv, Pisti

1) Üzleti folyamat specifikáció alapján és a kész termékre vonatkozó elvárások megértését követően az alkalmazás Excel frontend és funkcionalitások tervezése. A megrendelő és a fejlesztő közösen alakítja ki a koncepciót. Becsült munkaóra (BMó): 40 2) A működési koncepció implementálása Excel/VBA/.NET VB környezetek felhasználásával. BMó: 60 3) Fejlesztői kód dokumentáció. BMó: 20 4) Teszt esetek kidolgozása a megrendelővel közösen, azok végrehajtása, dokumentálása. BMó...

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.

I'm looking for a VBA expert who can help me automate the modeling of intermediate mechanical components in Autodesk Inventor. Key Requirements: - Automate part modeling in Autodesk Inventor - The parts to be modeled are intermediate mechanical components, such as gears and brackets - The VBA code should allow user input for customization of the parts, specifying dimensions and features Ideal Skills and Experience: - Proficient in VBA programming - Previous experience with Autodesk Inventor - Strong understanding of mechanical components and their modeling - Ability to incorporate user input into VBA code for part customization This project is perfect for someone who enjoys automating processes and has a good understanding of...

I'm in need of creating a series of articles that will provide investment tips specifically for beginners in the Bitcoin market. These articles are supposed to be clear, concise, and easy to follow for someone who may be new to investment in cryptocurrency. Ideal Skills and Experience: - Demonstrated experience in investing in Bitcoin and other cryptocurrencies - Previous experience in writing articles for beginners, especially in the field of finance and investments - Strong understanding of the technical aspects of Bitcoin and other cryptocurrencies - Ability to write in a professional and technical tone.

I'm looking for an expert to deliver a hands-on training on how to use a Digital Sound Board. I'm a beginner and my goal is to learn how to manipulate sound controls effectively. The prospective freelancer should be able to: -Know the design for a Church praise and worship team -Train users how to use the sound Board -Train users how to a set up Microphone sound. -Able to set up the vocals and microphones for each singer - Guide me through the intricate functionalities that a Digital Sound Board offers - Translate technical jargon into a simple, understandable language - Provide real-time feedback and clarification on my methods - Have exceptional patience and communication skills - Set up the sound -Set up the microphones for correct sound. -This is...

I am in need of a virtual assistant who can commit less than 10 hours weekly. The key tasks would be: * Making calls * Conducting research * Assisting in book creation Although I'm open to beginners, I value a great work ethic, good organizational skills, and, above all, a proactive approach. Excellent communication skills are also appreciated. I look forward to working with a dedicated and reliable individual.

I'm currently facing some issues with my Excel tracker. - The tracker contains a VBA macro file which seems to be causing formula errors and formatting issues. I'm unsure of the exact nature of these errors, but it's clear they are impacting the accuracy and usability of the tracker. I need a freelancer who can review and rectify these issues in the tracker. An ideal candidate would have strong experience with VBA and Excel, able to handle complex formulas and troubleshoot formatting problems swiftly. Your goal is to ensure that the tracker is fully functional and error-free. Experience with similar projects will be a plus.

I need an Excel VBA code that can perform exact word matching within an Excel spreadsheet. - The code should generate a list of matched words.

I'm in need of a talented copywriter to create engaging and motivational content for a radio spot. The aim of this project is to promote a product or service to a young adult audience, aged between 18-35 years. Your primary goal will be to craft inspiring content that connects with this demographic, encouraging them to take action, or consider a new perspective. The overall tone should be upbeat, motivational and forward-thinking. Ideal skills and experience for this project include: - Proven experience in creating persuasive and engaging copy - An understanding of the young adult market - Ability to use language and tone to evoke emotions and drive action - Familiarity with radio advertising is a bonus, but not essential. I'm looking forward to working with so...

I'm looking for an expert specialized in Computer Science (CS), Electrical Engineering (EE) and Mechanical Engineering (ME) to assist me with academic projects particularly focused on Power Systems with emphasis on Renewable Energy Integration. This will require: - Profound knowledge of Computer Science, Electrical and Mechanical Engineering concepts - Expertise in dealing with Power Systems, specifically Renewable Energy Integration into Power Systems - Tools Matlab, Python - Algorithms development Expect your assistance to be comprehensive, covering all bases to ensure outstanding outcomes. Your bid should demonstrate your expertise in these areas.

I'm looking for a proficient professional who can create a report in Microsoft Access from a MySQL database. The report should contain data from the MySQL database, calculations or summaries of data, visualizations or charts, and be structured as a paginated report, using SQL language. The report should be designed to be accessed as a printable PDF document. It is not required to be interactive, as a static report is sufficient for my needs. Key Requirements: - Proficiency in Microsoft Access, MySQL, VBA, PDF, Python, and Excel - Competency in SQL language for data manipulation - Experience in designing paginated reports The ideal candidate should have a proven track record of creating similar reports, with the skills and knowledge necessary to work wit...

... INR1200/day or fixed amount as decided by our project managers, for 8 hours of work on anydesk/github for adding functions 2. INR 2000/project for rebranding+testing+fixing 2 Apps systems of codecanyon like professional apps. 3. INR3000/project for rebranding+testing+fixing 3 Apps system of codecanyon like food and grocery. 4. We work from 6PM till 4AM in the morning in IST, so devs can join us after their regular working hours. We are seeking professional, only individual devs (no teams, no groups, no companies, as we are already a company), who can speak and understand English and Hindi. All devs who join our team will get recurring projects from us depending on time available with them. Timely delivery for projects is very impo...

As a professional with high-volume data, I'm seeking a highly skilled Excel expert. You should have proficiency in: - Data analysis - Data visualization - Excel formulas, functions and macros - Visual Basics Application (VBA) I'm dealing with more than seven datasets, each one having high complexity (many columns and over 5000 rows). I will need your expertise in managing and understanding this data. Ability to quickly comprehend and adjust to new data structures would be advantageous. Proven experience with large data sets and advanced Excel usage is a must for this project. Please include examples of previous similar work in your proposal.

2 excel files with VBA macro as per customer requirement

One excel file with macro as per requirement

...golf company that primarily focuses on selling golf equipment and Apparel . I'm in need of a talented designer who can help me create a brand identity that resonates with golfers of all levels, from beginners to professionals. Key tasks: - Logo design: I require a professional, visually appealing logo that embodies the essence of my brand. Ideal candidates for this project should have: - Experience with branding for sports companies or similar industries - A portfolio that showcases their creativity and proficiency in logo and packaging design - An understanding of the nuances of designing for different skill levels in the golf community. - Ability to deliver within a reasonable timeframe Looking forward to collaborating with a designer who can bring...

One excel file with macro as per the customer requirement

I run a content agency(primarily short form content) that edits videos for coaches, hypnotherapists and other projects The videos are up-to 60 seconds long and I expect you to edit subtitles, b-roll, stock footage, dynamic motion/graphics and make the video in general: entertaining and highly engaging. For longer videos I of course expect the same, but that is not happening that often. I am looking for a person that can be my full time editor for the next 6-12 months with the possibility of consistent pay-raises when the agency experiences growth. You will be paid at least 6usd for every video-edit from day one, and depending on the projects, the price will get higher. It is an easy project, and it is very sreamlined! Every video are t...

I am seeking a skillful writer to help create an accessible book that introduces barber techniques and tips for the general public, particularly those who are new to barbering. The ideal writer for this project should: - Have a clear understanding of barbering, its techniques, and terminologies - Be able to explain complex concepts in a simple, engaging manner catered towards beginners - Have excellent writing and communication skills with experience in instructional writing The final product should work as a comprehensive guide that breaks down the basics of barbering in a manner that's easy to understand for beginners. The audience should feel informed and engaged, developing a strong foundation in barbering techniques and practices.

I'm looking for a skilled trainer to deliver a comprehensive Excel training targeted towards beginners. The training will cater to a larger group of participants, around 15-20 individuals. Key Learning Objectives: - Understanding of Excel formulas and functions - Mastery of data analysis and manipulation The ideal candidate for this project would have a strong command of the above topics, with a proven track record in delivering effective training to large groups. Experience in breaking down complex concepts for beginners is essential. Practical demonstrations and hands-on activities should be incorporated to ensure the understanding and application of the learnt skills. Please, when making a bid, provide a brief outline of how you plan to struc...

As your client, I'm looking for an Excel VBA expert who can make my daily processes more efficient by creating an automated reporting solution for me. Key Tasks: - Design and implementation of a VBA macro in Excel to automate the generation of cost summary reports. - The automated reports should be populated by data from four different worksheets, namely Worksheet 1, Worksheet 2, Worksheet 3, and Worksheet 4. Ideal Skills and Experience: - Excel VBA Programming - Experience with automated reporting - Understanding of data manipulation in Excel. -Possible migration of Cost Summary data to Word contract. In your proposal, please share samples of previous automated reporting projects done with Excel VBA. Commitment to delivering high...

...Science, Digital Marketing, IT, Finance, and so on. Desired Qualifications: - Proven experience in quality lead generation - Knowledge or experience in the online course industry - Confident in reaching target audiences through various methods Job Scope: - Identify potential leads interested in online courses - The skill-level of the leads is not specified; your expertise should cover targeting beginners to advanced learners - You have the freedom to use popular lead generation strategies like Social Media Ads, Email Marketing Campaigns, Search Engine Optimization (SEO), or other beneficial channels This project provides an opportunity to apply and shape your lead generation strategies to help me reach a broader audience. Your contribution will significantly affect the succes...

I am a logo design expert. I can create logos as well as design other projects using CorelDRAW application

I need an Excel VBA expert to automate the generation and visualization of customer data reports. This task requires the building of a dashboard to simplify the report generation process. Key Tasks and Skills Required: - Strong understanding of Excel VBA for automation tasks. - Experience in building dashboards for report generation. - Skills in visualizing customer data within Excel. Outcome and Project Scope: - Develop an automated process for report generation. - Ensure the dashboard is user-friendly and visually appealing. - The final output should provide easily digestible customer data insights.

I need an Excel expert to build a tool that can automatically validate and correct any incorrect country codes in the file. Requirements: - Replace incorrect country codes: The tool s...should be determined based on a predefined list. - Daily updates: The tool should be able to handle daily updates. Ideal Skills and Experience: - Advanced Excel skills: You should have a deep understanding of Excel functions and VBA programming. - Data validation: Experience with data validation and manipulation in Excel. - Attention to detail: It's crucial that the tool is accurate in identifying and correcting country codes. - Timely updates: Experience in creating tools that can handle daily data updates would be ideal. If you have experience with similar projects, please provide ...

... Create unique and eye-catching emblems that are suitable for embroidery. Develop icons that align with our brand and design requirements. Collaborate with our team to understand project goals and deliver designs that meet our needs. Revise designs based on feedback from team members and clients. Qualifications: Proficiency in illustration software such as Adobe Illustrator or Procreate. Strong portfolio showcasing emblem and icon design skills. Understanding of embroidery design principles and limitations. Ability to work collaboratively in a fast-paced environment. Excellent communication skills and attention to detail. This is a remote position, and we welcome applicants from around the world. If you have a passion for creating unique and vibrant designs, we w...

...can provide a beginner level training on the MERN stack. The ultimate aim of the training is to equip learners with the skills needed to develop web based systems. Ideal Skills and Experience: - Knowledge of web development and software engineering - Understanding of both basic and complex coding concepts - Proficiency in teaching and mentoring, ideally with a teaching/mentoring background for beginners. - Good understanding and practical experience with MERN stack, this will be a plus. - Experience in practical web development and system design using MongoDB will be highly appreciated. - Can teach in a very interactive way, doesn't mind lots of dumb questions. Your ability to clearly explain concepts, provide practical examples and exercises, and foster a positive...

...design for composing a slide that clearly conveys information about Quick Wins/Actions, Responsible Parties, and Expected Results for both the Process Improvement and Project Studies areas. Attached is an initial slide that serves only as a starting point. The team is encouraged to make necessary changes in mode and design to meet the project specifications. The development team should seek inspiration from current slide design trends. It is important that the slide is visually appealing and clearly conveys the necessary information for both areas. Slide Specifications: Division by Areas: The slide will be divided into two main areas, with Process Improvement occupying 2/3 of the slide and Project Studies occupying 1/3. Each area will have its own clearly defined...

I need a seasoned VBA and Macro expert to assist me with the creation of an interactive dashboard for a small project. The main tasks include: - Development of VBA code to automate repetitive tasks. - Creation of custom functions to enhance the dashboard's functionality. - Ensuring the dashboard can generate reports effectively. I'm specifically looking for someone with: - Proficiency in VBA and Macro. - Previous experience in creating interactive dashboards. - Ability to generate reports through coding. - Good communication skills and attention to detail. If you're confident in your VBA skills and have a good eye for visualizing data, I'd love to discuss this project with you.

I have an existing VBA application that performs various calculations. I need to convert the VBA application to a Python-based desktop application. Key Requirements: - The converted application should perform the same calculations as the original VBA application. - The application should have a user-friendly GUI for easy input and output. - I am looking for a programmer with experience in both VBA and Python, to ensure a smooth and accurate conversion. Ideal Skills: - Strong proficiency in VBA and Python. - Experience in desktop application development. - Knowledge in creating user-friendly GUIs. - Ability to accurately replicate functionality from VBA to Python.

Hi Sukri Yatman A., I noticed your profile and would like to offer you my project. We can discuss any details over chat.

I'm seeking a skilled artist to conduct a 'sip and paint' workshop in a larger art exhibition context ...participants. Details: - The participants are novices in painting and hence, ideal candidate should be proficient in teaching beginners. - The key focus of the workshop will be to enage the guests, teach them few basic painting skills - oil, acrylic, landscape or fluid art. Skills Required: - Excellent painting skills - Strong teaching abilities, especially handling a large group - Prior experience in conducting workshops So, if you're someone who has experience in teaching novices the beautiful art of Landscape Painting, you could be just the one I need. Looking forward to work with a patient and engaging artist who could make this an unforgettable ex...

As the client for this project, I urgently require an expert in VBA.

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.

I'm looking for a professional who can help me set up my video coaching program on Digistore. The program I'm offering is designed for beginners in the subject area. Key requirements for this project include: - Setting up the course on Digistore as a seller - Providing a seamless download experience as the program includes downloadable resources Ideal candidates for this project should: - Have experience in setting up courses on Digistore - Be able to cater to beginner-level audiences - Be able to integrate and manage downloadable resources on the platform.

I'm looking for a solution to generate QR codes within an Excel document. The QR codes will be primarily used for URLs. The Attached Document Need Text Data from "Sheet Data" Column A into B2 Need Text Data from "Sheet Data" Cloumn B into A11 as a QR Code Need Text Data from "Sheet Data" Cloumn C into G1 as QR Code The data will be manually pasted into "Sheet Data" I need this for 50 Sheets Pages to ignore Coverpage, Inside and Page Breaks Key Requirements: - Ability to generate QR codes in Excel: The end product should be an Excel script or add-in that can create QR codes based on the URLs provided. - Implementation of standard QR codes: Custom designs are not required. The focus is on generating functional, standard...

Looking for an expert in Excel VBA and Macros to automate various processes in my work-flow. Here's the brief rundown of the task involves: - Automated data analysis which includes summarizing data, filtering, Slicers, automatic calculation, and the visualization of data. - Creation of a Custom excel automatic dashboard for real-time reporting and data visualization. Ideal Skill-Set: You should be knowledgeable and experienced in the use of Excel VBA and Macros for automation. Prior experience in VBA, Macros, data analysis and report generation would be a major advantage. Familiarity with automated summary, filtering, Slicer and calculation methods is essential; knowledge of using Macros to create dashboards for real-time reporting ...

I'm looking for an experienced VBA programmer to extend and modify the existing 'getpdf' project. The key focus is on integrating it with Microsoft Excel. Key Responsibilites: - Integration with Microsoft Excel: This involves extracting data from Excel files and downloading data from VBA which is PDF-based data, renaming it, and using Selenium. Ideal Skills: - Strong VBA programming skills. - Proficiency in integrating VBA with Microsoft Excel. - Experience with Selenium for web data extraction. - Prior work with GETPDF data extraction preferable.

Current logo is good, but I want to upgrade it and maybe have a more party vibe look / setting. the logo should mainly stay the same, but maybe add some attributes. the surrounding circle/text should stay the same, or if you want to make some small changes on it, you are...setting. the logo should mainly stay the same, but maybe add some attributes. the surrounding circle/text should stay the same, or if you want to make some small changes on it, you are allowed to do it. I provide you the illustrator files, feel free to provide first a sketch before you want to continue and spend more time on it If I'm really satisfied, I will provide you with a lot more projects for a wide range of clients in Belgium. I'm trusted on freelancer and I try to work on a long ...

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.

I'm in search of existing web projects that are unique and have potential for further development. Key Requirements: - I'm particularly interested in existing E-commerce websites, Blogging platforms, and Social networking sites. However, if you have a different type of web project that you believe is truly unique and has potential, feel free to reach out. - The projects should be distinct and not based on common templates or themes. - I'm looking for projects that have not been overused or replicated extensively by others. Ideal Freelancer: - You have a track record of creating original, unique web projects. - You have experience with redesigning and adding features to existing projects. - You understand the potential ...

I am seeking a captivating and educational video podcast geared toward beginner podcast producers. Key requirements are: - Video Length: Under 10 minutes long for easy consumption and understanding. - Content: Technological topics to fuel interest and expand knowledge of these aspiring podcasters. - Language: English, clear diction imperative for non-native listeners. Ideally, the freelancer will have experience in creating engaging and educational technology content and knowledge of podcast production. Experience in teaching or coaching beginners will be valued. Your ability to distil complex subjects into easy-to-understand language will be key. Video editing and production skills are also important.

Development and Enhancement of Excel VBA Project Tracker.

I'm on the lookout for highly skilled Excel VBA developers who can enhance my workbook's functionality and deliver efficient solutions. The scope of this project includes: - Automating data entry procedures to increase efficiency, reduce errors, and ensure accuracy - Designing custom Excel functions for a more streamlined experience - Producing comprehensive reports as per need Key Skills and Experience: - Proficiency in Excel 2013 and Excel 2016 is a must. - Strong knowledge of Excel VBA development - Prior experience with data automation and custom function creation - Expertise in generating powerful reports in Excel I am focused on seeing quantifiable improvements in efficiency and data accuracy through your work. If you have the required skills...

I'm seeking an online [western ,pop english singing]vocal coach to help beginners improve their singing skills. The focus of the training will include: - Teaching proper breath control techniques - Developing pitch accuracy - Working on vocal range expansion Ideally, you should have experience working with beginners and be able to provide supportive and encouraging guidance. The ability to effectively communicate and demonstrate techniques online is crucial. Your aim should be to nurture a beginner's passion for singing and build a solid vocal foundation.

...architectural projects. Your tasks will focus mainly on the structural elements and interior design. I need professional who can handle detailing of the interior space in terms of practical and production friendly 2d drawings, Design will be done on our end and would be shared in the form of sketches concept. One has to have knowledge about the construction of the following : 1. Fixed furniture 2. False ceiling 3. Plumbing 4. Electrical 5. Flooring • Software Proficiency: Proficiency in AutoCAD and SketchUp software is a must. Your advanced skills in these platforms will be leveraged to present architectural drawings in an impressive and articulate format. So, if you've got strong knowledge of residential architecture and experience with these software tools, you c...

• Automate the collation of data from two sheets, "Data" and "Report," into one Excel workbook. • Transfer data from specified columns in the "Data" sheet to new columns in the "...from specified columns in the "Data" sheet to new columns in the "Report" sheet. • Implement exception handling to address missing values during the data transfer process. • Develop an email notification feature to inform managers about the completion of the collation process. • Add "Data" suffix to transferred column names in the "Report" sheet for differentiation. • Provide a solution to automate the process without manual copying and pasting of VBA code. • Name the final file as "Bo...