Excel vba form dateงาน
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. มีระบบ...
ทำ 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
I'm looking for a skilled sales closer with a strong track record in retail sales. The ideal candidate should have a versatile background, capable of handling both brick-and-mortar and e-commerce environments. Experience in the pharmaceutical or healthcare industry is a plus. Key responsibilities include: - Engaging with...include: - Proven track record in retail sales, ideally with experience in both brick-and-mortar and e-commerce - Strong communication and negotiation skills - Ability to understand and communicate the benefits and features of pharmaceutical products - Experience in selling healthcare or pharmaceutical items would be highly beneficial If you believe you have the skills and experience needed to excel in this role, please do get in touch. I look forward to he...
I need a talented designer to create a minimalist logo for my company. Here are my requirements: - The primary color scheme should be based on black and white (grey if useful). - The design should be minimalist, with clean and straightforward lines. - Incorporation of the company name is not obligator...should be based on black and white (grey if useful). - The design should be minimalist, with clean and straightforward lines. - Incorporation of the company name is not obligatory. Skillful use of it, contingent on how it fits into the design and overall aesthetics, is appreciated. Ideal candidates should possess past experience in minimalist logo design and a keen eye for balancing colors. If you excel in creating attention-grabbing logos with subtle details, then this project i...
I am currently seeking a professional auditor in th...financial audit for my recently established housing contractor. Key Project Details: - The project involves auditing the financial accounts of my housing construction business in Jordan. - The ideal candidate should be well-versed with accounting principles, and must have ample experience in conducting similar audits. - The primary aim is to ensure that my financial records are accurate, up-to-date, and in compliance with relevant regulations. Key Requirements: - Professional with proven experience in financial auditing. - Must be based in Amman, Jordan. - The project turnaround time is less than a month and I am looking to get it done ASAP. Feel free to reach out to me if you have any further questions or would like additiona...
I'm looking for an experienced freelancer who can convert my Excel sheets into Word documents. The documents need to be in text only and follow a specific format, for which I'll need help in creating a template. Ideal Skills: - Proficiency in Excel and Word to ensure accurate conversion. - Experience in template creation and design to help structure the documents appropriately. - Attention to detail to ensure the final Word documents are error-free and cohesive.
I have various Excel sheets that I need organized into a single Word document. I'd like them structured in a way where each category has its own sheet. Key requirements: - Transitioning data from Excel to a Word document - Organizing the data by category, with each category on its own page - Incorporating visual elements like charts and graphs Ideal Skills: - Proficiency in Excel and Word - Strong organizational skills - Experience with data visualization - Ability to create visually appealing documents
I'm looking for someone...data entry from various sources into Microsoft Excel. The data is predominantly text-based and needs to be input accurately. Key Responsibilities: - Manual data entry from various sources into Excel - Ensuring accuracy and consistency in data entry - Organizing and categorizing data appropriately Ideal freelancer should: - Be proficient in Microsoft Excel - Have experience in data entry - Be detail-oriented and accurate in data input - Understand the importance of maintaining data integrity The output for this project should be a PDF document. If you have experience in creating PDFs from Excel, that would be a plus. Accuracy and attention to detail are extremely important for this job. Please mention your experience in data en...
Hola, María, necesitaría el trabajo de este excel: https://docs.google.com/spreadsheets/d/1tnP73xrnE0SGNuynpLpnl1r7mThhi4liPCQCYjTRdvE/edit#gid=1193400678 Gracias,
I'm looking for a freelancer who can create a custom Excel sheet to track the daily attendance of my employees. The sheet should: - Be user-friendly and easy to navigate - Allow for automated calculation of total attendance - Be able to handle multiple employees at once - Have the capacity to expand for future growth I'm not looking for anything too complex, just a simple, efficient tracker that can help me keep tabs on my employees' attendance on a daily basis. Ideal Skills: - Proficiency in Excel, including advanced formulas and functions - Experience in developing user-friendly, automated spreadsheets - Strong organizational and communication skills to ensure the tracker meets my needs and is easy to understand and use.
As a client, I'm seeking a seasoned data analyst with expertise in data science who can thoroughly clean, preprocess, and visualize a dataset sourced from CSV files. The chosen candidate: - Should first start with cleaning and preprocessing the data to create a reliable foundation for analysis. - Should then interpret and present that same...end-product of this project is not just predictive analytics but insight and data-driven recommendations that will inform future decision-making. Proficient use of Python or R for these tasks is essential, as is familiarity with data cleaning and visualization libraries and tools. To thrive in this role, you must be a highly analytical thinker with the ability to separate noise from signal in dataset and excel at drawing clarity out of com...
I'm in need of an individual proficient in Excel to streamline data analysis for my sales numbers. The main objective will be to dissect revenue trends within the data, so particular attention to this metric is essential. Ideal qualities include: - Great attention to detail - Previous experience in data analysis - Proficiency in Excel - Understanding of sales and revenue benchmarks This role will require you to receive raw data and translate it into an easy-to-understand format, highlighting pivotal information. Your focus will be on creating complex formulas to identify revenue trends, which will help inform our future sales strategies.
...footage into compelling, high-quality videos that align with our brand's style and tone • Collaborate with the creative team to brainstorm and develop video concepts and ideas • Add effects, transitions, music, and sound effects to enhance the overall production value of videos • Ensure videos are optimized for online viewing, including aspect ratio, colour correction, and compression • Stay up-to-date with the latest video editing trends and techniques to bring new and innovative ideas to the table • Collaborate with the production team to ensure quality and requirement of the video are met effectively. • Incorporate the feedbacks of Video Producer and Team lead into the revised video • Creating and maintaining project file, changes, and r...
I'm looking to automate my trading processes using the Zerodha Excel API. As I'm unsure of the API's development, I need a freelancer who is experienced in API integrations and has a good understanding of automated trading systems. Key Elements: - Automation: The primary goal is to automate trades based on predefined criteria. This involves developing a system that can analyze market conditions and execute trades automatically. - Zerodha Excel API: As I am unsure about the development of this API, you should have a good understanding of it or be able to quickly grasp its functionalities. - Trading Experience: It would be beneficial if you have prior experience in developing automated trading systems. - Predefined criteria: The system should be able to automati...
I require a skilled individual who is proficient in Excel to analyze market research data. This work requires a keen eye for detail and understanding of advanced analysis techniques. The main objective of this project is to provide precise quantitative summaries of the market research data. Your responsibilities will include: - Receiving and understanding the raw data provided - Analyzing and interpreting complex data sets - Producing quantitative summaries and reports based on your findings Ideal Skills & Experience: - Proficient in Excel - Previous experience in data analysis - Good understanding of market research principles - Excellent task management skills - Experience in generating data-driven reports. This project is ideal for freelancers with a knack for...
I am in need of a skilled data entry professional to assist me with the intricate task of filling out online forms. These forms require meticulous attention and thoughtful precision, with specifics instructions only on a basic level. Proficiency in deciphering and executing complex tasks with limited guidelines will be key to this role. Skills & Experience: - Exceptional attention to detail - Proven experience in complex data entry tasks - Ability to follow minimal instructions and use initiative - Strong problem-solving abilities. Please note, this is a challenging task that requires both technical ability and sound judgment. An innovative and flexible approach would be advantageous.
I'm in need of a custom-built production and stock tracking software tailored for paint manufacturing. - **Features Needed**: The software should primarily focus on robust inventory management and effective batch tracking. - **Batch Tracking Details**: The software needs to track important details of each batch, including the production date, supplier, and quantity. - **Reporting**: I'd like the software to generate insightful reports on stock levels and production efficiency. Ideal skills and experience for this job would include: - Proficiency in software development and design. - Experience in inventory management software development. - Prior work on tracking and reporting software. - A background in the manufacturing industry, especially paint production, woul...
**Your Bidding ...feature of uploading images/document, repair Year field, URL field etc, make the current captcha and email verification system better. Further, I want to dedicate one user as Admin. Admin gets all features like common users. Only difference is Admin can see user details like their username, email ID and registration date and can export it. No seperate Admin panel needed. See the site: This is very easy Project. Just making Form fields and report generating. Lowest bidder will win this project. You don't need to develop any new website or web design. Just a basic look will do. I need to deploy it in the Linux server. You need to give me the full copyright of the software and source code. Also help me to deploy it in server.
...correct answer (the choice in BOLD). - Some questions "refer to a figure". Most questions have zero or one figures, a few have more. I have provided Columns Figure A... FigureH for these as required. LOOK AT THE EXAMPLE. task is to put all 1090 questions into an excel file. I have put one question in there as a sample. I have also put one image which shows two additional questions. - If you win the project, you will get the full PDF. You will be able to cut and paste from the PDF. - To bid on this project, you must give me the excel file back with these two sample entries put in after the one that I did. The sample is a JPG file so you must type it in manually. Successful project: - All questions in there, in correct order from the PDF. - No typos. - Co...
I'm looking for a reliable freelancer to help with a small-sized project involving Excel data entry. The information will be shared via online documents. Ideal Skills and Experience: - Proficiency in Excel and data entry - Attention to detail is a must - Ability to handle small-scale tasks efficiently
I'm seeking a skilled photographer for an outdoor city family photoshoot in the evening hours. Familiarity with urban-style photography and the ability to create impactful portraits during the golden hour is ideal. Key requirements: - Skilled in family portraits and outdoor photography - Experience in capturing im...photographer for an outdoor city family photoshoot in the evening hours. Familiarity with urban-style photography and the ability to create impactful portraits during the golden hour is ideal. Key requirements: - Skilled in family portraits and outdoor photography - Experience in capturing images in the evening lighting - Proven ability to work in urban environments - Availability for the scheduled date and time Your portfolio of similar work would be apprecia...
...in one click In the result name date also changes daily , One such project should be made I'm seeking a proficient Excel specialist to take on a project that primarily involves formatting and creating advanced formulas. Key Responsibilities: - Take charge of the spreadsheet's aesthetic and logical formatting - Develop and implement formulas to aid data analysis and interpretation - Arrange numerical data alphabetically from A to Z Ideal Skills: - Proficiency in Excel functions and formulas - Strong attention to detail, particularly regarding formatting - Excellent problem-solving skills Project Timeline: This project needs to be completed within a month, demonstrating your ability to meet deadlines is crucial. So, if you have good experience with ...
I'm currently seeking a skilled freelancer for a data entry job concerning primarily text data. The data to be entered will be provided in an Excel spreadsheet and will need to be accurately transferred to an online database. Ideal candidates should have: - Proficiency in Microsoft Excel - Experience with data entry into online databases - Attention to detail and accuracy Please place your bid based on the information provided, and get ready to embark on an engaging and fulfilling data entry task.
...maintenance materials. Currently, we're managing our inventory through Excel spreadsheets. It's getting increasingly cumbersome and we're looking to streamline the process with a dedicated inventory management software. Key Features: - I'm interested in a system that will have robust reporting and analytics capabilities. This will help us keep a close eye on our stock levels, sales trends, and overall inventory health. Ideal Skills and Experience: - Experience with developing inventory management software, particularly for food and maintenance materials - Proficiency in building systems with strong reporting and analytics features - Ability to create user-friendly interfaces for easy data input and retrieval - Experience working with Excel and the abi...
I'm in need of a proficient individual who excels in SPSS for a data interpretation task. The main task involves the analysis of a questionnaire and exporting relevant tables from...individual who excels in SPSS for a data interpretation task. The main task involves the analysis of a questionnaire and exporting relevant tables from SPSS. Here's what I'm looking for: • Skilled in analyzing questionnaires using SPSS • Able to export data into tables • Analysis should be done based on patterns of behavior • Writing a brief description of data based on hypotheses The data is on an Excel file right now. Please bid only if you have relevant skills and experience as it will demand a high level of expertise and detail orientation. Don't hesitate ...
I'm seeking a skilled bookkeeper with experience in Zoho to help manage the financial aspects of my small business. Your responsibilities will include: - Regularly reconciling accounts, ensuring they are accurate and up-to-date - Categorizing transactions correctly for clear financial tracking - Generating financial reports for analysis and decision-making - Offering insights and suggestions for financial improvements This role would suit an individual with: - Strong bookkeeping skills and experience, ideally with small businesses - Proficiency in Zoho, or similar bookkeeping software - Excellent attention to detail, analytical skills, and a problem-solving mindset - The ability to communicate financial information clearly to a non-finance professional
...monks put their chopsticks on the table, do not pass them to each other and do not communicate with each other. The program should print in real time in a "table" (i.e. the console ;) who is currently waiting and who is eating. From time to time, it would be good if information was written on the "board" about who had their time and how many times they ate, so that everything would be written up to date in the console and so that at the end of the program it would be nice to see that each of them had the same amount of food. turns/time he ate. For simplicity, you can assume any numbers, which means that each of them eats, for example, 10 seconds during one "turn", you know. The risk of pinching must be taken into account. To write this program, you s...
As a Media TV Channel, we are seeking a UDAID Contract Compliance Specialist to review our contracts, ensure compliance with cont...adhere to all terms and conditions outlined in our contracts. - Auditing financial records: You will need to conduct detailed audits of our financial records to guarantee compliance. Industry Experience: While not mandatory, if you've previously worked in the media TV channel sector, it would be an added advantage. Understanding the unique nuances and challenges of this industry will help you excel in this role. Ideal Skills and Experience: - Experience with USAID contracts is a must. - Previous work in media TV channels would be beneficial. - Strong background in contract compliance and financial auditing. - Detail-oriented with excellent commun...
I need a competent Excel specialist to develop a robust strategy for documentations. The specific tasks are not yet determined, and the information that needs to be included will be clarified as we proceed. However, the project has no strict deadline, giving you ample time to plan, organize, and execute best practices. The ideal candidate will possess: - Outstanding Excel skills, including creating and working with complex formulas. - Robust organizational skills to manage and structure vast amounts of information. - Proactive attitude for identifying potential tasks that need documentation. - High attention to detail and accuracy. - Experience in data entry, sales records, and inventory management would be advantageous. Please bid with your plan of action and examples of p...
I'm in need of a sharp Australian expert who has access to the Australian Bureau of Statistics (ABS) database and can help me gather pertinent data regarding Melbourne's older population. If you have experience with ABS table builders this should be a relatively easy job as much of the data is collected in these ranges. Key Deliverables in Excel: - All SA3s in the Eastern and Southern Melbourne planning regions - TOTAL number of people in each SA3 and the number of people in the ages of 50+, 60+, 70+, 80+, 85+ - The number of people with income per week in each SA3 of $3,000-$3,999, $4,000 - $4,999, $5,000 - $5,999, $6,000 - $7,999, $8,000 or more The example table shows information from the 2016 Census and I will need data from the 2021 Census. Key Requirements: - ...
1 excel import task. and fix minor issue in db. Able to work with ftp. Follow and start Immediately
I need a tool that can search multiple sheets in an Excel workbook and copy specific rows to a new sheet based on manual selection. The core requirements of the tool are: - Searching across multiple sheets to find specific data. - Allowing me to manually select a specific number of rows from the search results for copying. Given these criteria, the ideal tool would be: - Capable of working with Excel files. - Providing a user-friendly interface for easy manual selection. If you have experience with these requirements, please reach out.
