Excel vba generate xml fileงาน
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 วันให้ทั้งแถวเปลี่ยนเป็นสีแดง
Use this platform When user registered Generate QR Code Use QR Code to open the turnstile by connect to SDK (Files Attached) The QR Code will generate for each member differently. Can't send to other to open the turnstile.
...สามารถ 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 ที่กำหนดให้
พิมพ์สูตรคณิตศาสตร์ได้ ตัวอย่างงาน
ต้องใช้ imacro คัดลอกข้อมูลจาก web site ลง excel
คีย์ข้อมูลต่างๆลง Excel การคัดลอกบทความต่างๆลง word
ทำ presentation งานโดยใช้ Powerpoint สามารถแทรกงานที่เป็นข้อมูล ตารางและกราฟ จาก data ที่เป็น Excel
ฉันมีไฟล์ .exe แต่ฉันต้องการเปลี่ยนให้มันรองรับกับภาษาของฉัน เพราะว่าตอนนี้มันไม่อ่านฟร้อน ไทยมันแสดงผลเป็นสี่เหลี่ยม i have file .exe but i want change language is my language
Creating the corporate website for a chemical company with eCommerce function. Able to search 300000+ items and show suggested result while typing, login to see price, can generate a quotation online, has add to basket order function and send out email confirmation . If possible, the product data will link to an ERP database ( Winspeed). Has live chat function and customers can subscribe to our newsletter. Back office can pull the quotation data, order data and customer data. The website will have CMS to manages pages like news, promotion, career opportunities. Also include contact form and catalog request form. Also need graphic design for banners. And also do SEO. สร้าง website บริษัทโดยมี eCommerce function สำหรับสินค้าประเภทเคมี 300000 รายการ สามารถ search และแสดงผ...
As a business with diverse inventory, I am in need of an application to generate unique SKUs, track their usage, and store pertinent SKU information. A distinctive facet of the project will be the creation of a custom format SKU algorithm incorporating department codes, which will ensure efficient identification and organization on our part. As such, a freelancer with a background in inventory management systems or similar projects would be advantageous. This job will require: We have a convention to follow for creation of the SKU IDS. Furthermore I want the ability to add product images at the time of generating the SKU. - Strong knowledge in application development. - Experience with custom format algorithms. - Understanding of department code incorporation. - Skills in SKU usag...
******* LOCATION ******* You must live in Eastern Europe or Latin America. ******* OVERVIEW ******* I will conduct searches on Google like "Plumbers Minneapolis, Minnesota" or "Carpenters Charlotte, North Carolina." Then I will run the script(s) you created for me. The script(s) you create will save the Google search results in a .csv file. That is trivial and straightforward. The script(s) will also open the websites associated with the search results. That is also trivial and straightforward. The main challenge lies in locating and filling out contact forms on these websites with my first name, last name, email address, phone number, etc. Most search results will include a link to the company’s website. For example, when I search on Google for&helli...
I need a proficient social media marketer who can create effective campaigns on Facebook, Instagram, and LinkedIn. The primary aim of these campaigns should be to generate leads and target Indian parents who would be interested in our English-speaking courses for their kids, specifically within the 15-30 age bracket. Ideal skills and experience that would be beneficial include: - Proven track results in lead generation via social media platforms - Experience in the education sector would be a plus - Proficient in targeting and engaging Indian parents - Understanding of Indian culture and education values - Comprehensive knowledge of advertising English language courses. The chosen freelancer should come up with innovative strategies to connect with our target audience meaningfu...
if you can do the work on this moment you can do it i need the file like in within 20 min. it is a eps file it seems it is unsharp. file format is correct but it looks unsharp who can fix it. these are dthe guideline of the file needed:
I'm in need of an experienced SEO team to optimize the online presence of my Dubai-based real estate company. The primary goal is to generate more leads for our properties. Key Responsibilities: - Develop a comprehensive and effective SEO strategy - Boost the visibility of our property listings on search engines - Monitor analytics to identify gaps and opportunities Ideal Candidate: - Proven experience in SEO, particularly within real estate - Familiarity with the Dubai real estate market - Proficiency in utilizing SEO tools and analytic software - Proven track record in lead generation through SEO
It's time for an essential task: looking for an experienced freelancer who can single-handedly generate leads for medical supplies. I'm focusing on three indispensable items: masks, gloves, and sanitizers. These supplies are high in demand and we need to constantly keep finding new distributors. Key Details Needed: - Contact information, including full name, phone number, and email - Physical location - Company name Ideal Profile: - Our ideal customers are wholesale distributors. Experience in this segment is a significant plus, and any knowledge or connections in the medical supply industry are warmly welcomed. Skills and Experience: - Proven lead generation record - Strong understanding of the medical supply industry - Excellent communication skills for collecting con...
We are using an online field service software platform called Uptick for our field technicians to carry out inspections of fire systems. The online software we use generates a PDF report based on the field technician inputs. We have access to the CSS/HTML/DJango source code to modify the PDF output. We require a developer who will work with us to generate a PDF output based on our design by modifying the existing source code. Please note: The developer must be willing to discuss the project via [Removed by Freelancer.com Admin for offsiting - please see Section 13 of our Terms and Conditions] so that clear instructions can be discussed as to the required PDF output.
...details into a spreadsheet. Responsibilities: -Conduct basic research to locate contact information for 25 specified agencies. -Validate that email addresses are current and active. -Accurately enter all data into a provided spreadsheet format. Requirements: -Experience in data collection and validation. -Proficiency in basic research and use of spreadsheets (e.g., Google Sheets or Microsoft Excel). -Ability to deliver accurate results within a set timeframe. -Project Length: Short-term, estimated completion within one week. ( MAX 80 AUD as a test round, if the work is good, Larger jobs will come) Application Instructions: Please message me with the keyword "VSL" at the beginning of your application to confirm that you have fully read and understood the job desc...
I'm looking for a proficient programmer or web developer with experience in creating Chrome extensions for social media platforms. The main requirement is to generate tailored content for Instagram. - You should create a Chrome extension with the following features: - Template-based content generation: It should support text templates and also have the capability to overlay different texts over one video. - Text overlays: This feature is to add text over images or videos. - Mass production/download: This tool should generate content in bulk and allow for mass downloads. The ideal candidate for this project would have a strong command over JavaScript (for Chrome extension development) and experience dealing with various social media APIs. A strong understanding of c...
I need an Excel 365 PowerQuery or VBA script that can fetch daily market data and handle potential data source interruptions or changes. Google Shhets example =INDEX(IMPORTXML("" & C31, "//span[@class='mod-ui-data-list__value']"), 1, 1). <Where C31 = Cell containing the Stock eg GB00B8XYYQ86, LU1033663649 or GB00B0CNH163 I need an identical function in MS365 Excel - either with PowerQuery OR VBA (preferable) Ideal skills: - Proficiency in Excel 365 and PowerQuery and VBA - Experience in web scraping and handling dynamic data sources. I am after a fixed quote for this project.
...Maintains primary responsibility for grant schedules and tracking grants; * Serves as a liaison to all funding agencies and organizations; * Works with appropriate personnel to research, develop, write and submit letters of inquiry, concept papers and grant proposals; * Coordinates and follows-up on the progress of submitted proposals; Institutional Effectiveness; • Develops and maintains a master file on pending grants and contracts; • Remains up-to-date on current issues relative to grant proposals; • Inform business owner on the progress of all grants and issues that may arise with each grant. • Maintains confidentiality of information exposed to in the course of business Minimum Education, Skills and Abilities; * proven successful track record in the la...
...levels. - Automated alerts for low stock levels. 3. Order Management - Enable creation of new orders with customer information, order details (product, quantity, price), and shipping method. - Track order status (received, processing, shipped, delivered). - Generate invoices and receipts for orders. 4. Shipping and Delivery Tracking - Record shipping details, including carrier, tracking number, and expected delivery date. - Update order status when shipped and delivered. 5. Reports and Analytics - Generate sales reports by date, product, or customer. - Inventory level reports. - Customer order history and patterns. Instructions: Based on the given information do the following: 1: Create a DFD using Visual Paradigm. (Note: we have worked on VP in...
I'm seeking a professional able to create a custom CRM system in Excel for my business. Key requirements: - Sales Tracking: I need a system that allows me to monitor sales performance and forecast future sales. - Task Management: The CRM should have a task management feature to help me organize and prioritize my daily activities. Additional details: - The system will be used by a small team of 1-10 users, so it needs to be user-friendly and easy to navigate. - No integration with other software or platforms is needed at this time, so the focus will be solely on creating a robust, efficient Excel-based CRM. Ideal skills and experience for this job would include: - Proficiency in Excel, with a clear understanding of how to create complex formulas and visual repre...
...& in person primarily targeting young adults aged 18 to 25 for our Diploma programs as well as younger students 8 - 17 for part time teen & children programs. The Academy is a private Career College training in the field of film & television. Key Tasks: - Develop a targeted Google Ads campaign aimed specifically at young adults aged 18 to 25. - While creating ads, the main goal is to generate leads who will potentially enroll in our in person & online courses. - Advise on budget, ad copy, and design to ensure maximum engagement and lead conversion. Skills and Experience: - Proven experience in running targeted Google Ads campaigns. - Strong understanding of the education industry and what appeals to young adults. - Demonstrated success in lead ge...
...scraping and data collation. The project will involve scraping blog articles in HTML format and compiling desired information into an Excel file. Key Project Requirements: * The extraction will be from specified URLs, using their individual patterns for efficient and accurate scraping. * For each blog article, I need the title, the full text, and the publish date extracted. * This scraped data must be properly arranged in an Excel file for easy analysis. * List of articles is here: Ideal Candidate Expertise: * Proven experience in web scraping is a must, preferably with full understanding of HTML structures. * Proficiency in Excel and data organization. * Attention to detail to ensure accuracy of the scraped data. * An understanding of URL patterns...
how to decode : All report content comes from the json data we provide, I explain the logic details in report logic.pdf., please check its content. I also attached a json data and a tire report , they come from one scan, you check its content to verify the report logic. we have to make similar script to generate report from our system
Dough one Sources is looking candidates for Senior Business Analyst – VBA, Advance Excel. Job Role: Senior Business Analyst Job Location: Remote Experience: 4 + Years as Business Analyst – VBA , Advance Excel 3+ years of experience is required in creating dashboards in Manufacturing, Banking, Retail Industry. Working Hour: 3 hour per day (per day) Salary: 150 – 200 INR Per Hour Job Responsibilities : • Understanding Company requirements. • Understanding, consolidating and analyzing data from spreadsheets. • Creating dashboards, reports and charts in Analytics tools. • Working on financial and other types of modeling projects. • Having knowledge Dashboard Creation, Mainframe automation through VBA. • Good...
...management software with barcode generation, scanning, stock quantity tracking, and weight measurement functions. The system should enable me to: - Generate and scan barcodes for every product in my stock - Track the quantity of each item I have in stock - Measure the weight of my stock in grams I prefer a cloud-based solution that can be accessed and updated from any internet-connected device. The software should have an easy to use interface and be able to: - Enable manual entry of stock data - Support updating stock information by scanning barcodes - Automatically update stock data from my sales records The software could be developed in Excel, as long as it's accessible online. As a freelancer, you should have experience in developing similar solutions and a d...
I need an Excel sheet created with the primary purpose of data analysis. This sheet should have the following features: - Data Sorting and Filtering: This is crucial for making the analysis process efficient and easy to navigate. I need the sheet to be able to handle large amounts of data and allow for quick and convenient sorting and filtering. - Data Visualization: In addition to the data analysis, I also require the sheet to include line graphs. I believe that visualizing the data will make it much easier to understand and interpret. The ideal freelancer for this project is someone with a strong background in Excel and experience in creating data analysis tools. It is important that the final product is user-friendly and has a clean, professional appearance.
I'm in need of a freelancer to assist with data cleaning from PDF documents. The task involves organizing the data into an Excel spreadsheet. Ideal skills for this role include: - Proficiency in data cleaning techniques - Strong attention to detail - Proficient in Excel for organizing data - Previous experience in similar data entry tasks
I am a motivational speaker, and my objective is to create compelling video ads that effectively target professionals, entrepreneurs, and C-level executives. The main focus of these ads will be: - High-quality, engaging video content - Captivating messages that resonate with my target demographic - Strategies designed to generate more leads The ideal freelancer for this project should have: - Expertise in video ad creation and editing - Proven record in creating successful video ads - Excellent understanding of target market dynamics - Skills in lead generation Your innovative ideas will be invaluable in achieving my goal of expanding my influence and reach in the professional and entrepreneurial spheres.
I am looking for a skilled social media marketer who can help me generate leads through my Facebook, Instagram, Twitter, and YouTube accounts. Key Responsibilities: - Develop and execute a social media marketing strategy that aligns with my goal of lead generation - Create engaging and shareable content tailored for each platform - Monitor, analyze, and report on the performance of the campaigns Ideal Candidate: - Profound experience in social media marketing across multiple platforms, with a focus on lead generation - Proven track record of creating successful YouTube content - Strong understanding of social media analytics and reporting - Excellent written and verbal communication skills - Creative mindset with the ability to think outside the box for content ideas Please appl...
I want to scrape daily leads from LinkedIn Jobs, Indeed Jobs, , etc. The task involves extracting data from these job sites and exporting it to Excel sheets. It would be preferable to have some kind of automation that reduces human dependency in obtaining leads every day. If someone has already set up a similar process before, I would prefer that. Preference will be given to those who have previously performed lead extraction tasks for recruitment websites.
I aim to develop a web application that is centered around the generation of test cases from data flow graphs. This tool is primarily intended for software developers and will be used to aid in the effectiveness of testing processes. Key Features: - Capable of analyzing data flow graphs to generate test cases - Simplistic, user-friendly interface designed for software developers - Incorporation of Java programming language for analysis The ideal candidate for this project should have: - Proficiency in web application development - Strong understanding of data flow graphs and test case generation - Excellent command over Java programming - Previous experience in creating tools for software developers This project is a great opportunity to contribute to the efficiency and productiv...
...candidate selection, with robust applicant tracking capabilities. 2. Employee Onboarding and Offboarding: Simplify the onboarding and offboarding processes for new and departing employees, ensuring a seamless transition. 3. LLM-Based AI Automation System: Develop an AI-powered system to schedule and conduct initial screening phone calls and first-round interviews with candidates. The system should generate comprehensive reports based on the conversation. 4. Payroll and Accounting Tool: Integrate a payroll and accounting tool to automate payroll processing and manage financial transactions efficiently. 5. Performance Management: Implement performance management tools to set goals, track progress, and conduct performance reviews effectively. 6. Learning and Development: Provide lea...
I would like a skilled Laravel developer to integrate PagSeguro's payment gateway into my website, including Boleto bancário and Pix. Key Project Requirements: - Integrate Boleto Bancário: The system should generate boleto slips, track boleto payments, and handle the necessary validations. - Include Pix: The system should support payments via Pix, a new and increasingly popular payment method in Brazil. Ideal Skills and Experience: - Proven experience with integrating payment gateways into Laravel applications. - Familiarity with PagSeguro's API and requirements. - Knowledge of Boleto Bancário and Pix payment systems. - Strong understanding of Laravel best practices. The project needs to be completed within a month. Please let me know if you have an...
I'm looking for a social media expert to help me create and manage business accounts on Facebook, Instagram, and Twitter. The primary goal of this project is to drive traffic to my app/website. Key Responsibilities: - Create business profiles on Face...and execute a comprehensive social media strategy - Regularly post engaging content to attract followers - Drive traffic to my website through social media marketing efforts Ideal Skills and Experience: - Proficiency in Facebook, Instagram, and Twitter - Proven experience in managing social media accounts for businesses - Strong understanding of social media marketing strategies - Ability to generate website traffic through social media I'm open to creative ideas and strategies to meet the project's goal, so feel fre...
