Excel vba import csv file into worksheetงาน
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 วันให้ทั้งแถวเปลี่ยนเป็นสีแดง
ผมต้องการทำ Google data studio เพื่อแสดงข้อมูลรายงานรายได้ ค่าจอดรถของผม ซึ่งผมมี เวป คราวที่สามารถดึง CSV ออกมาได้แล้วก็นำมา สร้างเป็นหน้ารายงานสรุป
...สามารถ 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 ที่กำหนดให้
กรอกข้อมูลในสเปรดชีต Everything about data entry ,ms word .ms excel
พิมพ์สูตรคณิตศาสตร์ได้ ตัวอย่างงาน
ต้องใช้ imacro คัดลอกข้อมูลจาก web site ลง excel
คีย์ข้อมูลต่างๆลง Excel การคัดลอกบทความต่างๆลง word
ทำ presentation งานโดยใช้ Powerpoint สามารถแทรกงานที่เป็นข้อมูล ตารางและกราฟ จาก data ที่เป็น Excel
ฉันมีไฟล์ .exe แต่ฉันต้องการเปลี่ยนให้มันรองรับกับภาษาของฉัน เพราะว่าตอนนี้มันไม่อ่านฟร้อน ไทยมันแสดงผลเป็นสี่เหลี่ยม i have file .exe but i want change language is my language
I want translate English to Japanese 1 page within 1 hr.
...batch file created to streamline my Windows 11 installation process. Can you help us with the following project? Please create a batch file to automate Windows 11 installation, software installation, and configuration. Below is a working view of the project. I want to automate these tasks. The video already automates these tasks, but the version of Windows 11 is old and the apps are old, so I would like you to create a new version of Windows 11. Automated installation of Windows 11, automated installation of apps, automated configuration I have version 6.1.1 of this. Reference site Key Requirements: - The batch file should
I am seeking a skilled WordPress developer to upgrade my existing website. The project involves enhancing the site's design, improving functionality, and ensuring responsiveness across devices. Familiarity with the latest WordPress plugins, firebase, GTM and themes is essential. The ideal candidate should have a keen eye for deta...link to the store visit history page that shows the visitors of a specific store. 3. add graphical elements like a bar chart on the store visit history page to show the first 10 store visits per day. it should be related to the filter. 4. add a category statics page with a date filter and it should have charts like bar, pie and others. 5. detect user city and country from IP. 6. export data as Excel from the store visit history page. my website is c...
I am seeking a skilled WordPress developer to upgrade my existing website. The project involves enhancing the site's design, improving functionality, and ensuring responsiveness across devices. Familiarity with the latest WordPress plugins, firebase, GTM and themes is essential. The ideal candidate should have a keen eye for deta...link to the store visit history page that shows the visitors of a specific store. 3. add graphical elements like a bar chart on the store visit history page to show the first 10 store visits per day. it should be related to the filter. 4. add a category statics page with a date filter and it should have charts like bar, pie and others. 5. detect user city and country from IP. 6. export data as Excel from the store visit history page. my website is c...
I'm seeking a developer to create a minimalistic website where customers can upload audio files, make payments, and receive a framed QR code via post. Key Features: - Minimalistic design - Audio file upload capability - Secure payment processing (Credit/Debit Card) - QR code generation -Emailing confirmation to customers -Customers should be able to chose different sized frames, eg A3, A4, A5 Ideal Skills: - Web development (full stack) - UX/UI design (minimalistic) - Payment gateway integration - QR code generation and emailing systems setup Please note, the website should not support PayPal or Cryptocurrency. The focus is purely on Credit/Debit Card transactions.
I'm in need of an Access database designed specifically for reporting and analyzing operational financial data. The project involves creating a system that can handle data storage and retrieval while also providing general ...tailored to my operational data needs, specifically Profit and Loss Statements on a per operating unit and collective/all units basis. - Creation of user-friendly dashboards for easy data visualization. - Implementation of automated data import processes involving excel and/or cvs file uploads. Ideal candidates for this project should have: - Extensive experience with Microsoft Access database development. - Strong skills in data analysis and reporting. - Prior experience in designing dashboards and custom reports. - Knowledge of automating ...
Excel Spreadsheet Template Development I'm in need of someone who can create me an Excel Spreadsheet template that's comprehensive and easy-to-use template for managing sales quotas. I need the design to be clear, neat, and extremely user-friendly. This template will be used to track the performance of 8 customers across 2 product lines throughout the year. What I need: - Develop an Excel spreadsheet to manage sales quotas for 8 customers, each with quotas for 2 product lines (Product A and Product B). - Track year-to-date performance revenue and percentages for each customer. - Integrate monthly forecasts, qualified pipeline, and renewals for each customer. - Ensure the spreadsheet is simple to use, allowing for easy addition or removal of customers and da...
I'm seeking a professional to review and optimize the VB code in my Excel file, which has been modified over the past 20 years. The primary goal is to streamline the code for future users. The code has sections that handle macros and automation scripts. These scripts involve data import, formatting, and report generation. Ideal skills and experience for the job: - Proficient in Visual Basic for Applications (VBA) - Extensive experience with Excel - Previous experience in code optimization for performance - Excellent problem-solving skills, particularly with macros and automation scripts - Ability to simplify complex code for future understanding
I have an e...have an existing logo that I need modified and saved in various file formats. Key Tasks: - Adjust Design Elements: I need certain design elements of the logo to be modified. - Resize Elements: Some elements of the logo need to be resized. - Reposition Elements: Certain elements of the logo need to be repositioned. - Add or Remove Elements: Some design elements need to be added or removed. The final logo needs to be saved in the following formats: PNG, JPEG, and SVG. Ideal Skills and Experience: - Graphic Design: Strong background in graphic design to ensure the modifications are aesthetically pleasing. - Logo Design: Previous experience in logo design/modification is a plus. - File Conversion: Proficient in converting files into various formats witho...
I'm looking for someone to help me with a beginner GIS project. The task involves creating a two-sheet Excel workbook from data compiled in ArcGIS Pro, specifically the results of distance-based point pattern analysis. This project also includes working with both specific locations and generalized regions through distance measurements. I will provide detailed instructions as well as the necessary ArcGIS Pro files once project has been awarded. The ideal freelancer for this project should be familiar with geospatial data, distance-based point pattern analysis, and proficient in Excel. The completed project is due by 11PM EST tonight on February 7, 2025. Please note, the final Excel workbook should be in a two-sheet format. It is crucial to adhere closely to the p...
I need assistance with integrating my Excel spreadsheet with an API and webhooks to fetch customer data from external sources. I am not quite sure which API service to use, so your expertise in identifying the appropriate REST, SOAP, or GraphQL API will be crucial. Key Requirements: - Understand and implement API integration in Excel - Expertise in identifying suitable API services - Experience in working with webhooks - Proficient in Excel I am looking for someone who can automate the process of fetching this data, allowing for a seamless and efficient workflow. Your experience with manipulating Excel for data processing tasks will be a significant advantage for this project. Please provide examples of similar projects you've completed in your bid.
I need an Excel expert to build and automate a user-friendly price sheet for me. Key Requirements: - The sheet should cover various categories: electrical items, labor, markup, taxes, etc. - The price sheet should be easily exportable to PDF & CSV format. Ideal Skills: - Strong proficiency in Excel - Experience in building automated Excel sheets - Ability to create user-friendly interfaces - Understanding of pricing components (labor, markup, taxes) - PDF & CSV export experience The goal is to create a comprehensive, user-friendly, and automatable price sheet that I can use for various categories. Please only apply if you have the relevant experience.
I am in need of a seasone...and monthly reports. These reports will be derived from our job sheets, which are Word documents stored in Dropbox. Key Responsibilities: - Develop an automated system using Power Automate to generate weekly and monthly reports from our job sheets. - Ensure this system sends the reports to our management team. - Present the data in an easily digestible format using Excel. Ideal Skills: - Proficient in Power Automate and Excel. - Excellent understanding of data visualization through graphs. - Experience with interpreting and reporting on employee performance, repeat clients, and staff performance data. As for the data visualization, the type of graphs used will depend on the specific data being presented. Therefore, a flexible and analytical mind...
I'm looking for a skilled Excel developer to create a custom Excel form for me. This form should automate the generation of professionally designed, formal and professional PDF donation receipts. The Excel form will need to collect: - Donor information - Donation amount and date - Custom messages or notes The ideal freelancer for this job should have extensive experience in Excel, PDF generation, and ideally has a background or understanding of creating formal and professional documents. The final output should be a single receipt per PDF.
I need assistance in converting XLS files to CSV format, but with a specific filtering process. - Data Selection: Only certain pieces of information from the XLS files need to be included in the final CSV. - Filtering Process: Data needs to be sifted through based on conditional logic related to its type. This may involve identifying numerical ranges, specific text matches, or certain date parameters. The ideal freelancer for this project should have experience with data manipulation and conversion, particularly from XLS to CSV. Familiarity with conditional logic and data filtering is crucial. Please include relevant experience in your proposal.
...Ability to work quickly and efficiently Strong attention to detail Prior experience with electrical layouts is a plus Compensation Payment is on a per-project basis, determined by the quality and timeliness of your work. Process I will send you the project files (in AutoCAD 2024 format). You will complete the edits and measurements to the required standard. You will then send back the updated file for review. If you meet these requirements and are interested in ongoing work, please reach out with your relevant experience and examples of previous projects....
TENGO UN EXCEL MACRO PARA LA EXPEDICION DE CERTIFICADOS LABORALES LLENOS DE FORMULAS, SIN EMBARGO AL PERDER MI PC SE ME PERDIÓ EL ARCHIVO ORIGINAL Y SE ME DAÑÓ MI ARCHIVO MACRO, PUEDO SEGUIR TRABAJANDO PERO YA NO ES COMODO. QUISIERA QUE ME VUELVAN A HACER MI EXCEL.
I'm looking for a skilled Power BI expert who can automate the sending of my Power BI reports via Gmail on a daily basis. The reports should include data from my ticketing tools in CSV format. Key aspects of the project: - Automate daily Power BI report emails - Use of Gmail for report distribution - Inclusion of ticketing tools data in CSV format Ideal Skills and Experience: - Proficiency in Power BI - Experience with email automation - Knowledge of handling and reporting ticketing tools data If you're interested in this project, please don't hesitate to reach out.
I'm looking for a Power Automate expert to create a workflow that monitors a SharePoint folder for a .csv file. The workflow should open the file, filter it based on text variables in 2 column, and create a new file for each filtered variable save back to SharePoint, attach to an email, and send to email addresses linked to each filtered variable Alternatively, it can paste the results from each filtered variable into the body of an email to and send to email addresses linked to each filtered variable . If possible, only selected columns of the original .csv file needs to be included in the output. Key Requirements: - Proficient in Power Automate - Experience with SharePoint and .csv files - Ability to create automated workflows...
I'm looking for a data analyst experienced with Kibana to sift through my data logs and identify any potential threats of unauthorized access. Key Focus Areas: - Analyzing login attempts and file access records for suspicious patterns. - Identifying and flagging any potentially malicious logs. Time Frame: - The analysis will cover the period between 24th August and 26th August, and on the 4th of September, 2024. Ideal Skills: - Proficient in using Kibana for data log analysis. - Experience with cybersecurity and threat detection. - Ability to identify and interpret patterns indicative of unauthorized access.
AI Cartoonization Expert – Trainer & Consultant We are looking for an AI Expert in Character Cartoonization to **teach and guide** us on professionally converting real-life images into **2D, Pixar, Disney-style, or 3D cartoon characters** using AI tools. ### **Responsibilities:** - Demonstrate how to **convert real human images into high-quality cartoon characters** using AI. - Provide **step-by-step training** on advanced AI cartoonization techniques. - Recommend and teach the use of **professional AI tools** for the best results. - Ensure the output is **highly professional and artistic**, not just basic AI filters. - Share tips on enhancing AI-generated images for a **polished, detailed, and lifelike** appearance. ### **Requirements:** - Expert...
I need a data entry form with over 100 fields. The form will be used for inputting mixed data (text and numbers). The entered data should be able to be synced into 10+ sheets with the push of a button. Requirements: - Design a data entry form with 100+ fields - Mixed data input (text and numbers) - Data synchronisation into 10+ sheets manually with a button Key Skills: - Proficient in Microsoft Excel or Libreoffice Calc - Experience in creating complex data entry forms - Knowledge in setting up data synchronisation - Familiarity with data validation rules Some fields in the form will need validation, so experience with setting up data validation rules is essential. Please reach out if you have the relevant skills and experience.
I'm looking for a freelancer who can help me with a data entry project. The task involves taking mixed data from a spreadsheet and entering it into a specific website. Details: - The data is organized in the spreadsheet as single rows with different fields. - The data types include both text and numerical data. - If an error occurs while submitting a row, the process should skip the erroneous row and log the error for review. Ideal skills for this job include: - Experience with data entry. - Proficiency in using websites for data input. - Ability to troubleshoot minor issues. - Familiarity with logging errors. Please note that the project requires careful attention to detail, as accuracy is critical in data entry tasks.
Estamos buscando un Asistente de Ingreso de Datos detallis...verificar datos en hojas de cálculo o sistemas internos. Organizar y clasificar información de manera precisa. Revisar documentos para corregir errores o inconsistencias. Mantener la confidencialidad y seguridad de los datos. Cumplir con plazos y objetivos establecidos. Requisitos: Experiencia en ingreso de datos o trabajos administrativos (deseable, pero no obligatoria). Manejo básico o intermedio de Excel, Google Sheets y otras herramientas de oficina. Atención al detalle y habilidades organizativas. Capacidad para seguir instrucciones y trabajar de forma autónoma. Si estás interesado/a, envía tu solicitud junto con una breve presentación sobre tu experiencia y dis...
...encouraging and supportive work environment? We are looking for a trustworthy and reliable EA/PA for a philanthropist / filmmaker with an interest in wildlife. The tasks will involve working on ad-hoc projects with the charities, film shoots and assistance with personal matters. The role is not just about organisation - it’s about a long-term partnership. If you have excellent communication skills, excel with logistics, have an analytical mindset and enjoy making this happen, the role is for you. Please note that the role is remote-based and the client is primarily based in Europe. Main tasks Carrying out various personal assignments of the manager related to business: real estate search, insurance, service provider companies; Search for contractors for assigned t...
