Format word 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 ที่กำหนดให้
2 document to Translate from English to Thai 1. 930 word 2. 717 word ไฟล์ส่งให้อีกทีนะคะ
พิมพ์สูตรคณิตศาสตร์ได้ ตัวอย่างงาน
ต้องใช้ imacro คัดลอกข้อมูลจาก web site ลง excel
คีย์ข้อมูลต่างๆลง Excel การคัดลอกบทความต่างๆลง word
ทำ presentation งานโดยใช้ Powerpoint สามารถแทรกงานที่เป็นข้อมูล ตารางและกราฟ จาก data ที่เป็น Excel
I have 5 voice files in Thai that I needed translated in the format given below. I : น้องเคยค้นหาแอคเคาท์ใครในออนไลน์ป่ะ อย่างเฟซบุค Have you ever try to look for someone or search for an account online? Or in Facebook S : เคย Yes I : เหมือนฉันชอบคนนี้ ฉันไปตามล่าหา If I like this person I would look for him/her. S : โอ้ย เอาทุกสเต็ปเลย โพสต์รูปอะไรเซฟมาให้หมด Everything from posting to taking picture. S2 : โมเม้นต์นี้ เคยครับ คือคนที่เราอยากจะรู้จักใช่มั้ยครับคนที่เราแอบชอบนั่นแหละ เราจะคอยส่องเฟซเค้า ไปดู If i like that person i would peek at her Facebook. I : ไปแอดเค้ามั้ย Did you add her? S2 : เป็นเพื่อนกันอยู่แล้ว ก็ดูว่าเค้าลงรูปอะไรมั่ง กดไลค์ให้เค้า นั่งดูภาพเค้าอยู่คนเดียวอะไรอย่างงี้ We are already friend. Most of the time just likes and ...
I have a PDF document that I need retyped into an Excel file. The PDF consists of a total of 10000 pages with data organized in 4 columns. I'm looking for an experienced multiple freelancer who can accurately retype the data from the PDF into an Excel spreadsheet as plain text. Key requirements: - Retyping the content of a large PDF file into Excel - Data organization into 4 columns - Ensuring high accuracy in data entry See the attached file and google sheet link I will give 500 pages first if we meet rate and deadline.
I am in urgent need of comprehensive bank statements covering a period of 3 months. The statements need to be in PDF format and should provide a detailed view of transactions. As a prospective freelancer with this task, you should possess: - Exceptional attention to detail - Proficiency in deconstructing financial data - Proven experience in handling sensitive and confidential information - Proficiency with Adobe Acrobat or similar software to generate professional PDF documents Your main task will be to generate fully detailed bank statements for a 3-month period. Please ensure confidentiality and prompt delivery of these statements.
...Ideally, your expertise should include but not limited to: - Professional web designing - Experience in creating sites for corporate entities - Proven track record in developing informational websites The website will be mainly used to provide in-depth detail about our product services. Therefore, showcasing services in an accessible and compelling manner is essential. A concise and appealing format that presents information clearly yet engagingly is what I'm aiming for. Being able to understand and design with a corporate professional audience in mind will significantly benefit the project's outcome. Having excellent communication and interpretation skills is a plus, as seamless collaboration on this project is key for me. Let's create a platform that perfect...
Hi, I'm looking for a graphic designer who has a deep knowledge of America...approved graphics from or original hand-drawn elements. - Use commercially approved fonts only from or Google Fonts. - Provide evidence that graphics and fonts used are properly licensed and approved for commercial use - Experience with Notion and Dropbox for project management and file sharing. File Specifications: Final designs to be delivered in PNG format with transparency. Required dimensions: 4500 pixels wide by 5400 pixels tall. Color mode: sRGB. Application Instructions: Please include examples of relevant t-shirt designs in your portfolio. When applying please mention the required file dimensions to confirm you have fully read the project description. Thank you!
...be adept at managing my calendar and coordinating with my contacts. - Managing emails and correspondence: You'll be responsible for filtering and replying to emails on my behalf. - Organizing documents and files: Keeping my paperwork in order is crucial. You should be proficient at filing, archiving, and retrieving documents. The ideal candidate should be well-versed in: - Microsoft Office (Word, Excel, PowerPoint) - Google Suite (Gmail, Google Docs, Google Sheets) - Calendar and scheduling software (Outlook, Google Calendar) In addition, fluency in German and Spanish, on top of English, would be considered a significant asset. This is a long-term role, with no strict deadline for completion. I value professionalism, discretion, and efficiency in my secretary, and ...
I need help transcribing six handwritten pages in Spanish into a Word document. The handwriting is mostly clear, but there are some parts that are hard to read. I'm comfortable with the transcriber using their best judgment to decipher these parts. Additionally, there are no specific formatting requirements. Ideal skills and experience for this project: - Fluent in Spanish - Strong transcription skills, particularly with handwritten text - Attention to detail and ability to make informed decisions in cases of uncertainty.
...texture and model files - Import of model and texture files that are already available - Making sure that .pack file (mod) is applied to correct characters Ideally, this project should not take more than a day to complete, and it requires basic knowledge of modeling for the successful import of the model and texture files. Total War: Three Kingdoms Character Reskin Mod for the game in "pack" format, suitable for the game and fully functional for the game and compatible with other mods. made for last version for the game. I will provide files for both characters. Modder that takes this job will have to use Blender or similar modelling software to bind Total War: Three Kingdoms skeleton and bones to model, QtRME (if necessary) to bind animations to the model
I need a skilled individual or team with the capability to enhance the legibility of writing on moderately blurry financial documents, specifically checks and backs of checks. My ideal candidate should have access to necessary software or techniques to improve legibility. Deliverables: - Extracted content from these documents in JPEG/PNG format, neatly organized and easily readable. Skills and Experience: - Prior experience in digital image enhancement and manipulation is highly desirable. - Familiarity with financial documents such as checks would be advantageous. - Technical skills in data extraction from images and OCR tools are key. Your mission, should you decide to accept it, is to enable us to decipher these financial documents clearly. Time and accuracy are of the essenc...
I am in need of an Excel expert to help in building a comprehensive Excel file. The purpose of this Excel file is to manage different types of data. This data is of intermediate complexity, consisting of multiple data sources and types. Key Tasks: - Data Analysis: I need assistance in analyzing the data that will be managed within the Excel file. - Formulas and Functions: The Excel file will require the use of various formulas and functions to ensure its smooth operation. - Data Visualization: Help is needed in visualizing the data in the Excel file. Skills and Experience: - Extensive experience with Excel, especially in data management. - Proven ability in data analysis, including the interpretation and manipulation of complex datasets. -...
I'm seeking a tech-minded professional to comprehensively assess critical areas of our IT infrastructure including: - Data security and backups, - Code base review, - Ecommerce Archi...them to aptly deliver. Their skills will also involve reviewing our existing software development, with the focus on custom software development. It's key that the assessment be as detailed as possible to help in making crucial investment pitches. Upon completion of the assessment, I'd like a scorecard that details the evaluation findings of our codebase. This should be in a tabular or narrative format, providing a clear, quantifiable overview. A background in IT analysis or similar would be ideal. The goal here is to achieve an actionable, comprehensive report that we can use as a b...
I am seeking a proficient Excel programmer who can assist me in automating tasks, creating complex formulas and calculations, and generating reports and trading signals based on S&P500 Index data. The ideal candidate should have: - Proficiency in Excel with a strong track record of automating tasks and creating formulas - Experience in generating reports based on financial data, specifically S&P500 Index - Strong analytical skills to ensure the calculations and data analysis are accurate and reliable - Excellent communication skills to understand my requirements and provide regular updates Some of the key responsibilities and tasks include: - Automating the extraction of S&P500 Index data - Creating formulas and calculations to analyze the extracted data - Devel...
I'm seeking a savvy graphic designer with a firm grasp on creating a compelling logo. The ideal candidate should excel at crafting Corporate and Bold designs. Key requirements: - Develop logo consistent with brand identity - Color scheme: Vibrant Colors - Experience in Corporate and Bold style preferred Your portfolio demonstrating similar work will greatly enhance your application. Be ready to provide a draft and work iteratively. This project will involve a creative, charming and bold design to reflect the character of my brand. Your committed engagement till the end of this project is appreciated.
For this project, I'm looking for an expert in Perfex CRM with a knack for creating well-organized and professional-looking PDF templates. Here's what I need: 1. "Total Amount" Layout Changes: - Replace the current numerical display of the total amount with a written format. - The currency should be displayed in words and must be in Euros (EUR). 2. Footer Alterations: - Incorporate legal information about my company in the center of the document footer. These modifications are crucial for improved visual representation and legal compliance. The freelancer hired for this task should understand the principles of layout design, the specifics of the Perfex CRM system, and be able to work independently with minimal supervision. An eye for detail and strong...
I am looking for a talented individual who can create technical drawings for an aluminum extrusion. The drawings should primarily focus on delivering precise dimensions. The ideal candidate for this job will: - Have a strong background in technical drawing, particularly with aluminum extr...individual who can create technical drawings for an aluminum extrusion. The drawings should primarily focus on delivering precise dimensions. The ideal candidate for this job will: - Have a strong background in technical drawing, particularly with aluminum extrusions. - Be proficient in creating detailed and accurate dimensional drawings. - Have the ability to deliver the final drawings in a PDF format. Only those with skills and experience in creating technical drawings should bid for thi...
I need a comprehensive spreadsheet created that will contain the match res...2019, 2021, and 2022. I can provide one source of the episodes but you are free to use any other you like. Key Requirements: - The data should be presented in a tabular format. - The matches results should be included. - the results of the matches should be presented in order for each day. - Contestant statistics such as wins, losses, eliminations, and other relevant information should also be covered. - Please ensure that the data from each year is kept separate. Key Skills & Experience: - Proficiency in data entry and organization, with a keen eye for detail. - Experience with creating spreadsheets in a tabular format. - Understanding of reality television or competitive show formats is a pl...
Enlgish: I have a large quantity of PDFs to process and I am looking for the same specific information each time. I'd like it to input it into Google sheet. I would like to have a program where I can drag and drop the documents, then click on "extract," which allows me to have the information in the correct cells of my Excel or Google Sheet file. ------------------------ French: J'ai Une grande quantité de PDF à traiter et je recherche à chaque fois le même information spécifique Je souhaiterais automatiser le processus
I'm in search of a proficient Excel Macro programmer who can automate data entry tasks with emphasis on numeric data. The ideal candidate would deliver a macro that inputs numbers into Excel and uses "if, then else" logic to perform specific tasks. Essential skills include: - Extensive experience with Excel Macros - Solid understanding of data entry automation - Proficiency in working with numeric data - Good grasp on logical functions especially if, then else Your primary function will involve interpreting requirements and programming the macro to swiftly and accurately complete data entry tasks. Please ensure your portfolio showcases relevant work.
I'm in need of a Malayalam verbatim transcription professional to transcribe my content into SRT format. I'm looking for someone who can deliver high quality, accurate transcriptions in a timely manner. Key Requirements: - Verbatim Transcription: I need the transcription to capture every spoken word. - Time Stamps: The transcription should have time stamps. Ideal Candidate: - Proficient in Malayalam: Ability to transcribe accurately and fluently in Malayalam is a must. - Previous Experience: Prior experience transcription and SRT formatting will be highly advantageous. - Attention to Detail: You should be meticulous and detail-oriented to ensure a high-quality output. - Punctuality: Meeting deadlines is crucial, therefore, the ability to deliver on time is highly...
I have included examples of each of the following files I would like to have: - Each US state in a vector EPS file with a cut line. Each as their own file name. - A photo of each with dimensions - A mock up photo of each state decal on the back window - An excel sheet with all the states and associated dimensions Example: North Each state .EPS cut file would need to be within a 3.5" x 5.5" rectangle or a 5.5" x 3.5" rectangle. Whichever best fits the state. I have attached an "Examples" file as well that gives further instruction for setting up the file. There are 50 States. I will need 3 folders: 1- Cut Files (50 .EPS files) 2- Dimension Photos (50 Photos) 3- Mock Up Photos (50 Photos To find all the state outlines, you will need to Googl...
I have a level sensor which is currently sending data to a local Wi-Fi network, accessible through a web brows...through a web browser using the sensor's IP. I'm seeking assistance to automate this process and have the following requirements: 1. Data Fetching: The sensor is measuring liquid levels. This specific information needs to be fetched and transferred directly to an Excel sheet. 2. Data Update Frequency: The data should refresh in the Excel sheet every minute. 3. End Goal: The collected data will be used to generate a chart in Excel. Ideal skills for this project would include extensive experience with automation, proficiency in Excel, and understanding of level sensor operations. Knowledge of networking would be a plus. Are you the right p...
I'm seeking a proficient developer to build a user authentication and authorization system using JS, Node.js, and MySQL. The core function of this project will be role-based access control. Key Features: - Role-based access control system: The system should be able to accommodate three different roles - Admin, User, and Guest, each with different permissions. Ideal Skill...sent to the relevant address based on the campaign. • I have a list of ASM email addresses from a Company. I'd like to trigger emails to each of the ASMs on the list. (Campaign wise)" 8. Download Reports: • Include Camp Details Entry Date: This option focuses on the purpose of having the date - to track when the camp details were entered. • To select Date Range • To Select HQ Wise ...
I'm in need of a proficient Smartsheet expert to assist me in recommending and developing multiple program and project plans. I want to work with expert on a shared screen to help me to learn as we go. I need someone fluent in English - I have a little hearing loss Key responsibilities will involve: -Building SMARTSHEET plans -- Linking to External data (i.e. Excel) that will be used in updating the SMARTSHEET plans. - Utilizing SMARTSHEET Functions: Proficient use of formulas and calculations is essential for this project. - Building Reports and Dashboards: Experience in creating comprehensive and visually appealing reports and dashboards is necessary. The primary goal for this project is to efficiently and accurately track the progress of different projects within the ...
*** US CANDIDATES ON...background to manage various tasks. Key Responsibilities: - Budgeting: You'll be responsible for creating and monitoring budgets to ensure financial health. - Expense Tracking: Accurately log and keep track of expenses to maintain a clear financial picture. - Invoicing: Prepare and send invoices to vendors and clients in a timely manner. Your Experience: - Proficiency in Excel: Since I currently handle finance using Excel, it is essential that you are comfortable with this software. - Previous Finance Management: Experience in budgeting, expense tracking, and invoicing is a must. - Strong Communication: Being able to keep me updated and informed on financial matters is key. Please highlight your relevant experience and how you can support me in ...
I have a PDF document that I need retyped into an Excel file. The PDF consists of a total of 10000 pages with data organized in 4 columns. I'm looking for an experienced multiple freelancer who can accurately retype the data from the PDF into an Excel spreadsheet as plain text. Key requirements: - Retyping the content of a large PDF file into Excel - Data organization into 4 columns - Ensuring high accuracy in data entry See the attached file and google sheet link I will give 500 pages first if we meet rate and deadline.
I'm looking for an expert in Excel to build a comprehensive 'Team Scorecard' for my team. This sheet will be used to track a range of tasks and behaviors to ensure the team is performing at their best. Key Features: - The project involves tracking various tasks and behaviors including daily reports, client communication, social media postings, timekeeping, invoicing, and meeting attendance. - I need the sheet to calculate total and average points automatically. This will be based on the tasks completed and the quality of those tasks. - It should also include conditional formatting to highlight outstanding performances. This will help us recognize and reward exceptional work. - Data validation is important to ensure accuracy and consistency in point entries. - Visu...
I need a freelancer to meticulously copy and paste data from PDF documents into a Word document. This is a simple data entry task but accuracy and attention to detail are crucial. Ideal Skills and Experience: - Strong proficiency in both PDF documents and Word documents - Excellent typing skills and attention to detail - Prior experience in data entry - Comfortable with repetitive tasks - Time management skills to ensure timely completion of the project
...booking tool. The site is partly developed (stack: NextJS, MongoDB & Prisma), only a small part of it is ready (not much around 25% done so far), initially the current code needs to be checked, fix bugs and develop the project The project is a flight booking site, Here's what the project entails: - Development of an AI-driven flight search and booking platform - To be exclusively used in a web format - Priority is quick project completion, as I need this done ASAP Attached are the specific tasks required Sigma design is ready and beta site is online Ideal skills and experience: - Proficiency in AI technology - Extensive web development experience - Previous work in the travel or airline industry would be a big plus - Ability to work under tight deadlines withou...
I am in need of a data entry specialist to input data from PDF files. Key Responsibilities: - Transferring information from PDF documents into a specified format - Ensuring accurate and efficient data entry - Handling a large amount of data in a timely manner Ideal Candidate Should Possess: - Demonstrated experience in data entry, particularly with PDF files - Proficiency in data management and organization - Attention to detail and accuracy is key Previous experience in handling a large volume of data entry from PDF files will be highly regarded. This is a great opportunity for someone who is detail-oriented and is looking for a data entry project.
