Vba excel capture website informationงาน
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 ที่กำหนดให้
ไฟล์ template ที่มีให้เป็น .AI ต้องการใส่ข้อมูลลงใน template มีข้อข้อมูลต้นฉบับให้เป็น ไฟล์ pdf ให้ใส่เนื้อหาและจัดเรียงตามตัวอย่าง (file pdf) จำนวน 39 หน้า
พิมพ์สูตรคณิตศาสตร์ได้ ตัวอย่างงาน
ต้องใช้ imacro คัดลอกข้อมูลจาก web site ลง excel
คีย์ข้อมูลต่างๆลง Excel การคัดลอกบทความต่างๆลง word
ทำ presentation งานโดยใช้ Powerpoint สามารถแทรกงานที่เป็นข้อมูล ตารางและกราฟ จาก data ที่เป็น Excel
...tasks primarily centered around Excel and Word. - Excel: The emphasis will be on crafting sophisticated formulas and performing financial projections. I need someone with an understanding of finance and the ability to manipulate data in Excel. A depth of knowledge in Excel formulas, calculations, and data analysis is crucial. - Word & PDF: Apart from Excel work, there is a need for expert formatting and layout design skills in Word, as well as converting Word documents to PDF format. Finally, I am seeking someone who can apply a professional design to a CV. The style I want to embody is professional, and therefore a good understanding of professional layout design and typography will be beneficial. Ideal candidates should have proficient ex...
I'm in need of an expert in Excel for data entry and cleaning. The tasks involve handling text-based, numeric, and date & time data. Key Responsibilities: - Perform accurate data entry - Cleanse and format the data as needed Ideal Skills and Experience: - Proficiency in MS Excel - Proven experience with data entry and data cleaning - Attention to detail - Ability to work with various data types, including text-based, numeric, and date & time data
I am in urgent need of a meticulous freelancer to assist with data entry and the organization of several Excel spreadsheets. Your primary task will involve entering data from various not-specified sources into Excel, as well as categorizing and structuring this data in a logical and efficient manner. Desirable Skills & Experience Required: - Mastery of Excel functions and formatting features - Strong attention to detail and accuracy - Proven experience in data entry - Ability to work with limited supervision - Data analysis and detection of irregularities is considered a plus. The task doesn't necessarily require prior relevant experience but being familiar with Excel and data structuring principles would be advantageous. Due to the nature of the...
I need assistance transferring my handwritten notes into a digital spreadsheet. Ideal skills and experience include: - Proficiency in data entry - Ability to decipher handwritten text - Expertise in spreadsheet software, such as Excel or Google Sheets
I'm in need of a talented videographer to cover an upcoming event for me. The video is expected to be edited in the style of a documentary. In addition to the main e...a talented videographer to cover an upcoming event for me. The video is expected to be edited in the style of a documentary. In addition to the main event coverage, I'm also looking for behind-the-scenes footage and a corporate video. Ideal skills and experience for this job include: - Proven experience with event videography - Proficiency in producing and editing documentaries - Ability to capture behind-the-scenes content - Experience in producing corporate videos Your bid should include a clear breakdown of your pricing, an estimated timeline for the completion of the work, as well as a portfolio showc...
As an advanced Excel user, I'm looking for a professional who can help me with two specific aspects of my project: performing advanced data analysis and creating macros to automate repetitive tasks. Key Requirements: - Data Analysis: You should be well-versed in data visualization, statistical analysis, and data cleaning and manipulation. Your ability to extract insights from complex data sets and present them clearly is crucial. - Macro Development: You will be responsible for automating repetitive tasks in Excel, including generating reports, automating data entry, and creating efficient formula calculations. Your macros should be user-friendly and easy to maintain. Ideal Skills: - Proficiency in Excel, including advanced functions and VBA programming ...
I'm seeking a Python developer who's proficient in web scraping to help me extract data from social media platforms. Key Responsibilities: ...help me extract data from social media platforms. Key Responsibilities: - Develop and implement a Python script for web scraping data from social media channels. Deliverable: - The scraped data should be compiled and delivered in an Excel spreadsheet for further analysis. Ideal Candidate: - Proficient in Python with a strong background in web scraping techniques. - Prior experience in scraping data from social media platforms will be a big plus. - Ability to deliver the end results in an organized, neat and easily accessible format, such as an Excel spreadsheet. Please reach out if you think you're the right f...
...content. The content will be used for: * Webpage content writing for a children’s art gallery * A variety of articles focusing on children's art, with special attention given to the different types of artwork such as paintings, drawings, sculptures, and ceramics. * Informative and persuasive product descriptions for our vibrant online gift shop items. * Engaging newsletter content that will capture the interest of our audience and keep them updated on the latest activities and available pieces. The ideal freelancer for this project should be experienced in writing about art and be able to craft content that is suitable for a range of audience from toddlers to teenagers. A knowledge of children's interests and language appropriate for different age groups (1-3,...
I'm looking for a skillful music producer who can create an engaging and high-impact Pop music track for a dance performance. - You should have a strong understanding of pop music, its subtleties, and how to use this to create a track that can control and enhance the mood ...dance performance. - You should have a strong understanding of pop music, its subtleties, and how to use this to create a track that can control and enhance the mood of a dance performance. - Moreover, I'm keen on reproducing specific pop tracks so a knowledge and experience in doing this is crucial. - Ability reprodcue orginal tracks with a twist In essence, I need a maestro who can capture the spirit of a dance performance in a Pop track. If this sounds like you, I'd love to hear your ...
I have a requirement for someone adept at data entry and proficiency in working with PDF documents and Excel. My project involves converting a PDF document into Excel format. Key Details: - Source Document: The source document is a PDF which needs to be copied verbatim into Excel. - Structure: The data should be displayed in the Excel document exactly as it appears in the PDF format. No need to segregate into different columns based on the type of data. - Special Handling: There are no specific requirements for handling or formatting any particular data in the PDF document. Ideal Skills: - Experience in data entry and manipulation - Proficiency in Microsoft Excel - Ability to work accurately with PDF documents If you have these key skills and c...
It is basically an app that helps the sales see the account profile data that is attached. We already have the designs ready, workflow will be decided in collaboration with the freelancer. Expertise required is app development and not design
...enhancing our efficiency considerably. Key Tasks: - Designing and implementing an automated system that effectively captures and tracks leads: For now, our website captures leads through a contact form, and we want this process to be automated. - Integrating with our current email marketing service: Currently, we use MailChimp for email marketing. Thus, experience in MailChimp integration is a plus. - Tailor-made sales funnel automation: The new workflow must streamline our sales funnel to ensure a smooth transition from leads to potential clients. Skills and Experience: - Excellent in and ClickUp - Past experience in lead capture, tracking, and marketing automation - Extensive knowledge in MailChimp Integration. - Understanding of sales funnel automation. If you...
I'm in need of a comprehensive contact list for Queensland-based mine sites. I'd like the list to include: - Company name and contact details - Mine site location and address - Contact person and title I'm looking for a high...contact list for Queensland-based mine sites. I'd like the list to include: - Company name and contact details - Mine site location and address - Contact person and title I'm looking for a high volume of entries, so ideally more than 50 mine sites should be included. The final deliverable should be an Excel spreadsheet. Ideal freelancers for this project should be experienced in data mining and collection. You should be thorough and detail-oriented to ensure all information is accurate. Knowledge of Que...
...main task will be: - Designing a bold and eye-catching landing page tailor-fit to my specifications. - Implementing HTML code injections to integrate WarriorPlus buttons onto the landing page. Particulars of the project are as follows: - WarriorPlus buttons should be placed in 4 strategic locations across 5 different pages to maximize user interaction. - The design must be appealing enough to capture the user's attention while retaining its functionality. Skills & Experience: - Proficiency in HTML, CSS, and JavaScript is paramount. - Experience with landing page design and WarriorPlus platform. - A solid understanding of UX designed for maximum conversion rates. I look forward to collaborating with a professional who can deliver a landing page that's not just ...
I have a requirement for someone adept at data entry and proficiency in working with PDF documents and Excel. My project involves converting a PDF document into Excel format. Key Details: - Source Document: The source document is a PDF which needs to be copied verbatim into Excel. - Structure: The data should be displayed in the Excel document exactly as it appears in the PDF format. No need to segregate into different columns based on the type of data. - Special Handling: There are no specific requirements for handling or formatting any particular data in the PDF document. Ideal Skills: - Experience in data entry and manipulation - Proficiency in Microsoft Excel - Ability to work accurately with PDF documents If you have these key skills and c...
I am in need of a professional videographer who can capture an informative product demonstration video showcasing the features and benefits of our product. Skills & Experience: * Expertise in videography and editing * Previous experience with product demonstration videos * Good understanding of pacing and tone to effectively convey informative content The ideal freelancer should be able to create a video that not just displays our product, but also truly engages the viewer by emphasizing the benefits and distinctive features of our product. The aim is to have an informative yet engaging tone that resonates with viewers. Your role will involve shooting and editing the video, and coordinating with our team for understanding specific product features to be highlighted. Your co...
I'm in need of a professional to develop an informational website that targets students. Ideal skills and experience for the job: - Proficiency in web development and design - Strong understanding of user experience - Experience in implementing contact forms - Ability to create a student-friendly layout Key Requirements: - Informational Website: The main purpose of this website is to provide information to students. The design should be clear, easy to navigate, and engaging for a younger audience. - Contact Form: I would like the website to include a contact form. This should be easy for students to locate and use. Please keep in mind that our target audience are students, therefore, the design should be tailored to suit their needs and preferen...
I'm looking for a skilled photographer who can help me shoot pictures of my bags for my e-commerce website. Key Requirements: - Photographers with prior experience in product photography, particularly bags, are preferred. - A good understanding of e-commerce photography standards. - The photos should be clear, high quality, and highlight the bags' features. - You'll need to capture the products from different angles to give our online customers a comprehensive view. The ideal candidate should be able to provide a portfolio to showcase their previous work in product photography.
I'm seeking a talented graphic designer to create an illustrative flyer to raise awareness for an important cause. Key Requirements: - Proficient in graphic design, with a focus on creating compelling and visually appealing designs - Experience in designing flyers, with a portfolio that showcases your ability to co...portfolio that showcases your ability to combine powerful imagery and text in a single, impactful design - Strong understanding of the principles of design and how they can be used to communicate a message effectively The ideal candidate should be able to create a design that is not only visually engaging but also effectively communicates the core message of the cause. The design should be able to capture the audience's attention and encourage them to learn ...
I'm seeking a talented designer to create a modern, promotional brochure that will capture the attention of my existing as well as new customers. The main goal of the brochure is to promote our brand and services and generate business. The ideal candidate for this project should have: - Solid experience in brochure design - A creative approach to modern design aesthetics - Proven ability to target design towards a specific audience - Excellent consumer psychology understanding to drive promotional objectives.
I'm looking for an experienced Excel professional to help me set up a SUMIFS formula in an Excel spreadsheet with the following requirements: - The SUMIFS function needs to work with numeric matching criteria. - The source for the data is an Excel spreadsheet. - The most crucial aspect for this project is that the SUMIFS formula needs to be dynamic. It should update automatically as new data is added to the spreadsheet. Ideally, you should have: - Proven experience working with Excel SUMIFS functions, especially with numeric matching criteria. - The ability to create dynamic formulas that update with changes in the source data. - Strong attention to detail to ensure the formula is implemented correctly and efficiently. If you're confident in your ...
I'm on the hunt for a skilled Data Analyst who will work closely with our customer data, primarily formatted in Excel/CSV. The primary goal of this analysis is to identify trends and patterns that could aid our business processes. Key Responsibilities: - Deep analysis of customer data to identify patterns and trends - Create visually engaging and understandable reports Ideal Skills and Experience: - Proven track record as a Data Analyst - Comprehensive understanding of data analysis methodologies - Superior skills in Excel/CSV data processing - Ability to present complex information in an engaging and understandable manner. Your contribution will hugely impact our business decisions. I look forward to viewing your proposals. Please include samples of your p...
Project Overview: The project involves reconciling sales data with weekly remittances over a span of 2.5 years in Excel. This requires merging multiple remittance files into one cohesive dataset, and then cross-referencing the sales data with the remittance data using a unique identifier (e.g., order number). The goal is to ensure that each sale corresponds to an accurate payout in the remittance, identifying any discrepancies or missing payments. Project Tasks: Data Collection: Gather all sales data and remittance files spanning 2.5 years. Ensure each dataset includes a unique identifier (e.g., order number) for matching. Data Merging: Consolidate all remittance files into one master remittance dataset. Arrange the data in a structured format for ease of analysis. Data Reconcil...
I'm seeking a driven sales assistant well-versed in multitasking. Your main responsibilities will include cold calling, lead generation and sales follow-up. My business resides within the marketing industry. Having knowledge of different marketing channels like social media, email marketing, consulting, content production, and digital assets is preferred. To excel in this role, here's what you need: - A strong background in sales particularly cold calling and lead generation. - Good understanding of multiple marketing channels. - Excellent follow-up skills to ensure effective sales conversions. Apply if you're ready to help drive growth in an active marketing environment.
...file for upload to Square. This extensive project requires three core competencies: meticulous data extraction from our website, proficient data entry into an Excel form, and the creation of engaging service descriptions using AI tools. The ultimate goal is to craft a CSV file that not only meets but exceeds the requirements for Square's platform, ensuring a seamless upload process. Key Responsibilities: Data Extraction and Accuracy: Initiate the project by extracting data from specific sections of our website. This data must be accurately transcribed into an Excel form, adhering closely to the required fields. Attention to detail is paramount to ensure that the information captured is both precise and aligned with our needs. Content Creation wi...
...create an LBO model urgently. The ideal candidate should be able to create a full LBO model from scratch given instructions from a Confidential Information Memorandum (CIM). Key project requirements: - Basic assumptions and financial projections: Your model should include detailed financial projections based on the provided assumptions. - Operating model and capital structure: You will need to build a comprehensive operating model, and structure the capital in line with the LBO requirements. - Sensitivity and scenario analysis: I expect you to provide a detailed sensitivity and scenario analysis that is easy to interpret. - I have a CIM and a template excel sheet that you can use to create the model. I have other instructions as well in which I will provide after you bid....
...specialist who can help me with inputting text-based data from digital files into a spreadsheet. Key Requirements: - Data Entry: The core task involves taking text data from digital files and accurately entering it into a spreadsheet. The data is not overly complex and primarily consists of straightforward text entries. - Skill with Spreadsheets: Proficiency in using spreadsheet software like Excel or Google Sheets is essential. The ability to accurately organize and input data into these platforms is crucial. - Attention to Detail: Precision is paramount. I need someone who can enter the data with great accuracy, ensuring that each entry is correct and in the right place. - Efficiency: While accuracy is key, speed is a factor too. I'm looking for someone who can work ef...
Seeking a skilled animator to create an engaging and entertaining cartoon-style 3D animation for a children's audience. The aim of the animation will be purely for entertainment purposes. Ideal Skills and Experience: - Proficiency in 3D animation - Prior experience with cartoon-style animation for young children - Demonstrated ability to capture the attention of young viewers - Passion for developing fun and engaging animated content To be considered for this role, please provide portfolio examples of previous work, particularly animations created specifically for entertainment for a young demographic.
I'm in need of a skilled cameraman with access to a professional camera and tripod to shoot a documentary that will span multiple days. The ideal candidate should have: - Experience in documentary or film projects - Proficiency in operating professional camera and tripod - Good understanding of lighting and angles - Ability to anticipate and capture key moments If you have your own lighting equipment, this would be a plus.
