Create word document excel vbaงาน
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 วันให้ทั้งแถวเปลี่ยนเป็นสีแดง
...สามารถ Export ข้อมูล รายงานต่างๆมาเป็น Excel 6. สามารถทำข้อสอบในลักษณะคล้ายๆ Google form 11:20 Avatar ได้ครับ 11:20 Avatar มี host หรือยังครับ 12:05 ยังครับ อยากทราบราคาก่อนนะครับ ว่าเริ่มต้นที่เท่าไหร่ 12:12 Avatar คร่าวๆ ประมาณ 15,000 ครับ รวมระบบหลังบ้าน ไม่รวม host กับ domain ครับผม 12:13 Avatar ทั้งนี้ต้องดูรายละเอียด ข้อ 1, 3 และ 6 อีกครั้งครับผม วันนี้ 15:24 ฉันสนใจจ้าง 15:25 โทษทีครับ ที่คุยไว้หลายเดือนก่อน โดนเบรคโปรเจคไป นี่จะกลับมาทำ 15:25 พอจะลดได้มั้ยครับ 15:32 อยากจะทำเว็บไซต์รวบรวมยอดขาย พนักงานให้มี Content ดังนี้ครับ 1. ให้พนักงานขาย รายงานรุ่นและจำนวนที่ขายกลับมาที่เรา โดยในเว็บจะมีสรุปยอดขายเป็นกราฟหรือชาร์ตต่างๆให้ ที่สามารถ sort เป็น สาขา เป็นเขต หรือทั้งประเทศได้ แล้วแต่แกนที่เราต้องการ export รายงานออกมาเป็น excel ได้ 2. มีระบบ Log in...
ทำ excel คำนวนภาษีส่วนบุคคล 5 คน โดยสามารถเปลี่ยน variable ต่างต่างได้เพื่อทำ scenario analysis (ie ถ้ารายได้ x จะได้ x) ______________________________________________ Excel personal tax calculations for 5 people, with different variables changing for scenario analysis. (ie if income x is obtained x)
คัดลอกข้อมูลจากเว็บไซต์ คัดลอกข้อมูลจากเว็ปไซต์ลงในไฟล์excel
หาข้อมูล 16 อย่างของ Blogger จาก 50 fanpage แล้วกรอกลงให้ excel ที่กำหนดให้
2 document to Translate from English to Thai 1. 930 word 2. 717 word ไฟล์ส่งให้อีกทีนะคะ
...บบของ โครงการที่ต้องมีการเข้ามาฟัง requirement และ design ร่วมกันกับหน่วยงานที่ดูแล มีเอกสารที่ต้องจัดส่งต่อไปนี้ (โดยสามารถรรับทำบางส่วนหรือทั้งหมดได้ ซึ่งงบประมาณก็จะต่างกันไป) a. Functional Specification b. Technical Specification c. Unit Test Result d. Release note and software configuration e. Deployment steps and checklist f. Knowledge Transfer (Training) document g. Operation manual & Troubleshooting document กำหนดขึ้นระบบ วันที่ 31 มค 2561 แต่ระยะเวลาพัฒนาจริงๆ จะมีแค่ประมาณ 1 - 2 เดือนเท่านั้น
พิมพ์สูตรคณิตศาสตร์ได้ ตัวอย่างงาน
ต้องใช้ imacro คัดลอกข้อมูลจาก web site ลง excel
คีย์ข้อมูลต่างๆลง Excel การคัดลอกบทความต่างๆลง word
ฉันสามารถออกแบบสิ่งที่คุณต้องการโดนหาแรงบันดาลใจจากคุณ เปิดโอกาศให้ฉันได้ร่วมงานกับคุณ
ทำ presentation งานโดยใช้ Powerpoint สามารถแทรกงานที่เป็นข้อมูล ตารางและกราฟ จาก data ที่เป็น Excel
looking for job typing document from book by on line I mean want to work at home
Translate a Thai certificate document into English (frond and back (2 pages))
Software and Application OCR Scan or Take Photo of Document OCR TO SQL
I need a skilled gr...replacing elements in existing design files. Full details are in the attached document. When applying, please include a cost and turnaround time. This is the first of many products we need to update. Successful completion will lead to much future work. Key Requirements: - Editing existing images, creating new images and reformatting images to align with Amazon's standards - Creating photorealistic images that will captivate our target audience Ideal Skills and Experience: - Profound expertise in graphic design, particularly for e-commerce platforms like Amazon - Strong portfolio showcasing previous work in editing, creating and reformatting images - Experience with producing photorealistic images - Able to create captivating images that driv...
...Description: We are seeking an experienced Microsoft Word specialist to create a one-page template designed for low-vision clients who use screen readers. This project involves formatting and setting up a Word document to enhance accessibility and functionality. Requirements: Font and Style: Use a clear, sans-serif font like Arial or Calibri. The text should be bold to enhance readability. Fillable Fields: Integrate fillable fields where information can be entered by the user. Users should be able to navigate through fields using the keyboard TAB key. Accessibility: Ensure the template is fully accessible to screen readers by adding appropriate titles and tags. Use Word’s Accessibility Checker to ensure compliance and address any issues. Documen...
I am in need of Employment verifica...potential hires at Dr. José Ángel Álamo Military Hospital. The vetting process should: - Verify candidates' previous job titles and responsibilities. - Confirm the duration of their previous employment. Ideal skills and experience: - Expertise in employment background checks. - Knowledge of the healthcare industry, as it is a priority for these checks. - Ability to accurately interpret and document employment history. Additional Information: - Attention to detail and accuracy are crucial in ensuring the accuracy of the verification process. Candidate Volume: - The project involves vetting 1-5 candidates. Please note that this project does not require additional verification services such as drug testing, credit c...
I am in search of a proficient data entry specialist based in LATAM who can help me with various data management tasks... and interpreting data. - Data Cleaning: Your role will also involve cleaning data sets to ensure they are free from errors and inconsistencies. - Data Verification: You will need to cross-verify data to guarantee accuracy and reliability. Preferred Tools: - Proficiency in Microsoft Excel, Google Sheets, and CSV file format is preferred. Ideal Candidate: - Prior experience in data entry, processing, and cleaning. - Familiarity with data verification methods and tools. - Proficiency in Microsoft Excel, Google Sheets and CSV file format. - Attention to detail and accuracy in data management. Please note that the estimated amount of data to be processed...
I am seeking a skilled and talented AI Engineer to create a PDF file of a Platform infrastructure of AI chatbot for enterprise use. I have envisioned a concept that requires a creative mind to bring it to life. Requirements: - Proficiency in AI technologies and LLMs. - Strong experience in diagramming and technical documentation. Key Responsibilities: - Create a detailed and visually appealing PDF document that outlines all technical specifications, architecture designs, and system integrations. - Collaborate with cross-functional teams to gather requirements and ensure the infrastructure aligns with business goals and technical standards. - Stay updated with the latest trends in AI and chatbot technologies to recommend improvements and innovations. Desired Experi...
I'm looking for a skilled professional who can create more than 10 bar charts for a PowerPoint presentation. Requirements: - Proficiency in Microsoft Excel - Experience in visualizing survey results - Strong understanding of chart design principles The charts will need to visually represent survey data in a way that's engaging and easy to understand. Your role will be crucial in transforming raw data into meaningful insights. Please include relevant experience in your bid, and share any similar projects you’ve worked on in the past.
...during the Facebook login process. Error Handling and Logging: Enhance error handling mechanisms and implement robust logging to capture any future issues related to Facebook login for prompt resolution. Testing and Validation: Rigorously test the updated Facebook login functionality across various iOS devices and environments to ensure reliability and compatibility. Documentation and Reporting: Document all changes made to the Facebook login implementation and provide a comprehensive report outlining the issues addressed and the solutions implemented. Deliverables: Updated iOS app with fixed Facebook login functionality. Documentation detailing the changes made and any relevant insights gained during the troubleshooting process. Test reports demonstrating the successful validat...
I am in need of a freelancer who can swiftly handle two data entry projects. The tasks involved include: 1. Updating Gas Station Addresses: - The spreadsheet requires updating existing addres...I will share with you upon commencement of the project. 2. Car Make & Model List: - The second spreadsheet requires the creation of a comprehensive list of car makes and models, supplemented with brief, succinct descriptions of each car. - I have a list in word document, there may be some duplicates and there could also be more that I have not considered The successful freelancer need not have to be a subject matter expert, but should be able to undertake data entry tasks with accuracy and speed. Experience with Excel data manipulation and a keen eye for de...
...Manually navigating these complexities can be time-consuming, prone to errors, and lead to costly penalties. The term GCC stands for Gulf Country Council, which brings six Gulf nations together, i.e., Bahrain, Kuwait, Oman, Qatar, Saudi Arabia, and the United Arab Emirates. Introducing GCC Tax Laws GPT GCC Tax Laws GPT leverages the power of Generative Pre-trained Transformers (GPT) technology to create an intelligent and user-friendly solution for GCC Tax Laws compliance. Here's how it will work: • Automated Data Analysis: GCC Tax Laws GPT will be trained on vast amounts of GCC Tax Laws data, enabling it to analyze invoices, receipts, and other financial documents accurately. • Personalized GCC Tax Laws Guidance: GCC Tax Laws GPT will analyze your company'...
I need help with a moderately complex data cleaning project. My spreadsheet data has missing elements that need addressing. What this entails: - Locating and dealing with missing data in the spreadsheets - Proposing solutions to prevent future missing data The perfect candidate would proficient in Excel or similar spreadsheet software, and have a keen eye for detail. Past experience with data cleaning would be advantageous.
Please use the same color as the sample 1. Red and white. and use the text in sample 2. We can have 1 salty crepe and 1 sweet crepe on the logo or only one. Feel free to use your imagination. The company name is " La bonne crepe de Maman" The flag is Blue/white/red for France Food truck * Quality Product (Flag) Thank you everyone .
I'm seeking a skilled individual to automate a series of tasks on Microsoft Excel, Sharepoint, Microsoft Teams and Email, using Pulover Macro and AHK where needed. Requirements include: - Automating a series of tasks in Microsoft Excel. This includes data manipulation, data analysis and reporting. The process is already mapped out and can be shared with you. - Using Pulover Macro and AHK, as well as VBA to facilitate the automation process. - Ensuring the automation process involves uploading files to Sharepoint, sending messages on Teams, and emails. The key deliverable for you is not just the completion of the automation process, but a clear and concise explanation of each step once the task is finished. This will be crucial for future troubleshooting and ind...
I need a professional writer experienced in fluid dynamics to craft a concise report, less than 10 pages. This project aims to document some aspects of fluid dynamics in a comprehensive, but succinct manner. Below is a breakdown of what I expect: - Mastery of fluid dynamics: Although no specific areas were stipulated, an understanding and ability to explain core concepts in fluid dynamics is crucial. Experts in Computational fluid dynamics, Magnetohydrodynamics, or Hydrostatics are welcome. - Strong research and analytical skills: Even though the main purpose is documentation, you might need to sift through existing literature or studies to provide an accurate write-up. - Clear and Concise Writing: Given the short expected length of the report, it's critical for the freelan...
I have a list of contacts in an excel file, and I need someone to find their email addresses. - The main task will be to locate and verify the email addresses of these contacts. It is crucial that the emails provided are accurate. - The purpose of this exercise is for personalized outreach to these individuals and not for mass email marketing or research purposes. The ideal freelancer for this job is someone with excellent research skills, an ability to meticulously verify information, and experience in email marketing or personalized outreach. A high level of proficiency with Excel is also required. Files: There are lots of entries that need to be completed. you will need to add the email address of
We are looking for a highly skilled Technical Support Specialist to join our team remotely. As a Technical Support Specialist, you will be responsible for providing excellent customer service and technical assistance to our clients. Your main duties will include troubleshooting hardware and software issues, managing device configurations, and providing account support. To excel in this role, you should have a strong technical background, excellent problem-solving skills, and the ability to communicate effectively with customers. Skills required: - Technical troubleshooting - Device management - Account support - Customer service - Communication skills
I need an Excel sheet that can help me analyze customer information for trends and patterns. This will involve: - Basic Formulas and Functions: The data room should have basic formulas and functions that allow for the easy manipulation and analysis of customer data. - Data Room Design: The sheet should be designed to be user-friendly and intuitive, making it easy for me to analyze the data without getting lost in the spreadsheet. - Data Analysis: The main goal of this project is to analyze the customer data for trends. So, the ideal freelancer will have experience with data analysis and the ability to create custom formulas to uncover patterns. - Attention to Detail: Accuracy is key in this project. I need someone who is meticulous and can ensure that all the data is ente...
I'm looking for a skilled professional who can modify the permissions on a PDF document. Specifically, I need to remove the 'Edit' permission, while ensuring the edited document remains compatible with all versions of PDF viewers. Key Requirements: - Remove 'Edit' permission from the PDF - Ensure the PDF remains compatible with all versions of PDF viewers Your expertise in PDF editing is crucial, as this task requires precision and understanding of PDF security settings. It's important that the finished document retains its functionality across different PDF readers. Please note that I'm not looking for any watermark to be added to the PDF. If you're confident in your PDF editing skills and understand the nuances of PDF pe...
I'm seeking a skilled administrative assistant to support me in the following areas: - Document Preparation: A key part of the role will be to assist in the development of documents that will be used in the market research and competitor analysis processes. This includes everything from preparing spreadsheets to developing presentations. - Market Research: The assistant will need to conduct thorough market research to help us understand the competitive landscape. This will involve looking into trends, customer needs, and industry developments. - Competitor Analysis: Equally important is the need for the assistant to conduct competitor analysis. This will involve gathering data about our competitors, analyzing their strengths and weaknesses, and suggesting areas where we can ...
I am looking for an expert who can convert PDF files into Word files. They need to be compatible with both .doc and .docx formats. The converted Word files must match the exact format as the PDF including any images, charts, tables, or special characters present. Key skills and aptitudes for this job include: - Expertise in Microsoft Word - Strong attention to detail - Ability to accurately reproduce formats, images, charts, tables, and special characters - Familiarity with both .doc and .docx formats. Your main task will be to efficiently and accurately convert the files, preserving the format, images, charts and so on, to be exactly as they are in the PDF files. Please provide evidence of your past work in this field with your bid.
I need a professional translator to convert a 5-page medical document from Arabic to English. Requirements: - The subject matter is medical, so prior experience translating medical documents is a must. - The final format should be a Word document. - No certification is required. Please ensure that the translation is accurate, clear, and maintains the original meaning of the text. Ideal Skills: - Fluency in both Arabic and English - Proven experience in medical translation - Attention to detail and quality of translation - Ability to deliver in a timely manner
I am looking for a skilled Alteryx expert who can take on a project involving data blending from complex Excel spreadsheets. The project specifically involves: - Utilizing Alteryx for blending data from multiple sheets in Excel - Handling complex data structures within the Excel spreadsheets, including nested tables and formulas. Ideal candidates will have: - Proven experience with Alteryx, particularly in handling data blending tasks - Strong understanding of complex data structures, like those found in nested tables and formulas in Excel This project requires a high level of attention to detail and proficiency in data manipulation, so please only apply if you have the necessary expertise.
I am urgently seeking an experienced typist to help prepare a large Word document. Key details include: - The job involves over 100 pages that need typing. - The document is in Word format. - Turnaround time was not specified, but quicker turnaround times will be preferred. Ideal freelancers for this opportunity should have: - Speedy typing skills and high accuracy. - Proficiency and experience in Microsoft Word. - Availability to start working immediately, and dedicate a substantial amount of time to the project. - Strong attention to detail to minimize errors. This is an important job, so experienced typists only, please. Thank you for understanding.
Seeking an experienced ghostwriter to craft an engaging and educational 38,000-word eBook focused on longevity. The book aims to blend scientific insights with practical wisdom, exploring how readers can achieve a longer, healthier life by adopting the lifestyle habits of the world's longevity hotspots. Key Project Details: 1) Word Count: Approximately 38,000 words 2) Goal: The primary aim of this ebook is to educate readers about health and fitness, offer actionable tips for improving nutrition, and share strategies for promoting longevity. 3) Timeline: 2.5 to 3 months for completion, with regular milestone check-ins 4) Target Audience: Aging adults, health enthusiasts, and anyone interested in preventative health strategies 5) Tone and Style: Conversational, enga...
