Optimize 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
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
Đây là website của mình: Website này về căn bản là đã hoàn thành nhưng mà mình thấy design của nó chưa dc đẹp cho lắm. Với lại tốc độc của nó cũng ...vì hình logo là thất bát và có cạnh nhọn, tránh không sử dụng các hình tròn. + Có thêm nhiều các hiệu ứng khi hover vào thì hình sẽ trồi lên, hay đổi màu gì đó (tùy designer xem sao làm cho đẹp là dc) + Phần contac khi send form thì sẽ vào mail: info@ + Content thì sau khi freelancer nhận, mình sẽ sẽ gửi thêm thông tin + Làm xong thì dịch ...
Mình cần tối ưu tốc độ load trang và điểm pagespeed google Check tốc độ load trên tool pingdom hiện tại khoảng 6 đến 8s -> Yêu cầu <=4s Check điểm pagespeed hiện tại 71 đến 76 điểm -> Yêu cầu: >=85 điểm Mình muốn xem bạn thực hiện trực tiếp (Video, teamview...), để học hỏi, cũng như đảm bảo tính an toàn. Các bạn xin lưu ý yêu cầu này. Thông tin thêm: Domain: - wordpress VPS Vultr - Script: HOCVPS
...acquire new business through homify. Since end of 2013, we expanded to more than 30 countries worldwide and we continue growing. We are currently looking for a Freelance Creative Content Writer (f/m) for the Vietnam market. As a young business, our website needs to make itself known and be distinguished in the market place. 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 proofrea...
Chúng tôi có một dự án tuyển sinh cho Trường trung cấp y khoa hà nội và cần tìm người có thể tối ưu hóa nội dung SEO trên facebook cho trường. Thời gian 15-20 ngày.
Mình cần 01 bạn tối ưu site cho mình. Yêu cầu: có thể chịu được lượng ol lớn nhất... có thể làm việc với: nginx php-fpm load balance big data Bạn đánh giá cho mình hiệu quả công việc của sẽ đạt được đến mức độ nào nhé! Các thông tin cụ thể: site: wordpress database "hiện tại" : mysql máy chủ Dell r210 v2 ram 16gb hdd 1tb băng thông gói vdc-100 Có thể hợp tác lâu dài, Cám ơn các bạn quan tậm!
Mình cần một bạn cấu hình cho server chạy site tin wordpress cho 10000 user cùng online! My wordpress site always goes down (gives 500 Internal Server Error) during high traffic when it's over 2,000 users online. It needs to handle up to 10,000 at least. Hoàn thành dự án trong thời gian đảm bảo, giá hữu nghị nhé Có thể hợp tác lâu dài Mong hồi âm nhanh chóng của các bạn quan tâm! Cám ơn nhiều
...spearhead the design, implementation, and optimization of a robust software solution tailored to our retail operations. Responsibilities: Collaborate with stakeholders to gather requirements and translate them into technical specifications. Design, develop, and deploy scalable and reliable inventory management software. Conduct comprehensive testing to identify and resolve any issues or bugs. Optimize system performance for reliability, scalability, and security. Stay abreast of emerging technologies and industry trends in inventory management. Provide technical support and guidance to end-users as required. Requirements: Bachelor's degree in Computer Science, Software Engineering, or a related field. Proven experience as a Software Developer, focusing on inventory manage...
I'm looking for a professional to create and manage an Amazon advertisement campaign specifically focused on promoting a range of dry fruits. ...Experience: - **Amazon Advertising**: Experience with creating and running Amazon ad campaigns is a must for this project. - **Market Segmentation**: Understanding of the target audience and how to create ads that appeal to them. - **Copywriting**: Ability to craft compelling ad copy that drives sales. - **Analytical Skills**: Proficiency in analyzing campaign performance and making adjustments to optimize results. The ultimate objective of this campaign is to increase sales of our dry fruits products. If you have a proven track record in successful Amazon advertising, especially in the food or health and wellness space, I'd lo...
I am seeking an experienced Shopify professional to help maximize the sale potential within my online store. - Product Range: My store features a roster of less than 100 physical products, and I'm seeking help to increase their visibility, optimize their listings, and, overall, improve sales. - Platform Requirements: I've opted to use Shopify for my ecommerce venture, so specialist knowledge of this platform is essential. - Ideal Candidate: The ideal candidate will have a proven track record of successful Shopify store optimization and sales growth. Business acumen, e-commerce expertise, SEO understanding, and Photography skills for product listing optimization, will all be appreciated. Please include evidence of your past work and successes when bidding. I look forwar...
We are seeking a skilled Squarespace developer to design and build a professional website for our new company. The website will serve as our online presence and showcase our products and services to potential customers. The ideal candidate should have a strong understanding of Squarespace platform and be able to customize templates, implement branding elements, and optimize the site for SEO. Excellent design sense, attention to detail, and ability to deliver a visually appealing and user-friendly website are crucial. Skills required: - Proficiency in Squarespace platform - HTML/CSS coding skills - Graphic design and branding - SEO optimization
...seeking a Google Ads expert to help me resolve errors and enhance the overall input and output mechanisms of my campaign. Key Requirements: - Correcting incorrect or unexpected output. - Enhancing the input process to make it more user-friendly. - Addressing issues with incomplete information and output that is hard to understand. Your role will be not only to resolve these issues but also to optimize the campaign to help me achieve my primary goal - which is to significantly improve the performance of the ads. Key Skills and Experience: - Proficient in Google Ads, with a proven track record of successful campaigns. - Strong understanding of data analysis and interpretation. - Experience in troubleshooting and fixing errors in Google Ads. - Excellent communication skills to ...
I'm looking for an experienced HR recruiter to overhaul and optimize my CV to ensure it seamlessly aligns with ATS, specifically SAP and Oracle systems. Your expertise will help me compose a CV that not just passes the ATS challenges, but also makes a compelling read for hiring managers. Requirements: - Demonstrated success enhancing CVs for HR individuals. - Know-how of SAP and Oracle ATS systems. - A knack for capturing and highlighting essential HR competencies. What you should focus on: - Human Resources experience. - Developing an engaging resume, compatible with ATS systems. Why you should apply: This is a great chance to apply your expertise in CV writing to help me level up my career. Show me your skills with real-life examples where your previous work h...
...so the demand is high, and even higher, when locally shipped and fulfilled that as a authorized direct dealer of the brand can do this locally for much quicker local service than competitors having to ship and fulfill from whatever home state the company is in Budget: Less than $500 per month Skills and Experience: - Proven experience in managing successful Google Ads campaigns - Ability to optimize ad quality and performance - Expertise in targeting specific demographics to maximize results - Strong analytical skills to track and analyze campaign performance - Knowledge of budget management and optimization strategies -MAIN fixing present identified errors from google as an Approved Google business but google ads within the past few months, not approved and need free business...
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.
As an Amazon seller, I am seeking a skilled writer to create concise, informative product descriptions for my listings. Requirements: - The content should be professional and informative, catering to customers ...seller, I am seeking a skilled writer to create concise, informative product descriptions for my listings. Requirements: - The content should be professional and informative, catering to customers looking for a quick overview of the product. - Each description should be kept to a brief overview of up to 100 words. - Experience with e-commerce and Amazon listings is a plus. - SEO knowledge to optimize the descriptions for visibility is highly desirable. The perfect candidate will have a knack for distilling product features into a concise and engaging format that dri...
...inference speed. - Implement this on a shared googleColab or Jupyternotebook for on-demand use of the application Ideal Skills and Experience: - Proficiency in Korean language and understanding of language nuances. - Previous experience with data evaluation using OpenAI API calls. - Proven track record in achieving optimal inference speeds for data processing. - Demonstrated ability to balance and optimize processing accuracy alongside inference speed. - Strong communication skills to provide regular updates on the project's progress. refer to this documentation; request for access to the example document where all the testing data and instructions should be kept
We are seeking a skilled React.js Web Developer to assist with a one-time project. The ideal candidate will be responsible for developing specific user interface components using React.js for a defined project scope. This project will involve bui...based on provided designs and requirements. Responsibilities: Develop specific user-facing features using React.js for the defined project scope Build reusable components and front-end functionality based on provided designs and requirements Translate provided designs and wireframes into high-quality code Collaborate with the project team to ensure alignment with project goals and deadlines Optimize components for performance within the project context Assist with any additional tasks related to React.js development for the project...
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 looking for an experienced professional to help me with content creation, optimization, and keyword research and analysis. Your key objective will be to increase organic traffic to my website. *Key Tasks*: - Create and optimize engaging content. - Conduct comprehensive keyword research and analysis to drive traffic. *Target Audience*: Businesses in a specific industry. If you've got proven skills and experience in SEO, specifically in these areas, I'm keen to hear from you. Your ability to understand and cater to a business-specific audience is crucial for this role. Let's bring more organic traffic to my website together!
...existing application, to enhance its scalability, maintainability, performance and more. Key aspects of the project include: - Codebase management and version control: You'll be tasked with setting up a robust codebase management system that ensures version control. - Dependencies management: You should have experience dealing with dependencies in Java applications, and be able to streamline and optimize these processes. - Configuration, release, and runtime processes: You'll also be responsible for ensuring that our application's configuration, release and runtime processes align with 12-Factor App best practices. In addition to your technical expertise, a strong understanding of software architecture, system design and the ability to communicate complex informa...
I'm seeking an experienced web designer to create, host and add content to a portfolio website. This website should reflect a modern a...limited to a homepage, about page, contact page, and pages dedicated to showcasing various pieces of my portfolio. Procedure and skills required: - Design first. Once I've approved the design, you can then proceed to web development and hosting. - Expertise in UI/UX design is crucial. Knowledge of different CMS platforms will be a plus. - Content will be provided but the ability to edit and optimize it for digital platforms is a must. - After developing the site, you'll host it. Please make sure the hosting provider offers excellent uptime. Would be fantastic if you've created portfolio websites before. Please share any simil...
As a mortgage brokerage, we're currently in search of a skilled and experienced lead generator who can help us to optimize our current methods. Our processes mainly involve online advertising and referrals. Preferred skills and experience: - Knowledge of Facebook Ads - Proficiency in creating compelling text-based content - Deep understanding of lead generation strategies Your task will primarily involve: - Enhancing our text-based advertising on Facebook - Finding new ways to capitalize on referrals - Exploring other innovative methods for online advertising Bid now if you're up to the challenge of improving our lead generation efforts. Let's grow together!
I need a freelancer to optimize a JPEG picture for faster loading and upload it to a designated location. Key requirements: - Optimize the picture to reduce its size to enable faster loading on a website. - Ensure the optimization process maintains a reasonable quality of the image. - Professional experience in handling pictures for web use would be an advantage.
I need a network monitoring tool that can provide detailed network information. The tool should be universally compatible across operating systems, however, if you have a preference or specialize in a certain OS, do let me know. The functionality I am looking for includes: - Monitoring bandwidth usage - Latency tracking - Network traffic analysis You should...in the field - Past projects related to network monitoring - Detailed proposals for this project To deliver an efficient solution, you should have a solid understanding of network systems' complexities, bandwidth usage, latency, and network traffic. Familiarity with the majority of operating systems will be advantageous. Please outline how you would approach this task in your proposal. Let's optimize our network p...
...business professionals, my goal is to expedite the growth of my online business. To achieve this end, I'm looking for a Performance Marketer with expertise in search engine advertising and social media. Your task? 1. **Web Traffic Growth**: Design and execute strategies that would significantly drive high-quality traffic to my website. 2. **Conversion Rate Improvement**: Monitor, iterate, and optimize campaigns to ensure they're directly contributing to increases in conversion rates. 3. **Sales Boost**: Proposition and manage methods to increase online sales effectively. The ideal freelancer would possess: - Demonstrable experience in performance marketing. - Proficiency in search engine advertising and social media marketing. - A knack for understanding and targeti...
...organizations. -Reach out to decision-makers via email, phone calls, and other communication channels to introduce our company and products. -Effectively communicate the value proposition of our products and services to potential clients. -Nurture relationships with prospects and follow up on initial contacts to schedule physical meetings. -Collaborate with the sales team to strategize approaches and optimize outreach efforts. -Maintain accurate records of interactions and progress in our CRM system. -Provide regular updates on outreach activities and progress to the management team. -Continuously learn about our industry, products, and competitors to enhance sales pitches and approaches. Requirements:- -We prioritize hiring Indian candidates for this job position. -Proven exp...
I'm in need of a skilled developer who can significantly decrease the loading time of my website. The website is already loading in less than 2 seconds, but I want to optimize it further for a smoother user experience. Key Responsibilities: - Analyze the existing website code and structure to identify any areas of improvement for speed optimization. - Implement strategies to decrease loading time without sacrificing the quality of the content. - Ensure that all changes are thoroughly tested and do not cause any functionality issues. Ideal Skills and Experience: - Proven track record in website performance optimization. - Proficient in web development and coding languages. - Familiarity with content management systems and website analytics. - Strong problem-solving skills and ...
I'm looking for an expert to run a Facebook ads campaign focused on increasing brand awareness among young adults aged 18-24. Key Deliverables: - Creating and running image-based ad campaigns - Targeting the specific age group - Monitoring, adjusting and r...18-24. Key Deliverables: - Creating and running image-based ad campaigns - Targeting the specific age group - Monitoring, adjusting and reporting the results Ideal qualifications: - Proven experience in Facebook ads, particularly for brand awareness - A deep understanding of the 18-24 demographic - Creative skills in designing engaging and appealing images for ads - Ability to analyze and optimize ad performance Please bid if you have the relevant experience and skills to boost my brand visibility on Facebook among ...
Vui lòng Đăng Ký hoặc Đăng Nhập để xem thông tin.
...beauty. High DA 50 plus Must write blogs and images to adhere to strict guidelines of Google. Redo our webpages and optimise words and keywords to adhere to Google and Meta. Proper landing page for Google Images optimized, speed optimized. I want 100 high DA backlinks with blogs to our website, permanent and immediate crawled from Google. Must review each of our pages and propose how you will optimize our pages, you tube videos, articles and comply with Google and Meta policies. Currently our keywords range from first page to second and some on third. I want all words first 7 first page. I want significant improvement to website traffic which I monitor daily through analytics and Moz Professional. All SEO issues fixed and optimised. Currently our SEO ranges from 78 to 92. Very ...
...emoticons and stickers, support importing third-party emoticons. • Group Chat (Multi-Person Chat) o Group Management: Allow users to create groups, add or remove members, set group information, etc. Group owner and administrator permissions management. o Group Messages: Support sending and receiving messages within the group, including @member function. Implement message broadcasting and optimize network load. o Group Notifications: Group event notifications, such as member joining, exiting, group information changes, etc. o Group Message History: Retain group message history, allowing new members to view messages before joining. o File Sharing: Support uploading and downloading files within the group, as well as permission management. o Group Links: Allow ...
