Create address book 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 วันให้ทั้งแถวเปลี่ยนเป็นสีแดง
...สามารถแก้ใขข้อมูลทั่วไปของนักศึกษาได้ เช่น เกรดเฉลี่ย รายวิชาที่เคยเรียน อาจารย์ที่ปรึกษา 1.3 สามารถอัพเดทหรือแก้ใขข้อมูลทั่วไป 1.3.1 สามารถอัพเดทหรือแก้ใขกิจกรรมหรือข้อมูลข่าวสารได้ 1.3.2 สามารถอัพเดทหรือแก้ใขข้อมูลทั่วไปเกี่ยวกับคณะได้ เช่น แผนการศึกษา ค่าเทอม 1.3.3 สามารถอัพเดทหรือแก้ใขข้อมูลการติดต่อได้ 1.3.4 สามารถอัพเดทหรือแก้ใขระบบหนังสืออิเล็กทรอนิกส์ (E-Book) ได้ 1.3.5 สามารถอัพเดทหรือแก้ใขระบบบริจาคเงินได้ 1.4 สามารถสืบค้นข้อมูลนักศึกษา/บัณฑิตได้ 1.4.1 แสดงรายชื่อนักศึกษา/บัณฑิตจากการค้นหา โดยข้อมูลที่แสดง ได้แก่ - รหัสนักศึกษา - ชื่อ-นามสกุล - สาขาที่ศึกษา - ปีการศึกษาที่เ...
...สามารถ 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)
ต้องการผู้ที่สามารถทำ SCADA ดึงข้อมูล Modbus Address จาก MK5 ของ Atlas copco Compressor
คัดลอกข้อมูลจากเว็บไซต์ คัดลอกข้อมูลจากเว็ปไซต์ลงในไฟล์excel
หาข้อมูล 16 อย่างของ Blogger จาก 50 fanpage แล้วกรอกลงให้ excel ที่กำหนดให้
พิมพ์สูตรคณิตศาสตร์ได้ ตัวอย่างงาน
ต้องใช้ imacro คัดลอกข้อมูลจาก web site ลง excel
คีย์ข้อมูลต่างๆลง Excel การคัดลอกบทความต่างๆลง word
ฉันสามารถออกแบบสิ่งที่คุณต้องการโดนหาแรงบันดาลใจจากคุณ เปิดโอกาศให้ฉันได้ร่วมงานกับคุณ
ทำ presentation งานโดยใช้ Powerpoint สามารถแทรกงานที่เป็นข้อมูล ตารางและกราฟ จาก data ที่เป็น Excel
looking for job typing document from book by on line I mean want to work at home
...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'm e...
Recopilar información de indicadores de turismo y su disponibilidad en la red. Trabajo de documentación y búsqueda.
As an author, I need a professional freelancer to help me with quick revisions to my two books' titles, subtitles, and descriptions. My requirements include: - Removing and adding a few words in the title and subtitle of each book - Revising and reformatting a few sentences in the description of each book Completion is needed ASAP, so proficient freelancers who can work under tight deadlines would be the most ideal for this job. Excellent command of English language, proofreading, and editorial skills are also highly preferred.
I am in need of a ...transfer the data to Excel. The PDF tables are consistent across all pages, maintaining a fixed column structure which you need to duplicate in the Excel spreadsheets. The data you will be working with is primarily text-based as opposed to numerical. Necessary Skills and Experience: - Excellent attention to detail - Proficiency in optical character recognition (OCR) processing - Experience with data scraping or extraction - Valuable skills in MS Excel - Familiarity or experience with PDF data extraction software Swift and accurate execution is essential for the successful completion of this project. Please only apply if you are comfortable handling a high volume of pages and can ensure that no data is lost or incorrectly transcribed in the trans...
โปรดลงทะเบียน หรือเข้าสู่ระบบ เพื่อดูรายละเอียด
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 an...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 essence in this project. All we need is one document...we are seeking the name and the a...
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 looking for a skilled professional to create a robust AI-driven marketing program. This project aims to optimize the marketing database, generate sales, and increase our revenue. Key requirements include: - Building an AI system for data verification to ensure high-quality, accurate information. This includes email verification, phone number verification, and address verification. - Implementing an AI program to sort and segment lists for each campaign. It should consider the following criteria: - Demographic data: Utilizing data such as age, location, gender, and income level. - Customer behavior data: Tracking and understanding customer interactions with the business, such as preferences, buying habits, and engagement. - Purchase history data: Analyzing past...
Project to create a digital memorial (mini social network) platform for people to honor their loved ones. Our prototype is ready, and we'll develop it using C#/.NET for robustness and scalability. Link to website prototype: (Copy)?type=design&node-id=0%3A1&mode=design&t=jfwDURBhWcI72r1x-1 You don't need to strictly adhere to the prototype design; it's meant to showcase the elements within it.
I am in need of a professionally designed Wix website for my dental practice. Primary features of the website are: - Appointment booking system: A calendar integrated system allowing patients to book appointments online. Moreover, the system should provide automated reminders and allow multiple service selections. - Landing page for advertisement: promotions and special offers. It should also include an integrated calendar displaying available appointment slots for potential patients to book directly from the page. Lastly, a section for contacts and leads is required. Ideal candidates for this job are those adept with Wix platform and have previous experience in similar projects. Strong understanding of user interface and web design along with knowledge of booking systems ...
I need 4 Instagram highlight covers made: I have a color combo I’d like used and I just want a simple animated picture to represent each topic. For instance “workouts” would just be a dumbbell. “Scripture” would just be an open book. “Dad life” could be a house and “my story” could have a heart. And one for “running” can be a shoe. I’ve attached examples and then a picture of me that is AI generated that I’d like to use the color of my hat and orange as the colors for the highlights.
I'm looking to create an engaging nutrition website that primarily sells e-books. The site should also offer valuable resources in the form of freebies and nutritional guides. To access these free resources, visitors should be prompted to sign up for a newsletter. The key elements of the project include: - Building a visually appealing and user-friendly website that integrates e-commerce capabilities for e-book sales - Creating a system that requires visitors to sign up for a newsletter to access freebies and guides - Developing a library of e-books for sale, with the potential for expansion in the future Ideal freelancers for this project should have: - Proven experience in e-commerce website development, particularly with digital products - A strong understanding of ...
...their API to our website so the orders placed on our website will be goes to my account on and they will print according to order and deliver to my customer with our name and address. Key Requirements: - E-commerce platform and Portfolio showcase. - Integrate APIs: Payment gateway and Social media login, along with the specific Service provider's API. - Tech: Flutterflow Utilize Flutterflow and API integrations to carry out these tasks. Ensure smooth, seamless transactions by integrating PayPal and Stripe as the payment gateway, allowing customers to make purchases straight from the site. Create a login and authentication system for users, facilitated by social media login integration. Provide evidence of related projects during your application. I'm lookin...
...decision making, particularly in developing economies. As a Site Verifier, you will be involved in our pre-employment screening by conducting a visit to our candidates’ residential address with the candidate’s consent letter. JOB DESCRIPTIONS: • Conduct the site visit to the candidate’s residential address • Conduct the basic verification of the candidate’s residence & reputation with the neighbors, head of the local community, police stations, building operators, etc. • Take pictures of the candidate’s residential address, as per Confirmis’ standard operating guidelines. • Provide observation about the address such as the location, the building, etc • Job will only take less than one hour to ...
I am searching for a Sales Representative specialized in technology. Your role will be to attract startup clients for my website development business. Key Responsibilities: - Prospect and qualify potential startup clients - Maintain relationships with clients - Utilize phone calls as a primary method of communic...Responsibilities: - Prospect and qualify potential startup clients - Maintain relationships with clients - Utilize phone calls as a primary method of communication Ideal Skills and Experience: - Solid experience in the tech industry - Ability to articulate the value of web development services - Proven record in tech sales This role requires a deep understanding of the startup ecosystem and how to address their unique needs. Apply if you can confidently navigate the...
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.
I'm looking for a developer who can replicate a person based on gpt. The functions I want are as follows. Development environment: Python 1. When I put in a YouTube link, I create a gpt model that has the person's personality, tone, and knowledge. 2. The model made in No. 1 and the app that can chat using gpt api (this is already made with flutter). What I want is to develop No. 1 into Python. If I have to use llm other than gpt, it doesn't matter if I can just get an answer with api. If I can't completely replicate a person with YouTube link alone, I welcome anyone who has other options. The key is to create a chatbot that has the way a particular person speaks, personality, and knowledge. An example is caryn ai on the market.
Project Description: We are looking for a skilled WordPress developer to build a website for , a company specializing in property and business loans overseas. The website should support multiple languages and feature a multi-currency loan calculator, secure loan application processing, and user account management. Objectives: Develop a clean, professional-looking website using WordPress. Include key functionalities such as a loan calculator, multi-language support, secure application forms, and customer login areas. Required Features: Multi-currency loan calculator Secure application processing User registration and management Responsive design for all devices SEO-friendly structure Skills Required: Proficient in WordPress, PHP, HTML, CSS, and JavaScript Experience with financial servi...
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 am having trouble configuring my TP Link Omada and facing some connectivity issues. I'm unsure if these problems are related to specific devices or the entire network. I am mainly requiring assistance with advanced configuration settings. Ideal Skill...problems are related to specific devices or the entire network. I am mainly requiring assistance with advanced configuration settings. Ideal Skills/Experience: - In-depth knowledge of TP Link Omada systems - Experience in diagnosing and troubleshooting connectivity issues - Expertise in advanced network configuration settings Please provide a clear plan on how you will identify and address the issues. I prefer structured and efficient troubleshooting approaches. Your expertise will be key in resolving my network...
Project Description I am seeking a skilled editor and formatter with experience in preparing books for publication on Amazon, specifically for Kindle and paperback formats. My book, titled "Dental Dollars: Essential Tax Reduction Strategies for Dentists," requires a detailed review to ensure it is polished and ready for readers. Scope of Work 1. **Formatting:** - Formatting the text to meet Amazon's Kindle Direct Publishing specifications for both eBook and print versions. - Adjusting layout, fonts, headings, and margins to ensure a professional appearance. - Including any necessary graphical elements such as charts or images in high resolution. 2. **Final Review:** - Proofreading the final version to catch any remaining typos or errors. - Ensuring ...
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...
