Excel vba basicงาน
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 ที่กำหนดให้
...THE WORLD THAI CULTURE AND CITY THEN PLEASE MAKE THE BEST USE OF THIS CHANCE. Our Expectations: Have a great body and being a fit person who goes to gym frequently (male/female) (Sharing your full photo is mandatory to apply along with resume) Provide security or being a bodyguard or secretary for our client in person or their organization. Speaks Thai fluently and knows driving bike/car. Speak Basic English Familiar with all the tourist attractions in your area or clubs,nightlife. Ideas to make tourists happy for secretarial jobs by being creative, smart, honest, punctual and hard working (10-12 hours daily). Should be currently living in Pattaya or should make his/her own arrangements for staying in Pattaya during internship. The testing phase is between September 29 to Octob...
พิมพ์สูตรคณิตศาสตร์ได้ ตัวอย่างงาน
ต้องใช้ imacro คัดลอกข้อมูลจาก web site ลง excel
ปัจจุบัน TOPICA EDTECH GROUP ต้องการผู้ช่วยสอนภาษาอังกฤษ 20 คน ในโปรแกรม TOPICA หน้าที่: - ช่วยเหลืออาจารย์เจ้าของภาษาในคลาส Live Session Basic - สอนนักเรียนในคลาสสนทนา - ช่วยเหลือและปรับปรุงคลาสเรียนออนไลน์ให้มีประสิทธิภาพมากยิ่งขึ้น - ทดสอบทักษะภาษาอังกฤษของนักเรียนไทย สิทธิประโยชน์: - เงินเดือนดี ขึ้นอยู่กับจำนวนชั่วโมงที่คุณสอน - ไม่จำกัดชั่วโมงสอน - ทำงานที่บ้าน - ได้ทำงานกับอาจารย์เจ้าของภาษาเพื่อฝึกทักษะภาษาอังกฤษไปในตัว คุณสมบัติที่ต้องการ: - พูดภาษาไทยเป็นภาษาหลัก - สามารถสื่อสารภาษาอังกฤษได้ดี - มีความมั่นใจในการสื่อสาร ชัดเจนและไม่ติดอ่าง - ต้องมีอินเทอร์เนตที่เสถียร (สำหรับที่บ้าน)
คีย์ข้อมูลต่างๆลง Excel การคัดลอกบทความต่างๆลง word
ทำ presentation งานโดยใช้ Powerpoint สามารถแทรกงานที่เป็นข้อมูล ตารางและกราฟ จาก data ที่เป็น Excel
ต้องการให้ set-up ในส่วนของ WEB Hosting (ตั้งค่า DNS + อื่นๆ) Wordpress installation (Basic Themes)
I need a freelancer to help me type text from digital files to an Excel spreadsheet. - The data you will be typing is textual in nature, with the content coming from digital files. The final output should be an organized and error-free Excel spreadsheet. - Attention to detail is crucial. The ideal candidate for this job will have experience with data entry, exceptional typing speed and accuracy, and a track record of working efficiently with digital text and Excel. Please be sure to include any relevant experience and your estimated timeframe for completing this task.
...registration, excel upload, and assigning packages. Key Requirements: - Develop a user registration system: The module should collect the following user information: Name, Email address, Phone number, password, course, batch. - Implement an excel upload feature: Users should be able to upload excel files select of course and batch - Enable package assignment: The module should allow for the assignment of packages to users. while user registration or excel upload Ideal Skills and Experience: - Proficient in PHP: As the app is built on this platform, a strong expertise in PHP is essential. - Experience in user registration systems: The successful candidate should have experience in creating user registration modules. - Excel upload integration: Experie...
We are seeking a Flask (Python) developer to set up a dashboard for our project using the following template: Please provide a quote for this job and an estimated timeline for completion. Objectives: We need a small application to facilitate user onboarding for our messaging bot. The dashboard will manage new user onboarding and offer basic administrative features. Dashboard Pages: • /signup • /signin • /forgot-password • /reset-password o Authentication logic with two roles: user and admin o Forget / Reset password logic required • /home o Accessible to logged-in users only o Displays bot updates and useful links o Updates data retrieved from the database • /profile o Accessible to logged-in users only o Contains a user profile data form
...skilled and experienced person to create compelling and optimized product listings for my Etsy shop specializing in handmade beaded jewellery. The ideal candidate will have a strong understanding of Etsy’s platform and SEO practices, with a creative flair for writing engaging product descriptions that attract and convert potential buyers. They will prepare the listings based on the photos and basic info about the product provided by me. Key Responsibilities: Make new listings and optimise existing ones - Title Creation: Develop clear, descriptive, and keyword-rich titles for each product. - Photo Selection: Ensure high-quality photos (provided) are used effectively in listings. - Description Writing: Write detailed and engaging descriptions, including: - Overview: Brie...
I need someone to type a Word document based on handwritten notes I'll provide. The handwriting is very clear, so it should be easy to transcribe. Key Requirements: - Type a Word document - Basic formatting - including bold, italics and underline Please note that this project doesn't require complex formatting, such as tables or headers/footers. The document will be relatively straightforward to type, and I will be available for any clarifications if needed.
I'm looking for a ticket reservation system to help manage vehicle bookings at my car repair workshop. Key Features: - Customers should be able to specify the type of repairs they need by describing it in a text field. - The system should capture this information, along with the basic details like their name, contact information, and the time they'd like to come in for the repair. Skills and Experience Required: - Experience in building ticketing systems, ideally for a service-oriented business like a workshop or a customer support center. - Familiarity with implementing text fields for user input. - Good understanding of user experience and interface design for a seamless customer journey. - Knowledge in database management to store and retrieve customer information....
I need an Android or PC based application for creating quotations, generating invoices, and tax receipts. It should support offline functionality, with essential features available without an internet connection. Key Features: - Creating Quotations: The app should allow users to create comprehensive and customizable quotations, including options to choose profile, colour, glass, mosquito netting, etc. - Generating Invoices: Users should be able to conveniently generate invoices based on the created quotations. - Generating Tax Receipts: The app should also support the generation of tax receipts. Additional Requirements: - Save as PDF: The ability to save these documents in a PDF format is essential. - Customer Data: The app should maintain a database of customer information. - Edit Old ...
I have bank statements from Bank A that I need converted into an Excel spreadsheet. The specific transactions you'll be dealing with are both deposits and withdrawals. Here's what I need: - A thorough and meticulous translation of each individual transaction: both deposits and withdrawals. - Once this data is entered into the spreadsheet, I need you to sort it by transaction type. This role requires expertise in Excel and a keen eye for detail is essential, as the integrity of the data will be paramount. Knowledge about financial transactions, specifically deposits and withdrawals, will be useful. A background in bookkeeping or accounting will also be a plus.
I'm in need of a professional to convert my hand-drawn electrical schematics, which are currently in image file format, into electronic schematics. The ideal freelancer for this job would...hand-drawn electrical schematics, which are currently in image file format, into electronic schematics. The ideal freelancer for this job would be experienced in: - Electrical engineering - Using AutoCAD, as this is my preferred software for the electronic schematics The specific requirements for these electronic schematics are: - Must be editable - Detailed, but clear enough for anyone with a basic understanding of electrical schematics to read. Successfully completed projects with similar requirements will be appreciated during the selection process. I look forward to receiving ...
I am seeking a talented Autocad 2D expert to produce a basic layout for a single-level house. I am focusing on structural elements, so no interior design or material specification is needed at this phase. Ideal Skills and Experience: - Detailed knowledge of Autocad 2D - Proven experience in architectural design - Works efficiently and accurately - Familiar with residential building layouts
...should be able to easily locate, access, and view their desired highlights. - **Revenue Generation:** The website should be optimized for ad placements. The goal is to maximize revenue from viewership through strategic ad positioning and formats. - **Scalability:** As a new enterprise, the site should be scalable and able to handle increased traffic and content as the platform grows. - **SEO:** Basic SEO principles should be applied to enhance the website visibility and attract organic traffic. I'm looking for a freelancer who has experience in website development and design, particularly in the sports or video streaming industry. Familiarity with APIs and ad revenue generation is a plus. The ideal candidate should have a portfolio showcasing similar projects and the abilit...
I'm seeking an experienced developer to create an online script that can automate the conversion of CSV files. Script must be browser based and linux based. No preference on programming language. Source file will need to be uploaded to CSV converter, and script will sort data and rename columns based of pre-existing requirements. Once conversion is finished, download link generated to download updated CSV.
I'm seeking a seasoned Excel VBA developer to create a script that will regularly manipulate data within my Excel sheets. I have vba code run each 5 hours to export my excel sheets as pdf photos, but the problem here is my pdf photo sometimes not shown correctly, and sometimes its shows correctly. here is my vba code: For i = 1 To 57 '54 ' = False sheetxx(i).Select (Now + TimeValue("0:00:05")) ' "({1068})", True 'DoEvents pdffilename = fname2 & "" & sheetxx(i).Name & ".pdf" jpegfilename = fname2 & "" & sheetxx(i).Name & ".jpg" Shell ("D:khalid savescreenshot " & jpegfilename) ' (Now + ...
I need assistance with a simple Excel data entry task. This job purely consists of data entry and doesn't require any form of data analysis. The data I need entered includes names and addresses. Ideal Skills: - Proficiency in Excel - Attention to detail - Experience with data entry
I need a professional with excellent data entry skills to assist in cleaning and refining my existing data sets. The data is currently in Excel format, and I want it to be more organized and polished. Skills and Experience: - Proven data entry skills - Proficiency in Excel - Experience with data cleaning and refinement - Attention to detail Tasks to be completed: - Review the current data sets - Remove any inaccuracies or errors - Reorganize the data if needed - Ensure all data follows a consistent format The ideal candidate is someone with a keen eye for detail and the ability to handle large amounts of data efficiently. I expect prompt delivery and utmost accuracy in the task. If that's you, place your bid now!
I need a Python script that will help automate various tasks. Key tasks for this automation include: - File Management: the script should enable the organized handling of Word documents and Excel spreadsheets. - Data Entry: automation for data entry tasks. - Email Sending: automation for sending emails. The ideal candidate for this job should have: - Strong experience with Python scripting and automation. - Understanding of file management concepts and libraries in Python. - Ability to implement automated data entry and email sending functionalities. Looking forward to finding a professional who can deliver efficient, clean code for this project.
...take input as lists of 'subject, problem, idea', and output completed posts, but you're welcome to use a different AI if you want to. We've even generated a list of prompts to generate such good content, so this should be a very easy project. We just need you to have an AI generate the content and make sure all the details are correct. -that the AI didn't hallucinate anything. Formatting is very basic: Subject posts: a few lines of text and some tags. (subject posts are often placeholders for the more interesting content: problems and ideas) Problem posts: a few lines of text, tags, a few statistics with sources cited, and a section for "potential harm". Idea posts: : a few lines of text, tags, and a few statistics with sources cited. One last...
I'm in need of a skilled professional to help me evolve my business, focusing specifically on sales, marketing, and operations. - **Sales and Marketing**: The goals here are twofold; enhancing the visibility of o...Marketing**: The goals here are twofold; enhancing the visibility of our brand and improving our lead generation tactics. Experience in digital marketing, social media, and creative marketing strategy is essential. - **Operations and Processes**: Currently, these are handled manually which is time-consuming and inefficient. We're looking for someone to advise us, and possibly implement, a transition to basic or specialized software tools. Ideally, you should have a strong background in operations management and process design. Let's bring our operat...
We need to build a basic Digital Twin Model for manufacturing processes. Must have experience with Digital Twins.
I'm looking for an expert to create a level1 digital twin of my pyrolysis cyclone tower aimed specifically at optimizing operations. Key Responsibilities: - Develop a basic operational parameter-focused digital twin of the pyrolysis cyclone tower. - The process of feeding, vacumm, flash point, etc should be implemented. - Ensure the digital twin is designed to focus on optimization of operations. - The project's main goal is to enhance general performance and operational efficiency through the digital twin. Ideal Skills and Experience: - Proven experience in creating digital twins and simulations, especially in the area of operations optimization. - Proficiency in developing digital twins that focus specifically on operational parameters. - Experience in the pyrolysis in...
I urgently require an intermediate Visual Basic developer to enhance an existing system, focusing on the creation of user interfaces and the development of our database applications. The main tasks to be undertaken would include: - Enhancing UI for optimal user interaction - Optimizing our database application operations The ideal candidate would have proven experience in Visual Basic portal enhancements, an understanding of database structures and interfaces, and a knack for user-centric design. Your ability to perform automation of repetitive tasks would give you an upper hand. If you believe you could make a significant contribution to my project, please do place your bid.
...- Investments (especially individual stocks) - Debt - Savings - Income - Expenses - Other category for miscellaneous expenses or income - I require a simple, user-friendly design that makes manual data entry easy and intuitive. Skills and Experience: - Proficiency in spreadsheet software such as Excel or Google Sheets is essential. - Experience in financial tracking and net worth management is highly beneficial. - Understanding of stock market, investment tracking, and basic accounting principles is a plus. Delivery: - I expect the freelancer to deliver a comprehensive, error-free spreadsheet that meets the specified requirements. - The spreadsheet should be easily updatable and not reliant on external sources for data input. - A brief tutorial or guide o...
...specifically for MySQL database design. PowerShell scripting or similar would also be beneficial. This is a basic level project taking existing Local government procedures and converting them into SQL based processes. An example of which would be creating a import procedure for traffic count data that is presented in a text format (example attached) Ideal Skills: - Experienced with MySQL Database Design - Well-versed in SQL coding - Ability to simplify complex instructions - PowerShell for anything not possible in SQL This project will demand creativity and intelligence to design procedures that simplify data entry processes. Please only bid if you can offer solutions according to the basic complexity level specified. This initial project will just be designing a...
Hi Roman, If you remember, last year you did a project for me to show the list of participants of an event to me. I want to improve on that code and add some functionality and features to it. W...show the list of participants of an event to me. I want to improve on that code and add some functionality and features to it. Would you be available? We can chat about the details, but basically, this is what I want: I have an Excel file with different sheets. For example, Founders, Advisors, Announcements, and Media. I want a code similar to the previous code (of course, more complicated) to read this Excel file and show the content of each sheet in a different format (as the amount of type of information is different). I will share an example of the Excel file with ...
I am in search of an experienced email marketer who is proficient in Klaviyo. My email list currently exceeds 10,000 subscribers and my main goal is to boost product sales through strategic email campaigns and flows. Note we are an established brand so do need for basic flows. Key Responsibilities: - Develop and execute effective email marketing strategies to drive product sales - Ensure high deliverability and open rates - Create and optimize email templates for maximum engagement - Monitor and analyze campaign performance, making data-driven adjustments as needed Skills and Experience: - Proven track record of success in email marketing, specifically with Klaviyo - Prior experience working with large email lists - Strong understanding of best practices in email marketing - Anal...
I need a photographer for a portrait session tomorrow in Madrid at 9:00 a.m. It will be an indoor shoot with workwear, featuring a couple of changes. - Type of Photography: Portrait Photography - Editing: Basic (color adjustments, brightness, etc.) - Usage: The photos will be used for my social media and potentially for promotional material. Ideal Skills: - Experience in portrait photography - Proficiency in photo editing software - Previous experience shooting for social media and promotional content
