Excel vba sum based value columnงาน
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)
หน้าแบบฟอร์ใบเสนอราคา 1. ดึงข้อมูลลูกค้าจาก Database หรือ สามารถเพิ่มรายชื่อลูกค้าใหม่ได้เลย ใช้ Select2 1.1 เมื่อดึงข้อมูลลูกค้าได้มากแล้ว ให้ Auto fill ข้อมูลที่เลือเช่นที่อยู่ใบกำกับภาษี 2. ค้นหาข้อมูลสินค้าในฟอร์ม 2.1 ค้นหาข้อมูลสินค้าได้จาก Database ในช่อง SKU ได้ และ Auto Fill ช่องอื่นๆเช่นรายละเอียดและราคา 2.1 ค้นหาข้อมูลสินค้าได้จาก Database ในช่อง Detail ได้และ Auto Fill 3. SUM ราคาสินค้าแยก VAT และราคารวม 4. ส่งเอกสารให้ ลูกค้าได้ในรูปแบบไฟล์แนบ PDF และ Email ได้ทันที ข้อมูลตามรูปแนบบ ใช้ Codeinater และ Boostrap4
คัดลอกข้อมูลจากเว็บไซต์ คัดลอกข้อมูลจากเว็ปไซต์ลงในไฟล์excel
หาข้อมูล 16 อย่างของ Blogger จาก 50 fanpage แล้วกรอกลงให้ excel ที่กำหนดให้
พิมพ์สูตรคณิตศาสตร์ได้ ตัวอย่างงาน
ต้องใช้ imacro คัดลอกข้อมูลจาก web site ลง excel
คีย์ข้อมูลต่างๆลง Excel การคัดลอกบทความต่างๆลง word
ทำ presentation งานโดยใช้ Powerpoint สามารถแทรกงานที่เป็นข้อมูล ตารางและกราฟ จาก data ที่เป็น Excel
I am in need of experienced tele sales professionals who can help me in selling more than 100 delegate tickets for an upcoming conference in Visakhapatnam. The target audience for this conference is mainly entrepreneurs, startup founders. Key Requirements: - Cold calling experience - Proven track record in telesales Tasks: - Make cold calls to potential delegate ticket buyers - Present the value of attending the conference to them - Close the sale and record necessary details Ideal skills and experience: - Excellent communication and negotiation skills - Previous experience with tele sales, particularly in promoting events - Understanding of the needs and interests of entrepreneurs - Knowing Telugu would be an added advantage The success of this project will be measured on the ...
I'm in need of a skilled developer who can create a comprehensive multitenant subdomain distribution system for my ecommerce business. The platform will be built on Laravel, and the system should incorporate the following key features: - User Authentication: A secure and efficient user authentication system is crucial to the success of this project. - Product Management: The system should allow for easy and effective product management, enabling me to efficiently add, update, and remove products from the ecommerce page. - Payment Integration: A seamless payment integration system is essential for the success of the ecommerce page. - Custom Domain Support: The system should also support custom domain mapping, allowing my tenants to use their own domain names. The design of the ecom...
...agreement. 3. Share Transfer: Be cautious about the transfer of shares. Seek legal advice to understand the implications fully. Consider negotiating a buyback clause or provisions for liquidation of shares in case of disagreements or breaches of the agreement. 4. Annual Target and Share Purchase: Clearly define the annual targets for the Manager and the mechanism for calculating the fair market value of the company's shares. Ensure that these targets are realistic and achievable. 5. Valuation Process: Clarify the valuation process for the shares if there is a disagreement between the Parties. Consider including provisions for independent third-party valuation to ensure fairness and transparency. 6. Shares Held in Trust: Understand the implications of shares held in trust and...
I'm gearing up to amplify the reach and influence of a mobile app which has a strong role in addressing social and political issues. I'm seeking a...Audience: The campaign should be effectively aimed at individuals with keen interest in social and political matters. Employ your strategies to tap into this niche audience with resonance, driving meaningful engagement. - Messaging: While formulating the ads and campaigns, put a strong emphasis on the benefits users can derive from consistent usage of the app. Align messaging to underscore the value addition to their social and political perspectives. Ideal Candidate: - Previous experience running ad campaigns for App downloads. - Solid understanding of user behaviour in the social/political arena. - Proactive, strategic, a...
I'm in need of a proficient Excel specialist to help me with data analysis and entry. The task involves handling mixed data (both numeric and text) and providing valuable insights from analysis. This is a remote role, so email will be our preferred mode of communication. Ideal Skills and Experience: - Advanced Excel proficiency - Previous experience with data analysis and data entry - Ability to work with mixed data types - Strong analytical skills - Excellent communication through email
I'm looking for a skilled salesperson/assistant with experience in the technology industry. Your primary focus will be closing sales for our business. Key Responsibilities: - Engage in both email and phone calls to reach out to potential customers and close deals - Understand our technology products/services and effectively communicate their value to customers - Ability to handle objections and negotiate terms to reach a successful sale Ideal Skills: - Proven track record in B2B sales, preferably in the technology sector - Strong understanding of sales strategies and techniques - Excellent communication and interpersonal skills - Ability to work independently and as part of a team - Proficient in email communications and phone sales This project is ideal for a sales profes...
I'm looking for a talented WordPress developer to build my website. I will provide the template. I will provide the design idea and you implement the design, so you will not have to worry about that, but I do need assistance implementing it into WordPress. Specifically, I expect: - Implementation of my provided design into the WordPress plat...feature for my online products - A custom contact forms for client queries I have a specific WordPress theme in mind, details of which I will share after hiring. Ideally, you have extensive experience in WordPress, particularly in building e-commerce sites, and in working with custom themes. Your expertise in my theme would be a huge plus. I'm also looking for someone who's communicative, as I value clear and consistent commu...
Looking for a personal assistant who is ideally based in Indonesia to support a busy executive/business owner to manager various admin related tasks. These include: - Online research for home renovations / home moving - Bookkeeping and data entry of receipts and audit of existing receipts and invoices - Budget management - Online research for furniture and home decorative items (Gumtree / Facebook Market Place and Google) Immediate start and must be familiar with Google Workspace (G sheets, G docs, Gmail and etc.
I'm in need of a custom bill format in Excel that incorporates my company's logo and branding. The bill should have automated calculations for the ease of use. Key Requirements: - A customized Excel bill format with a professional finish - Integration of the company's logo and branding into the bill - Automation of calculations within the bill Ideal Skills: - Proficiency in Excel, including advanced formula creation - Experience in design, particularly in creating professional, branded documents - Understanding of automated calculations and their implementation within Excel Upon completion, I expect to receive the Excel file with the custom bill template.
I am intending to develop a data flow network using Lingo as the programming language. The main focus of this project is to build a network that primarily caters to service providers. Key requirements for potential freelancers include: - Proficiency in Lingo - Proven experience in the creation of data flow networks - Strong understanding of the service providers' operational needs - Ability to execute tasks on time and to standard This exciting project is an excellent opportunity for tech-savvy minds who are keen to demonstrate their skills and problem-solving abilities.
I'm looking to create a comprehensive business plan for a radio station that targets adults aged 15-60. I require significant help to make my venture bank-ready. I would specifically like assistance with: • Defining clear goals and corresponding strategies. • Detailing my unique value proposition. • Demonstrating market understanding and target demographic. • Creating robust financial projections. The ideal freelancer for this task will have a strong background in business planning, knowledge of the media sector, the radio industry in particular, and previous experience in preparing business plans for obtaining bank financing. Your ability to conduct market research and in-depth understanding of financial forecasting would greatly benefit this project. D...
I'm looking for a professional who can assist in converting screenshots, which already depict data set in tables, into Excel tables. The purpose of this task is to better analyze the data, which is purely textual in nature. The ideal freelancer for this job would be experienced in data entry, with a particular emphasis on Excel, and have an eye for detail to ensure all data is transferred accurately. There's no requirement for interpretation or analysis, I simply need the information from the images moved into an Excel format. Attached is a sample of the screenshot.
I need a capability statement that explicitly showcases what our company excels at and the value we can bring to your construction projects. This document will target builders, and hence it should be tailored for this specific audience. Key Information to Include: - Previous Projects and Accomplishments: This should highlight our success stories and notable projects in the construction sector. Any big names we've worked with or significant milestones we've achieved should be articulated. - Company Background and History: A concise summary of our company's background and history. This should give an overview of our evolution, ethos, and what sets us apart in the industry. - List of Services Offered: A detailed list of the services we offer in the construction field. T...
I have Excel sheet in the are all products added with all the categories in it. I will also share a word file in which I will add that specific category and you have to take out the data from sheet and create the image in Photoshop. I will also give you product images with it's specific name. You have to only remove background and add text and image according to the data. The person must have latest Photoshop and have to create one sample image. You have to leave the space also for the main video and have to choose a shape or space according to the data Here are the links to sample: My budget is Rs.50 per image. There are 10-11 images which you have to create and I need it by today. This
I'm in need of an experienced React Developer to develop a webapp for my project. Should be able to implement user authentication, responsive design, and integration with third-party APIs into my project. A key authentication functionality is Whatsapp OTP based login. Ideally, you're versed in creating a bold and colorful layout that pops. I value clean code and innovative solutions. Strong knowledge of React and previous experience with Whatsapp API are essential. Look forward to your bids.
I need a proficient freelancer to help convert my Excel files, containing both numerical and textual data, into Word documents. The aim of this conversion is to ease the process of creating reports. The data should be precisely formatted into tables in the Word documents for a cleaner presentation. The ideal candidate would require: - Excellent skills in Microsoft Excel and Word. - Proficiency in data conversion and formatting. - Attention to detail to maintain data integrity. - High regard for timeliness and efficiency. Understanding the importance of report creation in business communication, this work must be meticulously done, reflecting professionalism in every converted document.
I'm keen on gathering a customized list of up to 50 nano or micro influencers who are distinguished in the pet food product niche. The preferred influencers are mainly thos...or YouTube. To attract quality bids, freelancers should possess: - Expertise in Social Media and YouTube data gathering. - A strong understanding of the pet products industry. - Ability to identify key influencers in the pet products niche. - Tracking and reporting capabilities. Freelancers with current experience in influencer research will be given priority. The deliverable is a Report (Excel format preferably) that includes: - Full Name of the nano/micro Influencer - Profile Link - Username - Channel Name - Channel Type (IG, FB, YT, etc) - Email (must be current and valid) - Engagement Ratio - So...
I need an expert in financial analysis to evaluate the financial performance of a project centered around HDFC Bank. Key Requirements: - Analyze Share Value: The primary task involves analyzing the share value of the project. - Provide Recommendations: You will be expected to provide clear and justified recommendations of whether to buy, sell, or hold the share. - Draw Conclusions: Based on your analysis and recommendations, a conclusive statement on the project's financial performance is crucial. Ideal Skills: - Proven Experience: A strong background in financial analysis, particularly in evaluating financial performance. - Proficiency in HDFC Bank: Prior experience in analyzing the financials of HDFC Bank or similar institutions would be a plus. - Data Interp...
I'm in need of affiliate marketer to promote a specific software; a website administration tool. This is a commission-based role, and your focus will be to boost sales and visibility of this particular software. Here are my expectations: - You should have substantial knowledge in website administration software - Proven experience in affiliate marketing is vital - Having any former marketing experience revolving around software would be a great advantage Please, kindly note that there's no specific functionality or feature for the tool that should be primarily promoted. Your goal is to universally market this software to prospective buyers and commission is pay based on the sales generated
I am seeking a highly skilled and experienced electronics engineer who can develop a wireless multimeter using the ESP32 module. This device should possess the functionality to measure voltage, current and resistance with a high degree of accuracy. Key Features: - Voltage Measurement: The multimeter should provide accurate voltage measurements. Experience with similar projects is desirable. - Current Measurement: The multimeter should also be designed to accurately measure current - previous experience with this feature is necessary. - Resistance Measurement: The device must measure resistance without error. A strong background in this area is required. The output from these measurements should be conveniently displayed on a mobile app. For this, I need a developer with experience in wi...
I'm seeking a talented designer to create a distinctive and functional outfit for women's competitive tennis. SINGLET AND SKIRT Key Points: - The outfit will consist of a singlet and skirt. The specific fabric for the outfit is yet to be decided. - It shoul...appealing, suitable for the competitive tennis environment. Requirements: - Strong design skills, particularly in sportswear. - Experience in creating custom clothing for sports. - Knowledge of functional and performance-enhancing fabrics. - A keen eye for fashion and current trends in sportswear. Your task is to develop a unique and high-performing outfit that will help a female tennis player excel in competitive play. The successful design should not only enhance performance but also make a distinct fashion sta...
...Meet or exceed expectations in relation to the modern look and feel that is the goal of this project - Think outside the box and propose creative ways in adhering to the modern style. - Initiate project with a detailed design strategy before proceeding to actual implementation I am open to proposals and ready to discuss further details as needed. Your creativity and professionalism will add value to this project. Let's join hands together to create a unique portfolio....
Function is done, amend the label that is stored and the value show. Only with ftp
...the specifics: Experience: Please share how many years you’ve been working in animation. Whether you’re a seasoned pro or a rising star, we want to know! Portfolio: Provide a few examples of your best work. Show us your range – from character animation to environmental design. We’re interested in seeing both 2D and 3D pieces. Quality and Pricing: Let us know what you charge for your services. We value quality, so be transparent about your rates. Whether it’s per project or hourly, give us an idea of what to expect. How to Apply: If you’re excited about joining our team, send us a message with the subject line “Animation Artist Application.” In the body of your message, introduce yourself, attach your portfolio, and include your pri...
I'm seeking a skilled developer to build a speaker identifier using Python and the Siamese Network model. It must be able to: - Differentiate between multiple speakers in a single audio clip - Identify the same speaker across different audio clips The developed system should accept .WAV as the input format. It's crucial for the prospective freelancer to be proficient in Python, with a deep understanding of Siamese Networks and audio processing. Sound knowledge of Machine Learning principles and techniques would also be a plus. ** explain the code
...need a gifted artist to bring the characters of my manga to life. Key requirements: - Mastery in Shounen style drawing. You'll be creating artwork that needs to blend seamlessly with the energised, action-oriented style typically found in shounen manga. Previous experience in this area is essential. - Collaborative mindset. While I'll be providing some direction for the scenes, I also value your creative input. Bring my characters and scenes up a notch with your imagination and level of detail. - Capacity for complexity. There will be 7 or more characters included in the anime drawings. Experience in detail-oriented work with multiple characters is advantageous. Your application will stand out if you can show previous artworks you've produced in th...
Looking for an experienced embedded systems developer to assist with bringing an existing prototype to market. More information will be provided on request but broadly speaking current prototype is based on a series of ESP32 modules using ESP-IDF. We're seeking a developer/engineer experienced in PCB design and firmware development on the ESP32 platform with particular experience on fine-grained optimisation of memory management.
I'm interested in building a robust, web-based Customer Relationship Management (CRM) app aimed at small to medium-sized businesses, as well as burgeoning startups. My expectation is a system that integrates three-fold functionality: • Coherent Contact Management: integration of an intuitive system to store and manage contact information. • Flawless Deal Tracking: A real-time, efficient system to track ongoing deals and future opportunities - very crucial for operations. • Advanced Email Tracking: A system that allows the tracking of sent and received emails, giving real-time updates and promoting efficient communication. In addition, the app should cater to finance, IT and HR operations, to facilitate seamless business activities. Developers adept in CRM softw...
I'm releasing a book (a gay romantic fiction) in the summer under a pseudonym, and I want to have somebody take photos of the book with parts of their body in the frame in a way which will be very shareable o...Instagram / Tiktok / Twitter etc. The photos would not feature your face. Example photos might be: - The book on your bed, while your legs are either side. - The book in your hands while you sit cross legged on the sofa. - The book resting on your torso is the sort of thing I have in mind. Requirements - Young (18+) white male - UK-based (so I can easily post my book to you) - Preferably has an e-reader (to include my ebook in the shot) but not essential - Physically attractive arms / legs / torso (no faces necessary)
