Excel vba lookup value in another workbookงาน
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 วันให้ทั้งแถวเปลี่ยนเป็นสีแดง
อัปเดต 4 แบบฟอร์มออนไลน์ใน Javascript Update 4 online forms in Javascript. Remove 3 paragraph from 1 form and add 1 text field to another form. Example, what needs to be done: Adjust this form according to the picture attached. Possible long term collaboration ahead.
...Content ดังนี้ครับ 1. ให้พนักงานขาย รายงานรุ่นและจำนวนที่ขายกลับมาที่เรา โดยในเว็บจะมีสรุปยอดขายเป็นกราฟหรือชาร์ตต่างๆให้ ที่สามารถ sort เป็น สาขา เป็นเขต หรือทั้งประเทศได้ แบ้วแต่แกนที่เราต้องการ 2. มีระบบ Log in ซึ่งจะยึด user ของพนักงานกับสาขาที่เรากำหนดไว้ หมายความว่าเมื่อพนักงานกดรายงานยอดขายระบบจะ แท็กว่ามาจากสาขาไหน 3. หน้าพื้นฐาน เพื่อแจ้งข่าวสารหรือโปรโมชั่นต่างๆ และสามารถแก้ไขได้ง่าย 4. มีแพลตฟอร์มหลังบ้านที่สามารถแก้ไข เพิ่ม ลบ ข้อมูลได้ ทั้งในเรื่องของข้อมูลพนักงานข้อมูลสาขา โดยกำหนดให้ทำได้เฉพาะ User ที่กำหนดไว้ 5. สามารถ Export ข้อมูล รายงานต่างๆมาเป็น Excel 6. สามารถทำข้อสอบในลักษณะคล้ายๆ Google form 11:20 Avatar ได้ครับ 11:20 Avatar มี host หรือยังครับ 12:05 ยังครับ อยากทราบราคาก่อนนะครับ ว่าเริ่มต้นที่เท่าไหร่ 12:12 Avatar คร่าวๆ ประมาณ 1...
ทำ 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
Improve my PS website ranking for 10 local keywords in 1 month - organic SEO - white hat only - off-site SEO - work report (weekly) - keywords ranking report (weekly) - need to see improved ranking result in 1 month to continue another month - not more than 75 USD - keyword นายสิบตำรวจ สอบประทวน สอบนายสิบตำรวจ นายสิบ สายอำนวยการ นายสิบ สายปราบปราม สมัครนายสิบ สมัครนายสิบตํารวจ ติวนายสิบ กำหนดการสอบนายสิบ สมัครเรียนนายสิบ
ทำ presentation งานโดยใช้ Powerpoint สามารถแทรกงานที่เป็นข้อมูล ตารางและกราฟ จาก data ที่เป็น Excel
...compelling pitch deck for our fashion and lifestyle concept store in Accra, Ghana. The pitch deck should effectively communicate our unique value proposition, target market, competitive advantage, and growth potential. Additionally, the deck should include well-researched financial projections that showcase the profitability and feasibility of our business model. Key Skills: - Pitch deck creation - Market research - Financial analysis - Presentation design - 10 to 15 Slides - Clear, concise, and engaging content - Visual appeal, mirroring fashion and design aesthetics The successful freelancer should have experience in the Fashion and Design industry or have demonstrable knowledge of it. They should also be proficient in creating persuasive presentati...
...responsibilities will include: - Understanding the existing design - Implementing a key-value store system within the bounds of this design As the data that will be primarily handled by the system is undetermined, the ability to build a flexible solution would be crucial. Ideal skills for the task: - Strong proficiency in Go programming language - Previous experience in building replication systems - Familiarity with a variety of data types - Keen attention to the details of the design I am excited to work with a developer who can accomplish these tasks efficiently while maintaining code quality. I require immediate assistance in solving a Go assignment focused on implementing a primary/backup replication(Key-Value Store) solution. The task invol...
I'm in search of a versatile freelancer with skills in Word, Excel, programming, and graphic design. Your expertise in these areas will help me in different domains. Your main tasks will include: - Formatting documents in Word, ensuring a professional and consistent layout. - Creating Excel spreadsheets and conducting data analysis. Proficiency in Excel will be crucial to help me interpret and visualize data effectively. - Developing software or web applications. I am working with Java/Spring/JavaFX and am open to creative development ideas and solutions. - Designing logos and visuals. Your ability to create engaging and unique visuals will be a big asset to my projects. I am currently using Word 2010 and will be workin...
I am looking for a skilled web developer who can construct an outstanding e-commerce website targeting the general public. As I am still uncertain about the color scheme or potential branding, I would value your input and creativity in this area. Key Skills & Experience: - Expertise in ecommerce platforms. - Experience with site design and aesthetics. - Familiarity with user-focused design. - Ability to understand and cater to a general public audience. - Proficiency in designing a user-friendly interface. - Suggestions for color schemes is a plus. Overall, I need someone who can create a visually appealing, easy to navigate, and successful online store. Your ability to understand audience preferences and translate this into an engaging and functional w...
I'm looking for an experienced prof...50-100 products. I'll provide all the necessary product descriptions and photos. - The ability to accurately and attractively present these on Etsy in a way that will attract potential customers is critical, including SEO knowledge and advanced experience with the Etsy platform. Skills and Experience Needed: - Proven experience setting up and managing Etsy stores - Strong visual aesthetics and understanding of product presentation and driving traffic with SEO - Attention to detail - Adept in handling a large volume of product listings - Knowledge in optimizing listings for search is a plus. An expert with these skills would bring significant value to me and this project. I'm excited to find the right prof...
...multi-faceted promotion strategy: I'm looking for someone who is well-versed in social media marketing, email marketing, and direct outreach. You will be using these methods to reach out to hostel owners and managers to promote my service. - Closing deals: You should be an excellent salesperson with exceptional communication and negotiation skills. The primary objective is to turn leads into sales, so the ability to close deals and meet sales targets is essential. Ideal Candidate: - Sales experience: Prior experience in a sales role is a must. Experience in the service industry or with hostels is a plus, as it will give you a deeper understanding of the target audience. - Marketing skills: A strong background in social media marketing, email marketing...
I have a list of 50000 urls, I would like to scape the pages to see if they contain references to scripts - I will provide a list of the urls and the scripts. Deliverable should be an excel with the 50000 urls and whether they contain the link for each script. Looking for fast turnaround
...vendor will be responsible for developing and implementing a solution to: • Subscribe to and navigate through multiple food delivery mobile apps. • Collect data on menu items including descriptions, pricing, customer ratings, and associated promotions or deals. • Move systematically from one restaurant to another within each app, ensuring comprehensive data collection. • Extend the data collection across all significant food delivery apps available in the specified city. • Store collected data in a structured format for easy access and analysis. • Conduct data mining to extract meaningful insights from the collected data set. 3. Deliverables The vendor is expected to provide the following deliverables: 1. Data Collection Framework: A d...
I need a professional developer to assist with creating a Shopify template. The design is based on a Magento template from my another shop. Key requirements for this project include: - Creating a Shopify template that closely mirrors the design of an existing Magento template, incl. graphics and layout I am looking for someone with the following skills: - Proficient in Shopify and Magento, with the ability to translate designs between the two platforms
...into an Excel file with separate sheets for doctors' information and disease descriptions. Requirements: Programming Language: Preferably Python. Libraries: Experience with web scraping libraries like BeautifulSoup, Selenium, and data processing libraries like Pandas. Output Format: Ability to export data into an Excel file using Pandas or similar libraries. Error Handling: Robust error handling to manage failed requests and parsing errors. Compliance: Adherence to the websites' terms of service and rate limits to avoid being blocked. Project Scope: Input: A list of CRM numbers and a list of CID numbers. Process: Automate the lookup and data extraction process. Output: An Excel file with the compiled data. Skills Required: Web Scraping Python Prog...
...Extract the first value from the first document that is loaded - Select the second value from the second document that is loaded The communication between the Chrome extension and the server should be seamless and efficient. The server should be able to receive and process the values extracted by the extension. Iam using a multiple AWS windows instances upto 16. So in every instance I use chrome Browser for my Business to customers daily. So I run a Extension in chrome for Auto click drop-down &radio button That extension developed by other freelancer So Every instance& chrome extension has to connect to the server and if we change the radio button and drop-down on the server it has to be clicked as order wise. If first loaded document Click ...
...Extract the first value from the first document that is loaded - Select the second value from the second document that is loaded The communication between the Chrome extension and the server should be seamless and efficient. The server should be able to receive and process the values extracted by the extension. Iam using a multiple AWS windows instances upto 16. So in every instance I use chrome Browser for my Business to customers daily. So I run a Extension in chrome for Auto click drop-down &radio button That extension developed by other freelancer So Every instance& chrome extension has to connect to the server and if we change the radio button and drop-down on the server it has to be clicked as order wise. If first loaded document Click ...
...000 sku's in online catalog. Discounts: Visitor, first order, seasonal, Occasional (tied to things like mother's father's day, Christmas etc. up to 25 occasions/year. Variety of Gift Cards. There may be many more items that would have to included due to client request or designer suggestions. Primary Market US, Canada (may be shipped from China or USA) Secondary market UK, All of Europe, GCC. and 50 additional countries. Secondary market to ship from China only. Incorporated in Houston, Texas or Kansas City, Kansas. Site visitor statistics by country, daily, weekly, monthly. Typical Visitor/Buyer profile, age, Gender, Education, Urban/rural, Competition survey (typical Walmart buyer): Every product carried will have 3 grades good, better, best, and...
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 – 300 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...
Hello, I need convert a PDF invoice to Excel to import to our invoices software
I'm looking for an experienced Power BI developer to create bespoke reports and dashboards, which will be integrated into Microsoft Teams. Tasks: - Handling data from Excel spreadsheets and converting it into insightful reports and dashboards. Skills and Experience: - Strong command of Power BI for report and dashboard creation. - Proven experience with Excel spreadsheets. - Good knowledge of integrating Power BI into Microsoft Teams. The goal is to make complex data easy to understand, facilitating better decision-making within our team. Your work will directly impact our day-to-day operations and strategies.
Create a presentation for an annual report in either a Microsoft product (Powerpoint, Word) or Google (Docs, Slides). The presentation will be based on data provided - a draft is attached but it is not yet final. Attached is a style of presentation that I am comfortable with, but another style could also be perfectly suitable. The ability to start on this immediately (after I provide the final draft) and finish it quickly is important.
I am in need of a specialized WordPress developer with experience in Excel operations and data showcasing. Key tasks: - Create a WordPress page that extracts numeric and text data from an Excel sheet. - Implement highlights and color-coded information on the webpage for better readability and understanding. - The data on the Excel sheet will be updated on a monthly basis, hence the website should be able to fetch the data automatically upon any modifications. Ideal skills: - Proficiency in WordPress and Excel integration - Experience in creating visually appealing data showcases or infographics - Strong understanding of data extraction and display technologies The aim is to have a user-friendly webpage that accurately represe...
I'm in need of a proficient business writer to assist me in crafting a compelling executive summary for my business plan. This is a specialized task and requires a detailed understanding of business storytelling, summarizing complex business ideas and value propositions into clear, concise language. Ideal Skills: - Proven experience in business writing - Expertise in writing business plan executive summaries - Excellent business acumen and ability to grasp complex ideas Experience: - Experience writing for various business industries would be an advantage - Demonstrated ability in achieving results in tight deadlines I look forward to reviewing your proposals.
Require a draft sketch of the attached - Drawing Emphasis: The focus of measurements - Skillset: Candidates with proficiency in mechanical engineering and a specialty in structural components are encouraged to apply. Prior experience with motor base designs will be a significant advantage. Your task will be to create a functional and practical design, and your insightful input will be of great value.
I'm in search of an Excel expert who can assist me with complex tasks in Excel. Specifically, help is needed in two key areas: - Formulas & Functions: While basic arithmetic operations are simple for me, I need assistance with text and date functions. - VBA Macros: I'm looking for someone who can develop advanced user forms and interfaces. This requires a high level of VBA expertise. The ideal candidate would have a strong background in Excel, with a focus on formulas, functions, and VBA. Previous experience working on advanced macros and a deep understanding of text and date functions will be a huge plus. The ability to communicate effectively and understand my specific needs is essential.
reproduire le même a l'identique copier coller avec les calcule automatique les formule de la ou il ya tout les chiffre
I'm looking for a skilled and creative designer to help me conceptualize and design an appealing food truck that serves crepes. I would l...and creative designer to help me conceptualize and design an appealing food truck that serves crepes. I would like to use the same design "design idea" with the name of La bonne crepe de Maman. You have as well my company logo and the dimensions of the trailer. I would like to have a scan code for Instagram etc.. like the picture of the trailer and another Scan code on the top of the side window with the title Order by Phone. It needs to be in high quality to be print out. The design has 5 sides ( 2 front, 1 back, 2 side) Please use the dimensions provided, it will be printed as wrap. I need to have similar design p...
I'm in search of a versatile freelancer with skills in Word, Excel, programming, and graphic design. Your expertise in these areas will help me in different domains. Your main tasks will include: - Formatting documents in Word, ensuring a professional and consistent layout. - Creating Excel spreadsheets and conducting data analysis. Proficiency in Excel will be crucial to help me interpret and visualize data effectively. - Developing software or web applications. I am working with Java/Spring/JavaFX and am open to creative development ideas and solutions. - Designing logos and visuals. Your ability to create engaging and unique visuals will be a big asset to my projects. I am currently using Word 2010 and will be workin...
I'm looking for a skilled developer to assist with syncing an Excel file to my phpMyAdmin database. Key Requirements: - Real-Time Syncing: The sync should take place continuously in real-time. Any updates made to the Excel file should be reflected in my phpMyAdmin database instantly. Skills and Experience: - Proficient in Excel and phpMyAdmin - Experience in data syncing and database management - Familiarity with real-time data syncing No specific data validation or transformation is needed during the import process. The goal is to ensure that any changes made in the Excel file are accurately reflected in the existing database.
I'm looking for someone who can design a sophisticated budget template for me in Excel. This template should: - Track both income and expenses - Project weekly outcomes - Compare actual amounts to budgeted amounts - Include more than 20 budget categories - Incorporate graphs and charts for visual representation. Skills necessary for this project will include advanced Excel knowledge and experience with financial modeling. The ideal candidate will have previously worked with complex budget templates and be comfortable creating a user-friendly interface. You should know how to devise a system that simplifies input and keeps data organized and easy to understand. Your ability to turn raw numbers into straightforward graphs and charts will be particularly valuable...
I need a professional to convert the information in the attached document into an organized, well-formatted Excel sheet. The project will require you to: - Copy all the text content of the document into corresponding cells in the Excel sheet. - Transcribe all tables and charts in the document accurately into the Excel. - Maintain the original formatting of the data in the document. The Excel document should: - Include all columns and rows from the original document. - Not require any additional formulas or functions.
