Excel vba get selected cell valueงาน
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)
หาข้อมูล 16 อย่างของ Blogger จาก 50 fanpage แล้วกรอกลงให้ excel ที่กำหนดให้
...should make his/her own arrangements for staying in Pattaya during internship. The testing phase is between September 29 to October 9, 2017. We are looking forward for people who love their work and are courteous and have good strong personality. Send in your resumes and your expected salary for a week. Additional perks in the bucket for selected employees. Benefits: You will directly work with the CEO for a week. After your internship, in case you are selected then after we setup our office in Bangkok you will be trained and coached according to international standards to meet ISO requirements and other security related certifications present globally. You will also have a permanent job by the early 2018. Drop an email about yourself along with photo and your expected p...
พิมพ์สูตรคณิตศาสตร์ได้ ตัวอย่างงาน
ต้องใช้ imacro คัดลอกข้อมูลจาก web site ลง excel
Hello, We are currently looking for a person to write 5 descriptions of selected online stores in Thailand (in Thai language). Approx. 3000 characters PER SHOP. It would be great if you could prepare them in HTML. Text must contain: 1. Description of the shop in general 2. Information about promotions and voucher coupons which the selected shop offers 3. Description of the products, brands, services, categories/types of products that people can buy in the shop 4. Description of the shopping process and posibilities (delivery, payment methods, …) In case of being interested in our project, please provide me your price expectations for the same as well as the time you need to prepare them and whether it's possible to do it in HTML version.
คีย์ข้อมูลต่างๆลง Excel การคัดลอกบทความต่างๆลง word
ทำ presentation งานโดยใช้ Powerpoint สามารถแทรกงานที่เป็นข้อมูล ตารางและกราฟ จาก data ที่เป็น Excel
Hello, We are currently looking for a person to write 20 descriptions of selected online stores in Thailand (in Thai language). Approx. 3000 characters. It would be great if you could prepare them in HTML. Text must contain: 1. Description of the shop in general 2. Information about promotions and voucher coupons which the selected shop offers 3. Description of the products, brands, services, categories/types of products that people can buy in the shop 4. Description of the shopping process and posibilities (delivery, payment methods, …) In case of being interested in our project, please provide me your price expectations for the same as well as the time you need to prepare them and whether it's possible to do it in HTML version.
Hi, I have a website that I added Google Adsence ads to display ads and monetize the website. A...Google Adsence ads to display ads and monetize the website. After submitting the website, I received this message: ------------------ You need to fix some issues before your site is ready for AdSense The Approval Status is - Needs Attention We found some policy violations: without content or with low value content, that are under construction, that are used for alerts, navigation or other behavioral purposes. ------------------- What is needed: Tell me what I need to add or remove in order to get this site approved. The website is forumer dot cm Any reply without "I have fully read and understood what needs to be done and I am an Adsense expert and I can explain what t...
...potential clients. - Convert conversations into promising leads. - Record conversational details into our database. REQUIRED SKILLS AND EXPERIENCE: - Exceptional persuasive communication skills. - Proven experience in lead generation. - Familiarity with the corporate events and conferences sector. - A resilient attitude to handle potential rejections and keep going. This role demands someone ready to excel in a fast-paced environment while showcasing dedication, autonomy and agility. Your ultimate aim will be to assist in the company's expansion through the successful generation of potential leads. This is an excellent opportunity for someone looking to apply and enhance their telecalling skills while significantly contributing to a growing company in the event managemen...
I need a skilled Flutter developer to create a medical diagnostic app. This app will be used to collect blood cell images or videos. Here are some specific features the app will need: - User authentication - Push notifications - In-app purchases Also, the app should be capable of capturing and storing High-Definition (HD) images or videos. If you're adept with Flutter and have some experience in creating medical or diagnostic apps, your expertise will be highly desirable for this project.
We are in need of a highly skilled Laravel expert team to continue development on existing web application, specifically with a focus on reporting and analytics. The specific Task - Requirements Document will be provided. Project will be developed by Phases(milestones), total 12. Selected team will be having opprtunity to work for long term! Skills and Experience: - Extensive experience in reporting and analytics!!!*** - Extensive experience in Laravel development - Proficiency in Laravel customization and optimization - Strong understanding of Gitlab - version control !* - Strong understanding of web development principles and best practices - Ability to work on a large-scale project and deliver high-quality results - Excellent problem-solving skills and attention to detail - Data...
I'm looking for an Excel expert to create a mark sheet for me. This mark sheet will be used to record student test scores and will automatically assign grades based on a custom scale I've provided. The sheet should have: - A column for Student Name - A column for Test Score - A column for Grade (to be calculated based on the score and the custom scale) The grade allocation should be as follows: - Score of 1: Grade E - Score of 2: Grade D - Score of 3: Grade C - Score of 4: Grade B - Score of 5: Grade A I do not require any additional calculations to be performed beyond the grade allocation based on the score. Ideal Skills: - Proficiency in Excel - Experience in creating automated grading systems - Background in academic assessment would be a plus Please let m...
...manage MIS excel sheets pertaining to data analysis, sales forecasting, and expense tracking on a daily basis. Key tasks: - Establishing excel sheets to analyze a broad range of data - Constructing a sales forecasting model within the excel sheets - Regular tracking and management of expenses via the excel sheets Data sources would primarily be spreadsheets and databases. These excel sheets will require daily updates, enabling close monitoring of key metrics. Ideal skills: - Proficient in Microsoft Excel - Exemplary skills in data analysis and modeling - Good understanding of databases and how to extract data from them Experience in handling and managing sales and expense data is crucial for this project. The freelancer should be able ...
I need an Excel VBA expert to automate the generation and visualization of customer data reports. This task requires the building of a dashboard to simplify the report generation process. Key Tasks and Skills Required: - Strong understanding of Excel VBA for automation tasks. - Experience in building dashboards for report generation. - Skills in visualizing customer data within Excel. Outcome and Project Scope: - Develop an automated process for report generation. - Ensure the dashboard is user-friendly and visually appealing. - The final output should provide easily digestible customer data insights.
I'm in need of an experienced PHP and Wordpress developer to assist with ecommerce website, theme customization, plugin development, and additional tasks relating to Inventory manage...management capabilities to track product availability, manage stock levels, and streamline order fulfillment processes. If you possess the skills and expertise in PHP coding and WordPress development, and you're passionate about contributing to the success of our ecommerce project, we invite you to bid on this project. Please provide details of your relevant experience, portfolio, and how you can add value to our project. We look forward to collaborating with a talented and dedicated developer who shares our vision for creating a cutting-edge ecommerce platform for health products. Thank yo...
Seeking Skilled App Designer for Spa & Massage Therapy Business Application We are looking for an experienced app designer to create a sophisticated and engaging mobile application for our spa and massage therapy business, which operates across four distinct branches. This application must provide a seamless and intuitive user experience, catering specifically to our clientele who value ease and efficiency. Project Requirements: Branch-specific Design: Each of our four branches should have its own section within the app, complete with a unique logo and a tailored list of services. Service Listings: Detailed information on the variety of services offered at each location, including descriptions and pricing. Custom Pricing: The application should display different pricing struc...
...Dashboard to integrate various data sources including Excel spreadsheets, CSV files, and SQL databases. The ideal freelancer would: - Have extensive experience with Power BI and DAX language integration. - Demonstrate an excellent grasp of designing dashboards that report on KPIs. - Be well-versed with creating DAX calculations in the Power BI environment. We require the dashboard to focus on specific metrics, therefore, a strong understanding of reporting on KPIs using DAX language is a must. Additional Skills: - Proficient in Microsoft Excel and SQL databases. - Understanding of data integration and reporting. - High attention to detail. We're excited to collaborate with a dedicated professional who can breathe life into data and bring value to our dec...
I'm in need of an expert web developer to convert my Figma design into a fully functional WordPress website. At this time, I do not have a specific theme selected, suggesting that you'd have the freedom to choose a responsive and compatible theme for the design at hand. Skills & Experience: - Profound knowledge in Figma and its translation into WordPress - Strong understanding of WordPress themes and customization - Ability to preserver design integrity during conversion - Capable of making theme suggestions Please note that I haven't mentioned any specific functionalities - but we can discuss any potential additions later on. Looking forward to receiving your proposals, showing me previous Figma to WordPress conversion jobs would be a plus.
I'm in need of a thorough and reliable freelancer who can assist me with typing 1-5 columns of text-based data into an Excel sheet. Data will be provided in a digital format, like PDF or Word. Key Requirements: - Proficiency in Excel: You should be well-versed in using Excel, particularly in data entry tasks. - Accuracy: Attention to detail is crucial as any errors could affect the quality and integrity of the data. - Typing Speed: A fast and accurate typist will be highly preferred to get the task done efficiently. - Reliability: I'm looking for someone who can commit to delivering the work on time, as per the agreed-upon schedule. Please note that this project will be an ongoing one, with the possibility of more work if this initial task is complet...
Hello, I have a WordPress website with dokan and I want sellers to be able to obtain a donation, currently the site does it with a plugin but I want to keep a commission from those donations. It is acceptable to install another plugin. Currently it does this with a PayPal donation plugin and gravity forms. Write ragnar to know that you read the work, Knowledge of WordPress, Dokan and PayPal donations is essential.
...new consulting platform focused on law discussions. The logo should reflect the professionalism and expertise associated with the legal industry, while also conveying a sense of trust and approachability. The design should be clean, modern, and visually appealing. We prefer a logo that portrays the idea of law discussions or discussions about the law, but we are open to creative suggestions. The selected designer should have experience in logo design and a strong portfolio showcasing their work. Skills required: - Graphic design - Logo design - Branding - Creative thinking The logo should meet the following conditions: - Should not be very colourful as we are dealing in law. - Should contain the words - Vidhi(meaning law) and Samvad(meaning discussion) (in any order) - Can cont...
In search of a competent Excel specialist adept in Microsoft Access for multiple automation tasks. I need assistance with: - Macros Development: The main tasks include automation and creating tools. The proficient use of macros in daily operations is essential. - Report Generation: Specifically, the generation of technical proposal reports. Alongside this, the candidate should also be capable of automating the formula calculation process. Familiarity with financial, sales, and project status reports is an added advantage. - Tool Building: The capacity to build tools and other operations geared towards improving efficiency is crucial. Ideal skills include deep understanding of Excel functionalities, proficiency in Microsoft Access, extensive experience in automation via macr...
We are in need of a highly skilled Laravel expert team to continue development on existing web application, specifically with a focus on reporting and analytics. The specific Task - Requirements Document will be provided. Project will be developed by Phases(milestones), total 12. Selected team will be having opprtunity to work for long term! Skills and Experience: - Extensive experience in reporting and analytics!!!*** - Extensive experience in Laravel development - Proficiency in Laravel customization and optimization - Strong understanding of Gitlab - version control !* - Strong understanding of web development principles and best practices - Ability to work on a large-scale project and deliver high-quality results - Excellent problem-solving skills and attention to detail - Data...
I need an Excel expert to build a tool that can automatically validate and correct any incorrect country codes in the file. Requirements: - Replace incorrect country codes: The tool should replace the incorrect country codes with the correct ones. - Predefined list: The correct country codes should be determined based on a predefined list. - Daily updates: The tool should be able to handle daily updates. Ideal Skills and Experience: - Advanced Excel skills: You should have a deep understanding of Excel functions and VBA programming. - Data validation: Experience with data validation and manipulation in Excel. - Attention to detail: It's crucial that the tool is accurate in identifying and correcting country codes. - Timely updates: Experience in...
...manage MIS excel sheets pertaining to data analysis, sales forecasting, and expense tracking on a daily basis. Key tasks: - Establishing excel sheets to analyze a broad range of data - Constructing a sales forecasting model within the excel sheets - Regular tracking and management of expenses via the excel sheets Data sources would primarily be spreadsheets and databases. These excel sheets will require daily updates, enabling close monitoring of key metrics. Ideal skills: - Proficient in Microsoft Excel - Exemplary skills in data analysis and modeling - Good understanding of databases and how to extract data from them Experience in handling and managing sales and expense data is crucial for this project. The freelancer should be able ...
Create a web application that combines information or functionalities from two or more web APIs in a useful and sensible way. This is called a Web Mashup. You are free to decide on the purpose of your application, and which Web APIs you use. However, the Web APIs you have selected need to work together to fulfil the purpose of your application. An example: An intelligent Flickr photo browser that displays photos related to user’s interest. This can be done by fetching user’s “like” from Facebook web API, and then use this information to retrieve Flickr photos (using Flickr search) related to user’s like. (Note: A good implementation of this application would be at a pass level) In a more sophisticated implementation, an analysis of user’s Facebook...
I need an expert to migrate my products from an Excel file to my WooCommerce store. Key Requirements: - Migrate products from an Excel file to WooCommerce - Use attributes to define variations within a single product - Update existing product descriptions during the migration Ideal Skills and Experience: - Strong experience with WooCommerce and product migration - Proficiency in handling product variations using attributes - Attention to detail for updating and modifying product descriptions - Excellent knowledge of data import/export and product management on WooCommerce. - Ability to ensure a smooth and error-free migration process.
I require a detailed and accurate excel typist with a strong background in financial data analysis specifically in calculating profit margins. This person should: - Have strong excel typing skills for efficient data entry - Be knowledgeable in financial data analysis - Be able to interpret and analyze profit margins effectively - Have logical data organization skills to improve the overall workflow This role is essential for understanding and monitoring the profit margins of my business. Accurate analysis will aid in making strategic business decisions. Your expertise in handling financial data is highly valuable for this role.
Looking for a talented web designer and developer to greatly enhance our landing page and web application, with a deadline of this very day. I'm eager to find someone who can: - Update our landing page's layout: I want our page to be sleek, modern, and easy to navigate. - Add fresh, engaging content to our landing page: The new contents need to be captivating, relevant to our services, and add value to our website. - Implement new features and fix prevailing bugs in our web app: I want our web application to be free of errors and add new functions that make it more user-friendly and efficient. The main goal of the landing page and the web app updates is to cater to 'software customizing’. I'm striving to make the entire user experience on both platforms s...
...background in financial web projects and a keen understanding of the stock market. The site should feature: - Historical Analysis: Capabilities to assess past market trends and options performances. - Technical Analysis: Tools to facilitate an in-depth statistical study predicting future activity. - Fundamental Analysis: Feature to dissect financial statements towards determining a stock's fair value. - Option Chain Analysis: A comprehensive review of option contracts for a particular security is required. Moreover, I want the site to include the following functionalities: - Real-Time Data Updates: Keep users informed with real-time data on the stocks. - Option Chain Analysis: Equip users to analyze market possibilities. - Portfolio Tracking: Let registered users track th...
I have a significant amount of text that needs to be typed into Excel quickly. The data is in a simple text format, no complex formatting required. Key requirements: - Proficient in Excel and typing - Attention to detail - Ability to work under tight deadlines The data is straightforward text and requires no specific formatting or analysis. The ideal freelancer will be skilled in data entry and be able to commit to a quick turnaround time.
As a client with emphasis on quality, I need the support of an experienced Python programmer who can take charge of the frontend aspect of my web development project. At the core of this project are the following requirements: - Full proficiency in Python as the main programming language for the task - Demonstrated experience in frontend web development using Python - Familiarity with the best practices in Python programming - Capacity to effectively communicate, provide regular updates and accept feedback The missing response for the third question won't be an issue — I am more interested in a Python programmer who can bring their own unique ideas and solutions. You are encouraged to showcase your creative problem-solving skills. Apply if you have the necessary skills and ...
I am seeking an Excel expert who can meticulously enter extensive amounts of text, numeric, and alphanumeric data into my spreadsheet. The task involves entering names, contact details, sales information, and inventory data. The size of the task is quite substantial, with up to 1,048,576 rows and 16,384 columns involved. The role requires a keen eye for detail, accuracy, and dedication. If you are efficient in Excel and possess experience with handling large data sets, your skills will be highly valuable for this project.
I'm looking for an expert in Excel data entry to assist me with a project. The job primarily involves: - Text data entry: Entering textual information into Excel. Accuracy is crucial, as even minor errors can greatly affect the output. - Data categorization: Organizing the entered data into different categories within the sheet. The ability to understand and sort data effectively is key. - Basic data visualization: I'd like the data to be presented visually. The freelancer should be able to create and include simple charts or graphs to represent the categorized data effectively. Ideal Skills: - Proficiency in Excel: A deep understanding of Excel and its functions is essential. - Data Entry: Previous experience in data entry is highly preferred. - Data...
Needs to hire 2 Freelancers Fitny, a leading fitness app specializing in stretching and gym instructions, is seeking two skilled and dynamic Black coaches or sports professionals, one male and one female. The selected candidates will participate in a content creation project to produce educational photo and video materials for our app. This freelance opportunity offers a chance to showcase your expertise and contribute to a growing fitness community. Key Details: Location: Filming will take place in Cyprus in May. Duration: The shooting period will last for 10 days. Content: The content will focus on basic gym exercises, predominantly without audio instructions. Responsibilities: - Demonstrate proper exercise techniques for filming. - Collaborate with the app's in...
