Import text file excel file vbscriptงาน
Coding vba ให้คำนวนและรายงานผลลงในแถบ status bar ที่มุมจอ โค้ดทำงานได้กับทุกชีทในไฟล์ รายงานผลคล้ายค่า sum, average ที่โปรแกรมมีมาให้เดิม ทศนิยมสองตำแหน่ง เลือกเซลล์จากชีทไหนก็ได้ (เซลล์1จากชีทa เซลล์2จากชีท(n) 1. รายงานผลหาร เซลล์1/เซลล์2 2. รายงานผลลบ เซลล์1-เซลล์2 3. รายงานผลเปอร์เซ็นต์ เซลล์2/เซลล์1*100
...สามารถ 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
ฉันมีไฟล์ .exe แต่ฉันต้องการเปลี่ยนให้มันรองรับกับภาษาของฉัน เพราะว่าตอนนี้มันไม่อ่านฟร้อน ไทยมันแสดงผลเป็นสี่เหลี่ยม i have file .exe but i want change language is my language
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 review, Dont expect more I am not big fish...
I'm looking for a professional who can make a .jar file in Java 17 for me. It is intended to be a software product which I want to package and distribute. Here are the specifics: - Purpose: The main goal of this project is to create a .jar file that is user-friendly and easy to use for anyone who downloads it. - Platform: The .jar file should be compatible specifically with Windows operating systems. It should be tested and guaranteed to run smoothly on those systems. You should have: - Proficient in Java 17 and Eclipse. - Prior experience in creating .jar files for software products. - A good understanding of user experience and interface design to ensure the .jar file's usability. I'm open to suggestions on how to improve this project. Your creativ...
******* LOCATION ******* You must live in Eastern Europe or Latin America. ******* OVERVIEW ******* I will conduct searches on Google like "Plumbers Minneapolis, Minnesota" or "Carpenters Charlotte, North Carolina." Then I will run the script(s) you created for me. The script(s) you create will save the Google search results in a .csv file. That is trivial and straightforward. The script(s) will also open the websites associated with the search results. That is also trivial and straightforward. The main challenge lies in locating and filling out contact forms on these websites with my first name, last name, email address, phone number, etc. Most search results will include a link to the company’s website. For example, when I search on Google for&helli...
...group chat client for me. The client will primarily be text-based, allowing group communication between multiple users. Key Features: - Group Chats: The primary function of this chat client is to facilitate group chats. Therefore, it should support multiple users in a single conversation thread. - User Mentions: I'm also looking for the implementation of user mentions, which will enable users to tag others in a message, signaling their attention. Additional Features: - File Sharing: The ability to share files within the chat would be a very useful feature. - Chat Moderation Tools: I'd like the chat to have basic moderation tools to oversee the group chats and manage user interactions. Ideal Skills and Experience: - Proficiency in text-based chat clien...
Need the work to start right away with fast turnaround. Convert a pdf to a google doc so the text can be editable.
if you can do the work on this moment you can do it i need the file like in within 20 min. it is a eps file it seems it is unsharp. file format is correct but it looks unsharp who can fix it. these are dthe guideline of the file needed:
...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 Length: Short-term, estimated completion within one week. ( MAX 80 AUD as a test round, if the work is good, Larger jobs will come) Application Instructions: Please message me with the keyword "VSL" at the beginning of your application to confirm that you have fully read and understood the job desc...
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.
...Maintains primary responsibility for grant schedules and tracking grants; * Serves as a liaison to all funding agencies and organizations; * Works with appropriate personnel to research, develop, write and submit letters of inquiry, concept papers and grant proposals; * Coordinates and follows-up on the progress of submitted proposals; Institutional Effectiveness; • Develops and maintains a master file on pending grants and contracts; • Remains up-to-date on current issues relative to grant proposals; • Inform business owner on the progress of all grants and issues that may arise with each grant. • Maintains confidentiality of information exposed to in the course of business Minimum Education, Skills and Abilities; * proven successful track record in the la...
I'm seeking a professional 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 repre...
For this project, I am in need of a text-based logo that's designed in a minimalist style with a monochrome color scheme. Key Requirements: - Text-based design: I'm looking for a logo that primarily features the name of my brand or company. - Minimalist style: The logo should be simple, clean, and incorporate minimal design elements. - Monochrome color scheme: The logo should be designed in a single color, specifically in a monochromatic palette. Ideal Skills and Experience: - Proven experience in logo design: A strong portfolio of text-based logos is highly preferred. - Proficiency in minimalist design: Prior experience in creating visually appealing minimalist designs is a plus. - Understanding of monochrome color schemes: A solid grasp of working within...
...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. * An understanding of URL p...
how to decode : All report content comes from the json data we provide, I explain the logic details in report logic.pdf., please check its content. I also attached a json data and a tire report , they come from one scan, you check its content to verify the report logic. we have to make similar script to generate report from our system
Project Budget: $100 Project Deadline: 1-2 Days Project Type: Custom WordPress Plugin Project Difficulty: Standard PHP Version: 8.2 and above Project Overview: Custom WordPress plugin required to allow a user to: -...Project Type: Custom WordPress Plugin Project Difficulty: Standard PHP Version: 8.2 and above Project Overview: Custom WordPress plugin required to allow a user to: - Upload a CSV with bulk new POST data - Select a post category, schedule start date, choose how many posts to PUBLISH each a day - Import post data and create all new posts as DRAFTS, to go live on the specified post schedule & keep a suitable log that can be checked - Insert the new POST IDs back into the original CSV file & automatically download the update CSV for a user 5* FEED...
Dough one Sources is looking candidates for Senior Business 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 ...
I'm in immediate need of a cloud-based stock management software with barcode generation, scanning, stock quantity tracking, and weight measurement functions. The system should enable me to: - Generate and scan barcodes...- 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 stock management ...
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 has a clean, professional appearance.
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.
I need a skyvia expert for an integration project. Source: HubSpot Target: HubSpot Objects to migrate: Contacts, Companies with it's relations Use the import package from skyvia. Please tell me if you have done HubSpot migrations with skyvia before. If not, don't apply to this project.
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-friendly interfac...
Hi Global Text Solutions, I noticed your profile and would like to offer you my project. We can discuss any details over chat.
Hello and Thank you for being here Trying to make this reference work Fails ("~/.ssh/mycreds") Works ("/home/username/mycreds") How can I make the logical reference work ~ Can you help me please ? Will give a 5 Star Review when this is done and will write such inspiring words for you, when done. Please understand; there is hope you can give your “best” price; been unemployed, and have cancer with bills backing up, $10 possible? Please note $10 is the max total that I can handle for this (doing hourly reduces % fee). Will leave a Glowing paragraph of feedback 5 stars : - ) My funds are low but will pay quick and leave 5 stars. Please give your best possible for your bid ? (something reasonable?) Please note there is hope we can mutually compl...
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 looking for an expert to help me set up an Amazon FBA business focusing on Home and Kitchen products. Key Responsibilities: - Registering as a seller on Amazon: I haven't done this yet, so I need assistance with the initial steps. - Product Sourcing: I need help with finding reliable suppliers for Home and Kitchen products. - Setting up the Amazon FBA store: ...Amazon platform and its requirements for sellers. - Strong sourcing skills and a network of reliable suppliers in the Home and Kitchen product niche. - Experience with store setup and optimization on Amazon. Looking for a professional who can guide me through the entire process and help me kickstart this business successfully. I have ready: My supplier from China. The 20 products I’m going to import....
I'm in need of an expert who can help in developing a relational database using SQL and Python. The project will pri...revolve around database management. Consequently, I would appreciate assistance in the following tasks: - Designing a new relational database, ensuring it's optimized for efficiency and performance. - Implementing data import and export capabilities for seamless data movement. - Developing queries to support the database's functionality and ease of use. The ideal candidate for this project should have a strong background in both SQL and Python, with a specific focus on database development. Experience with optimizing databases for performance and some knowledge of data import/export mechanisms would be advantageous. Moreover, an understanding...
I'm in need of an expert who can fix my corrupted .FIC file in my HFSQL database. Key Project Requirements: - The file is currently not opening and is producing errors, so the main goal is to restore it to its original state and ensure it can be opened without any issues. Please note that I can provide the corrupted .FIC file for analysis. Ideal Skills and Experience: - Proficient in HFSQL database management. - Proven track record in repairing and recovering corrupted database files. - Strong problem-solving skills to identify and rectify the issues within the file. If you're confident in your ability to handle this task efficiently, please provide details of your relevant experience and how you plan to approach this project in your bid.
Project Overview: I am seeking 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...
I'm on the lookout for a professional well-versed in text data entry. The ideal candidate needs to: - Be proficient in entering text data accurately - Ensure data integrity and meet strict deadlines - Manage a sizable workload—around 100 to 500 pages Previous experience with large volume text data entry would be an asset. Efficiency and attention to detail are must-have skills for this job.