Excel vba run multiple macros simultaneouslyงาน
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 ที่กำหนดให้
พิมพ์สูตรคณิตศาสตร์ได้ ตัวอย่างงาน
ต้องใช้ 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 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'm looking for a skilled developer who can create an engaging and comprehensive puzzles app for both iOS and Android. Key Features: - Multiple Difficulty Levels: The puzzles should cater to both casual and experienced players with varying complexity levels. - Timer for Completion: An in-built timer to encourage players to solve the puzzles within a specified time frame. - Hint System: An optional feature to guide players when they're stuck, without giving away the entire solution. Skills: - Proficiency in iOS and Android app development. - Experience in designing and implementing puzzle-based games. - Understanding of in-app purchases and ad integration (optional). - Ability to create an intuitive user interface for seamless user experience. Please provide examples o...
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.
We are academic researchers interested studying visit patterns to Museums, Aquariums, and Zoos, in the United States. We are seeking assistance in collecting reported visit counts for the year 2019 from 500 museums, 100 zoos, and 100 aquariums across the United States. We will send you an excel spreadsheet with the name and state of each location we would like visits counts for. Note that these ~700 locations have been pre-selected. Task: - Search the internet for reported visits to each location in 2019 - If you can find the number of visits, please enter that number in the "visits" column AND paste the link to the website / source from which you obtained that number in the "link" column - If you cannot find an official reported figure for 2019 after som...
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 address data for about 80 gas stations based in Jamaica. - I have a specific format that I require this in, which I will share...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 detail are ideal for...
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.
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...
...get paid extra for each of those weekends. Duties: (1) Answering the phone on the first ring, booking appointments in HubSpot, and transferring calls, when necessary (2) Placing immediate outbound phone calls to new leads or new people who have scheduled online telling them thank you and confirming some additional details and entering it into the system (3) Monitoring the live chat feature of multiple websites (4) Emailing/texting customers to remind them about upcoming appointments or working cold leads [during phone downtime] (5) Sending thank you notes and notes to neighbors (6) Working on other administrative or research tasks as assigned...
...to incorporate. - Manual Entry: Ability to manually input information. - Results Display: The app will need to parse JSON results and create an intuitive presentation for the user. See attachment for more information. In-depth experience in developing mobile applications is a must for this project. . Knowledge in building applications with push notifications is a plus. Knowledge of OCR and multiple bar code formats is a requirement. Please provide past examples of past development work in your response.. The request will take place in 2 parts before our selection is completed. We will review initial responses to create a list of potential candidates. We will contact the list of candidates and coordinate an online meeting to interview and provide more in depth information fro...
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 entered cor...
I'm seeking an experienced Pine Script coder to develop a custom hybrid trading strategy on TradingView for me. This strategy will be a combination of an indicator and a reversal strategy. Key Requirements: - You will be working with the Coral Trend Indicator as the primary indicator for this strategy. - The reversal strategy should incorporate multiple elements: - Candlestick patterns - Support and resistance levels - RSI divergence Entry Criteria: - The trading strategy should trigger based on: - A breakout of a support or resistance level - Formation of specific candlestick patterns - Confirmation of RSI divergence Your task is to write the Pine Script code to implement this strategy. Please get in touch if you're interested, and I will share the full req...
Building a UI for the previous AI whatsapp bot. Supports multiple agents
...experience for my guests. **Key Requirements:** - Expertise in container architecture and hospitality design - Ability to create detailed floor plans and 3D renderings - Experience designing Airbnb accommodations or boutique hotels - Understanding of building codes and regulations - Strong communication skills and ability to collaborate remotely **Project Details:** The resort will consist of multiple "villas," each featuring two bedrooms with ensuite bathrooms, a living area, kitchen, and an outdoor space with a small swimming pool and patio area. The design should prioritize modern aesthetics, sustainability, and guest comfort. **Deliverables:** - Initial concept sketches and mood boards - Detailed floor plans for each villa - 3D renderings to visualize the des...
I need a Shopify expert to create a multifunctional platform, focusing on sports equipment e-commerce and a website that connects coaches to athletes. Key Feature...equipment and both dropship and multi-seller models. - Sourcing from a diverse range of suppliers, you must be able to integrate with seven or more suppliers, each offering different rates for the same product. Ideal Candidate: - Strong experience with Shopify. - Exceptional e-commerce design skills. - Proficient at creating responsive designs for both mobile and desktop. - Experience integrating multiple suppliers in a single platform. - Understanding of the dropship and multi-seller models is a must. - Bonus: Experience or knowledge in the sports industry. Looking forward to seeing how you can bring this projec...
I need someone who can break my existing long-form content into multiple entertaining short-form pieces and from there adapt to my current style and take it to the next level. We'll start with the short videos and if it works out well I'll get him to edit my longer videos as well. If you want to stand out from the crowd please INCLUDE YOUR PORTFOLIO with the short videos you have edited before.
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.
...information, photos, as well as education and career details. • Matchmaking algorithm: Implement an effective and user-friendly matchmaking algorithm for an optimal user experience. This will play a vital role in the overall success of the app. • Messaging System: Allow seamless communication between prospective partners. Ideal Skills and Experience: Strong knowledge of app development across multiple platforms, prior experience in similar apps, especially with the development of matchmaking algorithms and secure messaging system, will be extremely beneficial....
I'm looking for a skilled web developer to create a website similar to indiabix but with a unique twist. Key Requirements: - **Online Quizzes:** The website should support creation and hosting of different types of quizzes. This includes multiple choice, true/false, and fill in the blanks. - **User Registration:** Users should be able to create accounts, log in, and track their progress. The project has no strict deadline, so I'm open to working with a freelancer who can deliver quality work even if it takes a bit of time. Ideal skills for this job include: - Proficiency in web development languages (like HTML, CSS, JavaScript, etc.) - Experience in building quiz platforms or similar interactive websites - Understanding of user experience and user interface design -...
I am looking for a professional, modern, logo design for our property management company. The company name is "Roam", which has distant roots to the Greek God Hermes who is known for his winged shoes. I would like to see a modern icon that loosely resembles a wing. It should not be a highly detailed wing with fine feather...identity, as well as the primary and secondary color sets for web. Update: it looks like my edit didn't save for some reason. There should be only a single wing, with the feathers to the left and the base of the wing towards the right to show forward movement. This can be integrated with the "r" in roam, or should be able to be pulled out as a stand alone favicon. We will eventually need multiple orientations, primary, secondary,...
I'm looking for a skilled AI artist to help me create a realistic portrait using artificial intelligence. Key Requirements: - The portrait should be crafted with a realistic style. - The color scheme should mainly consist of warm tones. Ideal Skills and Experience: - Proficient in working with AI tools to create portraits. - Strong portfolio that demonstrates the ability to work in a realistic style. - Experience with producing art pieces in warm color tones. Ability to use various AI programs to generate pictures for purposes of comparison
App Version 1.6 Laravel Version 7.30.6 PHP Version 7.4.33 Extension IonCube Loader is installed License code "To handle the Codegyan scripts. This was a prepaid version with multiple restaurants. This website is only for the orders that roll. As I checked, the speed is slow due to the JavaScript library not working properly. We need to update HTML for all three panels: user, restaurants, driver. Do you want to integrate new HTML? I need to remove the Livewire from my website. Delete all files not important for the website and logically structure all pages of the files. The website will only be used for delivery. Everything else must be deleted. Current version." musst be updated to the new version
...to suit our specific needs. At the moment, the specific SharePoint version being utilized is unspecified, so a basic understanding of multiple versions is beneficial. There's also a need to integrate Power Automate, so experience with this tool is essential. Ideal candidates must be proficient with SharePoint, organized, detail-oriented, and experienced in workflow automation and Power Automate. Below is JD Position Title: Functional Business Analyst 2- Run the Business (RTB) Reports to: Enterprise Solution Delivery Support Manager Classification: Exempt Creation Date: February 2023 EEO-1: Professionals Job Summary: This Functional Business Analyst 2- Run the Business (RTB) works within traditional waterfall project teams or within a strategic, agile, DevOp...
I have multiple Wordpress sites that need attention. They're currently facing some theme customization issues and plugin conflicts. The main focus of your work will involve: - Fixing the theme customization issues: This includes making sure the theme layout displays correctly and that the customization options work as expected. - Resolving plugin conflicts: During the process, you might encounter conflicts with some plugins. You'll be required to identify and resolve these issues. As you progress, you'll need to keep an open line of communication with me, in case I provide additional details or need clarifications on your work. Skills and experience I'm looking for: - Proven experience in working with Wordpress sites. - Strong knowledge of theme customiza...
I'm in need of a savvy professional who appreciates the finer details of Major League Baseball (MLB). You'll be tasked with compiling a comprehensive spreadsheet featuring specific MLB data. Essential parts of this data include game statistic...you're on board. 3. Additional Factors: In keeping with the finer details, the spreadsheet should also cover the Date of Game, Team A vs Team B data, analysis on which pitcher is better, and predictions on which team will win. The ideal candidate will have a strong background in data manipulation, particularly in Excel or similar tools. But more than just your average data enthusiast, I'm specifically looking for someone with a deep understanding of baseball. If you can hit a home run with MLB stats and predictions...
I need a freelancer proficient with both Excel and Photoshop for two primary tasks. Excel Work: - Conduct data analysis and create visualizations, leveraging skills in updating and organizing data Photoshop Work: - Provide graphic design and photo editing services Ideal candidate should have solid experience in both platforms and a keen eye for details. Understanding my needs in data management and visual design will be a key success factor.
I'm looking for a skilled Android developer who is experienced with automation to help me automate form interactions on the Android emulator. The primary goal of this task is to automate data entry. The forms I need to automate are moderately complex, involving multiple steps and various field types. Ideal candidates should: - have experience with Android development - be proficient in automation tools and techniques - be able to design and implement a solution that can handle complex forms with ease - have a keen eye for detail to ensure correct form interactions Please only apply if you have experience with similar projects and are confident in your ability to deliver a reliable and efficient solution.
I'm seeking a skilled developer with experience in Linux and networking to help create a custom openmptcprouter. The primary goal of this project is to aggregate multiple internet connections into one cohesive, high-speed network. Key Project Details: - Operating System: Linux - Primary Goal: Aggregating multiple internet connections - Types of Connections: DSL, Cable, Mobile Network Ideal Skills and Experience: - Proficiency in Linux operating system - Strong background in networking and internet connection management - Familiarity with openmptcprouter or similar technologies is a plus - Prior experience in aggregating multiple internet connections - Ability to deliver a stable, high-performance solution If you have the expertise and experience in Linux, netw...
As the developer for this project, you will be creating a state-of-the-art, real-time lipsync model. If you're a Python guru with Machine Learning and AI experience, this project is for you. Requirements: - Develop a real-time lipsync model - Ensure high level of accuracy - Model should support multiple languages Ideal skills: - Proficiency in Python is crucial - Previous experience in AI and machine learning - Strong understanding of speech recognition systems and avatar animations While the client didn't provide answers for preferences on specific tools or purposes, your ability to work with flexibility and adapt to possible changes mid-project will be highly beneficial. Ensure your bid reflects your capacity to handle such dynamic needs. Your expertise and sound t...
