Convert excel vba macros openoffice calcงาน
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
พิมพ์สูตรคณิตศาสตร์ได้ ตัวอย่างงาน
ต้องใช้ imacro คัดลอกข้อมูลจาก web site ลง excel
คีย์ข้อมูลต่างๆลง Excel การคัดลอกบทความต่างๆลง word
ทำ presentation งานโดยใช้ Powerpoint สามารถแทรกงานที่เป็นข้อมูล ตารางและกราฟ จาก data ที่เป็น Excel
I'm in urgent need of an experienced professional who ...Your main task will be to find data on mortgage foreclosures sold within the past 90 days. Key Responsibilities: - Collect data from public records, real estate websites, and county auctions. - Input data into an Excel sheet with a flexible structure. Key data points include: date of sale, foreclosed address, city, county, state, owner name, phone, email, opening and closing bid. - Leave cells blank for missing data. Ideal Skills and Experience: - Previous experience in data collection, particularly in real estate or mortgage foreclosures is preferred. - Proficiency in Excel with a keen attention to detail. - Strong understanding of honesty and accuracy in data reporting. Please do not waste my time if you cann...
I'm seeking an expert to convert my current web app into a locally hosted Angular app. This project also involves creating custom-built connectors for orchestration software that links the local app to AWS. Key Requirements: - Development of a local version of the web app with full data synchronization capabilities with AWS. - Implementing automated backups and error logging features in the orchestration software. - Creating custom-built connectors for AWS interaction. Ideal Skills: - Proven experience with Angular and web app development. - Strong background in AWS and creating custom connectors. - Proficient in implementing data synchronization, automated backups, and error logging. - Knowledge in user authentication, data visualization, and file uploads would be beneficia...
...Accessibility Designer/Operator with expertise in both Adobe products (InDesign, Acrobat, etc.) and Microsoft Office (Word, PowerPoint, etc.). Your role will be to ensure that documents meet WCAG 2.1 standards, providing accessibility for all. Key Responsibilities: Format and remediate PDF documents to meet WCAG 2.1 standards. Ensure accessibility compliance for Microsoft documents (Word, PowerPoint, Excel) and export them correctly to accessible PDFs. Use Adobe Acrobat and accessibility tools to add tags, alt text, and fix reading order. Conduct accessibility checks and resolve issues flagged by tools like Adobe Accessibility Checker and Microsoft Accessibility Checker. Key Requirements: Proficiency in Adobe InDesign, Acrobat Pro, and Microsoft Office tools. Strong k...
...consolidate it into a data source - preferably Microsoft Azure - for real-time PowerBI dashboards and reports. There are about 9 fields from Autotask, 3 from Quickbooks Online, and 4 fields from Excel which I need to have all in one place for analysis. Key Responsibilities: - Consolidate data from diverse sources, including Excel files, Google Sheets, Autotask, and Quickbooks Online. - Focus on Financial and Sales data primarily. - Ensure the data is clean, well-structured, and ready for analysis. Ideal Skills: - Proven experience with data consolidation from multiple sources. - Strong proficiency in Excel and working with Google Sheets. - Familiarity with Autotask and Quickbooks Online is a plus. - Expertise in preparing data for analysis in Power BI. I have f...
Seeking a talented professional experienced in converting two photos into Line Art. Must be skilled in digital drawing and proficient with tools like Adobe Photoshop, Procreate (for iPad), Clip Studio Paint, and Corel Painter. The final illustration should be provided in a high-resolution format (e.g., PNG or JPEG) suitable for sharing, printing, websites, and social media platforms. This project must be completed within 24 hours.
Project: 280-Page Word Document to PDF Conversion Overview Convert a 280-page Word document into a high-quality PDF using InDesign. Maintain consistent formatting, typography, and Arabic language accuracy. Daily target: 16 pages. Schedule: Monday - Friday. Payment: Upon successful completion of the entire project. Budget & Time Budget: 50-100 USD. Estimated time per page: 30 minutes. Requirements Fluency in Arabic. Expert InDesign skills (including Arabic typography). Strong project management & communication. Meticulous attention to detail. Application Only applicants meeting all requirements and comfortable with the budget & time will be considered.
...remote job. MS-SQL database expertise is required. The office hours are from 9 A.M. to 6 P.M., and lunch is complimentary. The project involves: - Implementing new features. - Bug fixing. - Performance optimization. The new features to be added include: - Customizable reports. The level of customization for the reports includes: - User-defined filters - Customizable layouts - Export options (PDF, Excel) Ideal candidates should have: - Extensive experience in raw PHP - Proven track record in developing reporting panels - Ability to work under pressure and meet deadlines - Excellent problem-solving skills for bug fixing and performance optimization - Experience in implementing new features in a timely manner - Skills in developing customizable reports - Familiarity with creatin...
...Design and develop a user-friendly, visually appealing online store. Features needed: responsive design, secure payment gateways, easy navigation, product filtering, and a seamless checkout process. Integration with inventory management tools and shipping options. 2. Digital Advertising for Sales Growth: Facebook and Instagram Ads campaigns designed to drive traffic to the online store and convert visitors into customers. Strategy to target users based on demographics, interests, and behaviors, focusing on people interested in traditional clothing or cultural products. 3. SEO and SEM for Online Visibility: On-page and off-page SEO to position the store on the first page of search engines. Keyword research to optimize the website and product pages. Google Ads campaign...
I am looking for a professional who can help me grow my Instagram account effectively. Additionally, I want to create Instagram videos using AI tools. I already have a script created with ChatGPT, and now I need someone to help me convert the text into videos, incorporating my own voice for narration. Requirements: 1. Instagram Growth Strategy: - Provide actionable suggestions to grow my Instagram account. - Share insights on optimizing content, hashtags, posting schedules, and engagement techniques. - Suggest trends relevant to my niche (astrology/tarot reading). 2. AI Tool Expertise: - Must be familiar with AI tools that can create high-quality videos from text. - The tool should allow voice cloning or the addition of my voice to narrate the script. ...
I'm seeking a professional who can convert a picture into a 3D model suitable for 3D printing. Requirements: - Convert provided picture into a low-detail 3D model - Deliver the model in STP file format Ideal Skills: - Proficiency in 3D modeling software - Experience with preparing models for 3D printing - Ability to deliver in specified file format
I have a floor plan for a house and I need it converted into a 3D video. The level of detail should be medium, with detailed textures and basic furniture. The interior design theme is traditional. - Video Creation: Convert the provided floor plan into a 3D video. - Editing: Afterwards, the video will need to be edited according to customer requirements. - Design: The 3D video should include detailed textures and basic furniture, in line with a traditional interior design theme. - Skills Needed: Proficiency in 3D modelling software, video editing skills, and a good understanding of traditional design aesthetics. Please note, the specifics of the areas to be included in the 3D video have not been finalised yet.
I'm looking to create a comprehensive PDF Software solution. The project entails building a web application akin to along with a desktop version compatible with Windows, MacOS, and Linux. Primary Functionalities: - Sign PDF both digital signature and drawn signature. - Merging PDF files - Splitting PDF files - Editing PDF content - Convert PDF to Word and vice versa Ideal candidates for this project should have: - Extensive experience in software development with a focus on PDF tools - Proficiency in cross-platform application development - Strong skills in creating user-friendly interfaces A solid understanding of implementing PDF functionalities and creating seamless desktop and web applications is crucial. While the web application's user authentication methods are...
I need an Excel report that handles financial data, including expense tracking, revenue generation, and profit and loss analysis. The report needs to have interactive features such as pivot tables and interactive charts. Ideal Skills: - Proficiency in Excel, particularly with pivot tables and creating interactive charts - Experience working with financial data - Ability to create comprehensive and easy-to-understand Excel reports
I'm looking for someone to complete an excel spreadsheet with financial data sourced from various company websites. This project will primarily involve researching and collecting data related to property purchase prices, monthly rent amounts, lease start dates, and lease lengths. Ideal candidates for this project should: - Have experience with data collection and Excel - Be detail-oriented and able to work independently - Have a basic understanding of financial metrics and real estate - Be able to source reliable data from company websites Please provide examples of similar projects you have done in the past.
Requirement for Formatting Output Using Microsoft Copilot in Word or Excel We are using Microsoft Copilot in Word and Excel, where we provide a document with a specific format as input. When we give prompts, such as "Create a new website" or "Suggest a laptop for purchase," Copilot generates content correctly based on the prompt. However, the output does not retain the same format as the input document. Our requirement is that the output should match the exact format of the input document, including colors, fonts, bold, italic, and other formatting. Currently, we must make additional adjustments to achieve the desired format, which is time-consuming. We discussed this with Microsoft, and they suggested that we could add agents to address this issue. We ...
I'm looking for an experienced data analyst or Excel specialist to create a dynamic spreadsheet for me. I have sales data from 5 stores, and I want a spreadsheet that I can upload weekly sales into. This spreadsheet should calculate: - Weekly and monthly running totals for items sold per store - Total sales across all 5 locations The data points I have include: 1. Date of sale 2. Item 3. Transaction number 4. Price sold at 5. Store # If a customer buys 3 of the same item, it will give me 3 separate lines of data (i.e., all sales listed are quantity of 1). I will be uploading my data weekly through a CSV file into Microsoft Excel. The spreadsheet needs to be able to generate the following reports: - Weekly total sales - Monthly total sales - Item-wise sales per store...
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 1 another website , VERY easy because 2 /3 brand 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.
I'm looking for a research assistant who can help me collect and analyze both quantitative and qualitative data fo...research assistant who can help me collect and analyze both quantitative and qualitative data for an academic project. Key Responsibilities: - Data Collection: Gather both quantitative and qualitative data relevant to the research. - Data Formatting: Organize and prepare the collected data in Excel/CSV files and Word documents. - Data Analysis: Analyze the data to extract meaningful insights. Ideal Skills: - Proficient in data collection and analysis - Experienced in academic research - Skilled in using Excel and Word - Capable of working with both quantitative and qualitative data. Please, only apply if you're experienced in academic research da...
Key features of your custom CRM 1. User management: • Role-based access for administrators, team members and other user groups. • Secure login and tracking of user activity. 2. Leads and Opportunities Tracking: • Centralized dashb...to assign tasks and leads to team members. 3. Workflow Automation: • Automate repetitive tasks like follow-ups, reminders, and approvals. 4. Communication: • Integration with email, messaging or telephony systems for seamless communication. • Notification system for important updates. 5. Reporting and Analysis: • Customizable dashboards to track key metrics. • Exportable reports (PDF, Excel) for performance reviews. Depict corporate structure: Main business can have multiple subsidiaries, and eac...
I am looking for a macro developer for PC that can help me automate the process of "opening" gifts in Hypixel Skyblock in Minecraft. Ideal Skills: - Experience with creating macros for PC games - Extensive understanding of Minecraft gameplay and mechanics, particularly Hypixel Skyblock - Proficiency in programming languages suitable for macro development - Knowledge of PC gaming hardware and software The macro needs to be efficient and unobtrusive, allowing for smooth gameplay without drawing attention.
I'm looking for a skilled professional to convert 4 of my PSD files into Figma. I need all layers to maintain the same structure as in the original PSD files. The Figma files should be completely editable, similar to how they currently are in Photoshop. Additionally, please ensure that all Adobe fonts used in the designs are included. Key Requirements: - Convert 4 PSD files into Figma - Connect 4 Figma pages to each other - Maintain original layer structure from PSD files - Important that everything stays organized - Ensure all design elements are editable - Include all Adobe fonts Please note, I do not need any new design elements or components to be added. The Figma files should only contain conversions of existing elements. See attached screenshots. I blocked out ...
...will be part of a single WordPress multisite installation but must have unique designs, colors, and themes for distinction. - Menu & Navigation: The menu should be designed to clearly explain the purpose of each site, making navigation intuitive for visitors. - Conversion of Example Sites: We will provide example versions of the websites (created online), and the freelancer will convert these into WordPress sites. - Content Integration: - Text and structure will be provided, but the freelancer will translate the content into English. - The homepage should feature summarized text, bullet points, and a creative, engaging structure. - Design Requirements: - A strong eye for color schemes and image selection, ensuring relevance and emotional impact...
I'm seeking a skilled mobile app developer to create a multi-faceted application for both iOS and Android. The app will encompass three key areas: a learning section, a paper trading segment, and an interactive gaming section. Key Features: - Learning: Users will access external online video lectures via a browser link. - Paper Trading: Users can convert real money into virtual currency for trading. If they lose all their virtual currency, they must purchase more. - Gaming: Users can engage in virtual trades against one another. The trading outcome is based on who gains more or loses less over a given time period. The app will charge a 10% platform fee on total trade value. User Experience: - The app will display index candles from a third-party source concurrently with the t...
I have a ZIP file containing a project that currently requires Power BI to activate. I need this converted into an API that can handle user data. Key Requirements: - Convert the ZIP file into a usable API - API should be capable of handling user data - Implement data filtering functionality within the API Given the budget is around $25, I am looking for a quick and easy solution. The ideal freelancer for this project should have: - Experience in API development - Knowledge in handling and filtering user data - Ability to convert files from various formats into an API.
I'm looking for a skilled Visual Basic programmer who can help me develop an Excel macro. This macro needs to automate data entry tasks in a spreadsheet. Key Responsibilities: - Develop an Excel macro using Visual Basic. - The macro should be capable of automating repetitive data entry tasks. - Ensure the macro is user-friendly and efficient. Ideal Skills: - Proficiency in Visual Basic, particularly in creating Excel macros. - Experience with data entry automation. - Excellent problem-solving skills and attention to detail.
I'm looking for an experienced architect who can convert my existing house plans (provided in Chief Architect or DWG format) into comprehensive construction documents using Chief Architect or CAD software. Key Responsibilities: - Transform current house plans into detailed and accurate construction documents, including complete specifications and annotations. - Ensure all drawings comply with local building codes, energy efficiency standards, and national building codes. - Provide multiple views and detailed sections of the construction plans. Ideal Skills and Experience: - Proficiency in Chief Architect or CAD software is a must. - Extensive experience in creating construction documents from house plans. - Strong knowledge of local building codes and energy efficiency stand...
I'm looking for a professional to compile an extensive list of exhibitors from the Fitur trade show. This list will need to be more than 200 exhibitors and should include: - Company name and contact details - Product or service offerings - Booth number and location The final data should be delivered in a Spreadsheet (Excel/CSV) format. Ideal skills for this job include: - Attention to detail: It's crucial that the information recorded is accurate. - Proficiency in Excel: The final product should be well organized and easy to understand. - Research skills: You may need to look beyond the official exhibitor list to get a comprehensive view. Experience in data compilation and familiarity with trade shows will be an added advantage.
I'm in need of a freelancer who can compile a list of exhibitors from Fitur 2025. This list should be formatted in Excel and include: - Company Name - Exhibitor's Country - Email - Phone Number Please note that this list should be sourced from other trusted sources, not the event's official website or a public directory.
