Vba saxo trader dde excelงาน
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 ที่กำหนดให้
พิมพ์สูตรคณิตศาสตร์ได้ ตัวอย่างงาน
ต้องใช้ imacro คัดลอกข้อมูลจาก web site ลง excel
คีย์ข้อมูลต่างๆลง Excel การคัดลอกบทความต่างๆลง word
ทำ presentation งานโดยใช้ Powerpoint สามารถแทรกงานที่เป็นข้อมูล ตารางและกราฟ จาก data ที่เป็น Excel
Necesitamos una hoja de excel donde podamos introducir datos y sea dinamica, os enseñaria un ejemplo de algo que ya tenemos hecho Solo Hispanohablantes por favor, sino es muy complicado el entendimiento
O trabalho consiste em digitar 140 páginas de extratos que estão em PDF para uma planilha do Excel, conforme modelo (os extratos a serem digitados e o modelo de planilha estão nos anexos deste projeto)
I am looking for a freelancer who is proficient in data entry and familiar with Excel to assist in the digitization of a 276-page vintage parts manual. Your task would be to: - Accurately copy the information from pdf to Excel. This includes part numbers, the description of parts, and all other columns present in the original tables in the document. - Organize the spreadsheet such that each section of the document is represented by a separate worksheet. No specific data validation rules or cell formatting are required, but the data must be accurate and searchable in Excel. This job requires someone with a keen eye for detail and a good understanding of Microsoft Excel. Prior experience in similar data entry tasks would be a significant advantage. A sample pa...
I'm urgently in need of a VBA expert to help tune an existing Word VBA that's not performing as expected. Even though it runs, it's not accomplishing the task it was meant for. Key objectives for this project are: - Identification and resolution of current issues with the VBA to align with its original purpose - Modification of the VBA to extract Word OLEs, while entirely bypassing PDF files (skipping them). The ideal freelancer for this task will have: - Extensive experience in VBA coding and troubleshooting - Experience with OLE extraction from Word - Proven track record in meeting deadlines. The timeline for this project is within a month. If you think you're the right fit for this project, I'd like to hear how you can hel...
Looking for an expert who can import data from 1-10 Excel files into Google Earth. Key tasks: - Convert location data from Excel into a format readable by Google Earth (preferred Google Eath Pro Tours for Commercial Real Estate Properties - Ensure perfect alignment of data with the geographical locations - Grouping and categorizing the locations as per the content of each column within the Excel files Ideal candidate: - Proven experience with data visualization tools, particularly Google Earth and Google Earth Pro tours for Commercial Real Estate Properties -- High proficiency in handling Excel files and data - Understanding of Geographical Information Systems would be a bonus.
I have a MySQL database that needs exporting. All user data, product data, and transaction data are required to be exported. Key Tasks: - Export all MySQL user data - Export all MySQL product data - Export all MySQL transaction data The final export should be in Excel format. This is not a job for beginners. You should have prior extensive experience with large database exports and MySQL. It would be a big plus if you're familiar with handling sensitive user and transaction data. As the project involves substantial data, confidentiality and data security are non-negotiable. Please include samples of similar database exporting projects you've completed.
I am in need of an Excel spreadsheet expert to create an Excel template using a PDF sample. Without being specific about the details, the ideal candidate should have excellent skills in extracting data from PDFs and well-versed in designing Excel templates. Here's what I'm looking for: Mactacquickshipsellsheet pdf converted into an excel sheet example of what I would like as template.
Database Tool Development I. Introduction 1. Purpose: The DRP Talent Solutions team currently manages an internal workforce partner database developed in-house and updated internally. This resource, currently in an Excel spreadsheet format, is used to assist employers in navigating our regional workforce programs and partners. To enhance its utility in responding promptly to RFIs (Request for Information), we aim to reinforce this database tool. Our objectives include implementing organizational features with multiple tags for efficient categorization and establishing a user-friendly update and maintenance system that does not require consultant engagement. 2. Objectives: i. Objective 1: Enhance Database Organization 1. Introduce multiple tags for easier navigation and filtering ...
I'm in need of an Excel expert to help me with intermediate-level spreadsheet formatting. The tasks include moving data from sheet to another sheet Ideal Skills and Experience: - Proficiency in Excel
I am looking for a freelancer to assist me with a data entry project. The task involves typing data from handwritten documents into a digital format. The data must be formatted in a specific way, so attention to detail is important. Skills and Experience: - Proficient typing skills and accuracy - Experience with data entry and handling handwritten documents - Familiarity with formatting data according to specific guidelines - Ability to work efficiently and meet deadlines The project includes 1-10 pages or documents that need to be entered. If you are interested in this project, please provide examples of previous data entry work and explain your experience with formatting data.
I'm looking for a talented Excel programmer to build an Excel tool tailored for my business' quotation procedures. Notably, this tool must provide these key functions: - Automatic Price Calculation - Customized Quotation Template Design I already have a specific design in mind for the quotation template and would require the freelancer to implement my design concept accurately. A potential candidate should have considerable Excel programming skills coupled with a solid understanding of quote creation processes. A sense of accuracy, creativity, and robust attention to detail would be beneficial for this task. Outputs should be precise and user-friendly, ultimately contributing to streamlining our current operations.
I'm looking for a talented Excel programmer to build an Excel tool tailored for my business' quotation procedures. Notably, this tool must provide these key functions: - Automatic Price Calculation - Customized Quotation Template Design I already have a specific design in mind for the quotation template and would require the freelancer to implement my design concept accurately. A potential candidate should have considerable Excel programming skills coupled with a solid understanding of quote creation processes. A sense of accuracy, creativity, and robust attention to detail would be beneficial for this task. Outputs should be precise and user-friendly, ultimately contributing to streamlining our current operations.
I'm looking for a skilled Excel expert who can help with adjusting product pricing, adding products, creating formulas, adding products etc via excel, .csv. This is a ongoing project. If you can upload .csv to wordpress is a big plus!! KEY REQUIREMENTS: - I specifically need assistance with spreadsheet automation. - The work required is at a basic level, focusing on formulas and functions. - Implement automation for the designated tasks. - Ensure that the automation is robust and well-documented. SKILLS & EXPERIENCE: - Proficiency in Excel is a must. - Experience in basic spreadsheet automation. - Strong understanding of formulas and functions. - Attention to detail and commitment to quality.
I'm looking to develop an Artificial Intelligence (AI) charges calculator for Excel. The core functionalities include: - Automatic calculation of fixed charges - User-friendly interface for effortless interaction and data management. - Reliable data input validation to ensure accuracy and consistency. - Calculate Profit based on fixed charges and earning from subscription The calculator will primarily handle financial data. Prospective freelancers should have a strong grip on Excel, data validation, and UI/UX design—along with financial acumen for effective calculator development. A successful execution ideally enhances efficiency and aids with precise financial management.
I'm in need of a meticulous and reliable freelancer to assist with online data entry tasks. You'll be required to input data into spreadsheets using platforms like Excel or Google Sheets. The data will be provided to you in digital formats, such as PDFs, Word documents, or scanned images. Key Requirements: - Proficiency in online data entry - Experience working with spreadsheets (Excel, Google Sheets) - Ability to maintain accuracy and attention to detail - Familiarity with handling data in digital formats Ideal Skills: - Previous experience with similar data entry projects - Proficiency in using Excel or Google Sheets - Background in spreadsheet management - Strong attention to detail and accuracy A successful candidate will be someone who can ensure da...
I would like a custom sales order created in Excel for about 50 different items. Key Requirements: - Each item's entry in the order should include item name, quantity, and description. - The items should be sorted by their ship date. - The system should incorporate a feature to apply a total discount on the order. Ideal Skills and Experience: - Advanced Excel Skills with the ability to create customized sales orders - Proven experience in developing financial/ordering spreadsheets - Excellent understanding of sales order process and discount mechanisms.
I'm looking for an experienced PostgreSQL professional capable of analyzing and generating reports from sales data. Key Responsibilities: -Analyzing sales data stored in PostgreSQL -Generating insightful reports based on analysis Ideal candidate should excel in PostgreSQL and possess strong data analysis skills. Previous experience with sales data is an advantage, however, specific functionalities required for the analysis have been left open-ended for your expertise to fill. Please outline in your proposal any relevant experience and your approach to this task.
If C4 and D4 have no entries, make E4 blank. If C4 and D4 have values, perform C4/D4 in E4.
We are existing business seeking a savvy freelance commodities trader to focus on agricultural commodities on the international markets (Europe, Asia Middle East are the main consumers, other markets to be defined), more precisely we are looking to sell Premium and graded Frankincense Resin from Somalia. Key responsibilities include: - selling Premium Frankincense Resin (aka Boswellia carterii and frereana resins) to international buyers Ideal candidates should have: - Having a strong network of potential buyers (preferably known contacts but not a must) - Prior experience in trading agricultural commodities (having experience in the market and established contacts) - Understanding of international markets
I need an expert in data formatting to help me clean and organize a large Excel file. The file currently contains unformatted data that needs to be segmented into distinct columns. I need the data separated into the following categories: - First Name - Last Name - Company Name - Position The ideal candidate for this job should have: - Proficiency in working with large Excel files - Experience in data segregation and formatting - Attention to detail to ensure data accuracy - Ability to follow instructions and deliver in an Excel file format Given that there are more than 500 entries in the file, efficiency and accuracy are key. The final deliverable should be an Excel file with the formatted data ready for use. If you have read till and reviewed the file, wr...
I'm seeking an expert who can assist with developing a comprehensive data analysis and automation solution within SMART sheet and Excel. Key Responsibilities: - Develop custom dashboards for financial analysis within Excel. - Automate data management processes within both SMART sheet and Excel. - Integrate the dashboards into SMART sheet for seamless use. Ideal Skills & Experience: - Strong expertise in SMART sheet and Excel, including VBA. - Proven track record of developing dashboards for financial analysis. - Ability to automate data management processes. - Excellent communication skills. Please provide examples of similar projects you've completed.
I need to scrape specific information from a website for all search results with a particular key. The data should include Name, Address, Phone number, Email, Company name, and Job title. This data should be organized into an Excel file, with each category of information in separate columns. Ideal Skills: - Proficient in Excel VBA - Experience in web scraping - Understanding of VPN usage to access region restricted sites Please note that the website will only work with a USA VPN.
I am looking for a professional lead generation expert with experience in the real estate industry who can help me to collect real estate l...a professional lead generation expert with experience in the real estate industry who can help me to collect real estate leads within the Greater Toronto Area. In this role, you'll be responsible for collecting leads of FSBO (For Sale by Owner), expired listings, and "Rent by Owners." I need - Collection of leads' name and contact information and collection of property address and specifics in excel sheet. The ideal candidate for this role should have: - Proven experience in real estate lead generation - Strong understanding of the real estate industry and the different types of leads within it - The ability to work indepe...
I am looking for a professional who can create an Excel sheet that will help me manage my product list and other essential production data. The excel file requires: - Filtering and Sorting Capabilities: The sheet should be able to sort and filter data easily. - Inventory Tracking: It is crucial that the sheet can track inventory levels to prevent overstocking or shortages. - Report Generation: The ability to generate reports will help me keep track of my production and make informed decisions. I need the excel file to have less than 10 columns, as I believe this will keep the sheet concise and easy to manage. The level of automation I am looking for is manual data entry with some formulas. This will help reduce manual work and ensure the data input is accurate. Idea...
I am looking for a professional lead generation expert with experience in the real estate industry who can help me to collect real estate l...a professional lead generation expert with experience in the real estate industry who can help me to collect real estate leads within the Greater Toronto Area. In this role, you'll be responsible for collecting leads of FSBO (For Sale by Owner), expired listings, and "Rent by Owners." I need - Collection of leads' name and contact information and collection of property address and specifics in excel sheet. The ideal candidate for this role should have: - Proven experience in real estate lead generation - Strong understanding of the real estate industry and the different types of leads within it - The ability to work indepe...
Do you understand instructions when given and can do tasks on excel? Are you a beginner? Are you free right now to work with me and read the data in pdf so I can write it on excel? If your answer if yes to all of that question bid by asking any question regarding this post to make your bid high quality. NEEDS TO BE DONE TODAY. WILL TAKE 3-4 HOURS APPROXIMATELY. (just an approximation)
...comprehensive e-commerce website focusing on car accessories. While I haven't specified the exact kind of accessories to be included and the target audience, your expertise in the automotive industry will be invaluable in determining these aspects. The platform will need to be user-friendly and engaging, with a strong focus on showcasing the products effectively. Some of the key areas you'll need to excel in include: - E-commerce website development - UX/UI design with a focus on automotive products - SEO optimization - Payment gateway integration - Responsive and mobile-friendly design It's vital that the end product is not just a sales platform, but a community hub for car enthusiasts and owners to find and discuss the latest and most innovative car acces...
I'm in need of an Excel expert to help me with intermediate-level spreadsheet formatting. The tasks include moving data from sheet to another sheet Ideal Skills and Experience: - Proficiency in Excel
I want to use Microsoft power automate for a simple RPA on my desktop browser. I want to repeatedly run a search on 6 websites which are ...extracted from individual PDF documents by going into each individual case docket and opening a certain document called a summons, which will have the defendant's address usually in the middle of the page, but always on the first page of the summons. Some of the summons are not PDF readable so I will need OCR functionality. Finally, when the data points are extracted, they can be exported into an excel file for mail merge and printing (that the easy part). The objective is to create about 7,000 individual mailings each month and to run the automation about twice per week. I need help finding the right OCR tools to work with power automate. ...
