Vba code examples for excel web scrapingงาน
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 ที่กำหนดให้
พิมพ์สูตรคณิตศาสตร์ได้ ตัวอย่างงาน
ต้องใช้ imacro คัดลอกข้อมูลจาก web site ลง excel
สวัสดีครับ ผมกำลังหาคนเขียนโปรเจคเกมส์ออนไลน์ โดยที่ผมมี Source code เกมส์อยู่แล้ว ซึ่งซื้อมาจาก Unity assert store แนว MMORPG (Offline) Link !/content/15552 มี Demo ให้ทดลองเล่นอยู่ครับ โดยความต้องการของผมมีดังนี้ครับ 1. สามารถมองเห็นความเคลื่อนไหวของตัวละครในเกมส์ของผู้อื่นได้ (Animation network) เช่น เดิน , วิ่ง ,เอฟเฟ็คตอนใช้สกิล , ฟันมอนสเตอร์ , เปลี่ยนแปลงอาวุธของตัวละคร 2. ใช้ Unity Network 5 , Javascript , C# ในการเขียน (หากใช้ Tools อื่นก็ลองเสนอมาได้ครับ) 3. สามารถกำหนดจุดเกิดมอนสเตอร์ได้ และผู้เล่นคนอื่นเห็นมอนสเตอร์เหมือนๆกัน 4. กำหนดการดรอปของไอเทมเวลาฆ่ามอนสเตอร์ได้ และผู้เล่นคนอื่นเห็นไอเทมเหมือนๆกัน 5. ระบบ Inventory สามารถดึงข้อมูลไอเท็มของตัวละครแต่ละคนได้ ใช้ database mysql หรือ ms sql ครับ 6. ระบบแชททั่วไป และแชทส่วนตัว
คีย์ข้อมูลต่างๆลง Excel การคัดลอกบทความต่างๆลง word
ทำ presentation งานโดยใช้ Powerpoint สามารถแทรกงานที่เป็นข้อมูล ตารางและกราฟ จาก data ที่เป็น Excel
...from a directory for our event, which lists approximately 2590 partners. The information must be obtained from the webpage after clicking on the exhibitor name to view the full profile and not just main profile Data Points to Extract for Each Exhibitor: 1. Logo 2. Company Name 3. Stand number/code 4. "Why Visit Our Stand" Section 5. Brands 6. Description 7. Company Activity 8. Product categories 9. Regions Operating In 10. Gallery 11. Follow us section (social media links) 12. Website 13. Email(s) 14. Company Address Special Requirements: • Utilize advanced AI technologies for automated data scraping. • Explain your methodology for AI-driven data extraction in your proposal. • Everything should be automated and no ma...
I'm in need of a proficient Excel specialist to help me with data analysis and entry. The task involves handling mixed data (both numeric and text) and providing valuable insights from analysis. This is a remote role, so email will be our preferred mode of communication. Ideal Skills and Experience: - Advanced Excel proficiency - Previous experience with data analysis and data entry - Ability to work with mixed data types - Strong analytical skills - Excellent communication through email
I am looking to work with a skilled WordPress developer who can assist in cloning our current business website. The primary goal is to create a similar service or product offering from this cloned website. Key Requirements: - Expertise in WordPress development, including cloning or copying websites - Ability to replicate website design, st...website design, structure, and functionality accurately - Strong understanding of e-commerce and product display - Incorporating Reviews functionality into the duplicated site Your role will be to ensure a smooth transition from our existing site to the new product-oriented version. Experience in e-commerce, product showcasing, and customer review integration is highly preferred. Please include examples of similar projects you've worked ...
I am looking for an experienced Python developer to create a scraper for Lazada. The ideal candidate must be skilled in web scraping and should reverse engineer API from mobile app because lazada blocks and throws captcha on web website is lazada . The script should work like i enter something in search box and it should scrape all the products from that search query Key Responsibilities: - Extract the following information: product names, prices, descriptions, stock, images, seller information, and product URLs. This list encapsulates the attributes you need to pay the most attention to. - Organizing the scraped data: The data, once scraped, must be organized in a well-structured CSV file. Ideal Skills: - Strong experience with Python. - Proficie...
I'm in need of a custom bill format in Excel that incorporates my company's logo and branding. The bill should have automated calculations for the ease of use. Key Requirements: - A customized Excel bill format with a professional finish - Integration of the company's logo and branding into the bill - Automation of calculations within the bill Ideal Skills: - Proficiency in Excel, including advanced formula creation - Experience in design, particularly in creating professional, branded documents - Understanding of automated calculations and their implementation within Excel Upon completion, I expect to receive the Excel file with the custom bill template.
I'm in urgent need of a profi...handled as promptly as possible. Though I didn't specify platforms, it would be advantageous for prospective freelancers to be able to work across a range of devices, including mobile phones, tablets, and desktop computers. What I'm looking for: - Excellent command of both Urdu and English languages. - Experience with translating Urdu to English accurately and efficiently. - The ability to meet short deadlines without compromising quality. Your Application: Please include examples of your past work in your application. I'm particularly interested in seeing translations you've done from Urdu to English in the past. This will provide me with a clearer understanding of your capabilities and suitability for...
...fully bilingual professional (I will interview in English via video) to do some tasks for my agency, such as: PR Outreach Social media Content editing or creating CRM management Email marketing Email scraping Researching Organizing data in spreadsheets Copywriting Basic Wordpress (change text, add a button, upload a file, etc) And others related to the position You must be a FAST learner, attentive to details, curious, with great writing skills. Looking for someone that pays attention and doesn’t keep making the same mistakes over and over. Attention to detail. Common sense. This job will part-time as a test period, after that it will be full-time. First, there is a task I’ll give as a test. Payment for part-time during trial period: Fe...
I'm currently in need of a professional with strong experience in CodeIgniter + Bootstrap, for an urgent task. I need the person for complete redesigning of dashboard, The code is of codecanon you can find that here demo code is Just look at the website carefully, before placing the bid. I will also provide you the html template of dashboard to change I need someone who can complete the work asap. Note:- kindly check the above code carefully and all my simple requirement is written above, so don't try to place low bid only to come into inbox, just place your final price bid else i will directly stop replying you in inbox if you will change your bid amount there.
I'm seeking an animation professional to create a captivating 2D animated short for my business. The main goal of this project is to promote our product or service to our target audience, specifically young adults. The successful candidate will bring the following skills and experience: - Proven track record in creating 2D animations - Understanding of marketing strategies and how to appeal to young adults - Ability to translate our product or service into an engaging, animated short - Strong communication skills for regular updates and revisions. Please include examples of previous relevant work and a rough timeline in your proposal. We look forward to collaborating with you on this exciting project.
I'm in need of an experienced AutoCAD designer to some changes on dwg file That i have . Skills and Experience: - Profound knowledge in AutoCAD - Experience with both 2D and 3D design - Ability to work with minimal directions - Good understanding of space utilization Please include your portfolio or examples of previous floor plan designs with your bid.
I'm in need of an experienced AutoCAD designer to create a 2D and 3D floor plan. The dimensions and specific design elements of the floor plan have been left intentionally ambiguous, giving you room to use your expert judgement. This project requires autonomy and creativity. Your input will greatly guide the outcome. Skills and Experience: - Pr...plan have been left intentionally ambiguous, giving you room to use your expert judgement. This project requires autonomy and creativity. Your input will greatly guide the outcome. Skills and Experience: - Profound knowledge in AutoCAD - Experience with both 2D and 3D design - Ability to work with minimal directions - Good understanding of space utilization Please include your portfolio or examples of previous floor plan designs...
...need of a talented interior and exterior designer experienced in both Scandinavian and Neoclassic styles, who can beautifully merge these styles for a 6-10 room villa. The project needs to equally prioritize aesthetic appeal and functionality, allowing the spaces to be not only visually pleasing but also practical and easy to live in. Key requirements are: - Experience in both Scandinavian and Neoclassic styles - Portfolio showcasing a strong sense for aesthetic appeal and functionality - Ability to translate personal tastes and ideas into a cohesive design - Proven track record with designing 6-10 room villas Please share visualization examples from your portfolio that showcase the blend of Scandinavian and Neoclassic you have designed before. I'm looking f...
I'm looking for a professional who can assist in converting screenshots, which already depict data set in tables, into Excel tables. The purpose of this task is to better analyze the data, which is purely textual in nature. The ideal freelancer for this job would be experienced in data entry, with a particular emphasis on Excel, and have an eye for detail to ensure all data is transferred accurately. There's no requirement for interpretation or analysis, I simply need the information from the images moved into an Excel format. Attached is a sample of the screenshot.
I have Excel sheet in the are all products added with all the categories in it. I will also share a word file in which I will add that specific category and you have to take out the data from sheet and create the image in Photoshop. I will also give you product images with it's specific name. You have to only remove background and add text and image according to the data. The person must have latest Photoshop and have to create one sample image. You have to leave the space also for the main video and have to choose a shape or space according to the data Here are the links to sample: My budget is Rs.50 per image. There are 10-11 images which you have to create and I need it by today. This
I require a proficient architect who specializes in commercial interior redesign. Project Scope: - The project involves a commercial property which is less than 10,000 sq ft in total size. Skills Required: - Comprehensive experience in commercial architecture - Sound knowledge of interior redesign techniques - Proven ability to manage small-scale proje...involves a commercial property which is less than 10,000 sq ft in total size. Skills Required: - Comprehensive experience in commercial architecture - Sound knowledge of interior redesign techniques - Proven ability to manage small-scale projects The ideal candidate will have substantial experience in maximizing the use of space while creating modern and professional aesthetics. Please provide examples of previous work in...
I need a skilled PHP developer to write a script that will interact with an API and retrieve User Information and Product Details. The fetched data should then be displayed in HTML format, enabling users to search through it. Key Requirements: - Fetch User Information and Prod...format, enabling users to search through it. Key Requirements: - Fetch User Information and Product Details from an API - Print the fetched details in HTML format - Implement a search function to enable user interaction Ideal Skillset: - Proficiency in PHP - Experience with fetching and handling data from APIs - Strong understanding of HTML and web interface design - Prior experience implementing search functions in web applications Please provide examples of your previous work with APIs an...
I need a creative designer to transform the image of a dragon statue into a small, 1-2 inch, promotional gold-plated coin. This project should ideally be completed ASAP. Key requirements: - Expertise in graphic design...completion as soon as possible. - Ability to take creative initiative based on provided dragon statue design. The goal is to produce a captivating and aesthetically pleasing design that will make our promotional coin stand out and catch the eye. It's essential for the designer to maintain the essence of the dragon design when adjusting to the size of the coin and the material used. The final design should embody both the intrigue of a dragon statue and the marketability of a promotional gold-plated coin. Please provide examples of similar design ...
Hi there, We are looking for someone who is: - Proficient in Python. - Experienced in automation and data scraping. Our budget is $3/hr for 20 hours on the initial project. This is a one-off task for now but could be ongoing work if successful. Please message with your CV/portfolio if interested
I need a proficient freelancer to help convert my Excel files, containing both numerical and textual data, into Word documents. The aim of this conversion is to ease the process of creating reports. The data should be precisely formatted into tables in the Word documents for a cleaner presentation. The ideal candidate would require: - Excellent skills in Microsoft Excel and Word. - Proficiency in data conversion and formatting. - Attention to detail to maintain data integrity. - High regard for timeliness and efficiency. Understanding the importance of report creation in business communication, this work must be meticulously done, reflecting professionalism in every converted document.
Looking for an experienced data entry professional to help me in typing less than 10 pages from a text document to Excel. This project involves text-based data entry. Here’s what I am looking for in the ideal candidate: - Proficient with Excel and able to input data with high accuracy - Experienced in copy-typing from PDF or other formats to Excel - Fast typing speed with a keen eye for details Ultimately, I require a reliable individual that can work efficiently within a set timeline. Your responsibilities will include: - Transferring data from the document into Excel accurately - Proofreading data entries to ensure no mistakes were made Please ensure you bring a good understanding of Excel functionalities. The text to be ...
...through several car websites (, , , , , , , Facebook Market Place) and display the results in one convenient place. Key functionalities should include: - Advanced filtering options - Price range filtering - Location-based search Ideal expertise would entail experience in advanced web scraping and designing search algorithms, along with a deep understanding of diverse automobile databases and SEO. The candidate should be capable of verifying and testing the accuracy of the collected data as well. Efficiency in coding with an ability to manage site speed and response time is crucial, especially considering the breadth of services it will be searching. The final product should be
I'm keen on gathering a customized list of up to 50 nano or micro influencers who are distinguished in the pet food product niche. The preferred influencers are mainly thos...or YouTube. To attract quality bids, freelancers should possess: - Expertise in Social Media and YouTube data gathering. - A strong understanding of the pet products industry. - Ability to identify key influencers in the pet products niche. - Tracking and reporting capabilities. Freelancers with current experience in influencer research will be given priority. The deliverable is a Report (Excel format preferably) that includes: - Full Name of the nano/micro Influencer - Profile Link - Username - Channel Name - Channel Type (IG, FB, YT, etc) - Email (must be current and valid) - Engagement Ratio - So...
...developer to create a web application powered by AI. Here's what I need: - **User Uploads**: - Users should be able to upload documents to the platform. The supported file format should be limited to csv/excel documents only. - **AI Summarization**: - The core AI functionality of the application should be the ability to generate a summary text/data visualisation from the uploaded documents. This summary text should be a concise and accurate representation of the main content of the document. - **User Authentication**: - The application should include a user authentication system. Users are required to sign up with their email and verify it to access the upload and summary features. Ensure the authentication process is secure and user-friendly. Ideal candidat...
I'm looking for a skilled developer with experience in food delivery apps to help me set up a comprehensive solution for my business. - **Features**: I need to integrate several key features including user registration and login, order tracking, payment gateway, inventory management, a seller app, a delivery agent app, an iOS app, an Android app, and a web app. The solution must provide a smooth and seamless experience for both customers and my team. - **Platform/Framework**: While I'm open to suggestions, I'm considering using scripts from Envato or Code Canyon as a base for this project. Any framework compatible with these scripts would be acceptable. - **Timeline**: I don't have a strict deadline for this project, b...
I'm in need of a skilled web developer who can create a unique content marketplace website for me. The primary aim of this platform is to enable content creators to sell their locked content to interested customers. A very good example of this is - Key Requirements: - **Content Types:** I expect the platform to support video and image uploads. It's crucial that the website is optimized to handle these media formats efficiently. - **User Registration and Login:** The website should have a user registration and login system, specifically tailored for content creators. This feature will enable content creators to upload, lock, and set prices for their content and for each content they upload a unique link should be generated. Additional Featu...
I am looking for a skilled Graphic Designer to create print ready 6" x 9" postcard artwork following my mock-up (see attached). This is a double-sided four-color postcard that complies with US postal service requirements as shown. I will provide high quality photographs and logo. For this project, you will need: - A strong understanding and experience in print design. - Proficiency in graphic design software. - Speed and accuracy. - Cost effectiveness. Please provide examples of similar projects you have completed in your proposal. And your proposed price and timing.
I'm in need of a skilled video editor who has experience creating and editing cinematic Instagram montages. Key Requirements: - The final montages should be 15 seconds in length, engaging and polished. - You should be able to work with the fast-paced and energetic style of editing. Ideal Skills and Experience: - ...with the fast-paced and energetic style of editing. Ideal Skills and Experience: - Proven experience in video editing, particularly with Instagram montages. - Strong editing skills, with the ability to create engaging and energetic content. - Proficiency in relevant editing software. If you have a portfolio that showcases your skills in this area, I'd love to see it. Please include any relevant examples in your bid. Here is an example:
I'm looking for an experienced paid social media advertising specialist to help me drive traffic to my website. Key Responsibilities: - Create and execute strategic social media advertising campaigns on Facebook, Instagram, TikTok, and YouTube. - Optimize campaigns to achieve the primary goal of driving website traffic. - Create retargeting campaigns Requirements: - Demonstrated experience in running successful paid social media advertising campaigns. - Proficiency in leveraging Facebook, Instagram, TikTok, and YouTube for advertising. - Proven ability to drive traffic to websites through social media advertising. I'm looking for someone who can take this project on and deliver results. Please provide examples of relevant work and outline your app...
I am seeking an experienced HTML/CSS/JQUERY/PHP developer with at least 4 years of experience to join me on a project. for agency Website/portfolio. Key Skills: - Proficient in HTML and CSS, with experience in responsive design, CSS animations, and the Bootstrap framework. - Strong command of JQUERY and PHP. As part of the application process, I'd like to see: - The number of years you have worked in this field. - Examples of your previous projects showcasing your expertise in the mentioned technologies. Please only apply if you meet these requirements and have a portfolio that demonstrates your proficiency in these areas. Experience is key, so make sure to highlight this in your application. Looking forward to seeing your applications.
I'm seeking an SEO expert to boost our online visibility and client engagement for our access matting business in Canada. Key Goals: - Increase Website Traffic: By optimizing our website, you should help strengthen our online presence. - Improve Search Engine Rankings: We aim to enhance our rankings on search engines, particularly for the primary keywords detailed below. - Generate More Leads: Ultimately, the goal is to attract more qualified leads for our business. Key Keywords: - Access Matting - Access Matting Services - Matting Solutions Targeted Regions: - National (Across Canada) - Specific Provinces - Specific Cities Ideal Skills: - Proven track record in SEO, particularly for Canadian companies. - Familiarity with the access matting industry is...
