Vba script import txt excelงาน
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...
ฉันต้องการซื้อ Travian Script 5 หรือ 4.4 ปราศจากช่องว่างและปัญหา รองรับมากกว่าหนึ่งภาษา ตัวอย่าง
ทำ 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)
ต้องการสคริป Jquery Script สำหรับโฆษณาวีดีโอ ก่อนโหลดตัวเล่น Iframe จาก data-href button - ตอนกดโหลด Player จะมีโฆษณามาแสดงทุกครั้ง ก่อนที่จะดึงตัวเล่นมากจาก data-href <div class="player_ep"> <div style="text-align: center"> <button type="button" data-href="" data-resolution="fast_p2p" class="btn btn-primary play-ep">Player 1</button> <button type="button" data-href="" data-resolution="google_photos" class="btn btn-default play-ep">Player 2</button> </div> </div> โดยรูปแบบ ดึงโฆษณาวีดีโอมาแสดง จะดึงจาก รูปแบบคล้ายๆ แบบนี้ครับ หรือออกแบบมาให้ก็ได้ครับผม <script> an...
หาข้อมูล 16 อย่างของ Blogger จาก 50 fanpage แล้วกรอกลงให้ excel ที่กำหนดให้
พิมพ์สูตรคณิตศาสตร์ได้ ตัวอย่างงาน
...Agile ตัวจริง - อยากทำงานกับ guru ตัวจริงในการทำ automated test และ TDD - อยากเรียนรู้ technology ใหม่ๆ ที่ full stack developers ต้องทำได้ - อยากทำงานแบบ work from home ไม่ต้องมาเครียดกับรถติดและเวลาเข้างาน - มี passion ในการช่วยพัฒนาสังคมด้วยเทคโนโลยี - ใช้ชีวิตอยู่ได้ด้วยเงินไม่เกิน 50,000 บาท ต่อเดือน - มี skill เหล่านี้ : AngularJS 1.5.X, Bootstrap 3.x, Responsive design, Jquery 1.11.x, Java Script/DOM, Rest web service / JSON / HTTP Request, Git (Optional : Less or Sass css, Webstrom) ถ้าทั้งหมดคือตัวตนของคุณ [Removed for encouraging offsite communication which is against our Terms and Conditions.] PromptCoach () คือ startup สาย Edutec ที่มีปณิธานแน่วแน่ในการช่วยพัฒนาคนในสังคมให้มีคุณภาพมากขึ้นผ่านเทคโนโลยี เราต้องการเป็นศูนย์รวม โค้ช และ คอร์สอบรม ที่ใหญ่ที่สุดในโลก
ต้องใช้ imacro คัดลอกข้อมูลจาก web site ลง excel
คีย์ข้อมูลต่างๆลง Excel การคัดลอกบทความต่างๆลง word
ทำ presentation งานโดยใช้ Powerpoint สามารถแทรกงานที่เป็นข้อมูล ตารางและกราฟ จาก data ที่เป็น Excel
looking for voice talent for a 2-minute tutorial video. Script is in Thai. must sound young and energetic. please use the lines below to send sample เดบิตออนไลน์ช่วยให้คุณสามารถทำการโอนเงินเรียลไทม์ง่ายจากบัญชีธนาคารออนไลน์ขของคุณเข้ามายังบัญชีโบด็อกอย่างไรก็ตามหากคุณออนมือถือหรือที่บ้านทางคอมพิวเตอร์มันเป็นวิธีที่เร็วที่สุดสำหรับการโอนเข้าบัญชีโบด็อกของคุณ Thanks!
I have a medium complexity Pine Script that I'm currently using for backtesting on TradingView. I would like to convert this script into Python so that I can run backtests on my local machine. This Python script should produce the same results as the Pine script on TradingView, but handle different data resolutions (1hr to 1Day data). Key Requirements: - Convert a Pine Script into Python. - Ensure the output of the Python script matches the results produced by the Pine Script on TradingView. - The Python script should be able to handle different data resolutions from 1hr to 1Day. Ideal Skills and Experience: - Prior experience in backtesting trading strategies in Python - Proficiency in Pine Script and familiarity with T...
I am in need of a skilled professional who can assis...system to enable the creation of goods and service invoices in USD. - Implement moderate customization to the invoice templates, focusing on layout changes and adding custom fields. - Import all of my product information from an Excel sheet. This includes product names and their respective cost prices (which are in INR). - Enable and Teach me to Use Odd's OCR feature to fetch pdf data from invoice to transfer it to software Ideal Candidate: - Proficient in working with Odoo Books and setting up invoicing processes. - Experience with customizing invoice templates within Odoo. - Skilled in data import from Excel sheets to Odoo. I look forward to working with a professional who can deliver these requi...
A project is to find a better script or an idea to overcome ozforensics. Facial LivenessDetection Biometric verification without the presence of the person concerned
I need a skilled video creator to produce one mixed media promotional videos for my learning platform. The ideal candidate will be able to handle both animated and live-action elements seamlessly, including script writing. Actually what I wanted is to show a real person using my platform https://ooro.com.au. Platform is designed so anyone with a skill or talent can register as a mentor. This includes actual teachers. And then if someone wants help with something they are learning, they can search for a mentor, who will use video call on the platform to engage with them. So I would prefer if we show actual people in the video. The animation part could be limited to to the signing up to the platform. As an example, trying to imagine a video where people are getting assistance fro...
I'm looking for an Indian Python developer to create a script that can retrieve specific data from Telegram. Key Points: - The script should be able to fetch phone numbers and migration of users from Telegram. The ideal candidate should: - Have a strong background in Python development - Be familiar with working with API's - Have experience in web scraping - Have a good understanding of data privacy and security - Be able to deliver the project on a monthly basis. Looking forward to hearing from Python developers with relevant experience.
I’m in need of an experienced Excel software engineer who specializes in automation. The project revolves around automating data entry tasks in Excel. We are an accounting firm and I am looking to automate my compliance practices. Tasks include 1) rolling forward previous year excel work papers 2) taking information from. Client data sheets (excel) and importing into new excel workpaper workbook 3) data analytics based on metrics 4) hyperlink to source data Ideal candidates should have: - Proven experience with Excel macro programming and automation - Ability to work with numeric and legal data - Strong attention to detail to ensure data accuracy This will be a valuable addition to our workflow. Looking forward to your proposals.
I am in need of a PrestaShop expert to assist with the specific task of importing products via cvs into my PrestaShop store. The ideal freelancer for this project should: - Have proven experience in working with PrestaShop - Be highly proficient in importing products via cvs into PrestaShop - Be well-versed with the complexities of ecommerce product data The product data that needs to be imported is relatively simple, including basic details like product name, price, and category. In your application, please include your experience working with PrestaShop and specifically with product imports. Your experience in managing product data in e-commerce platforms will be a significant advantage.
I have a Node.js script that I've been using to sort and verify emails. However, there are some issues that I need to be fixed. I'm looking for a professional who can assist me in enhancing the script. Requirements: - The script should be able to validate the existence of email mailboxes without freezing when processing a large volume of emails. - Email verification must be accurate and reliable, and the script should be able to handle a large list of emails efficiently. Key points for the project include: - Implementing a more efficient algorithm to handle large email lists without freezing. - Ensuring that the script provides accurate validation of email mailbox existence. Ideal Skills: - Strong proficiency in Node.js and email verificatio...
...need an Excel expert to create a comprehensive spreadsheet to track and calculate project costs, revenues, expenses, and profits. Specific calculations required include sum, average, percentage. The Excel sheet should track the following: - Project cost - Project revenue - Project expenses - Percentage of account receivable - Percentage of account paid - How the client paid after tax - Description for the costs - Percentage of the costs - Percentage of the profit before tax - Percentage of account receivable before tax - Date of payment The data presentation in the spreadsheet should be in the form of tables and graphs. Experience with financial data analysis and management is vital. Understanding of cost and profit calculations, as well as capability to implement adv...
I have an existing Excel macro that is predominantly used for handling formatting tasks within the Excel file. However, I need an expert who can assess and modify it to ensure compatibility with Excel for Mac 2019 or later. Key Requirements: - The existing macro primarily deals with formatting tasks within the Excel file. - The data in the Excel file is stored in both text and numerical formats. - The main change required is to update the formulas in the macro to ensure it functions smoothly on Excel for Mac 2019 or later. The ideal freelancer for this job would have prior experience with: - Excel macros and VBA - Formatting tasks in Excel - Updating or creating cross-platform Excel macros This project requires a me...
I am in search of a skilled 2D animation professional. You will be creating a 2D-style video for the primary aim of promoting my brand. The target audience for this video is primarily adults. Key Responsibilities: - Develop a visually appealing and engaging cartoon-style 2D animation video - Clearly convey the brand's message and values - Ensure that the video is suitable for an adult audience Ideal Skills and Experience: - Extensive experience in creating 2D animations, particularly in a cartoon style - Proven track record of developing successful brand promotion videos - Excellent understanding of adult audience preferences and sensibilities - Strong communication skills to understand and translate my brand's core values into animation Your engaging and professional animatio...
I have a Pine Editor script that I believe is in a good place, but I'm hitting some error messages that I can't seem to fix. I need someone who knows their way around Pine Script and TradingView to help me get this script running smoothly. Key Requirements: - Troubleshoot and debug script errors: The main issue I'm facing is error messages when I try to run the script. I need someone to go through the script, identify the root cause of these errors, and help me fix them. - Pine Script proficiency: The ideal freelancer for this project should have a good handle on Pine Script, as it's essential for understanding and improving the script. - TradingView experience: Since the script is set to work within...
...file with over 50 pages of data in mixed formats - text, numbers, and tables. The task is to accurately transfer this data into an Excel spreadsheet in a tabular format. Key requirements: - Data entry from a PDF file into an Excel spreadsheet - The data is of moderate complexity, so a good understanding of Excel is needed - The output should be a well-organized and clean Excel spreadsheet Ideal skills for this job: - Proficiency in data entry and working with large data sets - Advanced Excel skills, including the ability to work with mixed data formats - Attention to detail and accuracy to ensure the data is correctly captured - Experience with PDF to Excel data conversions would be a plus Please note that while the task is to transfer data,...
i got my code pine script i need some when to add messge to the code and ill link it to webhook to send the signals Json signals fit to Cornix bot i need it asap in hours thanks
I've been working on a Python script that I'd like to make accessible online through a web interface. This would involve uploading the script to a suitable web server and setting up a simple user interface. Key Requirements: - Deploy my Python script onto a web server, optimization for best performance. - Implement a basic but intuitive UI for the script. - Ensure it can be accessed by anyone without requiring user authentication. Ideal freelancer for this project should have: - Strong experience in deploying Python scripts to web servers. - Proficient in creating user-friendly web interfaces. - Familiarity with various web servers, especially as I'm undecided on a specific one. If you have experience in deploying Python scripts online and can...
--- ### Job Title: Excel Sheet Creation for Job Tracking and Payment Calculation **Description:** I need a custom Excel sheet to help me track jobs completed by my installers, including details about each job, such as dates, customer information, and payments. The sheet should be able to automatically calculate the total number of jobs done and the total payment owed to each installer. **Requirements:** 1. **Job Tracking:** - Columns for the date each job was completed. - Columns for the job details including customer address and account number. - Columns for the installer assigned to the job. 2. **Payment Calculation:** - Ability to input the payment rate per job. - Automatic calculation of the total number of jobs completed by each installer. - Automat...
Just a quick bit of help needed in excel macro writing. See attached before and after showing a piece of the original data. and what i neeed the macro to achieve. WHAT IM ASKING If two adjacent cells in column b are equal, then add cells adjacent column c cells, put the result in the first column c cell and remove the duplicate row. AEE ATTACHED png. I need a tailored solution for a data manipulation task within Excel. Specifically, I am looking for an Excel macro that can accurately merge cells based on their adjacency. Essential skills and experience should include: - Expert knowledge of Excel and its macro functionality - Prior experience with data manipulation tasks such as merging cells - Understanding the rules or criteria for merging specificall...
I am looking for an expert who can as...expert who can assess and modify an existing Excel macro for compatibility with Excel for Mac 2019 or later. The current macro mainly handles formatting tasks within the Excel file. Key Requirements: - Assess the current macro's compatibility with macOS - Modify the macro to ensure compatibility with Excel for Mac 2019 or later I don't have a strict deadline for this project, so you can work on it at your own pace. However, I am looking for someone who can get this done efficiently and effectively. Feel free to ask any questions for more information. Ideal Skills and Experience: - Proficient in Excel VBA and macros. - Extensive experience in adapting macros for cross-platform compatibility. - Kno...
Hello, This is a $20 project. Looking for a freelancer to develop a python script to retrieve restaurant data from Google Maps using the Maps/Places API. The script should target restaurants that have a phone number and *do not* have a website. The inputs I need to enter are: - Location (latitude and longitude) - Search Radius (in meters) - Ensure the business/place is a restaurant, bakery, etc. Key Data to Retrieve, output in a .CSV: - Business Name - Address - Phone Number - Google Maps URL Thank you, trooper501
I'm in need of a skilled professional to help me create a data mining script. The task involves mining emails, data from a certain website and delivering the data in a raw text file format. Key Requirements: - Develop a data miner script that can effectively scrape email data from websites. - Ensure the script can handle multiple sources and is scalable for future needs. - Deliver the mined data in a raw text file format. Ideal Skills: - Proficiency in web scraping and data mining techniques. - Experience with developing scripts for text data mining. - Strong knowledge of scripting languages suitable for scraping like Python/BeautifulSoup, R, etc. Please provide samples of your previous similar projects or portfolio that demonstrate your ability in this area.
I'm looking for a skilled video editor who can help me create engaging review and how-to videos for products. Key Responsibilities: - Editing TikTok videos to be between 15 to 60 seconds long - Incorporating English voice-over. I will provide sample videos for you to use in the video. You can use snippets of the sample videos and cut them in small snippets for the final video. ...looking for a skilled video editor who can help me create engaging review and how-to videos for products. Key Responsibilities: - Editing TikTok videos to be between 15 to 60 seconds long - Incorporating English voice-over. I will provide sample videos for you to use in the video. You can use snippets of the sample videos and cut them in small snippets for the final video. I will provide the scri...
...AI assistant with a focus on language understanding and real-time conversation support. Key Features: - Cross-Platform: The app should be developed for both iOS and Android, ensuring a wide user base. - Page Translation: Users should be able to translate live any page on their phone. - AI Assistant: The AI assistant should have the ability to provide information on various topics and should excel in language understanding, helping users with translation in real-time conversations with others. - Live Translation: The app should provide a smooth live translation experience for conversations. Ideal Skills: - Proficiency in React Native for cross-platform development. - Experience in building apps with live translation capabilities. - Strong background in AI development, specifi...
I'm in need of a skilled OpenCV programmer to help me with a bug in my WhatsApp automation script. Here's what you need to know: - The specific issue is that the automation isn't starting as expected. - The script is written in Node.js. - I haven't been able to locate any error messages or logs that might be related to the issue. You should ideally have experience with: - WhatsApp automation - Node.js - OpenCV Your task will be to identify the root cause of the automation failing to start and rectify it.
I have a YOLO v5 detection Python script, and I'm looking to turn it into an API-based web program with FastAPI. The API must support user inputs for 4 Twilio contact numbers and 4 RTSP addresses, and it should display the four video streams in a grid on a single page. Key requirements: - Convert the existing YOLO v5 detection Python script into a FastAPI-based web program. - Implement user input functionality for 4 Twilio contact numbers and 4 RTSP addresses. - Display the video streams in a grid layout on a single webpage. Ideal skills and experience: - Proficiency in Python and experience with YOLO v5 detection. - Strong knowledge of FastAPI for building web APIs. - Previous experience integrating Twilio for messaging. - Familiarity with displaying multiple video st...
I'm looking for an experienced and creative video creator who can generate an explainer video to introduce my company/brand. Key responsibilities: - Develop an original, compelling script from scratch. - Deliver an engaging video that effectively communicates our brand message. Ideal Skills: - Strong scripting and storytelling skills. - Experience in creating explainer videos. - Proficient in using video editing software. - Keen eye for details and creativity. - Understanding of branding principles. The ultimate goal of the video is to provide viewers a clear, appealing introduction to our brand. Looking forward to excellent pitches from skilled professionals.
