Vba outlook rulecô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,
Một email mới từ KH gửi vào Email chung công ty, rồi căn cứ vào email KH gửi hoặc Tiêu đề email hoặc tệp bên trong email để phân loại - Lưu toàn bộ file vào Sharepoint - Lưu data email thành 1 sheet và cập nhật liên tục khi có email mới - Tạo folder tự động trên SharePoint theo quy tắc nhất định, hoặc folder được chỉ định
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
...hàng (Customer) thêm 1 sản phẩm vào Giỏ hàng thì một số sản phẩm liên quan được đề xuất ngay trong trang Giỏ hàng, khách hàng có thể chọn "Add to cart" để mua thêm những sản phẩm đề xuất đó. Mục đích : Tăng hiệu quả, doanh thu cho website bán hàng App cần có 2 chức năng chính : 1) Trong Shopify admin, chủ shop bán hàng (Shopify shop owner) có thể lựa chọn các điều kiện (rule) để hiển thị sản phẩm đề xuất. Một số ví dụ về rule : - Đề xuất thêm 2 sản phẩm cùng nhóm "mũ" khi khách hàng vừa thêm sản phẩm "mũ vành có nơ" vào giỏ h&agrav...
Cần một số Form vê VBA Cần một số bạn có khả năng lập trình VBA
Chúng tôi đã hoàn tất 70% dự án, đang cần thuê hoặc hợp tác với 1 freelancer để hoàn chỉnh dự án đưa template lên Themeforest. Hãy liên lạc khi: - Bạn có khả năng cao cấp trong: + PHP&My SQL + html5, CSS3 + Twitter Bootstrap, ZURB Foundation: responsive - Hiểu về rule của Evato Rule Hình thức làm việc: - Thù lao làm theo dự án. - Hợp tác theo dự án. - Làm việc toàn thời gian tại công ty chúng tôi.
Dough one Sources is looking candidates for Senior Business Analyst – VBA, Advance Excel. Job Role: Senior Business Analyst Job Location: Remote Experience: 4 + Years as Business Analyst – VBA , Advance Excel 3+ years of experience is required in creating dashboards in Manufacturing, Banking, Retail Industry. Working Hour: 3 hour per day (per day) Salary: 150 – 200 INR Per Hour Job Responsibilities : • Understanding Company requirements. • Understanding, consolidating and analyzing data from spreadsheets. • Creating dashboards, reports and charts in Analytics tools. • Working on financial and other types of modeling projects. • Having knowledge Dashboard Creation, Mainframe automation through VBA. • Good Technical kno...
I need an Excel 365 PowerQuery or VBA script that can fetch daily market data and handle potential data source interruptions or changes. Google Shhets example =INDEX(IMPORTXML("" & C31, "//span[@class='mod-ui-data-list__value']"), 1, 1). <Where C31 = Cell containing the Stock eg GB00B8XYYQ86, LU1033663649 or GB00B0CNH163 I need an identical function in MS365 Excel - either with PowerQuery OR VBA (preferable) Ideal skills: - Proficiency in Excel 365 and PowerQuery and VBA - Experience in web scraping and handling dynamic data sources. I am after a fixed quote for this project.
I need some minor changes made to a HTML template. The email template needs to be optimized for various email clients, including Gmail, Outlook, and Apple Mail. I need the new layout to be inspired by specific designs I will provide.
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.
Calling all ace animators; we are in need of your groundbreaking skills in 3D animation to produce engaging videos for our brand promotion. We aim to target teenagers primarily so the videos must resonate with their interests, likes ...on brand awareness. We aim to imprint our brand in the minds of our young audience through compelling stories, colors, and music that they'll relate to. Skills & Experience: - Proven ability in 3D animation with no less than 3 years of experience - Previous experience in creating animations for teenagers - Outstanding storytelling capability that can draw the audience's attention - A creative outlook that will bring our brand to life, inspiring young audiences We are excited to see how your skills can help our brand become a household...
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 mechanical engineering prin...
I'm in a project to migrate Windows devices to new Microsoft 365 Tenant. The devices are registered in Intune in the current tenant and users are using their Microsoft work Account to log in to Windows. After I retire the device from Intune Portal (Source Tenant) ...and try to add a new work account (that is the user account in the destination tenant) I got the following ...and users are using their Microsoft work Account to log in to Windows. After I retire the device from Intune Portal (Source Tenant) ...and try to add a new work account (that is the user account in the destination tenant) I got the following error message: "the work or school account couldn't be found. check the account name and try again" The user is signing in successfully to Services like Out...
...link, and deploy across all users. - An active countdown clock feature within the signature. - Compatibility with Microsoft Outlook, our primary email client. Additional Requirements: - While not essential, the ability to track interactions (clicks) on the email signature elements would be a nice to have. Ideal Skills and Experience: - Strong graphic design skills with a portfolio of visually appealing email signature designs. - Proficiency in HTML and CSS for email signature creation. - Experience in incorporating rotating banners and countdown clocks in email signatures. - Familiarity with QR code generation and usage. - Previous work with Microsoft Outlook email signatures is highly desired. - Familiarity with tools for tracking email signature interactio...
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 am currently in the need of a professional who can set up a business email account for my new website using Outlook. Key Requirements: - Experience in setting up business email accounts on Outlook. - Familiar with domain integration. - Can assure a standard security level for the account. Please note, I already have a purchased domain for the business email. You are expected to promptly align this task within the given requirements. The right candidate should have the experience and skills to carry out this task efficiently.
I am currently in the need of a professional who can set up a business email account for my new website using Outlook. Key Requirements: - Experience in setting up business email accounts on Outlook. - Familiar with domain integration. - Can assure a standard security level for the account. Please note, I already have a purchased domain for the business email. You are expected to promptly align this task within the given requirements. The right candidate should have the experience and skills to carry out this task efficiently.
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.
Having a significant issue with my Outlook and Microsoft Business account. When I create a new users in our system they are UNABLE to send outgoing emails to external parties. To help solve the issue, I'm looking for a skilled individual with: -We use Proofpoint, microsoft office, and cloudflare -Domain knowledge, cloud flare, - Expertise in troubleshooting Outlook email - Knowledge about the ins and outs of email settings - Prior experience in dealing with similar issues Your task will be to resolve this issue so I can seamlessly send and receive emails across all our devices for all our employees
...photos need to be saved as a single PDF document. I don't require individual image files. - The resolution quality of the extracted photos must be high - 300 DPI or more. Please ensure this whilst extracting as it's essential for the final output. - The photos extracted should ideally follow a random naming convention. The order doesn't necessarily need to adhere to the page number or alphabetical rule. The ideal freelancer for this task would have experience in handling image data extraction, particularly from PDF files, and should be adept at maintaining high-quality outputs. Familiarity with PDF and image editing software is highly desirable. Your ability to follow instructions and pay attention to details will be critical for the success of this project. If...
...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 with the specified technologies. Your ability to deliver a professional, well-structured, and visually appealing report within the give...
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 the customer requirement
I'm in need of a professional logo for my company, Bristol Heritage Wills and Probate. The logo must be modern and incorporate the color gold. Key requirements: - Modern Design: I'm looking for a logo that reflects a modern outlook while maintaining a sense of professionalism. - Color Scheme: I've chosen gold as the color for the logo. The design should be centered around this color, potentially using it as a primary element. - Industry Relevance: Given that my company is in the legal sector, the logo should reflect a sense of trustworthiness and reliability. Ideal Skills and Experience: - Experience with logo design, particularly for corporate or legal industry. - Proficiency in modern design styles. - Strong understanding of color theory and experience in using g...
I'm seeking a video editor who specializes in basic editing, such as trimming and merging. The raw footage total duration is less than an hour and I would like the final edited video to be less than 10 minutes. Skills and experience: - Proficient in basic video editing which includes trimming and merging. - Experience with managing raw footage of less than one hour. - Proven track recor...total duration is less than an hour and I would like the final edited video to be less than 10 minutes. Skills and experience: - Proficient in basic video editing which includes trimming and merging. - Experience with managing raw footage of less than one hour. - Proven track record of producing final edited videos of less than 10 minutes duration. - Exceptional attention to detail and creative ...
I used my cpanel webmail at my hosting company easily on my Gmail account for years, and it stopped working on Sunday. The email still works on roundcube mail on my control panel. It's supposed to be easy to set up either Outlook or Gmail, but I can't do it. Is this expensive?
...directly within Outlook's meeting creation interface. The add-in should allow users to input agenda items and action items while creating a meeting event in Outlook. Upon meeting creation, the add-in should gather all meeting details, including the agenda and action items, and pass this information to an API endpoint in Salesforce. Subsequently, this data will be utilized to automatically create a corresponding meeting record in our Salesforce application. Our team includes Salesforce developers who will handle any necessary integration with Salesforce. Therefore, the focus of this project is solely on the development of the Outlook add-in. The add-in's responsibility will be to capture meeting details, including agenda and action items, and pass them to an API...
I need a virtual office assistant primarily for managing emails and appointments, as well as some data entry tasks. The ideal candidate would be skilled in the following areas: - Proficient in Microsoft Office Suite: As a part of this role, you will be handling my email and appointments. Familiarity with Microsoft Outlook will be a plus. - Google Suite: Your knowledge and experience with Google Suite, particularly Google Calendar, will be essential as well. I'd like you to maintain my calendar and schedule, so you should be comfortable working with this tool. - Data Entry: You will also assist with some basic data entry tasks. Therefore, attention to detail and accuracy are important. I'm looking for someone who can commit around 10-20 hours a week to start, with the pot...
...novice and realize I need help with this. Key Requirements: - Expertise in email deliverability: I need a professional who can accurately diagnose and rectify the problem. - Gmail/Outlook Knowledge: Familiarity with Outlook/Gmail interface and settings is helpful as it's used when sending from outside our CRM. Familiarity with Zoho CRM a plus but not required. Ideal Skills and Experience: - Proven track record in successfully improving email deliverability. - In-depth understanding of SPF, DKIM, DMARC implementation. - Specific experience with deliverability issues when sending from Gmail and outlook. - Strong troubleshooting and problem-solving skills. Your role would involve investigating the underlying cause of the delivery failure, making ...
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 quality and defect-f...
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...Requirements: - Replace incorrect country codes: The tool should replace the incorrect country codes with the correct ones. - Predefined list: The correct country codes 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 example...
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.
