Create file tree excel vbaงาน
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 ที่กำหนดให้
พิมพ์สูตรคณิตศาสตร์ได้ ตัวอย่างงาน
ต้องใช้ imacro คัดลอกข้อมูลจาก web site ลง excel
คีย์ข้อมูลต่างๆลง Excel การคัดลอกบทความต่างๆลง word
ฉันสามารถออกแบบสิ่งที่คุณต้องการโดนหาแรงบันดาลใจจากคุณ เปิดโอกาศให้ฉันได้ร่วมงานกับคุณ
ทำ presentation งานโดยใช้ Powerpoint สามารถแทรกงานที่เป็นข้อมูล ตารางและกราฟ จาก data ที่เป็น Excel
ฉันมีไฟล์ .exe แต่ฉันต้องการเปลี่ยนให้มันรองรับกับภาษาของฉัน เพราะว่าตอนนี้มันไม่อ่านฟร้อน ไทยมันแสดงผลเป็นสี่เหลี่ยม i have file .exe but i want change language is my language
I'm in need of an app developer who can create a messaging app similar to WhatsApp & twitter . The app should include the following features: - Group Chats: Users should be able to create and participate in group conversations. - Voice and Video Calls: The app should support both voice and video calling. - File Sharing: Users should be able to share files of various formats and sizes. I'm looking for a professional who can develop this app for me at a reasonable cost. Please provide a quote along with your proposal. Experience in developing messaging apps, particularly with the features mentioned, will be highly appreciated.
Tengo una asesoría energética, la cual paga comisión por contrato. La comisión depende de distintos factores. Actualmente tenemos un backend en excel y un frontend en pdf, es decir: Creamos las comisiones en excel para agilizar la creación, las copiamos en un POWERPOINT algo más atractivo y visual, y las convertimos a pdf. Nos gustaría poder implementar la subida de estos excels en una interfaz BONITA, incrustrada en una web. Lo ideal sería poder cargar estos excel a la web y que la web "pintara" estas comisiones a través de una interfaz visualmente atractiva y llamativa para nuestros agentes comerciales. Adjuntamos ejemplo de excel de comisiones de algunas de nuestras compañ&ia...
See PDF below for details Dimensions suitable for Instagram and Facebook posts
Hi, If anybody is interested to create an Api using bearer token and consume it using web forms in asp.net c#. Thank you.
I'm seeking a proficient freelancer with experience in unpacking Themida v2-protected DLL files. The unpacked file is intended for analysis and research, and there's no need for detailed documentation. Key requirements: - Proficiency in unpacking Themida v2-protected files - Previous experience working with DLL files - Ability to efficiently provide the unpacked file Your primary task will be to successfully unpack the DLL file, providing me with the unpacked version for further analysis. Your expertise in this area is crucial. Please note that detailed documentation on the unpacking process is not required, only the unpacked file itself.
I'm in need of a freelancer who can automate my Excel spreadsheet to increase efficiency and accuracy in data entry and analysis. Key Duties: - Automate data input, validation, and manipulation - Perform calculations and formulas automatically - Generate reports and summaries for the data Ideal Skills: - Proficiency in Excel - Excel input form design - Previous experience in automating data entry processes - Understanding of data manipulation
I'm seeking an experienced Google Script specialist to automate tasks and manage data for my project. Here are the specifics: Automating tasks: Your main responsibility will be to automate data import/export processes using Google Script. I need to take the data attahed to a daily email in excel format, upload this data (and historic) to a data base and then allow to consult that data from different spreadsheet in google with a query. Ideal skills and experience include: - Proficiency in Google Scripts and automation - Experience in data management - Google spreadsheet analisis reports If you have the needed expertise, I'm excited to work with you!
I'm seeking a seasoned freelancer to create a photo-realistic architectural rendering see sample provided. The purpose of this project will be to visualize design ideas. i have included the pdf drawings, image samples, and rendering samples House will have the following... Brick - White Stone - dark gray siding - black Trim and windows - black garage doors - black gable features and porch post - red cedar landscaping items are provided in the pictures uploaded you can use your own pictures but they need to be the same type of tree or bush to be clear the is the house you will be rendering the AutoCAD file can be provided upon request Ideal skills and experience: • Proven record in architectural design • Expertise in photo-realistic rendering techni...
I'm in urgent need of a professional who can assist with pushing my source code files to an existing repository on GitLab. Key Points: - The task is solely focused on pushing source code files. - A new repository doesn't need to be created, we will utilize an existing one. - The existing repository has files inside of it. I cloned this repository and zipped it and sent it to my friend. - The source code files have been amended by my friend on his computer. He has sent me the updated files. I want to push these files under my name and account details. - You must be an EXPERT at Git. Not a regular user but an expert in case something goes wrong. The ideal freelancer for this project will be someone who is experienced with GitLab and has prior experience with pushing and mana...
Looking for assistance with enhancing and modifying my PowerPoint file. It contains the procurement steps from start to finish, but the current block flow diagram is quite basic. I'm looking to redesign the diagram to make it more visually appealing and clear, especially for presenting to higher management and for printing purposes. The objective is to ensure that the workflow is easily understandable at a glance. Here are the key points: Enhance and modify PowerPoint file with a focus on the block flow diagram. Redesign the diagram to make it clearer and more efficient. Ensure that the final design is suitable for printing and presenting to higher management. My initial budget for this project is $15, but I'm open to increasing it if the job is comple...
...for specific industrial scenarios. We’ll analyze factors like cost, efficiency, and compatibility with existing systems through a decision tree. The goal is to guide stakeholders in choosing the most effective technology for reducing emissions in their operations. 1. Literature Review: Summarize relevant research and findings on carbon capture technologies. 2. Technology Briefs: Provide a brief overview of each technology, including key features and operational principles. 3. Influence Diagram: Create a diagram that shows how different factors related to carbon capture technologies influence each other. 4. Decision Tree (EMV): Develop a decision tree that calculates the Expected Monetary Value (EMV) for each technology option. Need to use probablity...
...for specific industrial scenarios. We’ll analyze factors like cost, efficiency, and compatibility with existing systems through a decision tree. The goal is to guide stakeholders in choosing the most effective technology for reducing emissions in their operations. 1. Literature Review: Summarize relevant research and findings on carbon capture technologies. 2. Technology Briefs: Provide a brief overview of each technology, including key features and operational principles. 3. Influence Diagram: Create a diagram that shows how different factors related to carbon capture technologies influence each other. 4. Decision Tree (EMV): Develop a decision tree that calculates the Expected Monetary Value (EMV) for each technology option. 5. Risk Profile: Anal...
I'm in need of an application that prints labels from an Excel spreadsheet. The scope is to print personalized employee labels with names and respective earnings for cash payments. Key project features: • Read an Excel spreadsheet in a consistent format, with different entries for each worker's name and earnings. • Print labels with the worker's name and corresponding earning. Candidates should have: • Extensive experience in programming • Familiarity with reading data from Excel • Expertise in printing functions Just to clarify, the format of the spreadsheet will always be the same, only the contents (worker names and earnings) will differ. Please ensure the program is capable of handling this accurately. Your...
I'm in need of a proficient social media manager who can post daily content on Facebook, Instagram, TikTok, and other platforms through Loomly. The job will mostly entail modification of existing content. However, your creative input is most welcome. There is an official step-by-step Process to follow. Minor Excel reporting is required as well. I need somebody who is proficient in English-written and listening/talking. Must be able to work in a New York time zone between the hours of 12 PM and 8 PM. Roughly 2-3 hours a day total Monday-Friday at $30 a week! This role requires: - Excellent understanding of these four platforms - Proven ability to edit and modify existing content in an appealing way - Capacity to deliver consistently on a daily basis - Attention-to-detail...
...Freelancer – I will decide on the project in 3 days. The business evaluator estimates what your business is worth and offers a blueprint for scaling your business to the next level. The blueprint will establish your business baseline, identify your peer group, and advise you on what you need to do (people and budget) to accelerate to the next peer group level. Currently: 1) Written in MS Excel and utilizing Macros for a. Navigation between Sheets b. Set a subscription, 1st time the Worksheet is run, it writes a date in a database worksheet 2) There are 2 worksheets for Input: a. Customer Main Input Screen - worksheet (90% of the application runs off data from this worksheet i. The information from this worksheet is utilized for all 8 other reports (worksheets...
i need the same colors and theme of the website you did
I'm seeking a talented developer to create a custom Telegram bot for my company. The bot will serve as a communication tool and a source of information. Ideal Skills & Experience: - Proficiency in Telegram Bot API - Experience with bot design, including user input and automated messaging - Capable of implementing and managing information resources The main functionalities of the bot are: - Sending automated messages: The bot should be able to send pre-determined messages at set intervals. - Receiving user input: It should be able to interact with users and receive text input from them. - Providing information based on user queries: The bot needs to be able to present content from our company's internal library which will be provided upon Bot design by using MENU BUIL...
You are asked to create an Excel file (FILE A) that: 1) Automatically extract data from another Excel file (FILE B) which is located in an FTP folder and which is updated every day. 2) The FILE A must extrapolate the data from the FILE B based on some filters that can be set or changed. For example, a filter could be the Brand or the Price. 3) The output (FILE C) of FILE A must be a .CSV file composed of 3 columns: SKU, Quantity and Price. 4) The final part is that this FILE C is saved inside another FTP folder. This entire 1+2+3+4 process must be done automatically every day at a certain time without the intervention of an operator.
...need to be converted to a SolidWorks or STEP file. This file will be crucial for the manufacturing of the product. Key Details: - End Goal: The main aim of this project is to obtain a manufacturing-ready model. It should be a precise and detailed 3D model suitable for industrial production. - Material Properties: It's essential for the selected freelancer to consider the material strength in the design. The integrity and durability of the final product depend on this factor. - Assembly Features: The design should include screw holes or threads. These features are necessary for the assembly process and should be clearly defined in the model. The ideal candidate for this job should have a good understanding of both AutoCAD and SolidWorks/STEP file conversions. ...
I'm looking for a skilled Excel expert to work on my financial data. The task involves clearing the data and conducting a thorough analysis specifically focused on profitability. Key responsibilities: - Clearing the provided financial data - Analyzing the data based on the profitability metrics Ideal skills and qualifications: - Proficiency in MS Excel, especially in data analysis - Strong understanding of financial metrics, particularly profitability - Attention to detail and ability to ensure data accuracy - Ability to present findings in a clear, concise manner - Previous experience working with financial data is a plus Please note that the data requires thorough analysis. Clarity and precision are crucial as the analysis will be used to make important business de...
I have a set of Excel sheets that need to be transformed into a powerful data analysis tool. The primary purpose of this tool is to provide detailed data analysis in the form of summary reports. Key requirements: - Data analysis: The tool needs to be proficient in data analysis. It should be able to handle the data provided and present it in a clear and concise manner. - Summary reports: The data analysis results should be presented in summary reports. These reports need to be visually appealing and easily digestible for a non-technical audience. - Automated chart updates: When new data is added to the tool, the charts should be automatically updated to reflect these new changes. This automation is crucial to ensure the tool remains accurate and up-to-date. Ideal skills and exper...
**Your Bidding Amount is Final. No change allowed later**##Please read the attached file for details## I have an existing Online Stamp Inventory for Postal Stamp Collectors in my site. It is made in CakePHP. I need to add some features to it and repair current feature. I want to add Export feature, improve search feature and add the feature of uploading images/document, repair Year field, URL field etc, make the current captcha and email verification system better. Further, I want to dedicate one user as Admin. Admin gets all features like common users. Only difference is Admin can see user details like their username, email ID and registration date and can export it. No seperate Admin panel needed. See the site: This is very easy Project
I'm seeking an experienced Tableau and Excel expert to assist in creating a high-quality data visualization project. Key project requirements include: - Intermediate level of complexity: The data that needs to be visualized is sourced from multiple sources and requires the implementation of filters. - User-driven data filtering: I am looking to implement specific interactivity features that allow users to manipulate and filter data. The ideal candidate will have: - Proficiency in Tableau and Excel - Experience in creating intermediate level data visualizations - Strong understanding of data filtering and interactivity features If you possess the required skills and experience, please bid on this project.
Setup issue for web. Data is not showing after create. Only work with ftp.
I have a project that involves merging 80 .blk scan files in Cyclone and creating plans for a rooftop in .dwg format. This must be extremely accurate as the client is using this to order rooftop units for its HVAC system. Key Requirements: - Proficiency in Cyclone and Autocad software for merging .blk scan files and creating plans - Creation of highly detailed rooftop plans with all architectural elements included - Adherence to industry-standard layers for the DWG files - Strong understanding of AutoCAD for ensuring compatibility and high-quality output Please bid on this project if you can deliver on the above requirements and have a proven track record in using Cyclone for similar tasks.
I'm seeking an experienced and knowledgeable data scraping professional to collect specific information from three major platforms - RERA websites (specifically Maharas...(Maharashtra, Telangana, Haryana, Delhi) - Google (DSA and Loan Agents data) - Justdial (DSA and Loan Agents data) The ideal freelancer for this job will be highly experienced in data scraping and will be able to deliver the results in an organized manner. Proficiency in scraping from Google, RERA websites, and Justdial is particularly important. Delivery Format: - The data should be delivered in an excel file format. If you have the required skills and this project fits your area of expertise, I encourage you to bid. Your understanding of the project could make a real difference. Let's discus...
I require an expert in both C# and AWS to build a AWS Lambda function using .Net Core. The function should create a simple message in the SQS queue. The deliverables should include: 1. AWS Lambda Function: The AWS Lambda function should be capable of both Asynchronous processing and Dead letter queue. It should be written in C#. 2. Serverless Template: A serverless template is required that will be used by our gitlab pipeline to create the queue on AWS account. This template should be comprehensive yet efficient. 3. Gitlab YAML: Lastly, a gitlab yaml will be needed to facilitate the Lambda's deployment. Ideal Experience: - Highly skilled in C# programming - Extensive experience using AWS services - Familiarity with serverless templates - Understanding of Gitlab YAML f...
