Goal seek vbacông việc
mình đang tìm dịch vụ support cho tự động hoá đọc dữ liệu ở Excel dùng VBA. bạn nào có thể giúp thì sẽ nói chuyện trực tiếp để giải thích thêm
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
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
Dự án nói về cách giảm chi phí sản xuất và giảm tồn kho thông qua phương pháp fuzzy goal programming. Bây giờ mình chỉ cần code theo cái model mẫu đã gửi bên dưới và add data của mình vô sao cho nó chạy ra kết quả là được, nếu thiếu gì có thể hỏi mình hoặc chế data vô . Bài mẫu mình là dùng Lingo
Cần một số Form vê VBA Cần một số bạn có khả năng lập trình VBA
Logo bóng đá lấy ý tưởng từ những vòng tròn đặt cạnh nhau mang dáng dấp của cầu thủ, vừa tạo thành hình quả bóng, Tên Logo: Goal King.(bàn thắng vua). Màu sắc chuyển màu đậm nhạt: chủ đạo màu xanh cỏ đậm, thiết kế theo phong cách 3D dạng như logo Vietcombank
Looking for a women communicator with great English skills to complete easy chores. Responsibilities include having regular discussions across multiple dating platforms. The final goal is to quietly shift folks from dating applications to Instagram chat or Snapchat app. This gig runs on a per commission basis and will cost $8. My greatest virtual assistant can close an appointment in 15 minutes or less. I'd imagine. Some minor fluff discussion is required. One out of every five leads to a sale in less time. So, for now, I'll put the fee at $8. A minimum of $250 to $350 a month can be earned from your phone. only working one hour or less. I'll be delivering two canned lines. You simply use it multiple times, but you can customize it to suit your preferences. I am ...
I am seeking a skilled professional to develop a facial biometric validation system that ensures high accuracy. This system will be integrated into both a mobile and web application for the sole purpose of identity verification. The primary goal of this system is to prevent fraudulent activities and provide enhanced security. Key Responsibilities: - Develop a robust facial biometric validation system with a high level of accuracy - Integrate the system seamlessly into both a mobile and web application - Implement features that support identity verification Ideal Skills and Experience: - Proficiency in developing biometric systems, particularly facial recognition technology - Prior experience in creating and integrating systems into mobile and web applications - Familiarity with va...
I'm looking for an experienced video animator who specializes in motion graphics. The goal of this project is to create 2D explanatory videos that educate viewers. Key Requirements: - Expertise in creating motion graphics-style animations - Solid experience in creating explanatory educational videos When applying for this project, please emphasize your experience with similar projects. Sharing some examples of your past work, especially related to education, will be highly appreciated. Let's create some exciting, informative videos together.
I'm looking for a professional who can guide me on filming a meeting with 3 iPhones and wireless lavalier mics. The goal is to have the video and audio well-synchronized for post-production editing. Key Responsibilities: - Set up 3 iPhones for optimal video quality - Configure wireless lavalier mics for clear audio - Advise on real-time synchronizing of video and audio Ideal Skills and Experience: - Extensive experience with video production - Proficiency in using iPhones for filming - Knowledge of wireless lavalier mic setup - Understanding of real-time video and audio synchronization Meeting Length: Less than 1 hour Environment: Indoors with controlled lighting I need assistance in all aspects of this setup, including ensuring that the video and audio match up perfectly i...
I'm seeking a lighting technician specialized in stage lighting, specifically for dance shows. The key requirement is expertis...the performance. Ideally, you should have: - Experience working with stage lighting for dance shows - Proficiency in creating compelling spotlighting effects - Great sense of timing and creativity to accommodate changing routines Your role will involve creating a spotlighting plan, setting up the equipment, running tests, and managing the lighting during the performance. Your ultimate goal is to highlight the dancers in a way that enriches the audience's experience. We have a children’s ballet show in a school theatre in weybridge. We need someone on 8 th June for rehearsal and show is Saturday 22 nd June all. lighting per...
I require a professional to conduct a thorough acoustical noise measurement in my condo's bedrooms and living area. The primary goal of this project is to identify potential noise disturbances. - A basic assessment, outlining general noise levels should suffice instead of getting into specifics of noise sources. - Expertise in noise assessment and in working in residential settings is preferred. - Knowledge of local regulations regarding noise levels would be beneficial. - The freelancer needs to provide a detailed report at the end of the measurement study, suggesting remedies if the noise level exceeds the comfort zone or is likely to cause disturbances. Ideal candidates for this job would be those who have experience in acoustics, noise measurement tools and are familia...
I'm looking for a skilled WordPress designer to create a visually appealing website for my bistro. The main goal of the website is to showcase our menu and daily specials. The website will be done in 1 page only with all content located in 1 page - About us: The section should display some basic info of the business - Drink Menu and Prices: This section should display all the drinks we offer, including relevant information such as sizes, prices and any special offers. - Happy Hour Specials: This should list our happy hour deals, complete with pricing and timings. - Upcoming Events: This section should provide information about any live music events we have scheduled, including dates, times and the performers. - Where are we located: showcase location & Google map The o...
I'm looking for a creative individual...essential. - Extensive experience in creating onboarding videos. - Understanding of client-centric communication. - Ability to create engaging content. - Excellent video production and editing skills. - Strong communication skills to help ensure client satisfaction. Please note, there's no need for interactivity in these videos. The target audience for these onboarding videos are our clients. The goal is not just to educate but to leave a lasting positive impression on them about our company. This is a critical project for us, and we're looking for someone who can deliver high-quality results within a reasonable timeframe. If you believe you're the right fit for this project, please get in touch with a brief overview of...
I'm looking for a talented designer who can create visually appealing banner ads for LinkedIn to promote my products. Key details: - Primary Goal: I want the banner ads to encourage viewers to fill out a lead form. - The lead form should collect: Name, Email, Phone number and Purpose Ideal Skills and Experience: - Proven experience in creating banner ads, preferably for LinkedIn. - Nothing else matters - Your past experience does NOT matter - Your education certainly does NOT matter - So long as you can give me about 6 banner ads at a very competitive cost, I am fine WHAT SHOULD THE AD LOOK LIKE - Nothing much ! Very Simple Really! - Need an image of a corporate trainer carrying out his training session - A group of people smartly dressed are getting the training We ca...
I'm in need of CNC cutting plans for designing disassembly joints primarily enhancing re...types of joints - Butt, Lap, Mortise, and Tenon. Each should be designed with dismantling in mind to facilitate recycling procedures. - The ideal freelancer should have significant experience in CNC cutting design, with an in-depth understanding of woodwork joint designs - Familiarity with sustainable design principles, especially concerning recycling, will be highly appreciated. The overall goal is to minimally impact the environment while producing functional and aesthetically pleasing joints. Your contribution will play a significant role in my journey towards eco-friendly woodwork design. Looking forward to professional insights and experience. Reach out if this project aligns wi...
I'm an experienced Amazon FBA seller and my focus is on wholesaling. I need to identify profitable products within the Home & Kitchen, Electronics, and Health & Personal Care categories. Key Aspects: - Product Research: I need thorough analysis to identify items with high sales potential. - Profitability: The primary goal is to find products that can generate significant profit margins. - Category Expertise: Experience with Amazon's Home & Kitchen, Electronics, and Health & Personal Care categories is essential. - Competitive Analysis: I need a clear understanding of the competition in these categories. Ideal Skills and Experience: - Proven track record in Amazon FBA and experience in wholesale model. - Strong analytical abilities for in-depth product res...
I'm looking for a Flutter developer who can create an application that simply redirects to an existing responsive website, www.saveonrx.net. The main goal is to give this website a feel of a native mobile application, while supporting both Android and iPhone devices. Key Details: - The application should be built using Flutter. - There is no requirement for extra functionality beyond redirecting to the site. The ideal freelancer for this project should have: - Experience in developing with Flutter. - A good understanding of mobile application design. - Ability to work with provided assets, including logos and brand colors. Please share your relevant experience.
...recommendation engine to enhance the shopping experience, automated email marketing for customer engagement, and a content creation tool to assist in generating compelling product information. - Discount Code Integration: Having a discount code on my store's front page is a key priority for me. Experience in integrating this specific feature into Shopify is highly valued. - Chatbot Functionality: The primary goal of the chatbot I want to implement is to answer customer queries. It's crucial that the chatbot is efficient and helpful in addressing customer needs. The ideal candidate should have a strong background in AI, with previous experience in integrating these tools into Shopify. A deep understanding of e-commerce and customer service is essential. In particular, p...
I'm looking for an expert in on-page SEO who can help me increase my website traffic. - I'm interested in SEO strategies that focus on optimizing the content and structure of my website, so that it ranks higher in search engines. - Your main goal in this project is to drive more organic traffic to my website. Your role would be to: - Conduct a detailed analysis of my website to identify areas of improvement for on-page SEO - Implement strategies that improve the website's visibility and ranking on search engines - Monitor, measure and report on the impact of these strategies on website traffic Skills and experience required: - Proven track record of successful on-page SEO projects - Strong understanding of SEO techniques and best practices - Excellent analyti...
I'm looking to develop a website for my online pizzeria, focusing on a customizable menu for our pizzas. This project will involve: - Developing an intuitive and responsive website design, allowing for easy navigation and a smooth user experience. - Integrating a menu with customizable op...Integrating a menu with customizable options, enabling users to build their pizza based on their preferences. Ideal skills for this project: - Proficiency in web design and development - Experience in e-commerce, particularly in the food industry - Strong understanding of user experience (UX) and user interface (UI) design - Familiarity with integrating customizable options in menus The main goal is to provide a seamless and enjoyable user experience to make our customers fall in love w...
I'm in need of a proficient business report writer who can create engaging and informative blogs for my website. The focus of the blogs should be around the structure of a report, data analysis, and writing style. Key Requirements: - Proficient in business report writing - Able t...website. The focus of the blogs should be around the structure of a report, data analysis, and writing style. Key Requirements: - Proficient in business report writing - Able to simplify complex information - Create engaging and informative content The ideal candidate should have a strong background in business report writing and be able to tailor the content to both students and professionals. The goal is to provide tips and techniques and discuss common challenges in a way that is easy to unders...
I'm looking for a skilled developer to integrate a Keystrokes Dynamics system into our existing Biometric 2FA application. The main goal is to increase the security of our system. Key Requirements: - Integrate Keystrokes Dynamics with an existing Biometric 2FA application. - Ensure a seamless and user-friendly experience for our customers. - Prioritize security enhancements and compliance with industry regulations. Ideal Skills: - Proficiency in Biometric and 2FA technologies. - Experience with integrating Keystrokes Dynamics into existing systems. - Strong security and compliance background. - Prior work on user-friendly interfaces would be a plus. Please provide examples of similar projects you've worked on and how you would approach this task.
I'm in need of a skilled SEO expert to help raise my dispensary's online visibility. I'm looking to enhance my website's SEO efforts with the goal of increasing website traffic, improving keyword rankings, and ultimately generating more leads. Key Requirements: - Target Audience: My dispensary primarily caters to local customers so the SEO efforts must be focused on enhancing visibility locally. - Content Management System: My website is built on WordPress, so proficiency in this CMS is required. The project will involve: - Researching and recommending a list of at least 30 relevant keywords, and implementing these within the website. - Creating backlinks and local links to improve the website's domain authority and local SEO. - Implementing a suitable SEO...
I'm seeking a social media expert to increase engagement with my brand on Facebook. The main goal of this project is to garner more likes, shares, and comments. The content to be posted will include a mix of text posts, images/photos, and videos. Key tasks for this role include: - Developing and implementing a comprehensive Facebook engagement strategy. - Creating compelling, on-brand content that resonates with my target audience. - Managing and interacting with audience to foster engagement and loyalty. - Analyzing engagement metrics and adjusting strategies as needed for optimal results. Ideal candidates will have: - Demonstrable experience in social media management, specifically with Facebook. - Proven track record of boosting engagement metrics. - Strong copywriting ...
...persuasive descriptions while also having graphic design skills to incorporate images. - Target Audience: The descriptions should be tailored to health-conscious individuals, ensuring the content resonates with their interests and concerns. - Tone: The descriptions should not only inform and educate, but also persuade and drive sales. A friendly, conversational tone could be suitable, but the primary goal is to entice the reader to make a purchase. Ideal Skills and Experience: - Proven track record in persuasive content writing, particularly in the health or wellness sector. - Proficiency in creating or selecting and integrating images that complement the written content. - Understanding of the sales process and how to subtly incorporate persuasive elements into the descriptions...
I'm in need of a skilled Ventuz Developer for a project focused on creating an interactive training presentation. I'm looking to bring an innovative and engaging approach to my training sessions, utilizing interactive e...presentation. - Implement interactive polls within the presentation. Ideal Skills and Experience: - Proficiency in Ventuz software to develop interactive presentations. - Strong understanding of training content to create an effective presentation. - Experience in designing and implementing interactive elements such as polls. - Ability to engage with audience in a professional and informative manner. The goal is to provide an engaging and interactive training session for my target audience. Your expertise in Ventuz and interactive content will be crucia...
I'm in need of an experienced developer capable of creating an innovative app that will significantly impact waste management. The primary goal of this project is to optimize waste management by utilizing satellite imagery to identify dumpsites in real-time. Key Features: - Real-time Satellite Imagery: The app will need to incorporate this feature to collect the most up-to-date data. - GPS Location Tagging: Each dumpsite identified must be accurately pinpointed using GPS for easy tracking. - Dumpsite Detection Algorithm: A robust algorithm is needed to analyze the satellite images and efficiently identify dumpsites. User Base: The primary users of the app will be government agencies, so the interface must be user-friendly and intuitive. Ideal Skills & Experience: - Pro...
I need a literature review specialist focusing on the Rare Disease (POGZ Gene Disorder/White Sutton Syndrome). This will involve...description of what is currently established about the POGZ gene disorder in a simple way without technical jargons 2) the current state of research in the field, 3) Summarize and compare the findings of key studies 4) POGZ s impact on gene function, what genes are down-regulated/unregulated with POGZ 5) what animal models exists 6) The gaps that currently exist for further research ( the ultimate goal of creating a therapeutic plan) I'm looking for someone with a deep understanding of genetics, scientific research and rare diseases, Experience in conducting similar literature reviews, especially within the context of the NIH articles, will...
I'm looking for an expert with strong skills and experience in digital marketing and e-commerce, to help enhance my online sales. Key objectives: - My website's main goal is to increase sales, especially focusing on indoor lighting products. - The primary target audience is general households. Preferred skills and experience: - Proven track record in digital marketing and e-commerce, with a focus on directing product sales towards a consumer-focused audience. - Comprehensive knowledge of the indoor lighting market and its consumer needs. - Competency in SEO and user interface design to optimize the website for sales. Your help will be invaluable in driving my online sales and ensuring the growth of my business.
I'm looking for a skilled developer to assist me in creating a personal portfolio website. The goal of this site is to showcase my work and skills to potential employers and clients. Key Requirements: - Creating a visually appealing and professional website - A simplistic design, ensuring the focus remains on my work - Implementing easy navigation for visitors - Ensuring the website is mobile-friendly and responsive Ideal Skills and Experience: - Proficient in web development, with experience in creating personal portfolios - UI/UX design skills - Strong understanding of SEO and site optimization - Good communication and ability to understand and implement my vision for the site I look forward to collaborating with a developer who can help me put my best foot forward in the...
I am looking for an expert in SSRS to set up a solution to track our daily financial transactions. The primary goal for this solution is to provide us with a simple, user-friendly way to access and track these transactions on a daily basis. Key requirements include: - Set up and customize the SSRS solution to track daily financial transactions - Ensure the solution is optimized for daily use and can handle the volume of transactions - Implement a system that would automatically send the daily reports to a specified email address Ideal skills and experience: - Proven experience with SSRS and setting up similar solutions - Strong understanding of financial data and tracking requirements - Ability to create automated reporting and email functionality I am open to suggestions and re...
Dear freelancers, I need help to promote a petition against corruption in the entrepreneur program in Australia. The main goal is to increase petition signatures. Key Responsibilities: - Scrape some websites to gather contacts from 'Entrepreneurs and business owners' groups in Australia. - Sending mass emails / DMs that with a link to this a petition . If possible, create groups on other social media platforms. I have a vision problem and need to avoid looking at screens, so I don't have social media accounts. if it works and I get a grant, I will offer a $500 bonus at least and future gigs with good pay. Thank you.
I'm seeking a talented professional to help me grow my Telegram channel. Here are some key details: - **Goal**: My primary aim is to increase the subscriber count of my channel. You will be focusing on developing and executing strategies that directly contribute to this goal. - **Target Audience**: My channel caters to adult content consumers. Therefore, your methods will need to be tailored to attract this specific demographic. - **Strategies**: Your role will involve utilizing a combination of paid advertising and cross-promotion with similar channels to help attract more subscribers. - **Skills and Experience**: I'm looking for someone with a proven track record in growing Telegram channels, particularly those targeting niche audiences. Experience with adult con...
...graphics, to help me create an animation. This project is specifically for advertising a service or product to a business audience. Key requirements and expectations: - The animation style should be mainly focused around Motion Graphics. This includes using animation, text, and graphics to create engaging visuals that directly communicate the service or product being advertised. - The primary goal of the animation will be to create a compelling advertisement for a service or product. Your animation will be the main tool in the advertising campaign aimed at businesses. - Understanding of business audience: The animation should be tailored to suit the needs and expectations of a business audience. Ideal freelancer for this job will have: - Proven experience in creating motion g...
