Vb read excel find cellงาน
Coding vba ให้คำนวนและรายงานผลลงในแถบ status bar ที่มุมจอ โค้ดทำงานได้กับทุกชีทในไฟล์ รายงานผลคล้ายค่า sum, average ที่โปรแกรมมีมาให้เดิม ทศนิยมสองตำแหน่ง เลือกเซลล์จากชีทไหนก็ได้ (เซลล์1จากชีทa เซลล์2จากชีท(n) 1. รายงานผลหาร เซลล์1/เซลล์2 2. รายงานผลลบ เซลล์1-เซลล์2 3. รายงานผลเปอร์เซ็นต์ เซลล์2/เซลล์1*100
...สามารถ 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
รับเขียน ออกแบบ แก้ไข software ทุกประเภท ทั้งงานทั่วไป และ ในโรงงานอุตสาหกรรม ประสบการณ์ใน บริษัท และ โรงงานอุตสาหกรรม มากกว่า 10 ปี -VB -Delphi -MS SQL -Oracle -MS Access -Barcode reader, RFID - อุปกรณ์เชื่อมต่อกับระบบคอมพิวเตอร์ I/O Card, Machine controller และ อื่นๆ เรามีความเป็นมืออาชีพ ทำงานเร็ว คุณภาพเยี่ยม คุ้มค่า คุ้มราคาแน่นอน ติดต่อเรา
business profit loss reporting excel(Jan, Feb & March)
-The Excel workbook should comprise multiple worksheets showing the models, the regression analysis summary, the comparison of model performance, the decision tree, and the calculations you used to answer the task questions that require you to complete in Excel USING SOLVER. -report should be mainly for the economic order quantity (EOQ) analysis and the answers to the qualitative questions. No introduction -1900 word report -There should be at least FOUR worksheets in the Excel workbook. Two of them should show the following two demand forecasting methods that you are required to use to forecast the demand of 5 kg ice bags at Caltex, a petrol station in Melbourne. 1. Moving average 2. Static method. for the other two: summary of the regression analysis for the static...
I need an experienced data entry person to perform research on Twitter(X) for crypto/stock twitter influencers/posters with over 1,000 followers who make predictions on crypto/stocks. @CryptoCapo_ is one example of a desired crypto influencer account. I also want you to find stock and crypto prediction Substack accounts, there is no subscriber minimum. It is your job to find other similar accounts and make a spreadsheet with two sheets, one for twitter and one for substack. the twitter sheet will include the twitter handle and the link to their profile for each account. The substack sheet will include the link to the main substack page, the number of subscribers, and whether the substack is free or paid. if the substack is paid, please have different columns for the differ...
I’m seeking a skilled developer to convert my existing PortVB Desktop App into an iOS/Mac Desktop App. It a small tool that runs on a Windows PC and reads some flat XML files and inserts/updates a mySQL database. We need the same program to be able run on a iOS/Mac desktop. I have all the VB Project files/ Source code. - Skills in app development for iOS/Mac, ideally with previous experience in app conversion - Knowledge of data syncing, user authentication, and offline access, in case these features need to be incorporated - Familiarity with contacts management, communication, scheduling, calendar integration, and file/document management functionalities for potential focus areas - Creative design skills to potentially revamp the user interface and overall design of t...
...causing any conflicts. - Need to add additional search filter "Industry" before other search criteria and for this to match jobs or candidates in that particular industry. There are a total of 9 industries on this job board. - Need additional search fields for both Company / Employer, Candidate, Job Search and Filter, Post Job. - I would like to know if it's possible to upload job titles from excel into the job fields for search criteria. - I would also like a place for employers to add job title if it's not in the list. Most is setup in templates, just needing a few additions and changes. Would like additional blank fields that I can fill in later as additional requests are made. - Possibly style search and output pages. I'm open to input from previo...
...a definition of a flowchart e.g. the intended flowchart is attached file It creates an image file of the flowchart. Simple example: See attached file The text file has 3 lines as follows: 1 circle 1.5 5.3,1.2 Begin 2 rectangle 6,2 5.3,2.5 Find node that represents the itemset 3 line 1,2 This file would mean to: 1: Draw a circle with radius 1.5 at point (5.3 across,1.2 down) with the word "Begin" in it. 2: Draw a rectangle with width 6 and height 2 at point (5.3 across,1.5 down) with the words "Find node that represents the itemset" in it. 3: Draw a line pointing from 1 to 2 I don't care how the definition works other than how general it is. The above is just to show what I mean. 1. You could provide the flowcharts that some app allows you t...
As a small commercial general contractor, I'm seeking professional assistance to improve my Excel workbook used for estimates and bids. The ideal candidate for this task should have: - Top-notch Excel skills, specifically understanding VLOOKUP functions and formulas for summing totals. - Experience in creating automatic calculations to streamline my estimation process. - A knack for designing and customizing Excel templates. - A solid understanding of construction or a similar industry would be a huge plus. Specific tasks include: - Building automated calculations for summing totals and utilizing VLOOKUP functions. - Customizing Excel templates, specifically for the cover sheet, project details sheet, and bid summary sheet. Approach this task with a ...
I am actively seeking 50 dedicated women to assist with part-time digital marketing on Facebook and Instagram. Ideal candidates are those with: -No skills required - 10th pass can also apply - work from home opportunity - Training and guidance will be provided This is an exclusive opportunity for women only. If you're looking to excel in a digital marketing role, please place your bid.
...will be immediately cancelled. I must be 100% happy with the results and how the results are being obtained. The team is to work with me to achieve great rankings. If I say something needs tweaked a bit, I expect the team to listen to my desires as long as those desires will reach the end goal. I should see a drastic increase in DA and PA of the website. Post the phrase #seoGuru so I know you read and understand and agree to these terms. Post the sentence in your bid: "I understand and agree to the terms and conditions set forth in the project description. I agree that not following instructions will be grounds for termination and project cancellation without release of any pending milestones." Note I am not willing to change the terms. If you do not like the terms...
I am making a GANTT chart and need to make it highlighted. the chart is created using highlight formula instead of using basic insert chart option. I need help to do a part of it. Video explanation of the problem: Excel file I am working on is attached: The ideal chart should look like the attached image: Looking for the cheapest service as this is almost done.
I am seeking a skilled web developer to create a dedicated real estate we...information (photos, descriptions, amenities, rental terms, etc.). Interactive Listings: A "React" button under each listing allowing users to express interest in a property. Upon clicking the "React" button, the user's interest should be sent directly to our email, including details about the specific listing and the user. Search Functionality: An intuitive and easy-to-use search option for users to find properties based on various criteria (location, price range, property type, etc.). Filters and sorting options to enhance the search experience. Admin Dashboard: A backend dashboard for managing listings, user accounts, and tracking user interactions. Ability to add, edit, and de...
I'm looking for a logo designer to create a playful and fun logo for , an advertising platform aimed at helping girls find jobs in the adult industry. The ideal logo style should be playful and fun, while still maintaining professionalism. It should appeal to our target audience - women looking for job opportunities in the adult industry. Key points to consider: - The design should be bright and vibrant, to attract attention and make a statement. - The logo should include a symbol related to the adult industry, whilst remaining tasteful and not explicit. - The design needs to be modern and unique, setting us apart in this competitive market. - The end result should be a memorable and professional logo that represents our brand effectively. Skills and experience in creating
...e-commerce potential. Key Points: - The domain is ideal for e-commerce purposes, which makes it a great opportunity for someone in the online sales space. - I'm particularly interested in connecting with individual entrepreneurs, small to medium businesses, and potentially large corporations who are searching for a domain that fits an e-commerce website. I'm looking for someone who can help me find potential buyers and close the sale. This job will require: - Strong networking skills and an understanding of the e-commerce industry. - Experience in domain sales or similar areas. - The ability to identify and connect with potential buyers in the specified categories. If you have experience in these areas or believe you can effectively market this domain to the right ...
...visually appealing pamphlet. This pamphlet will be used to showcase the various service plans and benefits offered by our HVAC company. The goal is to clearly communicate the value and benefits of our services to potential and existing customers. Project Scope: Design and Layout: Create a visually appealing and professional design that aligns with our brand identity. The pamphlet should be easy to read and navigate, with clear headings, subheadings, and bullet points. Incorporate high-quality images, icons, and graphics to enhance the visual appeal and readability. Content Integration: Use the provided content from our three service plans (Basic Care Plan, Enhanced Care Plan, and Premium Care Plan) to populate the pamphlet. Ensure the content is clearly and accurately represen...
I'm in need of a freelancer to assist with labeling text tweets by topic (to aid in machine learning research). Key Requirements: - Labeling 1,000 tweets as to whether they are about the topic sustainability - Must be labeled by hand (no machine learning or AI) by a native English speaker Task: -Open the attached spreadsheet -Read the FULL TEXT of each tweet. Also read the brand handle and sector for reference. Make sure to pay attention to any hashtags included. -You do not need to open any URLs. Make your judgment based only on the text. -If the tweet is about sustainability, enter "1" in column E. If it is not about sustainability, enter "0" in column E. -Note that "sustainability" is a broad topic -- it is often a judgment call as to...
I'm looking for an experienced professional who can create a custom Microsoft Excel spreadsheet for me. This spreadsheet will be designed to generate GUIDs (Globally Unique Identifiers) in a random fashion. The GUIDs will be used for database record identification. Key Requirements: - Development of a custom Microsoft Excel spreadsheet. - Implementation of a random GUID generation mechanism. - Ensuring the functionality for database record identification. Ideal Skills & Experience: - Proficiency in Microsoft Excel, particularly in custom formula creation. - Strong understanding of GUIDs and their usage in database systems. - Previous experience in developing similar solutions. I'm looking for someone who can deliver a well-functioning and efficient sol...
I'm seeking an experienced Excel professional to assist with a small data entry project. Key Responsibilities: - Data entry with formulas: You should be proficient in Excel and comfortable working with spreadsheets that require formulas. - Handling digital data: You will be provided with data in a digital format, likely an Excel or CSV file. Ideal Skills: - Advanced Excel skills: You should be well-versed in Excel, particularly in data entry and formulas. - Attention to detail: Precise data entry is crucial for this project. - Efficient and organized: I'm looking for a freelancer who can manage their time and workload effectively. Please note that this is a straightforward project with no requirement for data analysis or visualization. A h...
I am seeking an experienced Excel expert to help resolve an issue with a percentage calculation in my Excel spreadsheet. Despite following standard procedures, the result is incorrect, and I need assistance to identify and correct the problem. Details: I am working with the following data in my spreadsheet: Total Costs for the Job (Cell V14): $241,779.50 Total Collected (Cell V17): $289,844.00 Profit (Cell V15): Calculated as =V17 - V14, resulting in $48,064.50 I need to calculate the profit as a percentage of the total costs, and this should be displayed in cell V16. The formula I am using is: = ( ? 15 / ? 14 ) ∗ 100 =(V15/V14)∗100 Given the values: = ( 48 , 064.50 / 241 , 779.50 ) ∗ 100 = 19.88 % =(48,064.50/241,779.50)&...
We are seeking a skilled freelance writer to create comprehensive documentation and set up demo data for our company's Customer Relationship Management (CRM) processes. The primary responsibility will be to research and document our existing CRM workflows, procedures, and best practices, as well as create sample data for demonstration purposes. Responsibilities: Collaborate with our CRM team to understand our current processes and requirements. Conduct thorough research and gather necessary information. Write detailed, step-by-step instructions and guidelines for various CRM processes. Ensure documentation is easy to understand and follow for both new and experienced users. Organize and structure the content logically for efficient reference. Maintain consistency in writing style, t...
We are seeking a skilled graphic and logo designer to recreate 5 logo designs based on provided samples and instructions. This project offers an excellent opportunity for designers to showcase their creativity and attention to detail. Responsibilities: Recreate 5 logo designs using the provided JPG files and instructions in a Word document. Follow the given logo concepts, sample designs, and color combinations closely. Make minor adjustments or enhancements as per the specified instructions. Ensure high-quality output and pixel-perfection in the final designs. Requirements: Proficiency in Logo designing Ability to interpret and execute design instructions accurately. Willingness to collaborate and incorporate feedback. Compensation: Fixed budget of Rs. 1000 INR for all 5 logo designs...
I need to make updates to userform so that empty dates do not affect filter on table. Right now leaving date field empty hides all the rows of table. Few more updates needed and more details will be shared with selected freelancer.
*Please read this carefully before applying for this job.* The ideal candidate/team will have worked on YouTube automation channels before with measurable success, have extensive knowledge of Youtube guidelines/copyright rules/fair use policies, strong drawing skills. We Want to Work With You If: - You have experience in creating high quality art work. - You understand psychology behind thumbnails - You can analyze competition and their thumbnails & create your own best version - You understand how to draw viewers in with an interesting and emotional art work to use for thumbnail. - You have experience working under tight deadlines - You are committed to high quality without the need for lots of revisions. - You are organized, communicative and have fast turnaround times. - Y...
I'm looking for a data scraping specialist proficient in leveraging social media platforms, business directories and website scraping. The goal is to create an Excel sheet with approximately 500 entries for market research purposes. Skills & Requirements: - Proficient in data scraping from multiple sources - Capable of filtering and sorting data - Able to extract and compile the following data fields: zip codes, locations, contact information, business name and industry. The successful candidate should demonstrate experience in similar projects, showcasing their ability to find and compile information efficiently and accurately for market research purposes.
...available on both iOS and Android platforms. Key Features: - User Profiles: Users should be able to create and maintain profiles showcasing their work and experience in the movie industry. - Push Notifications: The app should feature push notifications to keep users informed about job opportunities and industry news. - Search Functionality: A robust search functionality is crucial for users to easily find relevant job postings. Ideal candidates should have experience in app design, particularly in developing user-centric and intuitive interfaces. Knowledge of job portals, or similar platforms, will be an added advantage. Your work will directly impact the careers of budding movie industry professionals, so a keen eye for detail and a passion for the entertainment industry will ...
This is my website link I have used "Classima – Classified Ads WordPress Theme" theme. I want to upload date from xls sheet. Excel attached for your reference. Raduus Theme is not providing support and they only provides category and location import options. Can you help me to import data
...will enhance the content of the magazine. For the Ad Campaign: - The ad campaign should be separate from the magazine, but still aligned with the magazine's target demographic. - I am interested in promoting our rv resort using billboard and signage. Thus, experience and creativity in creating compelling outdoor advertisements is crucial. - The campaign aims to drive traffic to purchase or read the magazine, so understanding of effective call-to-actions and market strategies in this setting is preferred. The ideal candidate for this job would have experience in both magazine production and outdoor advertising, with a keen understanding of how to tailor content to the business audience. Most importantly, I am looking for someone who can bring creativity and fresh id...
I'm in need of a skilled UI/UX designer for a medical app I'm developing. The app will be available on both iOS and Android platforms, and is designed to prov...work that demonstrates your ability to create intuitive and visually appealing interfaces. - Familiarity with best practices in mobile app design, including responsive design principles and platform-specific guidelines for iOS and Android. Preference will be for designers who have attention to detail, so the designer will need to mention sky blue in their response/proposal to understand that they read the description. Any response missing sky blue will be rejected. Your role will be crucial in ensuring the success and user-friendliness of the app, so please provide samples of your previous work related to this pr...
I'm in search of a proficient freelancer who has expertise in utilizing MATLAB R2021a for complex Image Processing tasks. As my requirements are quite specific, it is crucial that the preferred candidate has in-depth knowledge of this software and can make the most of its advanced features. Key Responsibilities: - Conduct comprehensive Image Processing tasks - Utiliz...R2021a - Significant experience in Image Processing - High problem-solving skills using MATLAB Given the specificity and technical nature of this job, candidates who can showcase samples of their previous work with MATLAB, specifically in Image Processing, will be prioritized. This is an opportunity for seasoned MATLAB users; those with a more superficial understanding of the software may not find this pr...
I've got a list of company names on an Excel sheet that I need you to help me with. Here's how you can assist: - **Scraping from Multiple Platforms**: I need you to scrape email addresses, phone numbers, and any available social media accounts of these companies. You'll need to do this across Yelp, Google Maps, and TripAdvisor. - **Social Media Scraping**: In addition to the primary two platforms (Instagram and Twitter), I'll also need you to scrape Facebook accounts if available. Ideal candidates for this project should have: - **Web Scraping Experience**: A good knowledge of web scraping techniques and tools, which will ensure you can obtain accurate and reliable data. - **Data Mining Knowledge**: The ability to identify and extract the necessary data points...
I'm seeking an exam invigilator with at least a Bachelor's degree to administer an on-site exam in Nottingh...to see if they are available to assist test takers for their approved accommodations. We provide complete training and assignments pay hourly for the entire scheduled time, even if the exam ends early. We have a computer exam coming up where a test taker has been approved for a Reader and input assistance. For this assignment, you are required to be present on-site, sit with the test taker, and read the exam content aloud. You will then enter the answers as instructed by the candidate. The exam is taking place at a professional testing center in Nottingham, UK. Date: Thursday, 23 May, 2024 Time: 12:15 pm to 2:15 pm We provide full training, and this assignment...
