Excel vba multiple buttons single macroงาน
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 เป็นเมนูที่จะโทรออกอัตโนมัติ
...สามารถ 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)
หาข้อมูล 16 อย่างของ Blogger จาก 50 fanpage แล้วกรอกลงให้ excel ที่กำหนดให้
พิมพ์สูตรคณิตศาสตร์ได้ ตัวอย่างงาน
ต้องใช้ imacro คัดลอกข้อมูลจาก web site ลง excel
คีย์ข้อมูลต่างๆลง Excel การคัดลอกบทความต่างๆลง word
ทำ presentation งานโดยใช้ Powerpoint สามารถแทรกงานที่เป็นข้อมูล ตารางและกราฟ จาก data ที่เป็น Excel
Programming with c # or C ++ connected to the camera. Face Detection with Face snapshot datetime into the database with MySQL. CCTV ( Detection Face of multiple pages on a single ticket )
I'm looking for a skilled developer to create a Bitcoin HD wallet with specific features for the web platform. This wallet should also enable the tracking of incoming deposits and ensure secure user authentication. Key Features: - Generate new Bitcoin addresses: The wallet must be able to create and manage a sequence of addresses derived from a single seed. - Monitor transactions: The platform should provide real-time updates on incoming transactions to the user's wallet. - Secure user authentication: secure authentication system to protect the user's funds and personal information. Ideal Skills: - Proficient in Bitcoin and Blockchain technology - Strong experience in web development and security - Familiarity with HD wallet implementation - Knowledge in real-time...
...allowing for easy toggling between hardcore mode and regular mode. PROJECT DETAILS = = = = - Objective: Modify Minecraft gameplay to toggle hardcore mode on and off seamlessly. - Functionality: When the hardcore mode is activated, players and those they kill are permanently put into spectator mode, except for using commands. - The toggle switch is in the form of 'canon off' and 'canon on' buttons, with 'on' activating the hardcore aspect. - All players should be able to toggle between modes without accessing creative mode. - Hardcore mode operates irrespective of the activity status of the killed player. - Deliverables: - Fully functional mod integrated into the Minecraft SMP server. - Clear documentation outlining the mod's funct...
I urgently need an experienced web scraper who can extract data efficiently from multiple websites. Applicants' guidelines are as follows: 1. Websites for Scraping: Due to security concerns, the websites to be scraped will only be shared with the selected freelancer. 2. Application Contents: I didn't explicitly mention what I want freelancers to include in their applications. However, demonstrating your skills, experience, and past work related to web scraping will surely be a significant advantage. 3. Project Deadline: I require this project to be completed as soon as possible. Please include your estimated completion date in your proposal. Ideal Skills & Experience: - Proven experience in web scraping - Knowledge of Python, Selenium or other scraping tools - Stro...
I'm seeking a proficient Laravel-Vue expert to join an existing project. Without specific details, I am assuming the need for: 1. User Authentication - Implement secure, robust user authentication. 2. Real-time Updates - Add real-time functionalities to ensure smooth, responsive interactions for end-users. 3. API Integration - Integrate multiple APIs for efficient data utilization. The project's nature remains unclear, whether it’s modifying existing features or creating new ones. Hence, applicants should be comfortable with both. Ideal Skills: - Proficient in Laravel and Vue.js - Experience in API integrations - Strong understanding of real-time update implementation - Sound knowledge of defensive programming and user authentication mechanisms Freelancers inter...
...also, please instruct us how to create this specific users. - Co-ordinator in project/Task can also edit the project/task/so/sales/quotation / purchase order and all custom modules we created - Additional five Project list reports, just use the existing one and change the fields, add one combine report and one button or dropdown list then generate that. - Task, one click to update or add, create buttons in the task, then each button can copy the certain fields data from project to the certain fields in task? For example, click button one can copy project name and dates fields to task project name and dates, click button two can copy ETA and ETD from project to task ETA and ETD, click button three will copy project ETA 2 and ETD 2 to task ETA and ETD fields, etc... And it won'...
I require a knowledgeable freelancer to build an Excel sales order form which can handle multiple ship dates and calculate discounts on a sliding scale. Key Functionalities: - Multiple ship dates: I would like customers to choose their ship dates from a calendar function. - Discount calculation: Discounts should be calculated on a sliding scale based on the volume of the order. The ideal person for this task will have proven experience in building advanced Excel spreadsheets, primarily focusing on dates manipulation and financial calculations. An understanding of sales processes, specifically as it relates to ship dates and discounts, is advantageous.
I am looking for an expert in Doorbird system to help maximize the efficiency of my home unit, focusing specifically on: Access control: - Enable the system to control multiple doors and garage openers - Allow to lock/unlock remotely - Add a keypad entry system for a streamlined user experience. Automation: - Automize processes where possible for ease of use Ideal Skills: - Extensive knowledge in Doorbird systems - Experience in automating security systems - Expertise in integrating varying access control systems, particularly with keypad entry systems and magnetic locks Your will help me document the current setup, explore technologies and products to purchase, make a plan incl. wire diagrams. Proven experience with home automation (doorbird a1018, doorbird D2101) systems...
Our client seeks a skilled contractor to manage a network of 40 WordPress blogs. This is a... firewall configuration, virus scanning, intrusion prevention. SEO: Basic on-site/off-site optimization, Google Search Console, Google Analytics, Google Webmaster Tools, Google ReCaptcha, cookie consent implementation. The Ideal Candidate: Demonstrated WordPress administration expertise Strong security background with experience in infection cleanup. Proven ability to manage multiple websites simultaneously. Knowledge of SEO best practices. Excellent problem-solving and communication skills. Important: Our client's VPS experiences persistent infections despite current security measures. This role requires strong troubleshooting skills to identify and resolve t...
I'm currently looking for a React developer with knowledge in the use for FiveM, I'm just looking for a single developer, not companies or teams. I need the developer to do the frontend and call the events as the are called in the FiveM Game.
โปรดลงทะเบียน หรือเข้าสู่ระบบ เพื่อดูรายละเอียด
I'm in need of a professional who can develop a desktop application that can generate add...token. Some key details about the project include: - The token will be built on the Solana blockchain, so experience with this platform is essential. - The desktop application needs to support multiple operating systems – Windows, macOS, and Linux. - The address generation feature should be seamless and reliable. I'm looking for a skilled developer who has experience in creating cryptocurrency-related applications, particularly on the Solana blockchain. The ideal candidate should have a good understanding of blockchain technology and be proficient in developing desktop applications for multiple operating systems. Please provide your portfolio demonstrating your ex...
I'm in need of an AI-Powered Technical Service Desk that can effectively handle a variety of technical issues, particularly those related to hardware, software, and network setups. Overview: I'm looking to create an MVP of an AI-assisted technical service desk tool. The goal is to prototype the core capabilities of ingesting, analyzing, and respondi...Anyone who submits a new bid that is more than 10% of their initial bid will be eliminated due to not doing their due diligence. Final selection will be made on final proposal (time/cost/incentives). If the winner does not perform or communicate, the project will be cancelled and the next bidder will be asked to come in. Payment based on final milestone delivery only. Do not ask for hourly or multiple milestones - I will no...
Desarrollo de Planillas Avanzadas en Excel para un proyecto de consultoria
I need an expert to create Power BI slides for data analysis. - The primary objective is to assist me in analyzing the data from excel spreadsheets efficiently. - The slides are intended for basic data analysis. Therefore, the level of interactivity required is basic, encompassing features like tool tips and basic filters. Ideal candidates should have: - Proficiency in Power BI for data analysis. - Proven experience working with Excel spreadsheets. - The ability to create easy-to-understand visuals. - Good communication skills to understand the requirements and deliver the project urgently.
...**Labeling:** Each of the 29 bottles must be labeled in a manner that correlates with the entered data, ensuring no discrepancies. - **Shipping Coordination:** Prepare the samples for shipping. The process for this will be communicated and facilitated on our end to ensure a seamless transition. **Ideal Skills and Experience:** - **Organizational Ability:** Demonstrated proficiency in managing multiple tasks efficiently. - **Attention to Detail:** Accurate entry of product data, understanding of the importance of precise information. - **Communication:** Clear and responsive communication, especially regarding updates or any challenges faced during the task. - **Local Knowledge:** Familiarity with retail stores that potentially stock the specified soft drink brand would be advant...
...**Labeling:** Each of the 4 bottles must be labeled in a manner that correlates with the entered data, ensuring no discrepancies. - **Shipping Coordination:** Prepare the samples for shipping. The process for this will be communicated and facilitated on our end to ensure a seamless transition. **Ideal Skills and Experience:** - **Organizational Ability:** Demonstrated proficiency in managing multiple tasks efficiently. - **Attention to Detail:** Accurate entry of product data, understanding of the importance of precise information. - **Communication:** Clear and responsive communication, especially regarding updates or any challenges faced during the task. - **Local Knowledge:** Familiarity with retail stores that potentially stock the specified soft drink brand would be advanta...
I am looking for an expert to assist in creating a dynamic Power Bi dashboard. This job should revolve around integrating data from Excel spreadsheets and designing a variety of data visualizations. Key Responsibilities: * Guide me in creating the dashboard on my company account. * Connect the Power Bi dashboard to Excel spreadsheets as the primary data source * Develop compelling data visualizations using pie charts, line graphs, and bar charts * Configure the dashboard to refresh data on a weekly basis Ideal Candidate: * Strong experience with Power Bi and data analysis * Proficient in handling Excel data * Expertise in creating different types of charts * Ability to work with time-based data refreshing schedules Scope of Work: The Initiator engages the Creat...
I'm in need of a skilled Power Apps developer to create a custom business application with the following features: - Image Capture and Upload: The primary function of the app is to allow users to take pictures using their device's camera. - Integration with OneDrive: The images taken should be uploaded directly to a specific folder in OneDrive. - 4 Different Upload Buttons: I'd like the app to have 4 distinct buttons, each triggering the camera function on the end user's phone for specific image captures. here's a complete step-by-step guide with all the necessary Power Fx code for implementing a camera feature where the camera is triggered by an "Upload" button for each document section. Step 1: Initialize the App Start by creating a new...
I am looking for a skilled graphic designer for a logo redesign project. The goal is to deliver a fresh, modern design that represents our brand identity. I need changes in color scheme, typography, and iconography. I will provide ...color scheme, typography, and iconography. I will provide the correct HEX code (#33a1da) for the new primary color. The deadline for this project is one month. Skills needed include graphic design, logo design, typography, and color theory. A successful freelancer will be able to refresh and modernize our logo while staying true to our brand image. The designer will be responsible for creating multiple logo prototypes and presenting them for our consideration. If you have a portfolio showcasing your logo design skills, please include it in your ap...
...designer to create a modern, bold portfolio website for my business. It's essential that you have a fresh, innovative approach and previous experience building portfolio websites. Key Features: - Custom buttons: Engaging and interactive buttons are an absolute must. - Bold Design: The style should be modern and bold to reflect my distinct identity. It must convey my brand purpose, show our professionalism, and stand out from the competition. Required Skills: - Strong understanding and experience in portfolio website design - Creativity and innovation - Experience in creating custom buttons - Understanding modern design trends and principles. If you're someone who knows their way around website design and can deliver a visually exciting and accessi...
I screwed up on the backend of my website. The site is I must have clicked something that removed all the links to...all the links to the socials on the sign up page. I need for someone to do the following: 1. Put the logos back up (it should just be a click of a button. I just don't know which one) 2. I'd like to add two more social link to the list. (patreon & buy me a coffee) 3. I'd like for each person who signs up to get an email thanking them for joining. 4. I'd like to make it so people can't sign up multiple times with the same email address. 5. On wordpress there are numbers for each person who signs up. If I delete a person the numbers don't change order. It would be nice if they did. This isn't a major thing if hard to do th...
I need a proficient Python expert to scrape recipes from a designated website to an Excel sheet. The project needs to be completed as soon as possible. You can use this open-source working scraper Key requirements: - Scraping recipe information (name, ingredients, cooking instructions, nutrition facts) from a specific website. - Outputting the scraped data in a well-organized Excel sheet. Ideal skills for this project include: - Proficiency in Python for web scraping. - Familiarity with scraping data from websites. - Excellent organizational and data management skills for outputting the data in Excel. If you can deliver this quickly and efficiently, please feel free to bid.
I currently use Hawksoft CMS and Marketing 360 CRM. My project requires a platform that integrates these systems with a document signer and a calculator. Key Features: - A user-friendly log in system with multiple users. - Integration of Hawksoft CMS and Marketing 360 CRM into the platform. - A document signer with the ability for electronic signatures and document tracking. - A calculator that includes formulas for interest and payment schedules. Ideal Skills: - Proficiency in CMS and CRM integration, particularly with Hawksoft CMS and Marketing 360 CRM. - Experience in developing document signing features with elements such as electronic signatures and document tracking. - Strong background in building calculators with advanced financial formulas, particularly t...
DESIGN ME AN A5 FLYER - USE TEMPLATE ATTACHED AND OUR LOGO COLOUR SCHEME- TEAL COLOUR GRAPHICS- PHARMACY BASED FLYER DETAILS BELOW:- Penhill Pharmacy 257A PENHILL DRIVE, SWINDON, SN2 5HN Opening hours: Monday-Friday ( 08:30 - 17:30 ) T: 01793 723 534 E: info AT W: How to order your repeat prescription at Penhill Pharmacy 1. Hand in your repeat slip at the pharmacy 2. Request medication via the NHS APP 3. Email us at info AT 4. Call us on 01793 723 534
I am looking to fill a longterm editor position for multiple projects for my agency. I am running a short-format content agency that edits videos for various coaches, businesses and podcasts. *The videos are up-to 60 seconds long and I expect you to edit subtitles, b-roll, stock footage, dynamic motion/graphics and make the video in general: entertaining and highly engaging.* *I am looking for a person that can be my full time editor for the next 6-12 months with the possibility of consistent pay-raises when the agency experiences growth.* *You will be paid 7usd for every video-edit.* *The process is super streamlined.* *All videos are tailored by me -> you get the raw footage, edit it and upload the edited videos in a separate folder. I expect a simple thumbnail that fits t...
I need a React developer for immediate collaboration. The primary focus will be on frontend development, with special emphasis on creating a basic user interface, involving simple forms and buttons. Skills Required: - Proven experience in React, with a strong portfolio of work in frontend development. - Ability to work quickly and efficiently, meeting an immediate project deadline. - Familiarity with integrating APIs into a project. The ideal candidate will have: - Strong communication skills as this is an immediate requirement. - Prior experience working on simple UI/UX design. - A keen eye for detail and the ability to follow design specifications accurately. Please include examples of your work with your proposal.
We're looking for a graphic designer to create a fresh, modern logo for a website rebrand. Current site is which will be rebranded as StudentTravel.pro. The ideal candidate will hav...logos. Key Requirements: - Use of Blue, Purple and Green colors from the current site (or complimentary) in the design - Logo must embody a Modern style - Target audience is educators, primarily female over 40 years of age - Incorporation of the full site name, '', in the design - No use of globes, airplanes or other tired travel graphics - Will need high and low rez versions in multiple formats, also a greyscale/bw version upon completion of the project Please reach out with any additional questions. Looking forward to seeing some great designs! Good luck...
This is a one day project. I will provide a spead sheet to be formatted in excel. Debits and credits will be separated and sumed that easy 24 months are involved the files email for additional information.
