Excel vba create folder and save fileงาน
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 ที่กำหนดให้
กรอกข้อมูลในสเปรดชีต 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 am seeking a proficient freelancer with expertise in automating data entry tasks particularly re...tasks particularly related to spreadsheet entries. Specifically, the task involves automating the process of entering client details into Excel spreadsheets. The chosen professional should be well-versed with automation tools suitable for this task and have a keen eye for detail to ensure accurate entries. Ideal Skills and Experience: - Proficiency in Excel and data management tools - Previous experience in data automation projects - Detail-oriented and accurate in data handling - Familiarity with client details entry is a plus. Your responsibility will be to ensure that the automation process is seamless with minimal room for errors. Accuracy ...
...skilled Python programmer to help me automate the order placement on Interactive Brokers. Key Requirements: - Automate the placement of Market orders, Limit orders, and Stop orders - Strong proficiency in Python - Experience with Interactive Brokers platform - Knowledge about different types of trading orders Ideal Skills: - Python programming - Trading experience - Interactive Brokers expertise - Order placement automation I am looking to hire a pythan trading expert, You need to automate trade in Shoonya Broker Account, Automate the buy sell order, It has lots requirment I have attached excel file to fetch and update data, and automate trade, I can choose any interval, It need to fech candle data, more detaiil i wll give if you can provide re...
I'm seeking a skilled professional to create a CNC file for my logo. The file will be used with a plastic CNC machine, specifically working with HDPE 2 ply material. The logo design needs to incorporate intricate patterns. Ideal Skills and Experience: - Proficiency in CNC file creation - Experience working with plastic CNC machines - Understanding of HDPE 2 ply material - Ability to design intricate patterns - Prior experience with logo design
...sourcing and antenna design and construction and signal analysis and detection. I need you to design the SDR system I need and Provide the list of inexpensive equipment, instructions to assemble the handheld unit, and I need you to build the software I need. Please send me samples of your SDR projects that are close to what I need. I want to be able to detect distance, strength, direction, interference, etc... including elevation, and to be able to 3D graphic map everything. I would like to analyze 1Hz to 300GHz I know this is a wide spectrum, can you design an all in one small handheld that is inexpensive and that can see all these frequencies? The device needs to be handheld portable that is inexpensive and easy to asse...
...presented on a separate page, enhancing user focus and engagement. - Users should navigate through the questionnaire using both 'Next' and 'Previous' buttons, allowing for flexible pacing. Ideal Skills: - Experience with questionnaire design and user interface (UI) principles - Proficiency in relevant software/tools - Ability to deliver a seamless and interactive user experience. Description of the Excel Attachment: - The text in BLACK are the questions - The text in RED are the possible answers on that particular page - The text in GREEN is a bar that shows the percentage of the questionnaire that is complete. It should be a green bar. - NOTHING ELSE on the outline should appear on any of the pages. That is to help explain the ...
I'm looking for a quick Python script that can help me automate the reading and databasing of LAS file format headers using the LASIO library. The product tables should be exported in csv format. - Read a library of LAS files - Ingest and export CSV files The task is straightforward: there's no need for specific processing or data transformations on the files before exporting to CSV. The ideal freelancer for this job should have: - Proficiency in Python, particularly in file handling and CSV manipulation - Experience with automating tasks using Python scripts - Ability to deliver a simple and effective script in a short timeframe.
I'm looking for a skilled CAD designer who can convert my 2D JPEG/PNG drawings into high-detail STL files fo...model of a locomotive headlight. Ideal Skills: - Proficient in CAD software - Experienced in creating STL files for 3D printing - Detail-oriented and able to replicate intricate designs - Familiar with converting 2D drawings into 3D models Requirements: - Use the provided JPEG/PNG drawings to create high-detail STL files - Ensure the files are suitable for 3D printing - Deliver the completed files in a timely manner I already have the 2D drawings, and they are available in JPEG/PNG format. I require high-detail STL files that accurately represent the intricacies of the locomotive headlight. The ideal freelancer will have a keen eye for detail and...
I need a professional Excel macro specialist to help automate the generation of maintenance reports. Key Requirements: - The macro will need to compile and format data into tables and lists for the reports. - The ideal candidate should be proficient in writing Excel macros and have experience with report generation. - Attention to detail is crucial to ensure the reports are accurate and well-structured. If you can help me streamline this process, please get in touch.
I need an expert in Libre Office to assist in transferring files to PDF. Key Requirements: - Transfer of text documents from Libre Office to PDF - Dividing the master document into three separate files Ideal Skills: - Expertise in Libre Office - Proficient in creating and formatting PDFs - Attention to detail to ensure contents are accurately divided
...developer/designer to create a visually appealing roulette-style spinning wheel for a TikTok giveaway campaign. The idea is to integrate this roulette with the CommentPicker API so that I can automatically pull the list of users who have commented on my TikTok video, and the roulette will randomly select a winner from the comments. Key Requirements: 1. Integration with CommentPicker API: - The roulette must work with the CommentPicker API to automatically retrieve comments from a TikTok video (I will provide the API details and credentials). - The system should retrieve all comments on my video (including the usernames) and show them on the roulette, so the winner can be chosen randomly. 2. Visually Appealing Design: - The design should be modern an...
...enable phone call logging and voice recording. Ensure the CRM can manage incoming and outgoing calls, save call history, and allow tracking of communication with customers. Enable the ability to transfer numbers seamlessly and track outreach efforts efficiently. Google Calendar Integration: Sync jobs and tasks with Google Calendar to streamline team scheduling. Allow shared calendar access for real-time updates on job assignments, deadlines, and team availability. Invoice and Billing System: Implement a module for generating, tracking, and sending invoices directly from SuiteCRM. Ensure the system integrates with your accounting software (e.g., QuickBooks) for a smooth billing workflow. Estimation Automation with QuickBook...
I need to enhance my spreadsheets with dropdowns and automations. Specifics: - Implement predefined list of options dropdowns in 3 spreadsheets. - Create macros to handle data formatting tasks that are currently repetitive. Ideal candidate should have: - Proficiency in Excel or Google Sheets, including experience with dropdowns and macros. - Understanding of data formatting processes. - Ability to complete the job within 0.5 to 1 day's work.
I have two sets of images that need to be cropped then mapped to a grid in Sketchup. Textures need to be applied to faces as materials. Do not import and place images directly to model. There are 26 images in each set. (8192x3775 pixels uncropped) Each image is to be cropped to remove the grey box then save as jpg, 70% quality. Map each tile to the grid while making sure the resulting map does not show seams where tiles of different level of detail meet (between 0 and 1 series and between 1 and 2 series). Name material in Sketchup to match the image name (00 for example). Make each texture projected. Save as sketchup file. I am providing following inputs: Two sets of 26 images Template tile layout You are to produce: Two Sketchup files as...
Points to Work On: Considering that the website’s color palette must be respected, and ensuring that, despite the complexity, the information remains simple and clear for the user. Currently, my website operates with two different filters or search engines: H-Book and WP-Booking, which means the client has to perform two searches. This greatly affects usability, and it also creates difficulties for me to manage two calendars and many plugins. Therefore, I’d like to simplify it with just one search engine. --- 1. CHECK IF EVERYTHING CAN BE DONE WITH H-BOOK Unify and optimize the search filter: Remove the current search filter from WP-Booking, which only shows available houses. Keep and improve the H-Book filter, configuring...
I need someone based in a foreign country with a good English accent to create video testimonials for my digital product. The purpose of these testimonials is to provide service feedback. The format should be a 'talking head' video, where you speak directly to the camera. Ideal skills and experience for the job include: - Fluency in English with a strong accent (preferably British, American, or Australian) - Experience in creating video content - Ability to provide honest and constructive service feedback - Comfort speaking on camera
I'm seeking an Excel professional to assist with organizing and sorting data, as well as designing layouts and templates for a spreadsheet that will be used for uploading emails to a platform. Key Responsibilities: - Organize and sort data efficiently - Design user-friendly layouts and templates Ideal Skills: - Proficiency in Excel, particularly in spreadsheet management - Experience with data organization - Ability to create intuitive layouts and templates
I have a completed 18-pa...that needs to be brought to life with illustrations and professional layout. The book is filled with recurring characters and varied elements that need to be depicted on each page. Key Responsibilities: - Create bright, vibrant, and engaging cartoon-style illustrations for each page 3D - Design and layout the book in an editable PDF format - Ensure consistent portrayal of recurring characters and varied elements No AI images as I will need the copyright Ideal Skills and Experience: - Proficient in illustration and design software - Experience in creating children's book illustrations - Strong understanding of character continuity and visual storytelling - Able to work within a specified color...
I'm starting a service-based startup in the maintenance sector and need assistance filling out a startup business plan form provided by a financial institution. The form is in an Excel file and primarily requires future income and expense calculations to be filled. - You will need to analyse provided rough figures and fill in the form accordingly. - Previous financial statements or historical data. - A quick turnaround is essential. Ideal candidates for this project should have financial analysis skills, experience with startup business plans, and proficiency in Excel. Your ability to quickly and accurately complete this task will be key.
I am seeking a skilled web developer who can help create a tool to automate travel itinerary generation from an existing Excel database. This tool will also carry out various calculations and assist in enhancing the quality of the current database. Key Requirements: - Develop a web application that automates the creation of daily travel plans based on flight details and hotel bookings. - Incorporate cost estimation features to help determine the most economical travel options, including the optimal travel pass for each customer. - Assist in refining and professionalizing the existing Excel database. Ideal Skills and Experience: - Proven experience in web application development. - Strong proficiency with database management. - Previous wor...
I'm looking for a highly organized and efficient secretary to assist with organizing our department's work. This role will involve arranging meetings, writing internal communications, and coordinating teams and their schedules. The ideal candidate will have: - Proficiency in Excel, Word, and PowerPoint - Excellent typing and reading skills in both Arabic and English - Preferably, a background in medical terminology and experience as a medical secretary Your main tasks will be to ensure the smooth operation of our department, facilitating communication and coordination. If you have the required skills and experience, I look forward to receiving your bid.
Develop and implement an effective marketing strategy to attract luxury travel agencies and direct clients, using Sales Navigator and other digital marketing techniques. Target Definition Identify the Ideal Customer Create a detailed profile of luxury travel agencies and direct clients, with a focus on: - Agencies specializing in customized travel and exclusive packages. - High-level professionals and executives needing premium transportation services. - Segmentation - Classify agencies based on their specialization, such as high-profile events or partnerships with luxury hotels. --- Setting Up Sales Navigator - Lead List Creation - Compile a list of 50-100 potential agencies and clients using Sales Nav...
I need assistance in backing up my WordPress website pages. I am unsure which tool or method is best, so I would appreciate a professional's advice on the most effective way to create this backup. Additionally, I need help setting up an email through Mail. Ideal Skills and Experience: - Proficient in WordPress management - Experience with website backup processes - Knowledgeable about email setup on Mail - Excellent communication skills to explain process and tools used.
Solicito apoyo para realizar llamadas a un listado de clientes ubicados en México, con el objetivo de presentar los servicios de mi empresa. Es necesario que se complete un formulario con la información proporcionada por los clientes, incluyendo un apartado de comentarios en formato Excel. El propósito principal de esta tarea es obtener los datos de contacto (nombre, teléfono y correo electrónico) de las personas encargadas de compras y de las áreas de laboratorio.
Convert Excel data to Access for monthly data storage and invoice calculation and creation for small water utility company.
