Microsoft excel vba project organizationงาน
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)
สร้างฐานข้อมูลเกี่ยวกับรายการอาหารและเชื่อมข้อมูลเข้ากับตัวเว็ป หรือสามารถให้คำปรึกษาและสอน สามารถสื่อสารช่องทางออนไลน์(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 ...
หาข้อมูล 16 อย่างของ Blogger จาก 50 fanpage แล้วกรอกลงให้ excel ที่กำหนดให้
...Direct Transfer, or Rabbit Line Payment • List Donation Transactions - Search for all the donation transactions based on the input from donors like citizen id, full name, and mobile number Administrators • Manage Organizations - List all organization that were registered so far and can be filtered by some information • Register Organizations - Input form to register new organizations • Update Organizations - Update form to modify some information about registered organizations • Remove Organizations - A confirmation page to delete an organization • View Donation History - List all the transactions made during a period and can be filtered by some information • System Parameter Configuration - Display the current system paramet...
...WILL BE OUR PILOT BATCH. IN CASE YOU ARE INTERESTED IN SHOWING 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...
พิมพ์สูตรคณิตศาสตร์ได้ ตัวอย่างงาน
ทำ 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 แสดงรุ่น รุ่นย่อยทั้งหมดตามเงื่อนไขที่...
ต้องใช้ imacro คัดลอกข้อมูลจาก web site ลง excel
คีย์ข้อมูลต่างๆลง Excel การคัดลอกบทความต่างๆลง word
ทำ presentation งานโดยใช้ Powerpoint สามารถแทรกงานที่เป็นข้อมูล ตารางและกราฟ จาก data ที่เป็น Excel
กรอกข้อมูลลงในตารางหรือพิมพ์ข้อมูลผ่านโปรแกรม Microsoft office
I am seeking a detail-oriented freelancer to assist with entering customer feedback data into an Excel spreadsheet. Your main task will involve collecting data from online survey results and precisely transferring them. Ideal Skills: - Proficient in Excel data entry - Ability to work accurately and efficiently - Experience in handling customer feedback data Your goal will be to help me organize these crucial insights to enhance our customer's experience. Accuracy, attention to detail and discretion with confidential information will be critical.
I'm struggling with the latest version of Evernote on my Mac. Can you help me with the following issues? - User Interface Changes: The new version has a different interface, which I'm finding confusing and disruptive to my workflow. - Syncing Issues: I'm having trouble syncing my notes across my devices. It's causing issues in terms of accessing and updating my data. - Note Organization Changes: The way notes are organized in the new version has also changed. I need assistance in understanding and adapting to this new system. I'm looking for someone who is experienced with Evernote, especially the latest Mac version. Your job would be to help me understand and effectively use the new features, as well as troubleshoot any syncing issues.
I require a meticulous individual who is adept at data entry into Excel, with precision and accuracy being top priorities. - The task involves entering various types of data, including numeric, text, and alphanumeric, ensuring it is correctly and appropriately categorized. - The Excel sheet will consist of two columns which will require careful management for data uniformity and consistency. - The entered data should be organized based on the input order, therefore, attention to chronological details is paramount. The successful bidder should have proficient data entry skills and a keen eye for detail for successful completion of this project. Prior experience in similar projects would be an advantage.
Please read the attached instruction sheet along with below details before you bid Kindly bid if you are experienced in image editing...set in pixel -900 X 700+s...image or website link, The same shall be shared to you as per the required data. Any visible imperfections need to be painstakingly cleared off. Each picture will have to be improved in terms of lighting and contrast to make it more visually appealing. 2) the Size of the image should be 900 X 700 (Sample attached for your reference) 3) No Duplicates images should be created even if the brochure /excel or images (provided twice by us)has got duplicates 4) If the images are not clear as per the 900 X 700... YOU shall consider the image from the website. we will share you the link for your understanding if you require the a...
I am searching for a proficient and attentive freelancer to assist with data entry tasks, specifically within Microsoft Excel. The role will require the successful candidate to be highly tech-savvy, with a strong background in Excel and an eye for detail. Key Responsibilities: - Handle diverse data entry tasks within Microsoft Excel - Ensure accuracy and consistency throughout the Excel spreadsheets - Offer quick turnaround times for tasks, while maintaining quality Ideal Skills: - Excellent knowledge and proficiency in Microsoft Excel - Previous experience in data entry roles - Strong attention to detail and accuracy - Ability to work quickly and efficiently under minimal supervision.
I need a training manual created from a series of PowerPoint sli...Requirements: - Design a moderately detailed cover for the manual that reflects its training purpose. The design should be visually appealing and professional. - The manual should be a clear and easily accessible guide to the training content. - No interactive elements are required. Skills and Experience: - Experience with graphic design, particularly in creating book or manual covers. - Proficiency in Microsoft PowerPoint and the ability to convert slides into a cohesive document. - Understanding of instructional design and the ability to create a logical and user-friendly structure for the manual. The ideal freelancer will be able to translate the content from the slides into a well-designed, print-ready traini...
...JPEG diagrams into visually engaging PowerPoint slides (Or maybe Microsoft word) The goal is to make presenting information more impactful and striking. I have attached both the images that I require to be update/remade. These are the only copies that I have in png file types. - Modernisation: Though I'd like the new diagrams to reflect a revised color palette as the originals, I am keen for an updated, fresher look to make the overall presentation contemporary. I am also happy to used new/revised people icons. - Simplicity: I do not require any interactive elements like hyperlinks or animations, just a clean, aesthetically pleasing design that can effectively communicate the information. Ideal freelancers for this project would possess strong PowerPoint skills,...
I have code for login trading accound and fetch token data. I need to update more data from the code to my system.I need to collect live data from the web and candle stick, Mins Intervals are in Dropdown box, I can choose any minutes interval, I need you to collect Last 5 candle data from the Excel in the web and other details for each token, I will give token name in the excel, It will automatically display the rows of data. If i chanage time interval it will display those data only. Need ot automate the buy/sell order Note: I dont know about coding, If you install the code and run successfully at my system thereafter I will hire you and release the payment. If you agree this term you will apply this task Budet is 600 INR and Good review, Dont expect more I am not big fish...
Seeking an expert Access Developer to undertake some key aspects of a large-scale relational database for our office team. Tasks include: - Database Design and Development:...robust relational database incorporating more than 20 tables. - Form Creation and Customization: Create and customize user-friendly forms for data input and manipulation. - Report Generation and Analysis: Design analytical reports that will aid our decision making. Ideal skills: Proficiency in Microsoft Access, understanding of relational database theory and form design, experience with report generation and analysis. Prior experience working on large-scale databases would be a plus. This project offers a challenge but also a great opportunity for you to showcase your expertise and abilities as an ...
As a business with diverse inventory, I am in need of an application to generate unique SKUs, track their usage, and store pertinent SKU information. A distinctive facet of the project will be the creation of a custom format SKU algorithm incorporating department codes, which will ensure efficient identification and organization on our part. As such, a freelancer with a background in inventory management systems or similar projects would be advantageous. This job will require: We have a convention to follow for creation of the SKU IDS. Furthermore I want the ability to add product images at the time of generating the SKU. - Strong knowledge in application development. - Experience with custom format algorithms. - Understanding of department code incorporation. - Skills in S...
...small scale of not more than one hundred websites each day. ******* TESTING ******* You must test your script on Linux Mint 21.3 Cinnamon Edition to ensure that it runs properly on Python 3.10.12, on the current stable version of Google Chrome, on Linux Mint 21.3 Cinnamon Edition. I do not care if your script runs on any other operating systems or any other browsers. If you typically use Microsoft Windows, please consider setting up a virtual machine to install Linux Mint 21.3 Cinnamon Edition so you can test your code properly. In particular, if I were to send you a bug report, I would not like to receive a reply from you like, “The script works 100% perfectly for me on Google Chrome on Windows 11. Because I am a 100% perfect engineer, who always ships code that is 10...
...charitable organization raise funds to supply medical equipment to people in need in Israel (for starters). We are a USA charity, registered with the IRS. We have a website and payment portal ready. We also have initial marketing being carried out with The Times of Israel. Eventually, we will be expanding the scope of our service. We have suppliers and logistics for delivery of donated equipment. We have an online payment portal and are now ready for action. Your Present Role Involves: - Figuring out how to build momentum within the Jewish community, and with any other people or groups who have goodwill, who would be willing to help injured persons gain faster, better recovery with gifts of leading edge virtual reality rehabilitation systems. The initiative is called ...
I'm looking for a skille...feedback, and track progress of administrators over time. - The platform should include a user-friendly interface for managers to easily access and navigate through. - Integration with email services is essential. Notifications for upcoming reviews, reminders, and other relevant communication should be sent through this system. - Calendar scheduling tools should also be incorporated to allow easy organization of review meetings. Ideal Skills and Experience: - Proficiency in web development, particularly for building interactive and user-friendly platforms. - Experience with HR-related platforms is a plus. - A strong understanding of performance review processes and best practices. - Familiarity with integrating email services and calendar tools into ...
I'm looking to elevate our existing WordPress website for my Native lead non-profit organization. Currently we have a Wordpress site I’ve designed with Elementor, however I am not a web designer and we’d like to bring it to a professional level. Our main goal is to build connections and promote dialogue with Native American tribal communities around Nuclear Energy and consent-based siting of spent fuel. Key functionality for the site includes: - Blogging: To share our upcoming events, updates, and highlight why this is important to Native Americans. - Information: We want to share info about consent-based siting, as well as nuclear energy, and our coalition that seeks to work for tribes. - Contact: A clear and easy way for visitors to find our information and re...
It's time for an essential task: looking for an experienced freelancer who can single-handedly generate leads for medical supplies. I'm focusing on three indispensable items: masks, gloves, and ...name Ideal Profile: - Our ideal customers are wholesale distributors. Experience in this segment is a significant plus, and any knowledge or connections in the medical supply industry are warmly welcomed. Skills and Experience: - Proven lead generation record - Strong understanding of the medical supply industry - Excellent communication skills for collecting contacts - Proficiency in data organization and record-keeping We'll need a freelancer who can effectively generate leads and hopefully, open avenues for fruitful, long-term relationships with new distributors. Let&#...
As an organization, we aim to significantly boost our network security. Thus, we're seeking a skilled professional capable of: - Configuring firewall - Implementing an effective Intrusion Detection System - Establishing secure remote access Unfortunately, we skipped out on specifying our preferred secured remote access service and the size of our network infrastructure during the initial stages. However, we encourage applicants to be fully versatile with VPN, SSH, RDP, and to be equipped to handle infrastructure of various sizes. Prior experience with these areas will be advantageous. Do you have what it takes to help us execute a thorough network security overhaul? If so, we want to hear from you!
I am seeking a highly meticul...Responsibilities: -Conduct basic research to locate contact information for 25 specified agencies. -Validate that email addresses are current and active. -Accurately enter all data into a provided spreadsheet format. Requirements: -Experience in data collection and validation. -Proficiency in basic research and use of spreadsheets (e.g., Google Sheets or Microsoft Excel). -Ability to deliver accurate results within a set timeframe. -Project Length: Short-term, estimated completion within one week. ( MAX 80 AUD as a test round, if the work is good, Larger jobs will come) Application Instructions: Please message me with the keyword "VSL" at the beginning of your application to confirm that you have fully read and understoo...
I'm in need of a professional who can assist with a PERT analysis for my project scheduling needs. - The focus of this job is on project scheduling - I would require the PERT analysis to be at a small task level; a detailed task breakdown is not necessary - You will need to integrate the PERT analysis with Microsoft Project This project would be most suitable for a freelancer with: - Proficiency in PERT analysis - Experience with project scheduling - Knowledge of Microsoft Project or similar tools
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.
...opportunities for our organization and writing polished proposals to earn Ontario & Federal government grant money. The Grant Writer will identify, define and develop funding sources to support existing and planned program activities as well as lead the development, writing, and submission of grant proposals to the Ontario/Canadian Federal Government. Primary responsibilities include preparation of proposals and grant applications, and performance of responsible professional and administrative work in researching, identifying, developing and responding to Ontario/Canadian grant opportunities in areas that support IT, Digital Marketing & SEO programs. Essential Functions * Understand the history, structure, objectives, programs and financial needs of our organizatio...
I'm seeking a professional able to create a custom CRM system in Excel for my business. Key requirements: - Sales Tracking: I need a system that allows me to monitor sales performance and forecast future sales. - Task Management: The CRM should have a task management feature to help me organize and prioritize my daily activities. Additional details: - The system will be used by a small team of 1-10 users, so it needs to be user-friendly and easy to navigate. - No integration with other software or platforms is needed at this time, so the focus will be solely on creating a robust, efficient Excel-based CRM. Ideal skills and experience for this job would include: - Proficiency in Excel, with a clear understanding of how to create complex formulas and visual repre...
I'm in urgent need of a seasoned fundraiser to help raise $100,000 for a non-profit organization. Your assistance will be invaluable in helping us reach our goal. Key Responsibilities: - Crowdfunding Campaign: You'll be in charge of creating and managing an online crowdfunding campaign. This will involve setting up the campaign, engaging with potential donors, and ensuring that the campaign stays on track. - Grant Writing: You should also have a proven track record in grant writing. You will be responsible for identifying suitable grant opportunities, crafting compelling proposals, and submitting them within deadlines. Ideal Skills and Experience: - Extensive experience in both online crowdfunding and grant writing, preferably within the non-profit sector. - Strong commu...
...looking for someone experienced in web scraping and data collation. The project will involve scraping blog articles in HTML format and compiling desired information into an Excel file. Key Project Requirements: * The extraction will be from specified URLs, using their individual patterns for efficient and accurate scraping. * For each blog article, I need the title, the full text, and the publish date extracted. * This scraped data must be properly arranged in an Excel file for easy analysis. * List of articles is here: Ideal Candidate Expertise: * Proven experience in web scraping is a must, preferably with full understanding of HTML structures. * Proficiency in Excel and data organization. * Attention to detail to ensure accuracy of the sc...
