Loading csv access using 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 วันให้ทั้งแถวเปลี่ยนเป็นสีแดง
ผมต้องการทำ Google data studio เพื่อแสดงข้อมูลรายงานรายได้ ค่าจอดรถของผม ซึ่งผมมี เวป คราวที่สามารถดึง CSV ออกมาได้แล้วก็นำมา สร้างเป็นหน้ารายงานสรุป
...สามารถ 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)
หาข้อมูล 16 อย่างของ Blogger จาก 50 fanpage แล้วกรอกลงให้ excel ที่กำหนดให้
ต้องการวิศวกรงานระบบ cctv, access control, telephone, internet, turnstile, data center, fire alarm คุณสมบัติ 1. ออกแบบ, ถอดแบบ, งานระบบสื่อสาร ระบบ security 2. ประเมินหน้างาน 3. ทำใบเสนอราคา, ประสานงาน suppliers 4. ควบคุมงาน, ควบคุมช่าง 5. ไม่ต้องประจำออฟฟิศ, ทำงานที่บ้านได้ แต่ต้องออกหน้างานเมื่อต้องประเมินราคา หรือต้องเข้าควบคุมงาน 6. โบนัสจากโปรเจคที่คุม สนใจติดต่อ คุณหน่อย (Removed by Freelancer.com admin)
ต้องการวิศวกรงานระบบ cctv, access control, telephone, internet, turnstile, data center, fire alarm คุณสมบัติ 1. ออกแบบ, ถอดแบบ, งานระบบสื่อสาร ระบบ security 2. ประเมินหน้างาน 3. ทำใบเสนอราคา, ประสานงาน suppliers 4. ควบคุมงาน, ควบคุมช่าง 5. ไม่ต้องประจำออฟฟิศ, ทำงานที่บ้านได้ แต่ต้องออกหน้างานเมื่อต้องประเมินราคา หรือต้องเข้าควบคุมงาน 6. โบนัสจากโปรเจคที่คุม สนใจติดต่อ คุณหน่อย (Removed by Freelancer.com admin)
พิมพ์สูตรคณิตศาสตร์ได้ ตัวอย่างงาน
ต้องใช้ imacro คัดลอกข้อมูลจาก web site ลง excel
คีย์ข้อมูลต่างๆลง Excel การคัดลอกบทความต่างๆลง word
hacking on a whatsapp account without access to the target's phone
ทำ presentation งานโดยใช้ Powerpoint สามารถแทรกงานที่เป็นข้อมูล ตารางและกราฟ จาก data ที่เป็น Excel
...ทับซ้อนกัน สามารถย่อ-ขยายภาพได้ จะไม่มีการ rotate(หมุนภาพ) เนื่องจากข้อจำกัดด้านกราฟฟิค เมื่อทำการขยายภาพ ภาพแผนที่จะเปลี่ยนจากตัวlayerที่มีความละเอียดต่ำกว่าไปเป็นตัวlayerที่มีความละเอียดสูงกว่า (หากเป็นไปได้ อยากให้มี animation การเปลี่ยนภาพ เป็นแบบ fade in และ fade out ภาพที่ความละเอียดต่ำจะค่อยๆเลือนหายไปในขณะที่ภาพที่มีความละเอียดสูงค่อยๆปรากฏขึ้นมา )* 2 หากตัวอุปกรณ์ support location access ให้ใช้ Location Manager บอกตำแหน่งของอุปกรณ์นั้น บนภาพแผนที่ offline (มีการระบุbearingหรือไม่ก็ได้)* ปริมาณงาน : ในแอพพลิเคชั่นประกอบไปด้วยจำนวนหน้าpageดังนี้ หน้าหลัก 1 หน้า ไว้ให้userเลือกแผนที่ที่ต้องการ ออกแบง่ายๆมีเพียง button link ไปยังหน้าอื่น หน้าแผนที่ 8 หน้า ประกอบไปด้วย แผนที่ offline 3 layer จำนวน 3 หน้า แผนที่ offline 2 layer จำนวน 4 หน้า ...
รับเขียน ออกแบบ แก้ไข software ทุกประเภท ทั้งงานทั่วไป และ ในโรงงานอุตสาหกรรม ประสบการณ์ใน บริษัท และ โรงงานอุตสาหกรรม มากกว่า 10 ปี -VB -Delphi -MS SQL -Oracle -MS Access -Barcode reader, RFID - อุปกรณ์เชื่อมต่อกับระบบคอมพิวเตอร์ I/O Card, Machine controller และ อื่นๆ เรามีความเป็นมืออาชีพ ทำงานเร็ว คุณภาพเยี่ยม คุ้มค่า คุ้มราคาแน่นอน ติดต่อเรา
...developer to implement a web-based Uno card game. The project involves multiple layers and components, all of which need to be developed from scratch. Key requirements: - Database Layer: You will need to integrate sqlite for data storage and retrieval purposes. - DAO Layer: Implement a Data Access Object layer for connecting the business logic with the database. - Server Layer: Develop a RESTful web service to manage the game's logic and handle user interactions. - Frontend: Create the game's user interface using JavaScript, CSS, and HTML. The design should be moderate, with pleasing aesthetics and some animations. Importantly, use only the library for this purpose (). Modify this to match UNO Card Game. You can also use jQuery. No more framework
Looking for an expert who can bring my educational content to life with vibrant, engaging 3D animations. The animations should be a blend of character-based and abstract to maintain viewer interest. Key Requirements: - Skilled storyteller through 3D animation. - Experience in character-based and abstract animation. - Excel in conveying complex information simply and clearly, ideally within an educational setting. - Ability to work collaboratively, ensuring your creations align with my vision. Enhance your bid with relevant work samples, especially animations used for educational purposes. I am excited to see your creativity at work!
I need to outsource the API connection to various e-commerce platforms to retrieve data for reporting, using Python. Here is the list of platforms I need to connect to: 1/ Shopee 2/ Lazada 3/ Google Ads 4/ TikTok 5/ Tokopedia Requirement: a demo of a project you have previously connected that is on the list You can choose one or all platforms to outsource.
I'm seeking a professional with extensive experience in uploading apps to Google Play Store. The app I need to be uploaded is already developed and ready for deployment. It is a Social Media app that requires the following permissions: - Location access - Camera access - Microphone access - Storage access - Photos and videos The ideal candidate should have a strong understanding of Google Play Store's policies and guidelines, and be able to ensure the app complies with these standards. Moreover, they should be able to efficiently manage and configure the permissions the app requires, ensuring user privacy and security are maintained. Experience with similar apps and a strong track record of successful uploads is a plus.
I'm looking for an experienced freelancer to help me configure the folder and file permissions for a specific website on CyberPanel. Key Requirements: - The main goal of this task is to ensure the website's functionality is not hindered by strict security measures. - The website should have specific folders and files with read-only access, and others with read and write access. - Experience working with CyberPanel or similar control panels is essential for this project. In your application, please highlight your relevant experience with similar tasks. Note: Please focus on experience in your application, rather than detailed project proposals. Thanks.
Confirmis ( ) is a Singapore-based business information provider specializing in connecting businesses with global capabilities; comprised of industry veterans, Confirmis business model is designed to ov...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 accomplish (excluding travel time) REQUIREMENTS: • Must be living in (or nearby) Pangasinan, Philippines • Has a camera or phone/tablet of quality with a camera, internet access Note: Payment will be released the following week after the site visit to give us time to organize the report and contact you if we need additional c...
I need a joomla informational website for a business that does construction work, mainly masonry work. I will provide: 1) the websites logo () 2) access to cpanel 3) website needs to be delivered in 4-6 days The website should: 1) be mobile ready 2) should have a contact form displayed on every page so that customers can request free estimates. These will be the fields: name, phone, email, address, description 3) The phone number and address should be displayed on the top, always visible 4) the message 'Licensed and Insured' should be on top and visible 5) ability to easily edit text and upload pictures from backend These will be the website menus: 1) home 2) patios 3) stoops & steps 4) walkways 5) driveways 6) retaining walls 7) brick & stone veneers 8) More a) ...
...coast region of Australia. Key Information Required: - Contact details: I need a name of the person who manages the trucks their phone number. - Geographic location: It's important to know where these individuals or companies are located. - I need the company name The final list should be delivered in an Excel spreadsheet. Ideal Skills and Experience: - Strong research abilities: The ability to dig deep and find the right contacts in these specified industries. - Proficiency in Excel: The ability to compile and present the data in an organized and clear manner. - Understanding of the target industries: Experience in or understanding of the Transportation and logistics, Construction, and Agriculture sectors would be a big plus. Please let me know about any past ...
...leads by contacting the customer by calling or messaging them to scheduling a zoom call using Calendly. The states will depending on the states you hold an active license in. (I will help you get your Non-Residence license in the states you get clients) #2 Agent Acquisition Specialist. I am looking for someone to scout for people looking for jobs that allows them to excel in the company quickly. I am looking to hire 10 more agents just like you. Or agents with potential in any state (CLOSERS). This position with require you to generate your own leads for potential life insurance agents screen them for the criteria listed above, and book the potential agent on a zoom call with me or one of my staff using Calendly. Please note that these agents will not be you...
...to capture high-quality, captivating images of a property. The photos will mainly be used for the property listing. Key Requirements: - Expertise in real estate photography, particularly in Interior and Exterior photography - Previous experience with real estate listing photos is a big plus - A good understanding of lighting, angles, and composition to highlight the property's best features - Access to professional-grade photography equipment Your responsibilities: - Conducting a thorough pre-shoot inspection of the property to plan the shoot - Capturing high-quality, edited images of the property's interiors and exteriors - Ensuring the photos meet industry standards and are suitable for a property listing - Providing the edited photos in a timely manner Ideal Skill...
I have Excel sheet in the are all products added with all the categories in it. I will also share a word file in which I will add that specific category and you have to take out the data from sheet and create the image in Photoshop. I will also give you product images with it's specific name. You have to only remove background and add text and image according to the data. The person must have latest Photoshop and have to create one sample image. You have to leave the space also for the main video and have to choose a shape or space according to the data Here are the links to sample: My budget is Rs.50 per image. There are 10-11 images which you have to create and I need it by today. This
I need a compact and efficient RFID decoding device that can effectively handle access control duties. We have multiple RFID 1k cards which are encrypted. We want to decrypt the card and should be able to edit the data in it Key Requirements: - **RFID Support**: The device should be able to work seamlessly with Low Frequency (LF) RFID tags. Such as mifare 1k. RFID 1k card - **Wi-Fi Connectivity**: if required it should have Wi-Fi capabilities to enable remote access and data management. Ideal Freelancer: - Proficient in RFID technology. - Experienced with access control systems. - Skilled in hardware development and connectivity. - Ability to create a compact and user-friendly device.
On my recent trip to Iceland, I managed to capture some potentially stunning landscapes with my DSLR. Unfortunately, the images when downloaded are pixelated, blurry and do not display correctly. Around 50-100 images I require a proficient, experienced Photoshop or Camera expert to help: (Not sure if this wo...exact dimensions for the final output, I demand for the results to be in the highest possible resolution. This would mean that they can be suitable for various display sizes from smaller picture frames to larger canvases. Your portfolio or samples of previous similar tasks would be the key to winning this assignment. Looking forward to seeing the photo miracles you can perform. I also have access to the photoshop, etc. if this helps! Not sure how to solve this speci...
I need a professional...- Extracting: I require the following contact information to be extracted: Business Name, Email, Phone number, Full address separated by suburb, postcode and state. - Formatting: All extracted data should be structured and organized into an Excel spreadsheet. Ideal Skills: - Web Scraping: Proficiency in web scraping tools and techniques is essential. - Data Entry: Experience with data entry and extraction. - Attention to Detail: Accuracy in capturing and organizing contact details is crucial. - Excel Proficiency: Ability to create and format an Excel spreadsheet effectively. - Communication: Regular communication and updates on the progress of the task would be appreciated. I'm looking for a reliable freelancer who can deliver this tas...
I'm in need of an experienced Java Selenium APIs tutor to help me automate test cases for two business web applications. Requirements: - Expertise in Java programming and IntelliJ for test automation. - Proficient in Selenium and APIs, particularly in creating automa...for test automation. - Proficient in Selenium and APIs, particularly in creating automation scripts. - Knowledge of Cucumber for implementing BDD framework. - Ability to guide and advise on the automation process. This is a collaborative effort, I'm looking for someone who can not only help automate my test cases, but also teach me how to do it effectively. Also due to Coles VPN and restricted access, the job has to be online with connecting to my computer either through meetings with share screen or shar...
I am looking for a skilled designer to create a book cover for my t my non-fiction books. I need the covers to comply with Amazon's guidelines. Genre: Christian Non-fiction Title: Kingdom Innovation Design Elements: My vision is a lightbulb that is plugged into an open Bible. The light bulb will shine and the Holy Spirit will be in it or on top of it. For the title, Kingdom - the dot of the "i" will be a crown, and in Innovation - the "t" will be a simple cross. I have attached my logo for reference. The logo says "Kingnovation" but the title is Kingdom Innovation. I want the cross to be similar to that. I am open to any design that fits the genre and effectively communicates the content of the books. Timeline: I need the project to be complet...
...verification with the subject company’s authorized representative, such as line of business, key executives' name, etc. • Take pictures of the subject company and its vicinity, as per Confirmis’ standard operating guidelines. • Provide observation about the company to gauge activeness, e.g., staff working at the premise, loading/unloading of goods, etc. REQUIREMENTS: • Must be living in (or nearby) Mevo Dotan, Israel • Has a camera or phone/tablet of quality with a camera, internet access • Must be available during business hours (9 AM - 4 PM) on working days Please see the attached file for the site visit guideline. You are only required to deliver the pictures, video & observations and are not expected to put togethe...
I need a wide range of details about accommodations on , downloaded for analytical purposes. This data should include r...data should include room availability, pricing, customer reviews, accommodation rate variances, photos, addresses, and phone numbers. - Essential Skills and Experience: 1. A strong understanding of web scraping tactics and data extraction. 2. Proficiency with 's platform and data structures. 3. Data organizing skills to deliver finalized data in CSV format. The outcome I envision is a well-organized CSV file that can further my research and analysis goals. A successful delivery will require attention to detail to ensure all requested information is included. Please bring forward your innovative solutions and reliable data handling methods.
...distributor company. The website should not be based on WordPress, but built for fast loading and easy navigation. Key Functionalities: - A general product catalog: The website should have a general minimalist product catalog with mentioning sauna models, sauna heaters, accessories and steam generators. - CMS for self-management: I'll need the ability to easily update and manage the content, so a simple and user-friendly Content Management System (CMS) is essential. Ideal Skills: - Proficiency in modern, sleek web design. - Experience in creating product catalogs with detailed pages. - Expertise in non-WordPress website development. - Prior experience implementing self-managed CMS for clients. - Focus on fast-loading website design. Looking for a freelancer who ...
1. Objective • Develop a responsive, mobile-first website optimized for conversions and equipped with fast loading times. The website will feature high-converting pages, support internationalization, and integrate seamlessly with existing business tools. Clean and update ui/ux. • By internationalization, we want it to switch to local language based on IP, not have a separately translated set of pages. • Would prefer webflow, open to wordpress • Need it to be easy to edit from a non-html or non-technical person. 2. Key Features • Mobile and Conversion-First Design: The site will be optimized for mobile users and designed to facilitate easy conversions. • Super Fast Load Times: Implement best practices in web development to ensure the site loads quickly ...
...X shortly and would like this integrated as well. Live Chat Functionality: I want to implement a pop-up chat box that allows for instant messaging, enabling me to respond in real-time to visitors. Content Navigation Improvements: Videos: Maintain the tab for video content. Articles: Enhance the articles tab with a dropdown menu for easier navigation, allowing users to select and directly access articles of interest. Blog Section: Introduce a new tab for a blog, which will host regular posts and updates. Homepage Design: The home page should convey a warm, welcoming feeling to visitors. Privacy Policy: Include a link to our privacy policy at the bottom of each page to ensure transparency and compliance. Mobile Optimization: It is essential that the website is fully o...
Hello. I have a multiple page excel spreadsheet, but I need it to have more flexibility. It is for a 10 room facility, and it's purpose is to show projected revenue based on room type, employee job type, and schedule. The current spreadsheet has 10 rooms with two room types. Also there are 11employees with 6 job types. Your task will be to change the current spreadsheet to 40 rooms, 3 room types. and 22 employees with 12 job types. Changes to be made to Revenue Targets Page, Column A -I want to be able to select room type from a dropdown menu, and input the revenue for different room types on the Revenue Target page. Room types are Private Room, Shared Room, Shared Medicaid. Employees Page, Column A -I want to select employee job type from a dropdown menu for ea...
...verification with the subject company’s authorized representative, such as line of business, key executives' names, etc. • Take pictures of the subject company and its vicinity, as per Confirmis’ standard operating guidelines. • Provide observation about the company to gauge activeness, e.g., staff working at the premise, loading/unloading of goods, etc. REQUIREMENTS: • Must be living in (or nearby) Dakar, Senegal. • Has a camera or phone/tablet of quality with a camera, internet access • Must be available during business hours (9 AM - 4 PM) on working days Please see the attached file for the site visit guidelines. You are only required to deliver the pictures, video & observations and are not expected to put together a...
I'm looking for an expert in VBA and macros to help streamline my processes in Excel. Key Requirements: Shifts: Defined two shifts in the "task tap": Morning: 6:00 to 15:30 Afternoon: 14:00 to 22:30 Quality: Updated the agreed-upon columns in the "quality tap." And remove the error code if there is no any number Delays: Ensured delays are reflected as discussed. Task Order: Arranged tasks in the "task tap" from oldest to newest. Please review the file and let me know if you have any questions or require further changes. Requirements: 1- Required an option in this file (Excel) that when the planner change the completion date of any task in column K in the TASKS tap, the color of the cell will be changed to yel...
...Requirements: The project must be completed within 2 days from the start date. The freelancer will have access to support and clarification throughout the project duration. Proficiency in Autodesk Revit plugin development. Access to Revit 2024 installed on your PC for testing and development. Ability to work independently and efficiently. Project Details: The objective is to develop a plugin that performs the following tasks: Retrieve quantity data for four specified materials from predetermined Revit schedules. Display the retrieved quantities in a user interface within the plugin. Prompt the user to select from three predefined conditions (each associated with a specific percentage) using a dropdown menu. Based on the user's selection, calculate an averag...
