Vba excel lock columns refreshing sheetงาน
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
พิมพ์สูตรคณิตศาสตร์ได้ ตัวอย่างงาน
...delete - Design Web Page เรียบง่าย ใช้งานสะดวก ไม่เน้นลูกเล่น มี Concept , มีรูป ให้ 1. รถยนต์มือสอง 1.1 Download excel file format การกำหนดราคา รถยนต์มือสอง 1.1.1 Download excel file ใน Format ของการกำหนดราคา โดยเลือกเงื่อนไขได้ 2 วิธี 1.1.1.1 เลือกตามยี่ห้อ สามารถเลือกได้มากกว่า 1 ยี่ห้อ 1.1.1.2 เลือกตาม segment เลือกได้ครั้งละ 1 segment 1.1.1.3 ถ้ามีราคาที่เคยกำหนดในระบบให้แสดงด้วย 1.1.2 แสดงรุ่น รุ่นย่อยทั้งหมดตามเงื่อนไขที่เลือกด้านบน 1.1.3 แสดงข้อมูล 1 sheet ต่อ 1 ยี่ห้อ 1.2 Upload excel file การกำหนดราคา รถยนต์มือสอง 1.2.1 สามารถ Upload การกำหนดราคา รถยนต์มือสอง จาก excel file ในขั้นตอน Download เพื่อเพิ่มหรือปรับปรุงราคา รถยนต์มือสอง ...
ต้องใช้ imacro คัดลอกข้อมูลจาก web site ลง excel
คีย์ข้อมูลต่างๆลง Excel การคัดลอกบทความต่างๆลง word
ทำ presentation งานโดยใช้ Powerpoint สามารถแทรกงานที่เป็นข้อมูล ตารางและกราฟ จาก data ที่เป็น Excel
...experienced web developer to repair and implement a function that allows users to download free sheet music after registering via a pop-up form. The pop-up form should collect user details and ensure the visitor is added to the mailing list via the Arigato Pro plugin, but only if the visitor is not already registered. The issue is currently present on certain pages of our website, , including the page “A Minor Indulgence – Free Sheet Music for the Flute.” Key Responsibilities: -Repair Existing Function: Replicate the working functionality of the download button from the page Free Sheet Music for the Flute – A Minor Indulgence to the page A Minor Indulgence, by Andrew Scott – Free Sheet Music for the Flute. -User Registration and...
...lounge, such as: - Lounge Name - Airport Name & 3-Letter Airport Code (IATA) - Terminal and other location details - Access Type (e.g., airline-specific, membership programs, or pay-per-use) - Operating Hours - Amenities and services offered - Ensure all data is accurate, up-to-date, and categorized appropriately. Deliverables: - A structured CSV file containing the compiled lounge data, with columns clearly labeled and formatted for easy use. Ideal Candidate Qualifications: - Proficiency in Research and Data Collection: Strong ability to gather, verify, and organize information from multiple sources. - Familiarity with Airline and Lounge Systems: Knowledge of airport operations, frequent flyer programs, and lounge networks (e.g., Priority Pass) is highly advantageous. - ...
...planning tools using integrations with Smartsheet, Excel, Utrakk, and other tools as specified below. This project is focused on improving efficiency, minimizing manual tasks, and providing me with actionable insights. Key Features and Requirements: 1. Task Management Automation • WW Team: a) Automatically retrieve daily orders from Smartsheet and export them into Excel. b) Create an editable Excel sheet for my team to update their progress on orders. c) Generate KPIs such as: • Completion times for orders. • Missing parts or delays per order. d) Provide a clear summary of completed orders. • PP Team: a) Download two sheets (latest status of orders and a new list of orders). b) Organize them in chronological order in an Excel...
...Energy, and we create an energy drink made with fruit juice, lion’s mane, maca root, ginseng, and natural caffeine. There are no added sugars, artificial colourings or flavourings. The drink not only boosts energy but enhances focus too. We started off as a small production made to help the founder and his friends with focus to overcome ADHD. Now we are ready to launch to the public. We are a more refreshing alternative to coffee and a healthier alternative to RedBull, Monster, etc while still having a bold flavour. The drink is Non-carbonated to feel more fresh and natural. Requirements: Logo: At least two options, one text based and one icon based. The brand should be modern, fun, and friendly, while also showing clearly that it is a healthy energy drink. Branding Guidel...
I need assistance with finding product codes (SKU and size in either US or EUR and link for a proof) for 4100 EANs. The data should be sourced from Google or VERY easy because 2 /3 brands only Key Requirements: - Data processing and research skills - Experience with Excel/CSV - Ability to follow a specific format for data input I will provide the EANs in a spreadsheet (Excel/CSV) and I already have a format for the SKU and size. This is a straightforward project that requires basic data input and online research. Please be prepared to work meticulously and efficiently.
Are you an experienced graphic designer with a proven track record in creating outstanding Amazon content? We are looking for top-tier professionals who excel in designing as well as creating captivating product images and brand content, including A+ Content and Brand Stores. We are particularly interested in working with forward-thinking designers who use AI tools for bulk image generation like Midjourney, Dezgo, Adobe Firefly, and equivalents to create compelling, emotion-driven product visuals —without the need for complex photoshoots. Bonus points if you also have expertise in digitally creating product videos to enhance listings further. What we’re looking for: - Extensive experience in designing Amazon-specific content. - A deep understanding of Amazon’s ec...
I need an expert in Excel 365 who can link two sheets for me. The first sheet should update the second in real-time. - Data Type: The data to be linked is mixed, consisting of both text and numerical data. - Version: The linking has to be done in Excel 365. Please only reach out if you're proficient in Excel and can ensure real-time data linking. Thank you.
...hls player to show live stream - add stream, support multi source setup, select gpu , select profile for transcode, select output http stream/rtmp stream output *( rtmp,rtsp,rtp,rtmpe, udp,http,mpegts,ts,hls,dash all protocols) - profiles for transcoding (attach to gpus) (all settings for best quality streaming (all codecs) - multi gpu support - create/userpass for watch http stream/rtmp streams /lock to ip not able to view from other ips. - show current connected connections by username/connected channels/country flag - show users/ online/offline / disable users/ kick connection user (disconnect all connections)/ban user - create stream bouqets /categorys, add streams to categories, user limit access to wach selected stream categories. - advanced export playlists mutli option ( ...
I need a skilled Excel professional to clean up the formatting in my Excel document so that "amount" and "total" columns are formatted consistently (centered or justified to right) and ensure that existing formulas in "amount" columns calculate to amounts in "total" columns. Create formula for all "total" amounts to calculate and produce grand total at end of doc. The project involves adding new formulas ensuring that newly inserted data is added to "amount" colum that the numbers will automatically calculate and be added to the totals, similar to the setup at the beginning of the document. When in doubt please ask questions. This is a small project with a deadline of end of day to late evening S...
...c. Contact Information: i. Contact Person’s Name ii. Contact Person’s Title iii. Mobile Number iv. Main Number v. Email Address 2) Specific NGO Focus: Ensure the search targets Muslim-based NGOs only. 3) Use array aggregation to optimize credit usage, grouping multiple data points into a single data object. 2. Output Requirements: 1) Export the aggregated data into Excel format. 2) Automatically upload the Excel file to a designated Google Drive folder. 3) Provide sample outputs for the following locations: a. Malaysia, Selangor b. Indonesia, Jakarta c. Thailand, Bangkok d. England, London 3. Documentation: 1) Create a Microsoft Word instruction manual covering: a. How to run the workflow. b. Adjusting search parameters for countries, states, and categories. c...
I have multiple Excel files that need to be consolidated into a single Excel workbook. Each file should be placed in a separate sheet named according to its original file name. No data transformations or cleaning are required. Ideal skills for this project include: - Proficiency in Microsoft Excel - Experience in data consolidation tasks - Attention to detail to ensure correct file placement and naming.
...Constraints: The report will be provided to the manager within 3 seconds. The report will include all tasks marked as "Completed" or "In Progress." Displaying the report: The system will present the report clearly and orderly, including graphs and statistics. Constraints: The system will ensure the report loads within 5 seconds without delay. The system will allow downloading reports in PDF or Excel format. 6. Use Case: Smart Recommendations for Employees or Managers User Actions: Requesting a smart recommendation: The manager or employee can request the system to provide a suggestion for improving or optimizing work. Constraints: Recommendations will be provided only after the system has gathered sufficient data on projects and tasks. System Actions: Collec...
Proposal for building a new scraper which contains feature. all sku from google sheet 2. Go to Website tradezone and serach for SKU 3. Fetch data like price and other required details. 4. Save Scraped data back to Google sheet Apart from all other feature you will get a two month of support as well.
I'm looking for someone to collect and verify data of CEOs and Managing Directors from the provided link. The total will be data from 3900 companies. Data Requirements: - Full name and title - Email and contact number - Company address Please check the Google sheet and make a sample of 10. If the sample is satisfactory, we can continue with the project. The highlighted columns in yellow are the ones I need. Budget is fixed, please only bid if you agree with the budget.
Hello, I have experience in Python, web scraping, and data extraction using tools like Scrapy, Pandas, and Selenium. I can quickly debug your script and ensure it meets all your requirements. Here’s how I plan to help you: ...data extraction using tools like Scrapy, Pandas, and Selenium. I can quickly debug your script and ensure it meets all your requirements. Here’s how I plan to help you: 1. Fix bugs in your script within 2-3 hours. 2. Add functionality to match conditions and extract data as per your requirements. 3. Provide an easy-to-use script for future use. I will deliver the output in the required Excel format. Looking forward to your response so we can start immediately! Budget: $8 (as per your project description). Timeframe: First phase within 2-...
# Job Title: Submit Job Applications on Job portals using my Resume # Job Description: I am looking for a reliable freelancer to submit job applications on my behalf usi...postings on Linkedin, Glassdoor, Workday and Indeed that match my experience and skills. - Submit my resume to the job listings - Ensure each application is relevant to my background and experience. - Track and report the total number of applications submitted using MS Excel or Google Sheets # Requirements: - Strong attention to detail and understanding of different job roles. - Ability to follow instructions and submit applications appropriately. - Good communication skills for reporting progress. - Experience using MS Word, MS Excel, Google Doc, Google sheets. # Compensation: - $10 for every 100 applic...
...proficient Excel VBA programmer to create a script for my Purchase Order workbook. This project involves both an existing workbook and the creation of a new one. The VBA script should be triggered automatically when the workbook opens. Key Tasks: 1. Implement filters at the top of the worksheet. 2. Adjust the width of Column C (Products). 3. Insert new columns with specified modifications: a. After Column I: Discrepancy (using formula: =I2-H2) b. After Column J: Reason (with a dropdown list sourced from the next sheet) c. After Column K: Notes (a free text column) 4. Apply specific formatting to the columns: a. Column A: 40 points b. Column B: 10 points c. Column C: 60 points d. Column D: 35 points e. Columns E-J:...
I'm seeking a professional engineer to design a TPE sheet extrusion machine meant for industrial production. The machine needs to be capable of processing Thermoplastic Elastomer (TPE) and producing sheets with a width of 1800 mm. Key project specifications: - Design must cater to industrial-scale production - Compatible with Thermoplastic Elastomer (TPE) - Producing sheets of 1800 mm in width Ideal candidates should have extensive experience in machine design, particularly for industrial production, and knowledge of TPE materials. A portfolio demonstrating past successful designs will be highly advantageous.
I'm seeking an expert in plastic sheet extrusion machine design. The primary objective of this project is to create a machine capable of producing TPE sheets, which will be used specifically for the manufacturing of car mats. Key Requirements: - Design of a plastic sheet extrusion machine - Specific focus on TPE sheet production line - Should have experience working with some machine manufacturing company
I'm in need of a seasoned Chartered Accountant who can effectively analyze my business...effectively analyze my business's annual financial performance. Your main responsibilities will entail: - Creating a comprehensive summary of all the profits and losses I've encountered over the year. - Providing a detailed breakdown of the Balance Sheet, Cash Flow Statement, and Equity Statement. I will provide you with full access to my accounts. The final report should be delivered in an Excel spreadsheet. Ideal candidates should possess: - Extensive experience in financial analysis. - Proficiency in creating detailed and understandable Excel reports. - Prior experience working with small to medium-sized businesses. Please include examples of similar project...
I'm seeking a skilled Excel programmer to create a macro. This macro should compile various employee data from different sheets into a new Excel sheet. The task involves data cleaning, analysis, and report generation. Key Requirements: - Experience in Excel macro development - Understanding of data cleaning and analysis - Ability to generate summary reports, pivot tables, charts and graphs - Familiarity with handling employee data Please note, the goal is to create a macro that can automate this process, saving time and ensuring consistency in data compilation.
I'm looking for someone to create several spreadsheets that display various financial metrics related to shipments of multiple grades across different countries. The sheets should track specific details for each shipment and highlight key insights. Ideal Skills: - Proficient in Excel or equivalent spreadsheet software - Strong understanding of financial data - Ability to visualize data clearly and concisely Specific Requirements: - Track shipment dates - Monitor product grades - Keep a record of destination countries - Provide an overview of which grade has moved the maximum - Include quantities and other relevant data - Need charts and graphs to represent the data as well - Pivot tables and more. These spreadsheets will be instrumental in helping me understand the financia...
I'm seeking a professional with extensive experience in cybersecurity and data analysis to build a consolidated vulnerability report and accompanying dashboard. Requirements: - The report should encompass ne...professional with extensive experience in cybersecurity and data analysis to build a consolidated vulnerability report and accompanying dashboard. Requirements: - The report should encompass network, application, and database vulnerabilities. - The final report should be delivered in Excel format. - The dashboard should visualize: - Vulnerability trends over time - Severity of vulnerabilities - Overview of affected systems Ideal Candidates: - Proven experience in cybersecurity. - Proficient in data analysis and Excel. - Previous work with creating security...
I need a skilled Excel expert to perform a Chi-Square Analysis on my survey data for a school statistics project. The main focus of this project is data analysis. Please have a strong background in statistics and Excel, with prior experience working with survey data. Your understanding of Chi-Square Analysis is crucial for the success of this project.
I need a skilled Excel expert to perform a Chi-Square Analysis on my survey data for a school statistics project. The main focus of this project is data analysis. Please have a strong background in statistics and Excel, with prior experience working with survey data. Your understanding of Chi-Square Analysis is crucial for the success of this project.
I'm looking for a comprehensive search for M&A advisory firms across Southeast Asia, specifically in Singapore, Malaysia, Thailand, Indonesia, Philippines, and Vietnam. Key Requirements: - The search should encompass all types of firms: local, international with local offices, and boutique firms. - The information gathered shoul...and boutique firms. - The information gathered should include, for each firm: - Name of company - Contact details - Services offered - Client portfolio - The final output should be a detailed spreadsheet with all the information. Ideal Skills: - Proficient in internet research - Experience in business analysis - Familiarity with M&A advisory firms is a plus - Proficient in Microsoft Excel or similar spreadsheet software. Lookin...
I need help finding high-quality, freely available downloadable dataset/links on consumer behaviour...ready-to-eat or cooked food. Also, I need assistance in creating related questions on which the dataset is based. The datasets/questions should be in Excel format. Key Aspects of Consumer Behaviour to Explore: - Purchase frequency - Brand preference - Consumption patterns - Additional parameters for in-depth analysis Other Considerations: - Demographic information - Spending habits - Product satisfaction - Sustainability considerations - Customer satisfaction The freelancer will also be required to assist in formulating relevant questions based on the dataset. Ideal skills for this project include: - Data analysis - Market research - Excel proficiency - Understanding of c...
