Excel vba web query macroงาน
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 วันให้ทั้งแถวเปลี่ยนเป็นสีแดง
หลังจากลูกค้าโทรเข้ามาเมื่อคุยเสร็จแล้วลูกค้ากดวางสาย หรือ พนักงานกดวางสาย อยากให้หลังจากนั้นประมาณ 20 นาทีให้โทรศัพท์กลับไปหาลูกค้าเพื่อประเมิณความพึงพอใจ โดยใช้ macro-survey เป็นเมนูที่จะโทรออกอัตโนมัติ
...สามารถ 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
I'm looking for a freelancer who can create a comprehensive, user-friendly Google Form and Excel template system. This system will be geared towards the hotel management sector and will be used for recording bookings, sales, expenses, and other business-related data. Key Requirements: - Design and Implementation of Google Form: The form should be intuitive and easy to use. It should have fields for recording bookings, sales, expenses, and other relevant business information. - Excel Templates: The gathered data from the form should be integrated into a set of Excel templates. These templates should be professionally designed and easy for hotel management to use. Your Role: - Your role will be to create a system that can manage multiple businesses. The system sho...
Looking for someone with advanced skills in Excel and PDF interactivity who can transform a multi-sheet excel document into an editable PDF, while maintaining its ability to be converted back into an excel document. The purpose of this conversion is to enhance collaboration, hence the PDF should feature: - Interactive input fields that can be edited. - Checkbox and/or radio button functionalities. Also looking to add our company logo in the header and company info (addresses, phone numbers etc) in the footer. The ideal freelancer would not only support this conversion, but also maintain the original formatting to protect the sanctity of the document. Previous experience in similar work would be advantageous. Looking forward to your proposals!
...recurring project, and I require the newsletter to be sent out on a weekly basis. Key Requirements: - Design and Set-up: I need someone with a keen eye for design who can make the newsletter visually appealing and professional. - Audience Focused: The content of the newsletter should be tailored and engaging for experienced freelancers, providing them with valuable insights and tips that can help them excel in their freelance careers. Ideal Skills and Experience: - Proven experience in designing newsletters, specifically for experienced professionals. - Familiarity with email marketing tools for managing and sending out newsletters. - Strong understanding of the freelance industry and the needs of experienced freelancers. This is a long-term project, so I'm looking for a ...
I'm encountering issues converting Excel formulas to Google Sheets, particularly with the VLOOKUP function. The problematic formula in question is central to my data analysis processes. I need a professional who can troubleshoot and effectively convert these formulas to be compatible with Google Sheets. Key Tasks: - Identify the source of the "IFERROR" error in the VLOOKUP formula as it functions in Google Sheets. - Modify the formula for accurate results in Google Sheets, ensuring it retains its original functionality post-conversion. Ideal Skills and Experience: - Proficient in both Excel and Google Sheets formulas and functions. - Strong experience with VLOOKUP and IFERROR. - Ability to troubleshoot and adapt formulas across different spreadsheet platforms...
I need assistance in creating a specialized budgeting spreadsheet focusing on drivers license renewal costs. As someone who understands the intricacies of financial data, you...understands the intricacies of financial data, your task encompasses the following: - Developing a budgeting spreadsheet with an emphasis on renewal fees. - Including a feature for expense tracking and an income versus expenses comparison. - Incorporating a mechanism for budget forecasts to plan my finances better. The ideal freelancer for this task should excel in financial data management and have a comprehensive understanding of Excel or similar platforms. Previous experience in creating budget planning or financial management tools would be a significant advantage. Let's simplify my financia...
As the client, I need a website that can function offline, primarily aimed at assigning 3D components to various errors. These components should be simple structural designs. The basis for the as...the client, I need a website that can function offline, primarily aimed at assigning 3D components to various errors. These components should be simple structural designs. The basis for the assignment of these components is a manual input system. Integrating a feature for capturing photos of these errors is also crucial for this project. Ideal skills and Experience: • Proficient in 3D designs • Web Development Skills • Experience with Offline Application Development Key Features: • Assign 3D Components to Errors (manual input basis) • Capture Photos of Errors ...
As the client, I am search of a seasoned virtual assistant to support me during typical work hours, 9am to 5pm (UTC +1). The ideal candidate will possess the following expertise: CRM MANAGEMENT: Monitor and manage follow-ups and sales activities within the CRM. Update and maintain accurate records of customer interactions and sales leads. Assist in developing ...tasks as assigned by the CEO. QUALIFICATIONS: Proven experience as a Virtual Assistant or in a similar administrative role. Excellent written and verbal communication skills. Strong organizational and time-management abilities. High level of professionalism and confidentiality. Ability to work independently and handle multiple tasks simultaneously. Proficiency in Microsoft Office Suite (Word, Excel, PowerPoint) and Google ...
I'm looking for a skilled developer to update...controllers in my Laravel backend for my React Native application. Specifically, I need help with a single task to start, and if that goes well will task additional items thereafter: 1. Laravel Backend has a 'ProviderController' which sends 'Provider' results to app based on distance within radius. There is a 'Mobile Only' option that when checked is not limiting results to within that radius. The query is a bit messy, but is likely where the change needs to be made (see attached). App is published to TestFlight already and should not need to modify React Native source to address this, but can provide if needed. Ideally looking for a developer who can fix this bug fairly quickly, then will have on...
...with direct links to the pages/templates where this work has been started. I need someone who is proficient enough with these tools to be fairly self-directed once given access. My web/marketing manager can give you access to the source site if needed, but you then ideally will be able to make sense of the setup and put things in place as intended to achieve this functionality without recreating the wheel. As an example, there is a Styles page for which a screenshot of the hero section is attached, showing Portfolio Items as well as Artists related to that style. The Artists are shown via a Query Builder query that uses a "Grandchild/Grandparent" relation, looking at the Portfolio Items related to the style, then checking the Artist that is related to ...
I'm seeking a highly skilled digital advertising contractor to manage and drive a targeted campaign on social media and via email marketing. The successful applicant should have: - A proven track record in digital advertising, specifically in social media platforms and email marketing. -...advertising, specifically in social media platforms and email marketing. - An understanding and ability to successfully target business professionals. - Tactical skills at creating and managing effective, results-driven advertising campaigns. This job is ideal for professionals who are adept at developing captivating advertising campaigns that resonate with a business-focused audience. They should also excel in consumer profiling and targeted content presentation. I look forward to he...
I'm looking for a freelancer to conduct market research to determine the best selling aftermarket products in the motorcycle industry: specifically, my target segments are in the super sport, sport, sport touring and cruiser Japanese motorcycles (Honda, Suzuki, Yamaha and Kawasaki). I'm looking for at least information from 2 databases (examples would i...Yamaha and Kawasaki). I'm looking for at least information from 2 databases (examples would include Amazon and Ebay but open to other possibilities too). I wanted to limit the types of products to: (1) Brackets (2) Protective engine covers (3) Levers (brake, clutch, etc..) (4) Air intake components (air intake box or air inlet ductings). The project consists of 2 parts and thinking it would be in Excel format (but op...
I'm seeking a skilled data architect for providing consultation and recommendations on a Statement of Work (SOW) that involves data warehousing, ad hoc reporting, complex SQL format...recommendations on the SOW for data warehousing - Offering expertise on ad hoc reporting and complex SQL formation - Helping to streamline data storage and improve decision-making - Ensuring the architecture can support monthly data integrations Ideal candidates should have: - Proven experience as a data architect - Expertise in data warehousing and ad hoc reporting - Strong SQL skills, including complex query formation - Familiarity with streamlining and enhancing data storage - Experience in supporting monthly data integrations Your insights and guidance in this project are crucial for our lon...
...with direct links to the pages/templates where this work has been started. I need someone who is proficient enough with these tools to be fairly self-directed once given access. My web/marketing manager can give you access to the source site if needed, but you then ideally will be able to make sense of the setup and put things in place as intended to achieve this functionality without recreating the wheel. As an example, there is a Styles page for which a screenshot of the hero section is attached, showing Portfolio Items as well as Artists related to that style. The Artists are shown via a Query Builder query that uses a "Grandchild/Grandparent" relation, looking at the Portfolio Items related to the style, then checking the Artist that is related to ...
Description: We are currently seeking a dynamic and motivated freelance cold caller to join our team and assist in prequalifying low-income prospects for our revolutionary no-cost health benefits program. This is an excellent opportunity for individuals who are skilled in high-volume cold calling and have a passion for help...management. Benefits: -Daily and Weekly Bonuses based on production!!! -Competitive compensation based on performance and call volume. -Opportunity to make a meaningful impact by helping low-income individuals access essential healthcare services. -Potential for growth and advancement within the company based on performance. If you are passionate about making a difference and have the skills to excel in a fast-paced cold calling environment, we want to hear...
...Developer to automate tasks relating to a list of codes (stored in a txt file, excel file, etc) and Web interaction, for a demostration of micro RPA possibilities Basically you will take 1 data from 1 excel cell (example cell d5) with that data you will create an hyperlink the link will be a fixed text + the code taken from excel you will open a broswer tab with that link IF one text is present in the resulting html response, you will close the tab, and repeat the process with the next data from the file If another text is present, you will "click" 3 or 4 following buttons Iterate with the next data from the excel file Until Excel's data EOF Everything configurable via external TXT file - name of the excel file or txt file -...
...developers. Responsibilities Design and implement efficient database solutions for our organization, leveraging Netezza and Oracle technologies. Lead a team of developers in the implementation and maintenance of database systems. Collaborate with other stakeholders to gather requirements and define database architecture to meet business needs. Optimize database performance through indexing, query optimization, and other performance tuning techniques. Develop and enforce data standards and best practices to ensure data integrity and security. Provide technical guidance and mentorship to junior developers. Troubleshoot database issues and provide timely resolution. Stay up-to-date with the latest trends and technologies in database management and architecture. Ski...
We are an Ecommerce company dealing with variety products and we are looking for a ...Social Media Ads Manager to join our team. The tasks includes but not limited to: Creating the ads on different Social Media Platforms Create reports in Excel, and Google Sheets on a daily and monthly basis Turning off the ads which are not delivering the acceptable ROI Creating a new ad for the stopped campain Write text for the posts Edit Pictures and videos in Canva or Capcut The Ads Manager must be solely free for this project and not committed to any other task, job or study work hours: 6 days a week, 10 hours a day The agent must be fluent in both Arabic and English Must also have good communications and sales skills Can work on Excel Have sufficient experience in Social Media Ads and ...
Hello there, We will translate your Excel file (Magic Jackpot Ads (Slots)) into Hungarian. Thank you!
...work under tight deadlines **Requirements:** - Design a unique, illustrative logo that embodies my brand's values and essence. - The final logo must be scalable, as its primary use has not been defined yet; it could range from web applications to print materials or product packaging. - Deliverables include the original vector files and high-resolution PNGs. - Must be available for a brief consultation before starting and open to revisions, if necessary. **Timeline:** - Complete within 2 days from project start. This project is ideal for creative freelancers who excel under pressure and have a knack for delivering high-quality work promptly. Your contribution will play a pivotal role in the launch of my new product, and I'm excited to see how your creativity wi...
...operations support assistant to aid me in daily tasks. Key Responsibilities: - Spreadsheet Management: You will be tasked with keeping our Excel sheets organized and updated to ensure seamless operations. - Report Generation: You will also be responsible for generating reports for our activities. These reports must be clear, concise, and error-free. - Daily Calls: You will make regular teams calls within the operations team. - Research & Analysis: The role will also require you to conduct research and analysis on various topics as needed. Your Excel Skills: I need a candidate who is proficient in Excel. An intermediate level of understanding and experience in Excel is a requirement for this role. You need to have a personal computer and a data speed ...
Looking for a Python & Active Directory Expert to create a script and test data to capture all meta data linked to and which describes the confined parameters of an AD account, group policy etc. and export to a MS Excel File. More information attached.
We are an Ecommerce company dealing with variety products and we are looking for a ...Social Media Ads Manager to join our team. The tasks includes but not limited to: Creating the ads on different Social Media Platforms Create reports in Excel, and Google Sheets on a daily and monthly basis Turning off the ads which are not delivering the acceptable ROI Creating a new ad for the stopped campain Write text for the posts Edit Pictures and videos in Canva or Capcut The Ads Manager must be solely free for this project and not committed to any other task, job or study work hours: 6 days a week, 10 hours a day The agent must be fluent in both Arabic and English Must also have good communications and sales skills Can work on Excel Have sufficient experience in Social Media Ads and ...
More details: Which version of Excel are you using? Excel 2016 What type of data processing do you need? Data sorting, Data filtering What specific criteria will you use for sorting the data? Numerical order It is required to set up a script that will process an Excel file every day, filter the file according to an algorithm and leave the necessary data in the file.
...lead should include the following: • Company Name • Company Address • Company Phone Number • Owner's Name • Contact Email • LinkedIn URL (if available) 4. Target Titles: The contact should hold one of the following titles: • CEO • Chief Executive Officer • Owner or Managing Partner • Founder • Chief Financial Officer (CFO) • Board of Directors • Pharmacist • Manager • Director Deliverables • An Excel spreadsheet with the collected data points for 2,000 contacts. • Ensure that there are at least 1,400 unique companies represented in the list. Quality Assurance • Perform regular reviews of the data to ensure completeness and accuracy. • Use tools to remove duplicate entries and ens...
...the IT industry amid the remarkable growth of the US job market. As part of our prominent company, you'll contribute to cutting-edge projects that shape the future, positioning yourself at the forefront of innovation. With comprehensive support programs, we ensure a seamless transition into our team, empowering you to hit the ground running and excel in your role. What You Bring: - Over 8 years of experience as a Python Developer, specializing in web API development, data analytics, and machine learning. - Proficiency in Python and related frameworks/libraries such as Django, Flask, NumPy, Pandas, and scikit-learn. - Strong communication and collaboration skills, with the ability to work independently and solve complex problems. - Bachelor's degree in Computer S...
I'm in urgent need of an expert in revenue summary analysis for my accounts assignment, to be completed ASAP. Areas of focus include: - Deciphering and analyzing an Excel file, which contains base financial data. - Providing a thorough understanding of the balance sheets, income statements, and cash flow statements in relation to the given data. Ideal qualifications: - Strong accounting background. - Proficiency in financial analysis and interpretation. - Familiarity with balance sheets, income statements, and cash flow statements. - Proficient in Excel data manipulation and interpretation. - Must be able to work fast as this task has a high-priority deadline.
Preciso de um profissional que saiba desenvolver processos automação RPA, que integra site e arquivos excel em processos rotineiros.
I need a proficient Excel expert who can create an organized spreadsheet to track our monthly sales data. Key Requirements: - The spreadsheet should be organized by month. This means that the sales data for each month should be clearly separated. - The primary function required is to sum up the sales totals for each month. This will help us in tracking our sales performance over time. Ideal Skills/Experience: - Proficiency in Excel, with a good understanding of formulas and functions. - Prior experience in creating sales data spreadsheets would be a plus. - Attention to detail is crucial to ensure the data is accurately presented and calculated. Deliverables: - An error-free, well-organized spreadsheet that clearly presents our sales data on a monthly basis. If you bel...