Self taught vbacông việc
Tôi có 1 list file excel báo cáo có chung cấu trúc đc đặt tên file theo quy tắc bao gồm mã đơn vị nộp và danh sách đơn vị nộp báo cáo. Tôi muốn xử lý: - Đánh dấu những đơn vị đã/chưa nộp báo cáo - Đối với các file đã có tiếp tục phân loại nếu ô X có số liệu thì đánh dấu có/ nếu ko có số liệu thì đánh dấu không.
Cần xử lý file thô từ hệ thống thành file hoàn chỉnh .
Dựa vào stock và các raw đã được đặt, và bảng thành phần để tạo nên một mã hàng, dùng Vba excel tạo template sao cho chỉ cần nhập vào tên mã hàng, có thể xuất ra mã hàng đó có đang bị thiếu raw không, raw nào thiếu, và những raw thiếu đó ảnh hưởng đến bao nhiêu mã hàng
Dữ liệu về logistic (Có sẵn các cột, trường dữ liệu, cần code VBA để ra được bảng kết quả chuẩn) (Removed by Freelancer.com Admin for offsiting - please see Section 13 of our Terms and Conditions)
Mình cần tạo code vba để thực thi công việc: 1 mở website cố định đăng nhập theo user pass tìm kiếm các dữ liệu theo các điều kiện download các dữ liệu tìm kiếm sau đó lưu lại vào thư mục
Công ty mình WHy NOt Build tại Melbourne Australia đang làm về lĩnh vực đầu tư, xây dựng và sửa nhà cần tuyển người có những kĩ năng sau: Biết Tiếng Anh - chỉ cần giỏi về phần đọc hiểu Excel VBA Excel Macros Thân Mến,
Trích xuất 1 số data từ file excel cho sẵn thành bảng mới Budget: 800k/ 2 file excel
Mình cần tạo code vba để thực thi công việc: 1 mở website cố định đăng nhập theo user pass tìm kiếm các dữ liệu theo các điều kiện download các dữ liệu tìm kiếm sau đó lưu lại vào thư mục
...full. Maintain and gradually improve the ranking among the top securities companies, become an Investment Bank " Core values: - Creativity: Constantly thinking, learning, proposing ideas to find ways work effectively, serve the best customers - Synergies: Each staff member is a representative of the brand BSC, together contribute to the overall success of the organization - Discipline: Respect, self-discipline, remind each other to comply with the organization's regulations; perform well assigned tasks in both time and quality ...
Tạo 1 macro lầy toàn bộ User Agent trình duyệt. Sau đó thay đổi User Agent của trình duyệt và tự động mở trình duyệt Yêu cầu: Lưu lại thông tin thay đổi User Agent để có thể khôi phục lại khi cần thiết (vì khi đóng trình duyệt thì User Agent sẽ tự động về lại như cũ nên cần phải lưu lại để load nếu cần) Ngôn ngữ là VBA viết trên nền Excel
Một file VBA excel kết nối với một số form excel để tổng hợp thông tin và trình bày dưới dạng dash board, xuất ra Powerpoint - Sales development - Margin development; - PL, BS and CF; - Cost development; Một số nút chức năng: - kiểm tra tình trạng file link; - refresh link; - report (click button to release report); Security: presentation format cố định, có password để mở, thay đổi
Mình muốn tìm một bạn code VBA trên exel cho dự án : " Hệ thống thông tin cho phòng cung ứng" Chủ yếu tool này có 3 chức năng chính : + Tạo chứng từ ( PR,PO,RFQ) rồi trình phê duyệt bằng outlook tự động xuất ra các trạng thái của chúg như: ( Mới tạo, đã gửi, đã duyệt , hoàn tất) + Tạo phiếu nhập , phiếu xuất , xem lịch sử nhập xuất + Kết xuất báo cáo : Chi phí vật tư , đánh giá nhân viên ( thông qua làm PO) , nhập xuất
Tôi cần thiết kế 01 file excel (VBA) - để quản lý toàn bộ dữ liệu xuất - nhập - tồn , bán hàng & logistics của công ty
Tôi muốn thuê viết code VBA để lập các báo cáo, tờ trình, quyết định theo mẫu
Mình đang quản lý các DA và muốn thuê viết chương trình trên nền Excel để quản lý các công việc và năng suất trên công trường như sau: 1. Tạo CSDL công nhân viên và mã công việc 2. Tạo CSDL năng suất lý thuyết theo từng công việc 2. Nhập chấm công theo công việc và mã nhân viên 3. Tạo bảng chấm công theo thực tế chấm công và năng suất lý thuyết 3. Tính toán và báo cáo năng suất theo các yêu cầu: loại công việc, thời gian, v.v
Nhập liệu với số lượng lớn , xuất ra theo định dạng có sẵn sử dụng vba excel
- Bạn có thể sử dụng VBA để lập trình quá trình sau: Mô tả: - Khi người dùng chọn vào ô đã thiết lập Data Validation trong Excel và nhập bất kỳ ký tự thì hệ thống sẽ tự động hiện ra list xổ xuống gợi ý những kết quả gần đúng có chứa những ký tự đó. (không sử dụng combo box) - Nếu người dùng bấm "Enter" thì ô sẽ hiển thị kết quả đầu tiên trên list - Nếu người dùng chọn một mục trên list thì ô sẽ hiển thị kết quả đã chọn - Thao tác xong sẽ đóng list lại
Cần một số Form vê VBA Cần một số bạn có khả năng lập trình VBA
... With this in mind we are looking for someone who can both create and optimize content for our online magazine. Your profile: Native level Vietnamese speaker You know the Vietnam market well Relevant experience in writing - journalistic or otherwise creative (experience in appropriate fields beneficial) Experience with SEO is advantageous Ability to work alone with minimal guidance Self starter mentality is a must Good research and proofreading skills Strong communication skills We are looking forward to hearing from you! -- Chúng tôi là homify - là nền tảng về Nhà cửa và Không gian sống! Dù bạn đang cần kiến trúc sư phù hợp hay đơn giản là cảm hứng - chúng tôi đem đến ch...
Motivation center là một dự án lưu trữ các tài liệu, video, phim ...một dự án lưu trữ các tài liệu, video, phim ảnh về tạo động lực cho bản thân, cho doanh nghiệp, công việc bây giờ là tìm người làm wordpress tốt *Tôi cần một người có các yếu tố sau:* _thành thạo wordpress _có năng lượng làm việc _tích cực _(ưu tiên người biết SEO) _(ưu tiên người ở Việt Nam) Motivation center is a project for saving, containing documents, videos, images, films about self-motivation, for companies too. The job now is to find a good wordpress-builder *We need someone who:* _proficient as wordpress _Having GREET energy _Positive _(p...
Hi. I need help to setup the binding for a RichTextBox .NET Control so that data is retained. There may be use of VBA that is needed. This is within a FactoryTalk View SE version 14 application. I don't know .NET or VBA, I am a FactoryTalk guy though. Example use case: Lets say a factory has 100 valves. If a user opens popup for Valve #3, I need a text box field in that popup for the user to enter data, and then data is preserved/saved. That popup should be one common FTV display that references the Valve_# that was selected (using parameter files, or...). This example is the main objective. I need a simple and easy solution to this, and I need to understand how to do it myself afterwards. This is perhaps a 1 hour job. My name is Marc. I'm ready to start ...
...face-to-face customer interactions to onboard new clients -Represent international brands with excellence in service delivery -Collaborate on marketing campaigns to drive sales -Ensure accurate execution of sales procedures Educational and skill requirements - Quick learner with the ability to grasp and apply new information promptly - Effective communicator - Possesses an entrepreneurial mindset - Self-motivated and proactive in achieving both personal and client objectives - Detail-oriented with a commitment to following procedures accurately - Previous retail experience is advantageous but not obligatory Job benefits -Comprehensive training in client management, sales, and customer service -Potential travel opportunities -Bonuses based on performance -Progression program...
I'm in need of skilled freelancers who can assist me with a Business-to-Business (B2B) outbound sales calling project. The primary aim of this task is to generate sales leads and ultimately convert them into sales. Key Respon...Following sales scripts and pitch guidelines Key Requirements: - Proven experience in outbound sales calling, especially in a B2B context - Strong communication and negotiation skills - Ability to handle objections and rejections tactfully - Persistence and resilience in a sales-driven environment - Familiarity with CRM software and sales processes Ideal candidates should be results-oriented, self-motivated, and possess a genuine interest in sales. Your contributions will play a crucial role in the success of our sales campaigns. Looking forward to wo...
...client-to-client tutoring services, accommodating users of all ages, from elementary students to adults. The website needs to be intuitive and user-friendly, fostering seamless interactions between students and tutors. It should include features like: - Live Tutorial Sessions: Real-time connections between tutors and students. - Recorded Tutorial Lessons: An archive of pre-recorded lessons for self-paced learning. - Interactive Quizzes: Engaging tools to evaluate the learners' understanding of the topics. - Peer-to-Peer Learning: A unique feature to encourage student-to-student tutorial sessions. Added functionalities such as a robust search engine for tutor profiles, a secure payment system, and a user-friendly interface for scheduling and booking sessions will be appre...
...ahead Curiously finding our way carefully Sharing the walks, amid our minds, in shadows shade, things now behind Healing our hearts as we glide so bravely Chorus Dreams of a dark room, us standing together, as whispers so calmly delight As the Angels and spirits of those who've been watching are lifted by loves coming light Crescendo In weakened spirit, we wept and knealt. To cleanse the self, to become well And in the now, with opened eyes we see Within the rust, through time was dealt, the weathered truths, of love once felt. We lived the falls, yet strong in heart are we Chorus 2 Yes, all through the dark, we are standing together, grasping the tools of our grace While the whispers of Angels and Spirits among us allume in the words we create Crescendo I...
I need a skilled designer to create a captivating car branding for my Maruthi Eeco. I have specific details that I would like to be included in the design: - Incorporate my logo in a creative and visually appealing way. - Integrate my contact information which includes my phone number, adress, and website. Ideal skills for this project include graphic design, branding, and experience in creating designs for vehicles. The final deliverable should be a high-resolution print file. I need by today EOD
I'm in need of a talented video creator who can help me with my vlogs. These vlogs will center around self-development and should be medium-length, ideally around 5-10 minutes. - Task: Craft engaging, insightful, and inspiring vlogs on various topics related to self-development. - Style: The style should reflect the theme of self-improvement, motivation, and personal growth. Ideal candidate would have: - Experience in vlog production and editing - A keen understanding or interest in self-development topics - Ability to produce content that is engaging, inspiring, and relatable - Creativity in storytelling and idea presentation. This is monthly requirement Please share how much you will charge for 30 shorts - short length min 60 second 8 Video - Video le...
I need a skilled Figma designer to help me improve / design a vibrant and engaging design for self-improvement iOS app. I will provide: - Designs that will need to be converted and improved in Figma. See Journey - attached - Suggested Style, See Suggested attached, based on bloom app - Examples of designs There will be from 10 to 20 screens to convert to Figma. Requirements: - Provide the timeframe when you plan to start and finish it. - You will need to improve the designs and suggest the best practices for the app. - Proven experience designing iOS apps in Figma - Portfolio showcasing previous designs in the self-improvement or wellness industries preferred - Strong understanding of color theory and user interaction principles - Ability to balance user-centric desi...
...writing skills, specifically in the domain of self-help literature. The project involves writing a complete self-help book and will require the freelancer to have: - Strong proficiency in English writing, grammar, and punctuation - Prior experience in working on self-help or similar genre projects - Ability to creatively convert ideas into engaging & persuasive content - Capability to incorporate given feedback with prompt edits Please note, the process will demand a close collaboration and regular communication for providing updates, receiving inputs, and ensuring the project stays on track. The ideal candidate will have diligence for timelines, an appreciation for the genre, and dedication to quality output. Your previous work samples in the self-help...
...- Model Versioning: Unlike other models that auto-update or create new versions, I require a plugin that allows me to manually select the version to work with. This ensures control and adaptability to changing needs or scenarios. The Ideal candidate has advanced knowledge not only in plugin development but also a deep understanding of financial data and its complexities. Proficiency in Excel, VBA, and data management are key, along with a keen attention to detail and a commitment to accuracy. Experience in financial modeling is a big plus. Your ability to meet these specific needs could make a significant difference in my work. - I would like to do quick interactions of the project and rapidly develop the final product. My design does not require any database connection. -...
Seeking a writer with a strong understanding of Algebra at the intermediate (high school) level, with an emphasis on communicating concepts clearly for self-learners studying independently. My project involves: - Transcribing my current rough drafts into written form. This includes working with some jpeg files. - Editing and improving the content once transcription is complete. - maybe writing in latex I am looking for a final product that independently studying students could use to improve their understanding of Algebra. If you have familiarity with formatting and editorial standards for educational resources, your skills would be particularly valuable here. Skills and Experience: - Strong understanding of Algebra (high school level) - Ability to accurately transcribe from jp...
I'm in need of a digital marketing virtual assistant to help grow my business through pitching our brand to podcasts. The main task I need you to carry out is to pitch our business to different podcasts to be featured as a guest. The focus here is on spirituality, with a particular interest in topics around psychic...this niche, with a good understanding of what makes a successful pitch in this space. Skills and Experience: - Solid experience in digital marketing, especially in building pitches for podcast guesting - Good understanding of the spirituality niche, particularly psychic themes - Strong pitching and negotiation skills - Excellent command of English, both written and spoken - Proactive and self-driven, able to come up with creative ideas for podcast pitch...
...digital marketing strategies with a passion for both learning and growing in this area. In order to be considered for this role you must: Be a team player with an analytical mind, creative spirit, and passion for what they do. Be able to meet deadlines and manage work effectively and efficiently. Possess effective and clear communication Be resourceful and efficient -- have the ability to be a self starter. Have a strong attention to detail Be available for a scheduled 30 minute virtual meeting each week to synchronize Be located in the US or Canada If you think you’re a fit, send us a message and tell us why you would like to be considered! Please attach a copy of your resume, as well as anything else you'd like to share! Writing samples and any relevant industry ...
As someone struggling with certain aspects of Excel 2016, I need an experienced VBA Developer who can assist in creating custom Excel functions and rectifying existing Excel errors. Key duties will include: - Macros programming to automate repetitive tasks - Troubleshooting and fixing inaccuracies in the current Excel functions, if any Despite my lack of specificity about the exact functions or errors, I expect the developer to have a strong understanding of Excel functions in general and to use this knowledge to identify any issues that may exist. Ideal candidates should: - Have significant experience in VBA development - Have a solid understanding of custom Excel functions - Be proficient in troubleshooting & error handling in Excel 2016 - Demonstrate flexibility a...
I'm looking for a VBA programmer to help me with creating custom functions and macros for data analysis in Excel. Key Tasks: - Creating Macros: The project involves developing macros that can automate repetitive tasks and facilitate data analysis. - Building Custom Functions: I need custom functions to aid in data cleaning and manipulation, as well as report generation. Ideal Skills: - Proven experience in VBA programming, especially in Excel. - Strong background in automating tasks and data analysis. - Ability to develop custom functions for data cleaning and report generation. Output: - The generated reports should be in an Excel spreadsheet format, as well as a PDF document. Please provide samples of your previous VBA work, specifically any projects rel...
My Oshine WordPress site, advmediaservices...., is completely down. I need an expert to get it back up and running, as well as incorporate a number of updates to the site. Key tasks include: - Resolving the issue that's causing the website to be down - Updating the theme and plugins - Merging content from two existing sites In addition, I need assistance in: - Fixing broken portfolio links and adding new items - Training for me to self-manage site content Ideal candidate should have: - Proficiency in Oshine WordPress theme - Experience in troubleshooting and resolving website issues - Knowledge of content management and consolidation - Good communication skills for training - Ability to work in a timely manner to ensure the website is operational as soon as possible.
I'm in need of a talented video creator who can help me with my vlogs. These vlogs will center around self-development and should be medium-length, ideally around 5-10 minutes. - Task: Craft engaging, insightful, and inspiring vlogs on various topics related to self-development. - Style: The style should reflect the theme of self-improvement, motivation, and personal growth. Ideal candidate would have: - Experience in vlog production and editing - A keen understanding or interest in self-development topics - Ability to produce content that is engaging, inspiring, and relatable - Creativity in storytelling and idea presentation. This is monthly requirement Please share how much you will charge for 30 shorts - short length min 60 second 8 Video - Vide...
I'm seeking an experienced graphic designer for my upcoming Business and Self-improvement non-fiction book. Your design approach must be abstract and conceptual. I value quality, attention to detail, and creativity. Key requirements: - Proven experience in book cover design - Proficiency in design software - Ability to design abstract and conceptual book covers Get in touch if you believe you're the right fit for this job. Please include relevant examples of your past work.
Hello everybody! My and my partner started our podcast and we looking to add a 2D animation to accompany our podcast, the podcast will be a storytelling of a chosen book and will have one chapter for each episode. After after finish reading the episode (we have the permission of author)we will talk about what we have ju...what we have just read and have a conversation about the meanings behind. I would like to add an amine in animation to accompany us during the reading and the conversation. It will be approximately one hour each episode And hopefully one episode for the week We don’t have high budget, we looking for an animator whom love to work on a new project and have a big love for books and for depth and self improvement! We can give you the best place to expose y...
I'm looking for a skilled software engineer. THis task is too large for excel power query, however i want it to operate in a similar fashion. The main purpose of this project is to develop a self-updating database of every racehorse in the state of NSW, Australia, via the website. Key tasks and responsibilities: - Determining the best platform for the software (Web-based/Desktop-based/Mobile application). - Creating a software solution that will automatically update and manage a database of racehorses. Skills and Experience: - Proficiency in at least one high-level programming language i.e., Java, Python, C++ - Experience with automation software - Familiarity with database management - Ability to recommend best software platform based on project requirements. Thanks :
I'm in need of a unique, specialized alternative to traditional glass cleaners. Ideal candidates for this project will create an effective formula to clean a variety of glass surfaces ranging from windows, mirrors to glass tabletops. • Key deliverables: - A unique, efficient cleaner formula - Should work on various surfaces (windows, mirrors, glass tabletops) - product is a self dissolving pod so it should be compatible with the biodegradable content Note: As I've skipped answering the question regarding the form of the cleaner, I am open to recommendations on whether the cleaner should be a gel, wipe, or foam. Experienced chemical engineers, product developers, or anyone in a related field are encouraged to apply. Prior experience with cleaning product develo...
...ability to extract insights from complex data sets and present them clearly is crucial. - Macro Development: You will be responsible for automating repetitive tasks in Excel, including generating reports, automating data entry, and creating efficient formula calculations. Your macros should be user-friendly and easy to maintain. Ideal Skills: - Proficiency in Excel, including advanced functions and VBA programming - Strong background in data analysis and visualization - Experience in creating macros for automation - Excellent communication skills to understand the project requirements and translate them into effective solutions This project is a great opportunity for someone looking to enhance their skills in advanced Excel-based roles and gain hands-on experience in data analy...
As I'm looking for a skilled ERP and CRM developer to support the development of a comprehensive system for my business. The ideal candidate will have expertise in: - Inventory management - Sales and order processing - Financial management - Customer relationship management - Indian accounting and tax...and other Indian accounting standards - Implement features like: - Lead management - Contact management - Sales forecasting - Bookkeeping - Bank reconciliation - Payroll The successful freelancer should have a robust understanding of ERP and CRM systems, particularly in the context of the Indian market. Experience with manufacturing processes would be highly beneficial. A proactive, self-motivated professional who can deliver accurate, reliable and high-quality cod...
I'm looking for a talented writer who can create a collection of 51-100 inspirational quotes for my project. The quotes should primarily focus on themes of success and achievement, as well as personal growth and self-improvement. Ideal Skills and Experience: - Proven experience in writing motivational or inspirational content - Excellent research skills to gather quotes that are fresh and engaging - Understanding of the themes of success, achievement, personal growth and self-improvement - A creative mind to structure the quotes in a cohesive and inspiring manner The final deliverable should be a well-curated list of quotes that are not only inspiring but also original and thought-provoking. If you have a passion for motivational writing and a knack for capturing life...
I'm currently seeking a motivated and experienced Sales Representative who can assist in expanding my marketing agency. This role entails: Key Responsib...will be businesses in the marketing sector. Location: - I'm looking for someone who can reach out to international clients, so familiarity with global outreach is a huge plus. Ideal Skills & Experience: - Demonstrated experience in sales, specifically cold calling and client relations - Background in marketing industry - Ability to target and communicate with international clients effectively - Self-motivated and results-driven. Your role will be vital in driving business growth, so I'd like you to be able to demonstrate a strong track record of success. If you're proactive and driven to exceed sales t...
I am seeking a proficient VBA developer to help me create a set of macros in Excel. The purpose of these macros is to automate the process of generating multiple files from a base Excel file, specifically for the task of data analysis. Key Requirements: - The macros should be designed to create multiple Excel files from a single base file. The output files should maintain the formulas, formats, and templates of the original file. - The macro should be designed to run on a monthly basis. - The output files can have the same format with different data. The ideal candidate should have: - Proficiency in VBA and Excel - Experience in creating macros for data analysis - Ability to deliver a reliable, efficient, and well-commented solution. I need this to be delivered in the next...
...manipulation, data analysis and reporting. The process is already mapped out and can be shared with you. - Using Pulover Macro and AHK, as well as VBA to facilitate the automation process. - Ensuring the automation process involves uploading files to Sharepoint, sending messages on Teams, and emails. The key deliverable for you is not just the completion of the automation process, but a clear and concise explanation of each step once the task is finished. This will be crucial for future troubleshooting and independent management. Ideal skills and experience for this role would include: - Advanced and proven experience in Pulover Macro, AHK and VBA - Proficiency in automating tasks in Microsoft Excel, as well as working with Sharepoint, Microsoft Teams and Email - Excell...
Job Title: Inbound Lead ...techniques, including content marketing, SEO, email marketing, and social media marketing. 3. Experience with marketing automation tools such as HubSpot, Marketo, or Pardot. 4. Excellent communication and writing skills, with the ability to create engaging content and compelling messaging. 5. Analytical mindset with the ability to track and interpret key metrics to optimize lead generation campaigns. 6. Self-motivated and proactive, with the ability to work independently and meet targets in a fast-paced environment. Join us in our mission to empower and celebrate teenagers worldwide through the World Teen Awards. If you are passionate about lead generation and driving sales for innovative applications, we'd love to hear from you! Apply now to join ou...
...the Power 9 Principles observed in longevity hotspots, personal anecdotes, and practical advice for integrating these principles into daily life. Ideal Skills: 1) Strong Research Capability: Ability to synthesize scientific research and health data into compelling, easy-to-understand content 2) Experience in Health and Wellness Writing: Proven track record of writing in the health, wellness, or self-help niches 3) Engaging Storyteller: Skill in weaving anecdotes and personal stories with factual information to keep the reader motivated and engaged 4) Sensitivity to Tone: Capacity to maintain a supportive and positive tone that encourages lifestyle changes without judgment 5) Proficiency in English: Must have excellent command of the English language, with the ability to wri...
