Vba macro microsoft projectงาน
Coding vba ให้คำนวนและรายงานผลลงในแถบ status bar ที่มุมจอ โค้ดทำงานได้กับทุกชีทในไฟล์ รายงานผลคล้ายค่า sum, average ที่โปรแกรมมีมาให้เดิม ทศนิยมสองตำแหน่ง เลือกเซลล์จากชีทไหนก็ได้ (เซลล์1จากชีทa เซลล์2จากชีท(n) 1. รายงานผลหาร เซลล์1/เซลล์2 2. รายงานผลลบ เซลล์1-เซลล์2 3. รายงานผลเปอร์เซ็นต์ เซลล์2/เซลล์1*100
1. ใส่ VBA ให้รายการที่ Tickแล้ว ย้ายจากtabแรกย้ายไปเก็บใน tab2 (done list) และให้วันที่ในtab2 เป็นวันที่ที่ย้าย 2. ใน tab ถ้าวันที่ในรายการ ไหน <3 วันให้ทั้งแถวเปลี่ยนเป็นสีแดง
หลังจากลูกค้าโทรเข้ามาเมื่อคุยเสร็จแล้วลูกค้ากดวางสาย หรือ พนักงานกดวางสาย อยากให้หลังจากนั้นประมาณ 20 นาทีให้โทรศัพท์กลับไปหาลูกค้าเพื่อประเมิณความพึงพอใจ โดยใช้ macro-survey เป็นเมนูที่จะโทรออกอัตโนมัติ
สร้างฐานข้อมูลเกี่ยวกับรายการอาหารและเชื่อมข้อมูลเข้ากับตัวเว็ป หรือสามารถให้คำปรึกษาและสอน สามารถสื่อสารช่องทางออนไลน์(Microsoft teams) (เลือกอย่างใดอย่างหนึ่ง)
...เขียนได้โดยตรงที่นั่น ( (คุณสามารถใช้ไฟล์คำและรูปถ่าย) [คำขอเมื่อสมัคร] - โปรดแจ้งให้เราทราบหากคุณมีบทความใด ๆ ที่เคยเขียนมาก่อน ขอบคุณมาก ๆ === - This is a job from a company that operates websites introducing Japanese tourist sites to foreign visitors. Please write articles with consideration of SEO measurements. ■Budget from 350 thb per article (not including all fees) ■Delivery Form Microsoft Word file and Picture data ■Hiring Conditions - Experienced writers - Persons with interest in Japanese tourism - Candidates may be offered more work if their results are good so we look forward to many applicants - Japanese speaking candidates are welcome but candidates who don't speak Japanese are still considered ■Prohibition - Copying or rewriting of any existing content ...
ทำ template เกี่ยวกับ company profile เกี่ยวกับงานก่อสร้าง งานเฟอร์นิเจอร์ เน้นใส่รูปเป็นหลัก โดยใช้ microsoft word
ใช้ AX2009 อยู่แล้วมีปัญหา ต้องการปรับปรุงหรือแก้ปัญหาให้ระบบมีประสิทธิภาพดีขึ้น ต้องการ consult เพื่อช่วยวเิคราะห์ปัญหาและออกแบบโซลูชั่น
- พัฒนาโปรแกรมโดยใช้ภาษา ASP.NET C# , Microsoft SQL Server - พัฒนาระบบเป็น web base application โดยมีเพียงส่วนของ UI และ Call Method ผ่าน Web Service - ไม่มีส่วนของ database design ,database create , database retrieve, database update , database delete - Design Web Page เรียบง่าย ใช้งานสะดวก ไม่เน้นลูกเล่น มี Concept , มีรูป ให้ 1. รถยนต์มือสอง 1.1 Download excel file format การกำหนดราคา รถยนต์มือสอง 1.1.1 Download excel file ใน Format ของการกำหนดราคา โดยเลือกเงื่อนไขได้ 2 วิธี 1.1.1.1 เลือกตามยี่ห้อ สามารถเลือกได้มากกว่า 1 ยี่ห้อ 1.1.1.2 เลือกตาม segment เลือกได้ครั้งละ 1 segment 1.1.1.3 ถ้ามีราคาที่เคยกำหนดในระบบให้แสดงด้วย 1.1.2 แสดงรุ่น รุ่นย่อยทั้งหมดตามเงื่อนไขที่เลือกด้านบน ...
กรอกข้อมูลลงในตารางหรือพิมพ์ข้อมูลผ่านโปรแกรม Microsoft office
I need an editable Word template created. The document will have permanent styles, but editable sections for my team to fill in. Key Features: - The template should include common formatting options like font styles a...in. Key Features: - The template should include common formatting options like font styles and sizes, bullet points, numbering, and page borders. - I need the following styles to be fixed in the template: Heading styles, Paragraph styles, Table styles, Font, color, alignment, Indentation. - The main body content should be the only editable section for my team. Ideal Skills: - Proficient in Microsoft Word and its advanced features. - Experience in creating editable templates. - Attention to detail to ensure that the permanent styles are consistent throughout the...
I need an editable Word template created. The document will have permanent styles, but editable sections for my team to fill in. Key Features: - The template should include common formatting options like font sty...Key Features: - The template should include common formatting options like font styles and sizes, bullet points, numbering, and page borders. - I need the following styles to be fixed in the template: Heading styles, Paragraph styles, Table styles, Font, color, alignment, Indentation. - The main body content should be the only editable section for my team. Ideal Skills: - Proficient in Microsoft Word and its advanced features. - Experience in creating editable templates. - Attention to detail to ensure that the permanent styles are consistent throughout the...
The purpose of this project is to create a detailed, technical drawing using SolidWorks 2022. The emphasis of the project is documentation of plastic parts, both on a macro and micro-level. Key Requirements: - Able to generate technical drawings that include overall dimensions, shapes, specific features, and tolerances of plastic parts. - SolidWorks 2022 ONLY!! - Extensive experience and understanding in documentation of manufacturing processes and components - Expertise in rendering intricate details of plastic parts - Must be able to abide by all requirements for precision-driven, technical documentation - Detailed and clear communication The ideal candidate will have a background in mechanical engineering or a related field, as well as experience in creating de...
The EdgeRecorder project aims to provide a tool for recording user interactions on web pages through a plugin for Microsoft Edge. This plugin captures user actions and generates useful information such as XPath, ID, Name, and other attributes of the elements. The main goal is to facilitate test automation and improve efficiency in web development.
I need a seasoned VBA and Macro expert to assist me with the creation of an interactive dashboard for a small project. The main tasks include: - Development of VBA code to automate repetitive tasks. - Creation of custom functions to enhance the dashboard's functionality. - Ensuring the dashboard can generate reports effectively. I'm specifically looking for someone with: - Proficiency in VBA and Macro. - Previous experience in creating interactive dashboards. - Ability to generate reports through coding. - Good communication skills and attention to detail. If you're confident in your VBA skills and have a good eye for visualizing data, I'd love to discuss this project with you.
I am looking for a detail-oriented professional to assist me in transcribing text data from Word Documents into an Excel sheet in alphabetical order. Specifically, you will be: - Handling text data from Word Documents - Accurately typing this data into an Excel sheet - Organizing this data alphabetically to aid in easy referencing Experience with data entry and a strong grasp of Microsoft Word and Excel is mandatory. I expect high attention to detail to ensure accuracy in data transcription and organization. Please submit your proposals detailing your relevant experience.
I have an existing VBA application that performs various calculations. I need to convert the VBA application to a Python-based desktop application. Key Requirements: - The converted application should perform the same calculations as the original VBA application. - The application should have a user-friendly GUI for easy input and output. - I am looking for a programmer with experience in both VBA and Python, to ensure a smooth and accurate conversion. Ideal Skills: - Strong proficiency in VBA and Python. - Experience in desktop application development. - Knowledge in creating user-friendly GUIs. - Ability to accurately replicate functionality from VBA to Python.
I need a proficient individual to assist with data entry into an Excel sheet. The data to be entered is purely textual, derived from printed documents and requires no complicat...textual, derived from printed documents and requires no complicated formatting. Key Responsibilities: - Transfer text data from printed documents to Excel - Ensure accuracy of data entered - Follow simple formatting guidelines Ideal Skills and Experience: - Proficiency in Microsoft Excel - Attention to detail - Experience with data entry - Fast typing speed - Experience working with printed documents This project is ideal for freelancers with a knack for accuracy and speed in data entry, particularly in Microsoft Excel. It involves simple one-word entries and familiarity with printed do...
NETCheck es una compañía especializada en consultoría y soluciones tecnológicas en entornos SAP, Microsoft, Open Source, Big Data, Ciberseguridad, BI e Inteligencia Artificial. Somos Microsoft Partner, con certificaciones: Gold en DevOps, Data Platform, Application Development y Application Integration, y certificación Silver en Cloud Platform. Desde el 2003 somos Service Partner de SAP . A lo largo de 22 años, hemos desarrollado proyectos para más de 100 compañías, tanto del sector público como del sector privado, en más de 15 países, incorporando en nuestros proyectos las mejores prácticas del sector. ¿Qué te ofrecemos? • Incorporación a una compañ...
I'm in need of a Microsoft Word expert who can help with formatting some documents. The documents are quite complex and require advanced layout designs. I'm looking for someone who has substantial experience in this area.
I'm in need of a professional typist with expertise in converting handwritten documents into digital format. My project involves general English content with no technical jargon involved. The selected freelancer should be adept at meticulously digitizing text, maintaining originality, and ensuring zero errors. The final typed transcripts should be provided in Microsoft Word. Therefore, proficiency in working with Microsoft Word is an indispensable requirement for this project. Ideal candidate should possess: • Past experience in similar typing work • Excellent understanding of English language • Accuracy and fast typing skills • Strong familiarity with Microsoft Word
...all material except page numbers, including figures, headers/footers, footnotes/endnotes, and full-page images. Page numbers: at least ¾" from the edge of the page. - Correct a few errors in the list of tables & figures - Move the page numbers for the beginning of the bibliography and appendices from top right hand corner to the bottom centers. Ideal Skills and Experience: - Proficiency in Microsoft Word for report conversion - Experience in formatting reports - Attention to detail to ensure all elements are accurately included - Strong communication skills to clarify any elements of the report if needed....
As the client for this project, I urgently require an expert in VBA.
We have an excel with macro script which converts a PDF (FFE 1a, 2a, 3a) to EXCEL (FFE) that allows us to be able to read all information we need. Unfortunately it is not working due to some changes in PDF (FFE 1b, 2b, 3b) as an extra page in the front has been added, so we are looking to hire someone that can fix this issue, so that excel can ignore this extra page.
I'm searching for an expert in Microsoft Power Automate to set up 3 automated workflows as an intitial test: Flow 1: If a new email is received use this as a trigger to check if a new email is in another outlook 365 folder, if there is, save the attached excel file as a csv and rename the csv file the date of the email in YYYYMMDD format and save to a folder in onedrive for business. On successful completion send an email confirming success. >If there is no new email in the other outlook 365 folder, email our info@ email address notifying that it is not present. Repeat the checking process 2 days later until successful Flow 2: If a new email is received use this as a trigger to check if a new email is in another outlook 365 folder, if there is, unzip the attachment using...
I require a skilled Excel VBA developer to create a dynamic system in Excel. The process should work as follows: - The system will generate a new CSV file when I hit a specific button. - The new CSV file should contain 'item data'. The item data will include: - Item name - Item description - Item price The CSV file should be structured in a simple, easy-to-read format, with each item's data on a separate row. I need this system to be easily maintainable in the future, so please ensure that the code is well-commented and organised. Ideal Skills and Experience: - Proficient in Excel VBA - Experience in dynamically creating CSV files - Attention to detail for correct data formatting - Ability to create user-friendly interfaces for Excel.
I'm looking for someone with strong skills in Microsoft Word and a good understanding of Hebrew to fix formatting issues in a table of contents of a Hebrew document. These issues involve inconsistencies with the font styles. Your tasks will include: - Ensuring all font styles are consistent throughout the table of contents - Establishing a clear indentation structure following the decimal outline format Ideal applicants would have good attention to detail and prior experience in document formatting, especially in Hebrew language documents. Knowledge of the Hebrew language and familiarity with Microsoft Word is essential. Your keen eye for detail will be instrumental for this project, ensuring that the final table of contents is free of any formatting errors an...
I am seeking an individual with high attention to detail for a data entry job. This project will involve translating textual information from a PDF document into a specified sheet format. Key responsibilities: - Accurate and efficient typing of textual data from PDF to sheet format - Strict adherence to the provided layout guidelines Ideal skills and experience: - Experience in data entry roles, specifically in transcribing textual information from PDFs - Proficiency in using Microsoft Excel and PDF readers - Strong attention to detail and adherence to guidelines - Ability to work efficiently and meet deadlines Please, consider this job if you have keen eyes and fingers primed for precision typing.
I'm initiating a monumental project focused on broad-based medical research. I need a professional to cultivate an impactful identity for my project through stellar naming, logo design, and profile creation. Here's what you should bring to the table: - Proficiency in Branding: I'm counting on you to bring your creative flair to the naming process. Make this project memorable. Name and Logo of the project - Expertise in Graphic Design: Demonstrate your talent in crafting a unique logo that truly symbolizes the essence of the project. Logo, Slogan, Images. - Exceptional Writing Skills: I anticipate a compelling project profile that encapsulates our commitment to advancing the medical field through various research types. Outstandin...
I'm seeking a Personal Assistant who can aid me in daily tasks such as scheduling appointments and conducting research tasks, ideally with a degree of familiarity in the online education industry, although this isn't a hard requirement. Daily responsibilities will include: - Managing my schedule - Undertaking research tasks For this role, the ability to use the Microsoft Office suite is necessary. Additional knowledge of the Classplus app would also be beneficial but is not mandatory. Ideal candidates will be fluent in English and able to commit to three hours of flexible work each day. Although some experience in the online education industry is preferred, I value dedication and willingness to learn above all else.
I am seeking a highly...design should embody a fitness-oriented feel, presenting information in a manner that is clear, concise and visually appealing. Alongside these specific elements: - Integrate meaningful images and graphics that enhances the readability and aesthetic appeal of the document. - Implement a fitness and meal-prep theme throughout the design In terms of skills and experience: - Proficiency in Microsoft Word document design is crucial. - Prior experience with a fitness-oriented theme would be beneficial. - Illustration skills for creating custom graphics would be a big plus - Ability to creatively implement text, images, and graphics together elegantly in a Word document format. See attachments, one for "instructions" and the other is the word doc th...
I'm looking for a solution to generate QR codes within an Excel document. The QR codes will be primarily used for URLs. The Attached Document Need Text Data from "Sheet Data" Column A into B2 Need Text Data from "Sheet Data" Cloumn B into A...provided. - Implementation of standard QR codes: Custom designs are not required. The focus is on generating functional, standard QR codes. - Ease of use: The end-user will be working in Excel, so the implementation should be user-friendly and seamless within the Excel environment. Ideal Skills and Experience: - Proficiency in Excel: A deep understanding of Excel formulas and VBA scripting is essential for this project. - Experience with QR code generation: Prior experience with generating QR codes, especially...
As an IT professional, I'm looking for an expert in Microsoft's Exchange Server 2019, as I need it set up for several organizations. The server setup must allow client access through Outlook on the web, Exchange ActiveSync, and Outlook Anywhere (RPC over HTTP). Ideal Skills and Experience: - Proficiency in Microsoft Exchange Server 2019 - Previous experience setting up servers for multiple organizations - Familiarity with various client access setups including Outlook on the web, Exchange ActiveSync, and Outlook Anywhere (RPC over HTTP) This task involves complex server configuration so only those with corresponding expertise should apply. This job would entail making sure that setup and client access is seamless for each organization.
...Integration with Zoom and Microsoft Teams is essential: The platform must include seamless and reliable integration with these video calling services. - ASP.Net Zero integration: We need the platform to work seamlessly with our current ASP.Net Zero platform. This includes user authentication and management, data synchronization and custom workflow integration. The ideal candidate for this project should have a strong background in LMS development, with a proven track record of creating customizable platforms that support multi-tenancy. They should also have experience in integrating with Zoom, Microsoft Teams, and ASP.Net Zero. Your proposal should outline your relevant experience, including examples of similar projects you've worked on, and how you plan t...
Looking for an expert in Excel VBA and Macros to automate various processes in my work-flow. Here's the brief rundown of the task involves: - Automated data analysis which includes summarizing data, filtering, Slicers, automatic calculation, and the visualization of data. - Creation of a Custom excel automatic dashboard for real-time reporting and data visualization. Ideal Skill-Set: You should be knowledgeable and experienced in the use of Excel VBA and Macros for automation. Prior experience in VBA, Macros, data analysis and report generation would be a major advantage. Familiarity with automated summary, filtering, Slicer and calculation methods is essential; knowledge of using Macros to create dashboards for real-time reporting is key. If you can meet th...
I'm currently in need of someone proficient in Hebrew and Microsoft Word to properly create and format a table of contents within my document. I've run into trouble while trying to structure the table of contents around headings and sub-headings. The ideal freelancer for this job would be someone: - Proficient in Microsoft Word. - Skillful with creating and manipulating tables of contents within Word. - Able to understand and write in Hebrew, as the document is in Hebrew. - Able to quickly troubleshoot and correct missing entries, as well as formatting errors. Your main task will involve the creation of the TOC, but anticipate a certain amount of back-and-forth as we refine it to my satisfaction. Please be prepared to communicate clearly and frequently about pro...
I'm looking for an experienced VBA programmer to extend and modify the existing 'getpdf' project. The key focus is on integrating it with Microsoft Excel. Key Responsibilites: - Integration with Microsoft Excel: This involves extracting data from Excel files and downloading data from VBA which is PDF-based data, renaming it, and using Selenium. Ideal Skills: - Strong VBA programming skills. - Proficiency in integrating VBA with Microsoft Excel. - Experience with Selenium for web data extraction. - Prior work with GETPDF data extraction preferable.
We required to develop some requirements to be done on Excel macro using office 365.
...Key tasks include: 1. Convert Pine Script into Python: The indicator is already written in Pine script. I have used Microsoft Copilot to convert it to Python, but I do not know how to implement and debug it in Python. 2. Backtesting: After the conversion, you'll assist in setting up backtesting from various exchanges, crypto and traditional finance. Hopefully just with tradingview data. Ideal Skills and Experiences are: - Advanced understanding of Python, Pine script. - Experience in developing and backtesting trading strategies. - Familiarity with Python bot implementation on the various platforms, and guidance regarding which platform to use. I am looking to have this project completed ASAP but I am reasonable regarding timeframes. If capable of meeting these req...
I require a skilled Excel VBA developer to create a dynamic system in Excel. The process should work as follows: - The system will generate a new CSV file when I hit a specific button. - The new CSV file should contain 'item data'. The item data will include: - Item name - Item description - Item price The CSV file should be structured in a simple, easy-to-read format, with each item's data on a separate row. I need this system to be easily maintainable in the future, so please ensure that the code is well-commented and organised. Ideal Skills and Experience: - Proficient in Excel VBA - Experience in dynamically creating CSV files - Attention to detail for correct data formatting - Ability to create user-friendly interfaces for Excel.
I have excel table with project tasks by dates start and end and duration. I want to change it to project table. Preferred microsoft format.
We are looking for a developer to help us develop an add-in for outlook that works for outlook on windows desktop app and web app. The add-on will be able to: - Read and analyze every email and send the files to our servers - Receive inputs from our server and suggest actions (save files to specific locations, proposed responses etc)
I require the expertise of a skilled data scraper who can quickly retrieve text data from a specified website. The...quickly retrieve text data from a specified website. The site in question is I need the following specific information delivered in Microsoft Excel Format: - Country Name - Grand Lodge Name - Website address - Email address - Phone - Address - Grand Master name (if available) The ideal freelancer for this project would have significant experience in data scraping, particularly text data, and an understanding of the website's structure to retrieve the desired information effectively. Speed and efficiency are of the essence. Your ability to deliver this project promptly without compromising accuracy will win you this bid.
1) I have just completed setting up a bing advertising account and need to make ads such as search, shopping, pmax, etc. Please help me complete all website (wordpress) and ad account configurations, including UET tags, conversion goals, and goal tracking, etc. In short, I need to allow my store to place search, shopping, Pmax and other ads on BING ads, and be able to track and optimize conversions normally. 2) Please tell me what information you need from me 3) Please tell me the time and cost required to complete the configuration 4) I have opened a Google Ads account and have a GMC, which is ready for advertising
Description: We require a developer to create a program capable of joining video meeting platforms such as Zoom, Microsoft Teams, and BigBlueButton (BBB), capturing the audio from these meetings, and streaming it to a transcription engine. We prefer the Python programming language for both development and deployment on the AWS cloud. Requirements: Integration with Video Meeting Platforms: The program should connect to popular video meeting platforms including Zoom, Microsoft Teams, and BigBlueButton. It should support joining meetings as a participant and capturing the audio stream from these meetings. Audio Capture: The program must capture audio from the meetings in real-time. Streaming to Transcription Engine: Once the audio is captured, the program should stream it t...
I'm on the lookout for highly skilled Excel VBA developers who can enhance my workbook's functionality and deliver efficient solutions. The scope of this project includes: - Automating data entry procedures to increase efficiency, reduce errors, and ensure accuracy - Designing custom Excel functions for a more streamlined experience - Producing comprehensive reports as per need Key Skills and Experience: - Proficiency in Excel 2013 and Excel 2016 is a must. - Strong knowledge of Excel VBA development - Prior experience with data automation and custom function creation - Expertise in generating powerful reports in Excel I am focused on seeing quantifiable improvements in efficiency and data accuracy through your work. If you have the required skills and ex...
As your assistant for this project, my job will be to type data into an Excel spreadsheet. However, I currently don't have specific information on what type of data (text, numbers, dates) you require. Additionally, I need clarification on whether you have any specific formatting needs for the data and if any calculations or formulas will need to be applied. Ideal Skills: - Proficient in Microsoft Excel - Precise and quick typing ability - Understanding of Excel formulas (just in case) Your prompt response to these questions will help ensure successful completion of your project. Looking forward to working with you!
...Smart Card Login functionality primarily to centrally manage user accounts of employees in my organization and improve security. The Key Responsibilities include: - Setup and Configure Azure AD to work with Smart Card Login. - Guarantee a flawless user experience that seamlessly integrates the smart card login feature with Azure AD. We want it to be 100% cloud based and users to use there microsoft accounts to login with there smart card. - If the smartcard is removed from the card reader we want the users windows session to be locked until they re-insert the card/resume session. Ideal Skills and Experience: - Strong experience in setting up and managing Azure AD. - Expertise in configuring smart card login functionalities. - Familiarity with USB-Based Smart Card Readers....
