Macro extract data excel filesงาน
Coding vba ให้คำนวนและรายงานผลลงในแถบ status bar ที่มุมจอ โค้ดทำงานได้กับทุกชีทในไฟล์ รายงานผลคล้ายค่า sum, average ที่โปรแกรมมีมาให้เดิม ทศนิยมสองตำแหน่ง เลือกเซลล์จากชีทไหนก็ได้ (เซลล์1จากชีทa เซลล์2จากชีท(n) 1. รายงานผลหาร เซลล์1/เซลล์2 2. รายงานผลลบ เซลล์1-เซลล์2 3. รายงานผลเปอร์เซ็นต์ เซลล์2/เซลล์1*100
หลังจากลูกค้าโทรเข้ามาเมื่อคุยเสร็จแล้วลูกค้ากดวางสาย หรือ พนักงานกดวางสาย อยากให้หลังจากนั้นประมาณ 20 นาทีให้โทรศัพท์กลับไปหาลูกค้าเพื่อประเมิณความพึงพอใจ โดยใช้ macro-survey เป็นเมนูที่จะโทรออกอัตโนมัติ
...สามารถ 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
คีย์ข้อมูลต่างๆลง Excel การคัดลอกบทความต่างๆลง word
ทำ presentation งานโดยใช้ Powerpoint สามารถแทรกงานที่เป็นข้อมูล ตารางและกราฟ จาก data ที่เป็น Excel
I'm looking for a skilled developer who can create a personalized Roblox script hub for the games Pet Simulator 99, Jailbreak, and The Survival Game. Key Requirements: - Decompilation: You'll be required to decompile the mentioned Roblox games and extract essential elements for the script hub. - Auto Farm Feature: Implement an auto farm feature within the script hub that works seamlessly across all the games. - Personalized Design: Design the script hub with a minimalist theme, ensuring it's visually appealing and user-friendly. User Interaction: - The script hub should offer a graphical user interface (GUI) for users to easily navigate and interact with. Ideal Skills and Experience: - Proficient in Roblox scripting and decompilation. - Experience in developing che...
I am looking for assistance in creating a visually engaging, professional PowerPoint presentation, using a provided style template, based on a 64 double side page Word document. Key details: - Extract key points and messages to form a summarized version of the Word document's content. - Encompass a range of 50 to 80 slides with a balance between text and relevant images to ensure readability and viewer engagement. - Align with pre-existing PowerPoint template aesthetic. Ideal candidate should have: - Excellent summarization skills and attention to detail. - Proficiency in PowerPoint. - Experience in creating engaging corporate presentations. Presentation would need to be done in 5 days
The machine learning component of this hybrid profile creation system in a Flutter app involves integrating a TensorFlow Lite model, possibly using DistilBERT for its efficiency and effectiveness in natural language processing tasks. The model's role is twofold: Text Analysis and Categorization: It processes user-generated text inputs and web-scraped content to extract meaningful insights, such as sentiment, key phrases, or categorization of interests. This helps in dynamically adjusting the user's profile to reflect their preferences and behaviors accurately. Usage Pattern Learning: The system tracks and analyzes app usage statistics to learn about user preferences over time. Machine learning algorithms can identify patterns in what features or content the user interacts...
I have code for login trading accound and fetch token data. I need to update more data from the code to my system.I need to collect live data from the web and candle stick, Mins Intervals are in Dropdown box, I can choose any minutes interval, I need you to collect Last 5 candle data from the Excel in the web and other details for each token, I will give token name in the excel, It will automatically display the rows of data. If i chanage time interval it will display those data only. Need ot automate the buy/sell order Note: I dont know about coding, If you install the code and run successfully at my system thereafter I will hire you and release the payment. If you agree this term you will apply this task Budet is 600 INR and Good ...
โปรดลงทะเบียน หรือเข้าสู่ระบบ เพื่อดูรายละเอียด
I'm in need of a skilled data miner who can help to extract certain details from a vast range of Shopify products. Your mission, if you choose to accept it, is as follows: - list products that contain non-English writing or words in text and videos - Organise and sort these findings for simple review - Identify and list any products filled with non-English language in the description, pictures or images - Compile lists of products that aren’t currently making top-seller lists - List any products can not be delivered in eight days or less. Please note that tractors and food vans may take up to two months to deliver. - List any products that are not suitable for industrial purposes/non-commercial products. Ensure that the products you are considering are meant for c...
I am seeking a highly meticulous and efficient Data Collection Specialist to gather basic contact information for 25 agencies specializing in scripting video sales letters (VSLs). The task involves sourcing and validating agency names, email addresses, and website links, then recording these details into a spreadsheet. Responsibilities: -Conduct basic research to locate contact information for 25 specified agencies. -Validate that email addresses are current and active. -Accurately enter all data into a provided spreadsheet format. Requirements: -Experience in data collection and validation. -Proficiency in basic research and use of spreadsheets (e.g., Google Sheets or Microsoft Excel). -Ability to deliver accurate results within a set timeframe. -Project Le...
I need an Excel 365 PowerQuery or VBA script that can fetch daily market data and handle potential data source interruptions or changes. Google Shhets example =INDEX(IMPORTXML("" & C31, "//span[@class='mod-ui-data-list__value']"), 1, 1). <Where C31 = Cell containing the Stock eg GB00B8XYYQ86, LU1033663649 or GB00B0CNH163 I need an identical function in MS365 Excel - either with PowerQuery OR VBA (preferable) Ideal skills: - Proficiency in Excel 365 and PowerQuery and VBA - Experience in web scraping and handling dynamic data sources. I am after a fixed quote for this project.
** Please do not apply. If you don’t meet the must have criteria at the beginning of this job description post. We are looking for a motivated and successful grant writer located within Canada! The grant writer will be responsible for locating, researching, and applying for potential funding opportuni...opportunities; * Comprehensive knowledge of research, and the ability to distinguish and identify Ontario/Canadian Grant opportunities • Ability to work effectively under pressure; • Excellent writing and verbal skills; • Be highly organized with the ability to implement systems and follow-up processes; • Proficiency in research, interpreting, and analyzing diverse data; • Excellent Computer skills (Microsoft Office Word, Access, PowerPoint and Exce...
...able to create a custom CRM system in Excel for my business. Key requirements: - Sales Tracking: I need a system that allows me to monitor sales performance and forecast future sales. - Task Management: The CRM should have a task management feature to help me organize and prioritize my daily activities. Additional details: - The system will be used by a small team of 1-10 users, so it needs to be user-friendly and easy to navigate. - No integration with other software or platforms is needed at this time, so the focus will be solely on creating a robust, efficient Excel-based CRM. Ideal skills and experience for this job would include: - Proficiency in Excel, with a clear understanding of how to create complex formulas and visual representations of data. - ...
...experienced in web scraping and data collation. The project will involve scraping blog articles in HTML format and compiling desired information into an Excel file. Key Project Requirements: * The extraction will be from specified URLs, using their individual patterns for efficient and accurate scraping. * For each blog article, I need the title, the full text, and the publish date extracted. * This scraped data must be properly arranged in an Excel file for easy analysis. * List of articles is here: Ideal Candidate Expertise: * Proven experience in web scraping is a must, preferably with full understanding of HTML structures. * Proficiency in Excel and data organization. * Attention to detail to ensure accuracy of the scraped data. *...
I require an efficient solution to extract contact details, specifically phone numbers and email addresses, for newly sold residential properties.
...Analyst – VBA, Advance Excel. Job Role: Senior Business Analyst Job Location: Remote Experience: 4 + Years as Business Analyst – VBA , Advance Excel 3+ years of experience is required in creating dashboards in Manufacturing, Banking, Retail Industry. Working Hour: 3 hour per day (per day) Salary: 150 – 200 INR Per Hour Job Responsibilities : • Understanding Company requirements. • Understanding, consolidating and analyzing data from spreadsheets. • Creating dashboards, reports and charts in Analytics tools. • Working on financial and other types of modeling projects. • Having knowledge Dashboard Creation, Mainframe automation through VBA. • Good Technical knowledge of VBAs, Macro, MS Office skills to drive a...
I'm in immediate need of a cloud-based stock management software with barcode generation, scanning, stock quantity tracking, and weight meas...for every product in my stock - Track the quantity of each item I have in stock - Measure the weight of my stock in grams I prefer a cloud-based solution that can be accessed and updated from any internet-connected device. The software should have an easy to use interface and be able to: - Enable manual entry of stock data - Support updating stock information by scanning barcodes - Automatically update stock data from my sales records The software could be developed in Excel, as long as it's accessible online. As a freelancer, you should have experience in developing similar solutions and a deep understanding of sto...
I need an Excel sheet created with the primary purpose of data analysis. This sheet should have the following features: - Data Sorting and Filtering: This is crucial for making the analysis process efficient and easy to navigate. I need the sheet to be able to handle large amounts of data and allow for quick and convenient sorting and filtering. - Data Visualization: In addition to the data analysis, I also require the sheet to include line graphs. I believe that visualizing the data will make it much easier to understand and interpret. The ideal freelancer for this project is someone with a strong background in Excel and experience in creating data analysis tools. It is important that the final product is user-friendly and ...
More details: What format are the company names provided in? pdf Do you have the capability to extract text from the PDF files? Not sure How soon do you need your project completed? ASAP
I'm in need of a freelancer to assist with data cleaning from PDF documents. The task involves organizing the data into an Excel spreadsheet. Ideal skills for this role include: - Proficiency in data cleaning techniques - Strong attention to detail - Proficient in Excel for organizing data - Previous experience in similar data entry tasks
I want to scrape daily leads from LinkedIn Jobs, Indeed Jobs, , etc. The task involves extracting data from these job sites and exporting it to Excel sheets. It would be preferable to have some kind of automation that reduces human dependency in obtaining leads every day. If someone has already set up a similar process before, I would prefer that. Preference will be given to those who have previously performed lead extraction tasks for recruitment websites.
...Python that can extract the SKU (product) list from the following Indonesian online grocery apps: - Astro - Sayurbox - Segari The scraper must be IP-block tolerant, meaning if the scraper gets blocked, execution can be continued from the point where the last row of data was successfully extracted. Scraper Functions Function: list_category_tree Input: competitor_name(astro | sayurbox | segari), existing_csv (optional - CSV file to append to for continuing execution, if the scraper stopped or got IP blocked) Output: CSV of category tree with the following columns (scrape_date, URL, category name, position index, parent_category (null if top level)) Function: extract_sku Input: competitor_name, location (autocomplete place from google maps API), category (optional - ...
I require a skilled Excel VBA developer to create a dynamic system in Excel. The process should work as follows: - The system will generate a new CSV file when I hit a specific button. - The new CSV file should contain 'item data'. The item data will include: - Item name - Item description - Item price The CSV file should be structured in a simple, easy-to-read format, with each item's data on a separate row. I need this system to be easily maintainable in the future, so please ensure that the code is well-commented and organised. Ideal Skills and Experience: - Proficient in Excel VBA - Experience in dynamically creating CSV files - Attention to detail for correct data formatting - Ability to create user-fri...
tengo libros excel que tienen diferentes planillas, son registros de notas de estudiantes, pueden ser varias hojas del libro excel, quiero poder transferir esa informacion a hojas con el mismo diseño en gsheets, y viceversa, lo que ponga en excel quieor que se envie a gsheets, y lo mismo de gsheets, puedo tener varios libros excel, cada uno con diferentes datos, quiero que cada libro excel y gsheets sea individual referente otro, y que se almacenen en diferente cuenta de correo electronico. adjunto imagen de referencia de una hoja del libro en excel. quiero saber cotizacion, manera de hacerlo, que se requeriria por favor. una de las ideas, seria desarrollar una app android que funcione como plantilla, que al tener la direccion de un libro...
I'm in need of a developer who can create a n8n script to login to a specific website and extract stock data for multiple companies. Key features of this project include: - Extraction of table data: You should have knowledge and experience working with web data extraction, specifically with table data. - Selection of stocks data: The script should have the ability to select and extract information from the stock table. - Capability for multiple companies: The tool should be versatile to handle data extraction for multiple companies, not limited to just one. Experience in the use of n8n for data extraction from websites, especially in the finance sector, will be a significant advantage for this project. One of the p...
...assistance in integrating image links into two Excel sheets containing a total of 620 and 46 product entries for my Shopify store. Each entry includes links to the official websites where the products are sold. The task involves creating a new column labeled Images in both Excel sheets and inserting corresponding image links. This integration is crucial for ensuring that when uploading a CSV file to Shopify, each product will display its respective images seamlessly. Project Details: Scope: Adding image links to Excel sheets for 666 products in total. Task: Create a new column labeled Images in each Excel sheet and insert corresponding image links for each product. Requirements: Image links should open the respective product images when clicked. The CSV fi...
Complete Excel Analytical and Descriptive Analysis on provided dataset by Friday 4 pm
...in need of a professional who can analyze comprehensive survey data and present the results in a detailed, report that relates to each hypothesis for my thesis research. The analysis is expected to be done using Excel analyses then further descriptive analysis is needed, focusing on summarising the main characteristics of the data and how they prove/disprove each hypothesis. This will involve exploring the responses to the survey questions, identifying patterns, trends, and constructing summary statistics. The key deliverable for this project will be as follows: an Excel spreadsheet with... - raw data in one tab (provided for you in the attached excel document) - cleaned data a separate tab (provided for you attached excel docu...
I need a professional to mine data for me. I need you to download and extract the submissions and comments from a public Reddit dataset for 40 subreddits that I will give you. - Data Collection: Please extract the submissions and comments from this academictorrents link: https://academictorrents.com/details/56aa49f9653ba545f48df2e33679f014d2829c10/tech&filelist=1 I only want the comments and submissions for specific subreddits that I will supply to you. Please save the extracted data as csv file. - Frequency: This is a one-time job. Skills and Experience: - Torrent download and extraction.
I need an experienced freelancer to assist me in typing data from handwritten notes into an Excel sheet. Key Requirements: - Previous Experience: Please include details of your previous work in this area - Handwriting Deciphering: Due to the nature of the data being handwritten, you'll need to have good skills in deciphering handwriting - Accuracy: It's crucial that the information is entered into the Excel sheet with the highest level of accuracy Looking forward to your application.
...have a tool developed that can accurately scrape specific data from Airbnb and AirDna. The aim is to retrieve information about rental prices, occupancy rates, and property descriptions, etc. Key Features: - Efficient data scraping: The tool should successfully extract rental prices, occupancy rates, and property descriptions from Airbnb and AirDna. - Localized scraping: The data scraping should be focused on a specific city, which will be revealed once the project commences. Use of Data: The scraped information will be primarily used for market analysis purposes. The data will be instrumental in helping me understand the dynamics of the rental market within the specific city. Skills & Experience Required: - Proven experience in data...
...are in search of a skilled freelancer proficient in web scraping with Scrapy to extract product data from This project involves scraping the Category page to retrieve product details including name, price, SKU, URL, breadcrumb, currency, and brand. Targeted webpage: Category page of Required data: Product name, price, SKU, URL, breadcrumb, currency, and brand Experience: Prior experience in scraping product-related information from e-commerce sites is essential, with proficiency in Scrapy being crucial for accurate and efficient data extraction. Data Handling: Ability to ensure accuracy and consistency of extracted data. Familiarity with different data formats is advantageous. Dynamic Scraping: Navigation logic for all categories must
I have a number of scanned documents that contain financial figures. I need someone to accurately type these into an Excel sheet for further analysis. Key Requirements: - Experience with data typing and analysis in Excel, particularly financial data. - Attention to detail is paramount; precision in typing is crucial for the accuracy of the analysis. - Proficiency in English is a must, as the data will be in English and will need to be accurately transcribed. The ideal candidate should have prior experience in financial data entry and analysis, and comfortable working with scanned documents. Your work will be the foundation for subsequent data analysis, so precision and attention to detail is key.
