Extract data from website to excel vbaงาน
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)
ต้องการสร้างแอพ Xamarin (Cross Platform) เชื่อมต่อฐานข้อมูล Mssql ดึงข้อมูลจาก แสดงข้อมูลจากฐานข้อมูลพร้อมรูบ และ ทำระบบ Login
คัดลอกข้อมูลจากเว็บไซต์ คัดลอกข้อมูลจากเว็ปไซต์ลงในไฟล์excel
หาข้อมูล 16 อย่างของ Blogger จาก 50 fanpage แล้วกรอกลงให้ excel ที่กำหนดให้
คำนวณ Dynamic flow เพื่อดูการ action เปิด-ปิดของตัว Valve ที่ Condition เเตกต่างกัน
กรอกข้อมูลในสเปรดชีต Everything about data entry ,ms word .ms excel
พิมพ์สูตรคณิตศาสตร์ได้ ตัวอย่างงาน
ต้องใช้ imacro คัดลอกข้อมูลจาก web site ลง excel
คีย์ข้อมูลต่างๆลง Excel การคัดลอกบทความต่างๆลง word
ทำ presentation งานโดยใช้ Powerpoint สามารถแทรกงานที่เป็นข้อมูล ตารางและกราฟ จาก data ที่เป็น Excel
looking for job typing document from book by on line I mean want to work at home
...experienced data analyst who can help me identify trends in our QI project data. This will involve working with an Excel spreadsheet sourced from Redcap data. It is a NICU breast milk QI project. Data collection includes: Mother's age, mother's race, infant gestational age, insurance type, Breast pump useMilk volume at 3 different time points, volume goal of 500ml/day, Lactation clinic appointment. Scatter plot, run plot, effects of intervention: Yes/no lactation appointment attended, and does this correlate with milk volume. Key Responsibilities: - Analyze data to identify trends related to process improvements - Present findings in an accessible and clear manner Ideal Skills and Experience: - Proficiency in ...
I need a proficient translator to convert a 3-page Tamil contract into English. The translation will be used for business purposes (property sale deed) , so it is crucial that the translator understands the nuances of Indian legal language and can convey them accurately in English. Key Requirements: - Native or fluent in both Tamil and English ( Indian Tamil) - Extensive experience in translating legal documents, particularly contracts - Understanding of legal terminology in both languages - Able to deliver a clear, concise and accurate translation suitable for business use
I need assistance with data entry from approximately 170 invoices. All invoices are in PDF format and have a consistent layout. The task involves locating EAN codes in the left section of the invoices, extracting prices and calculating the total sum. Ideal Skills: - Proficiency in data entry - Attention to detail - Ability to follow instructions precisely Experience: - Prior experience with data extraction from invoices preferred.
I'm seeking a talented writer experienced in crafting Wikipedia articles to create a biographical piece about a public figure. Key Requirements: - Proven experience in writing for Wikipedia - Exceptional research and writing skills - Ability to adhere to Wikipedia's standards and guidelines - Capable of creating a compelling and neutral biography I can provide a wealth of resources including: - News articles - The official website of the subject - Interviews Your task will be to sift through these materials, extract the most relevant information, and present it in a manner that's suitable for Wikipedia. Please ensure to maintain a neutral point of view and adhere to Wikipedia's content guidelines.
...for Gym Setup, Project Management, and Administrative Support Job Description I am looking for a detail-oriented and proactive Virtual Assistant to help me manage multiple projects related to the launch of a new outdoor gym on the beach in Belize and assist with other business initiatives. If you're organized, tech-savvy, and great at keeping tasks on track, I’d love to hear from you! Your Responsibilities 1. Gym Setup & Operations: Manage the development of a professional website that accepts online payments. Research and recommend a point-of-sale system for an outdoor, beachside setup. Assist with equipment research and project management to ensure gym construction stays on track. Help source and coordinate with contractors,...
...for Excel Sheet Automation We are looking for a skilled AP Script Expert to help automate processes in Excel sheets for our business. The ideal candidate should have expertise in creating, editing, and debugging Google Apps Scripts to streamline data handling, calculations, and report generation. Requirements: Proven experience with Google Apps Script for Excel/Google Sheets automation. Ability to create custom scripts to automate repetitive tasks, manage data, and enhance productivity. Knowledge of integrating third-party APIs (if needed) with Google Sheets. Strong problem-solving and debugging skills. Effective communication and ability to meet deadlines. Scope of Work: Analyze the current Excel wor...
Project Summary: Request Management System Objective: Develop a simple, user-friendly online request management system to handle different types of requests, such as maintenance and purchase requests. The system should include role-based access control, approval workflows, and basic analytics. Key Functionalities: User Management & Authentication: Users can register and log in with roles: Requester (can submit requests) Department Manager (can approve/reject requests) Engineering Manager (final approval and assignment) Passwords should be securely stored (hashed). Session-based authentication to restrict access. Request Submission: Dynamic form with the following fields: Auto-filled: Requester Name, Department, Date & Time, Sequential Request Number (per department...
I'm seeking a speechwriter who can craft a poignant yet uplifting wedding speech from a passed loved one. The speech should evoke mixed emotions, with elements that are emotional and heartfelt alongside light-hearted and humorous moments. Key Requirements: - The speech should last between 3-5 minutes. - It needs to incorporate specific memories and stories from the loved one's childhood and life achievements. - The tone should seamlessly blend sadness and joy, reflecting the bittersweet nature of the occasion. - Ideally, the freelancer has experience in writing speeches for weddings. Skills and Experience: - Exceptional storytelling and speech-writing skills. - Ability to create a mixed-emotion tone. - Experience in incorporating personal...
I'm looking for a comprehensive, end-to-end service to help me export my puppy from India to the UK. This project involves: - All legal requirements: You'll need to be well-versed in the legalities of shipping a pet internationally, specifically from India to the UK. - Health certificates: I will need your assistance in obtaining all necessary health certificates for my puppy. This includes vaccinations and general health checks. - Transportation booking: I need help with booking the transportation for my puppy, including flights. An ideal candidate for this project would have experience in pet shipping, a deep understanding of international pet export laws, and a proven track record of successfully arranging pet flights. I appre...
I have a project which involves processing a spreadsheet of 4100 EANs. The primary task will be identifying the SKU and size from the data. The EANs are currently stored in an Excel (.xlsx) spreadsheet. - Skills Requirement: Proficiency in Excel and data mining is essential. Experience with SKU and size identification will be a significant advantage. - Task: Extract SKU and size information from the provided EANs data. Please note, the specific SKU and size information that needs to be extracted has not yet been defined. A flexible approach and readiness to adapt to evolving project requirements will be key.
I'm looking for a data entry specialist to collect email addresses from a specific website. The site has 480 pages, and there are 10 companies per page. What You Need to Do: - Navigate through the 480 pages and 10 companies per page. - Collect email addresses and input them into an Excel file. - Format: One email per cell. Ideal Skills and Experience: - Proficient in Excel. - Good attention to detail. - Previous experience in data collection or web scraping is a bonus. Please note, I only require the email addresses, not any additional information.
I need assistance with an Excel file. The city name is currently located in the middle columns and needs to be moved to a different column. All of the data is in one sheet. The ideal freelancer for this project should have: - Proficient Excel skills - Attention to detail - Data management experience
I'm looking for an Excel expert to help with my homework focused on analyzing scientific data. The main goal is to conduct a thorough data analysis using various statistical techniques. Key Responsibilities: - Analyze provided scientific data using Excel - Apply various statistical analysis techniques Ideal Skills: - Proficient in Excel with strong data analysis skills - Experienced in conducting statistical analysis - Familiar with scientific data sets
More details: What is the primary focus of the business analysis? - Operational analysis Which areas of operations do you want to focus on? - Balanced scorecard (BSC) of the given company based on template -> Which perspectives do you want to include in the balanced scorecard? - Financial, Customer, Internal processes, Learning and development perspective Extended description of the task: Describe the vision, mission, goals and strategies of in Excel 1. Describe the financial perspective of the company selected in point 1), taking into account the following indicators: profitability (2-3 indicators, e.g. ROA, ROE), debt (1-2 indicators, e.g. total debt ratio), liquidity (1-2 indicators, e.g. current liquidity), cash conversion period (1 indicator) and risk m...
...content to complete the assignment. Key Responsibilities: - Collaborate with me in developing a web application using Java. - Implement features such as user authentication and database interaction. - Create engaging weekly content to facilitate the learning and development process. Ideal Skills: - Proficiency in Java and experience in web application development. - Familiarity with Visual Studio Code (VSC). - Experience in implementing user authentication and database interaction features. - Excellent content creation skills. - I have attached the assignment details (its in 3 parts), sot the students should be able to provide 3 submission. - I have attached the weekly contents in excel sheet. I will need you to be good in creating weekly contnets m...
I'm in need of a proficient VBA CorelDRAW programmer for the 2024 version. My project involves creating a VBA script that generates QR codes within a specific template of a certain size. The script should also arrange these QR codes for printing on various printer sizes, specifically a custom size of 48x96 inches. Ideal candidate should be skilled in: - CorelDRAW and VBA - Understanding of QR code generation - Experience with custom printer size arrangements - Ability to work with specific size templates (small, medium, large)
I need a professional who can help me extract data from my Clover POS system on a daily basis. This data extraction will specifically focus on orders, with an emphasis on breaking out taxes and fees separately instead of having them lumped together as 'fees'. Key Requirements: - Data needs to be extracted daily and made available for download from a secure server. - The extracted data must be formatted in Excel. Ideal Skills and Experience: - Proficiency in data extraction from Clover POS system. - Expertise in Excel for data formatting. - Experience with secure server data handling. - Ability to meet daily deadlines. Please note, the goal is to have a detailed, clea...
billing_last_name and billing_first_name columns. How can I get to show only one column on mobile devices? billing_address_1 and billing_phone. How can I get to show only one column on mobile devices?
I need an Excel sheet specifically designed for conducting profit and loss analyses. The primary function of this sheet will be to facilitate financial calculations. Key Requirements: - Creation of an Excel sheet tailored for profit and loss analysis - Integration of functionalities for various financial calculations Data Entry: - All data will be entered manually, so the design should be user-friendly and intuitive for manual data input. Ideal Skills: - Proficiency in Excel - Experience in financial analysis - Ability to create user-friendly spreadsheets
...Analyst to assist in managing budgeting, forecasting, cash flow analysis, and cash management for our real estate and contracting business. The ideal candidate will have experience in the construction and real estate industry and be proficient in using Excel for financial modeling, reporting, and analysis. Key Responsibilities: Prepare and maintain annual budgets, revenue forecasts, and expense tracking using Excel. Analyze cash flow and ensure liquidity to meet operational needs. Assist in financial decision-making by providing insights and recommendations. Monitor project budgets and ensure financial alignment with company goals. Develop financial models to forecast project costs and returns. I am looking for an experienced financial analyst who c...
I'm looking for a professional tester to conduct thorough testing on my website before we go live. The testing should cover both the front-end and back-end, with all glitches and errors documented in an Excel sheet, categorized, and using Scrum methodology. Front-End Testing: - Usability testing: Assess the user experience and interface design. - Performance testing: Measure the responsiveness and stability. - Cross-browser testing: Ensure consistent functionality across multiple browsers, specifically Chrome, Firefox, and Safari. Back-End Testing: - Security testing: Identify any potential vulnerabilities. Ideal candidates for this project should have extensive experience in website testing, and be proficient in using Excel for documentation and ...
I'm seeking an automation expert to help extract product information from an FTP server and update my Shopify store. Key Requirements: - Extract product information from the FTP server - Automate the process to ensure regular updates on Shopify Ideal Skills and Experience: - Proficiency in data extraction from FTP servers - Experience with Shopify updates - Automation expertise - Familiarity with product information management. Note: The specific product information to be extracted and updated, as well as the format of the data on the FTP server, will be discussed further. Please bid if you have relevant experience and can provide references.
I need assistance to eliminate personal information about me from Google. This includes my presence on social media profiles, public databases, and personal blogs or websites. Specifically, I am looking to remove: - Photos - Contact details - Accusations or defaming statements - Any other negative info Ideal candidate for this job should have: - Expertise in online reputation management - Experience in removing personal information from the internet - Strong understanding of privacy laws and regulations - Skills in navigating social media platforms and public databases - Ability to deal with personal blogs or websites
I need assistance in removing personal details about me that are visible on Google. This information is currently appearing on various platforms including social media sites, public records or directories, and personal websites or blogs. - I have not yet attempted to contact these websites directly for removal. - Your task would be to help in this process, and ideally, to successfully have this information taken down. Skills and experience needed: - Proven track record in web content removal - Excellent communication skills - Familiarity with social media sites and public record directories - Experience dealing with personal websites or blogs
I need assistance to eliminate personal information about me from Google. This includes my presence on social media profiles, public databases, and personal blogs or websites. Specifically, I am looking to remove: - Photos - Contact details - Accusations or defaming statements - Any other negative info Ideal candidate for this job should have: - Expertise in online reputation management - Experience in removing personal information from the internet - Strong understanding of privacy laws and regulations - Skills in navigating social media platforms and public databases - Ability to deal with personal blogs or websites
