Excel vba hide rows based on criteriaงาน
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
To streamline our media files searchability, we're in need of an adept developer capable of implementing AI add-ons to Cloudinary for image and video tagging. Here's what we need: - Capabilities to tag a mixture of user-generated and professionally created images and videos. - Having prior experience working with Cloudinary and AI technologies will be a definite plus. - Potential volume of media files exceeds 500, hence efficiency and scalability of your solution is vital. - Solution needs to address tagging of media already uploaded, but also in further uploads. The desired outcome of this project is a well-organized, searchable media library that would significantly enhance our user experience. Your expertise will play a crucial role in achieving this, so make your bid if yo...
**Project Objective:** We are looking to automate the management of absences within our company using VBA Excel. The goal is to simplify and optimize absence tracking, reporting, and data analysis to save time and improve accuracy. **Project Description:** The project involves developing an automated solution in Microsoft Excel that includes: 1. **Absence Data Entry:** - Interactive forms for entering absences (sickness, vacations, authorized absences, etc.) - Data validation to ensure accuracy and consistency. 2. **Automatic Absence Calculation:** - Automatic calculation of absence days per employee. - Tracking different types of absences and their quotas (paid leave, sick days, etc.). 3. **Report Generation:** - Creation of weekly, monthly, and ann...
I'm looking for an expert in freePBX to set up a cloud-based system for sales and telemarketing purposes. This system will be integrated with 1-10 Indian mobility numbers. Key Requirements: - Cloud-Based Setup: The selected freelancer should have ample experience in setting up freePBX systems on the cloud. - Sales and Telemarketing Focus: I'm seeking someone who understands the specific requirements of a system aimed at these functions, with a good understanding of how to maximize call efficiency. - Indian Mobility Number Integration: An understanding of the telecommunications landscape in India would be advantageous, as the system will need to be integrated with 1-10 Indian mobility numbers. Please share your relevant experience and approach to this pro...
I have a Microsoft Excel assignment that needs expert handling. My needs include: - Data analysis: I want to make sense of my data, and uncover any hidden trends or correlations. - Formula creation: I require the creation of Excel formulas to automate data processing tasks. - Graphs and charts: I need insightful visuals to represent my data. This will aid me in understanding and communicating it more effectively. While it's unfortunate I could not provide more detailed information, it's vital that the freelancer can work with a certain degree of ambiguity. Expertise in Excel-based data analysis, formula creation, and chart and graph creation are essential. An ability to uncover data insights, no matter how small the dataset, will be highly bene...
I need help with a data entry task that involves copying and pasting data from PDF documents into an Excel spreadsheet. Key points: - The task involves strictly copy and paste work, no data cleaning or formatting is required. - The primary source of data is PDF documents, so proficiency in extracting data from PDFs is a plus. - The data should be accurately transferred into an Excel spreadsheet. Ideal Freelancer: - Proficient in PDF data extraction and Excel. - Attention to detail is crucial. - Previous data entry experience is preferred.
I'm in need of a Power BI expert to create a comprehensive dashboard for our recruitment department. The dashboard will pull data from our existing Excel spreadsheets and update daily. Key Features Required: - Job Status: This will give us a clear overview of the number of open positions, positions in the interview stage, and positions that have been filled. - Recruitment Pipeline: Visual representation of where in the recruitment process our candidates are, from application to hire. - Applicant Information: A detailed breakdown of our applicants, their demographics, and the source from which they applied. - Application Source: Analysis of the effectiveness of our recruitment sources. - Time to Hire: Ideally, a calculation of the time it takes to move a candidate from applicat...
I'm in search of a skilled individual residing in Gurgaon, India to drive social m...Key Responsibilities: - The primary goal is to enhance brand awareness through strategic social media campaigns - Focusing on Facebook and Instagram, you'll be responsible for creating and managing content that resonates with our target audience - Running paid ads, monitoring, and reporting on campaign performance Your Profile: - Proven experience in social media marketing, especially with brand awareness as the primary goal - Deep understanding and experience in running marketing campaigns on Facebook and Instagram - Based in Gurgaon, India for effective communication and collaboration If you're passionate about digital marketing, have a strategic mind, and ar...
I am in need of a diligent professional who can assist in extracting text data from PDF files and accurately inputting the information into an Excel spreadsheet. The job calls for attention to detail and excellent data entry skills. Essential Skills and Experience: - Proficiency in Data Entry - Expertise in Excel Your responsibilities will include: - Accurately converting text data from PDF files into Excel - Ensuring data integrity through careful data entry - Delivering the project on time Ideal candidates would have prior experience in handling similar tasks. Your accuracy and commitment to the task at hand will be pivotal to the outcome of this project. Looking forward to receiving your bids.
I'm looking for a virtual assistant to support me with email handling and sales data maintenance in Excel. This role is important as it directly involves customer communication and data management. Key Responsibilities: - Responding to customer inquiries in a timely and professional manner - Efficiently sorting and organizing emails - Implementing appropriate spam management and filtering strategies - Updating product sales, revenue and customer information in Excel Ideal Skills and Experience: - Proven experience as a virtual assistant, customer service representative or related role - Strong proficiency in Excel and data management - Excellent written and verbal communication skills - Exceptional organizational abilities and attention to detail - Familiarity w...
I am in need of a skilled Excel professional who can create a comprehensive Excel dashboard focused on data analysis. The dashboard will integrate with various Excel files to provide real-time data updates. Key Requirements: - Create an Excel dashboard that primarily focuses on data analysis - Integrate the dashboard with multiple Excel files - Ensure that the data updates are in real-time Ideal Skills: - Proficiency in Excel - Experience in creating complex and dynamic dashboards - Knowledge of data analysis techniques - Familiarity with real-time data integration This project is ideal for an Excel expert who can not only design a visually appealing dashboard but also ensure that it is highly functional for data analysis pu...
Must use attachments. please read criteria -for using a clear letter type word graphics. Use arial, calibri or similar font, in upper and lower case. this is to promote a conference - a speaker series Do not create a heading or title of the magazine. I want just the graphics I need a bold and vibrant magazine cover design that reflects the core subject of lifestyle and culture. This project should mainly feature eye-catching visuals or graphics to draw readers in. - Design Style: Vibrant and bold to reflect an exciting lifestyle and culture theme. - Key Elements: Concentrate on creating captivating visuals or graphics that bring the cover alive. Ideal skills include prior experience in creating magazine covers, ability to portray complex concepts through minimal des...
I'm in need of a skilled designer to create a HubSpot landing page to help me with lead generation. Key Details: - Goal: The primary aim of this landing page is to generate leads for my business. - Color Scheme: I want the design to align with my website's col...HubSpot: Experience working with HubSpot is a must. - Creative Design: Ability to create captivating and professional landing page designs. - Video Integration: Capable of seamlessly integrating video content into the page. - Payment Gateway Integration: Familiarity with adding payment options to websites. If you're confident in your HubSpot skills, have a knack for design, and can meet the criteria above, please get in touch. I'm excited about the potential of this project and look forward to working...
We seek an Excel expert with experience in developing Bill of Materials (BOM) and Inventory management solutions tailored for small home businesses. The focus is on simplicity and functionality without the need for a commercial product presentation. **Key Features Needed:** - A user-friendly Excel workbook that manages electronic components, their stock levels, and inventory updates post-sales efficiently. - BOM creation from inventory items with an ability to incorporate "other costs" into each assembly. - Stock purchase entries should automatically update inventory quantities and costs. - Detailed sales tracking with automatic inventory quantity adjustments. - Low stock level notifications via highlighted rows in the spreadsheet. - The system s...
I'm seeking an individual who is well-versed with Excel for data entry tasks. This primarily involves typing and organizing data. Here's what you'll be doing: - Typing out data and organizing it in Excel spreadsheets - Ensuring accuracy and efficiency in data entry Applications should include: - Examples of past work, particularly those related to data entry and Excel Ideal freelancers for this job are those who: - Have prior experience in data entry - Are proficient in using Excel - Possess strong attention to detail, ensuring accuracy in their work.
I am looking to automate certain repetitive tasks that are currently performed in Excel using Power Automate. - Main Objective: The chief goal of this project is to automate data comparison tasks. This will greatly improve productivity and minimize errors that may come with manual comparison. - Ideal Experience: The ideal freelancer for this task should have extensive experience in Excel and Power Automate and should have successfully completed similar jobs in the past. A strong understanding of data comparison techniques and working with excel spreadsheets will be highly beneficial. - Skill Set: Key skills required include Excel, Power Automate, and a good understanding of data processing and workflow automation.
I'm in need of a skilled individual who can scrape data from various websites for the purpose of lead generation. The data should be delivered in Excel or CSV format. Key Requirements: - Proficient in web scraping - Experience with lead generation - Ability to deliver data in Excel/CSV Ideal Skills: - Proficiency in Python/R for web scraping - Previous experience in similar projects - Strong understanding of lead generation techniques If you have experience in web scraping and lead generation, I'd love to hear from you.
I am at the initial stages of a project that aims at creating a Deep Neural Network based Low power VLSI (Very Large-Scale Integration) architecture that is designed to classify Atrial Fibrillation for wearable devices. This ambitious project requires specialised expertise and precise execution. Key Tasks: - The design of a Low-Power, DNN-Based VLSI architecture, which is yet to be initiated. - Create a Full Custom VLSI that is suited for classifying Atrial Fibrillation. Ideal Skills and Experience: -Verilog. -FPGA. - Relevant experience and extensive knowledge of designing Full Custom VLSI architectures. - Proven expertise in VLSI architectures and their relation to wearable device technology. - Firm understanding of Atrial Fibrillation classification. - Familiarity wi...
I'm seeking an experienced and knowledgeable RFP consultant. I need help in evaluating potential IT and professional services solutions. Key Responsibilities: - **Understanding of Government Tenders**: The consultant should have extensive knowledge and experience in crafting RFPs and evaluating government tenders. - ...Applications and Mobile Applications: Experience in tendering for these services would be highly advantageous. Ideal Skills and Experience: - Proven track record in managing and evaluating RFPs - Deep experience in the IT services and professional services sectors - Strong understanding of Government tender processes - Previous work with applications and mobile applications is a plus If you fit these criteria and can help me in this evaluation process, pleas...
...new tech stack that aligns with the latest industry standards. Responsibilities: Design: Architect a modular CMS following MVC principles to ensure a clear separation of concerns. Development: Design and implement RESTful APIs to facilitate communication between various system modules, adhering to industry best practices. : Build the CMS from the ground up, focusing on modularity and replaceable components. : Conduct thorough testing of each module and the integrated system to ensure functionality, performance, and interoperability. : Provide comprehensive documentation for APIs, architectural decisions, and system functionalities. Conduct training sessions for developers and stakeholders as needed. : Work closely with the
I'm in need of a ski...ThinkOrSwim platform. Key Criteria for the Scanner: - The scanner should have the following filters for daily stock screening: - 15 EMA & 50 MA Crossing - Price goes above them both, comes down and holds the X, and makes a cycle low - MACD Angles UP - Scan all optionable tickers Scanner Output: - The scanner should display a list of tickers that meet the specified criteria. Delivery Preference: - Ideally, I would like the scanner integrated in ThinkOrSwim, or possibly as a watchlist. Ideal Skills and Experience: - Proficiency in ThinkScript - Experience in developing custom scanners for stock trading platforms - Understanding of technical indicators and their implications - Strong communication skills to ensure the final product mee...
saya among dan saya bisa mengoperasikan excel dan saya siap bekrjasama.
I'm seek...our experienced faculty, and the hands-on practical training the students receive. - Aim for a balance of engaging visuals, compelling narrative, and informative content that appeals to individuals considering a career shift into counselling psychology. - We'll need the final video to be high-quality and suitable for promotional purposes across various online platforms. The ideal candidate for this job will have: - Proven experience in creating promotional videos, ideally for educational programs or courses - A solid understanding of the psychology of career changers and how to appeal to this specific audience - Excellent storytelling and video editing skills to bring our program's unique strengths to life If this project sounds like something you'd ...
...an Excel table. The icons are for various amenities that will be listed on a real estate website. Responsibilities: • Search for icons on that match the list of amenities provided. The premium version of Flaticon may be used. • Ensure each icon matches the style and aesthetic suitable for a modern real estate website (in the style as attached files). • Document each icon in an Excel table with two columns: Title and Classname. List of Amenities: • See attached file. Requirements: • Experience with and familiarity with downloading and organizing icons. • Proficiency in Excel. • Attention to detail to ensure the icons are correctly matched to the amenity titles. • Ability to deliver the task within a specif...
I'm in need of meticulous and organized professional who can effectively manage data entry, document organization, and scheduling tasks. The scope of the project includes: - Streamlining data entry processes - Organizing and managing key documents, specifically financial statements - Handling a dynamic schedule effectively The ideal candidate should be proficient with Microsoft Excel and Google Suite (Docs, Sheets, Calendar). Your expertise will help us improve our administrative operations efficiently and effectively.
I have an Excel file that needs to be formatted with some basic arithmetic formulas. Key Requirements: - I need the data in the cells to be formatted to phone number style. - Basic arithmetic formulas are required for this project. The level of statistical analysis you'd need to provide is basic, such as mean, median, or mode. Ideal Skills/Experience: - Proficiency in Excel and formulas is a must. - Experience with basic statistical analysis is preferred. Please get in touch with your credentials and prior work samples. Thank you.
โปรดลงทะเบียน หรือเข้าสู่ระบบ เพื่อดูรายละเอียด
I need a detailed spreadsheet of information taken from public meetings. The content I'm seeking to compile involves: - Date of the meeting - Detailed descriptions of action items that were voted on, including the specific amounts. In this assignment, precision, attention to detail, and understanding of meeting notes is crucial. Mastery of Excel and experience handling similar tasks is required. Familiarity with action items and the voting process in public meetings will be a plus.
I'm in need of a VBA script that can generate textual reports from Excel spreadsheets. Key Requirements: - The VBA script should focus on generating textual reports, without the need for incorporating charts or graphs. - The data source for the report generation will be Excel spreadsheets. Ideal Skills and Experience: - Proficiency in VBA coding and automation. - Strong understanding of Excel and its data manipulation capabilities. - Prior experience in report generation through VBA is highly preferable.
