Export file list 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 วันให้ทั้งแถวเปลี่ยนเป็นสีแดง
...ที่กำหนดไว้ 5. สามารถ 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 รายงานออกมาเป็น e...
ทำ 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 ที่กำหนดให้
โปรแกรมสามารถแสกนลายนิ้วมือได้ โดยเชื่อต่อกับ SQL Server เมื่อลงเวลาออกสามารถ auto export file เป็น text ออกมาได้ (ต้องมีการคุยรายละเอียดกันอีกที)
พิมพ์สูตรคณิตศาสตร์ได้ ตัวอย่างงาน
...Concept , มีรูป ให้ 1. รถยนต์มือสอง 1.1 Download excel file format การกำหนดราคา รถยนต์มือสอง 1.1.1 Download excel file ใน Format ของการกำหนดราคา โดยเลือกเงื่อนไขได้ 2 วิธี 1.1.1.1 เลือกตามยี่ห้อ สามารถเลือกได้มากกว่า 1 ยี่ห้อ 1.1.1.2 เลือกตาม segment เลือกได้ครั้งละ 1 segment 1.1.1.3 ถ้ามีราคาที่เคยกำหนดในระบบให้แสดงด้วย 1.1.2 แสดงรุ่น รุ่นย่อยทั้งหมดตามเงื่อนไขที่เลือกด้านบน 1.1.3 แสดงข้อมูล 1 sheet ต่อ 1 ยี่ห้อ 1.2 Upload excel file การกำหนดราคา รถยนต์มือสอง 1.2.1 สามารถ Upload การกำหนดราคา รถยนต์มือสอง จาก excel file ในขั้นตอน Download เพื่อเพิ่มหรือปรับปรุงราคา รถยนต์มือสอง 1.3 Export ราคา รถยนต์มือสอง 1.3...
ต้องใช้ imacro คัดลอกข้อมูลจาก web site ลง excel
โปรแกรม track job status, สามารถ export data และส่งเมล์ ได้
คีย์ข้อมูลต่างๆลง Excel การคัดลอกบทความต่างๆลง word
ทำ presentation งานโดยใช้ Powerpoint สามารถแทรกงานที่เป็นข้อมูล ตารางและกราฟ จาก data ที่เป็น Excel
ฉันมีไฟล์ .exe แต่ฉันต้องการเปลี่ยนให้มันรองรับกับภาษาของฉัน เพราะว่าตอนนี้มันไม่อ่านฟร้อน ไทยมันแสดงผลเป็นสี่เหลี่ยม i have file .exe but i want change language is my language
I'm in need of a professional who can convert a PDF document to Excel format. The PDF contains a mix of text, tables, and images, which must be meticulously replicated in the Excel format. Key requirements: - Handle mixed content: The PDF has a mix of text, tables, and images. You should be able to accurately translate this diverse content into Excel. - Replicate PDF layout: The layout of the PDF needs to be maintained in the Excel format. This means tables should look the same, images should be placed correctly, and the text should be in the same positions. Ideal skills and experience: - Proficient in PDF to Excel conversions: You should have experience in converting PDF documents with mixed content to Excel while maintaining layout integr...
...code to extract a table from an HTML file. I need an expert in Python, Pandas and BeautifulSoup4 to review and make minor adjustments as necessary. The purpose of the table extraction is for data analysis. The HTML file has multiple tables with some nested elements, not overly complex. Key Requirements: - Need an expert in Python programming - Familiarity with Pandas and Beautiful Soup - Experience in data analysis The job mainly involves reviewing the existing code, fixing any issues that may hinder the data extraction, and ensuring that the extracted table is ready for analysis. Please note that no additional data preprocessing is required, just fixing the current code. --- name "iXBRL" , inside folder contain multiple html file, each html file...
Ho bisogno di un programma che mi permetta di aggiornare disponibilità e prezzo di vendita dei prodotti presenti nello store shopify partendo da un file excel/csv che viene generato automaticamente ogni x ore e viene esportato dal getionale su cartella FTP
I have a project that requires purely text data entry. I have a set of handwritten notes which need to be entered into a spreadsheet. Key Requirements: - The data is text-based, and it's crucial that the freelancer can transcribe this accurately and efficiently. - Proficiency in using spreadsheet software like Excel or Google Sheets is a must. Ideal Skills: - Fast and accurate typing skills - Proficient in using spreadsheet software - Experience with data entry, especially from handwritten sources
...Project Scope: • Research and identify qualified sign manufacturers/companies/suppliers/sellers/stores across France. • Utilize various online resources, including: o Search engines (Google, Bing, etc.) o Social media platforms (Facebook, Instagram, LinkedIn) o Industry directories and publications (list specific resources if known) o Business databases (mention specific databases if known) • Gather and verify contact information (name, email, phone number) for each lead. • Compile lead data into a Excel format . Qualifications: • French reading and understanding - ONLY • Excellent research and data collection skills. • Proficiency in using online search tools and social media platforms. • Strong attention to detail and accuracy. &b...
...Fiber (+$20) | Black Carbon Fiber (+$20) Bottom: Royal Blue | Navy | Hunter Green | Lime Green | Teal | Seafoam Green | Fighting Lady Yellow | Yellow | Orange | Pink Ice | Red | Purple | Black | White Carbon Fiber (+$20) | Red Carbon Fiber (+$20) | Blue Carbon Fiber (+$20) | Gray Carbon Fiber (+$20) | Black Carbon Fiber (+$20) Solutions I have Come Across: Native WooCommerce: export variables to Excel, edit, and reimport. Not an easy solution. Plugins: there are lots of plugins that are overkill and plenty that don't do enough. Script Snippet: I have seen several PHP snippets where you can add cost to a product. I prefer this over a bulky plugin since the only challenge is adding the $20 upcharge to the dynamic base price based on size. Example:
I need an Excel tool that can sort data by category and provide users with an interactive experience. I'm looking for an experienced Excel developer who can create a user-friendly, yet advanced, Excel tool. The tool should have the following features: - **Filtering**: The tool should allow users to filter data by category. This is a crucial aspect of the tool's functionality, as the data will be organized by this field. - **Interactive Buttons**: I would like the tool to have buttons that allow users to sort data. When a button is clicked, the data should rearrange itself based on the selected category. For example, when a user clicks on the button related to 'Category A', all data entries related to 'Category A' should be displayed. -...
From 2.5 lakh records, need to find the duplicate data and make different sheets with unique data. Example: In a sheet of alphabets, that have multiple A’s, B’s, C’s. Now I need separate them and make a sheet with all A’s, separate sheet with all B’s, another sheet with all C’s.
I'm in need of a skilled individual who can assist me in creating flat file templates for Amazon. I need a highly experienced Amazon listing expert. I need it in 24 hours. I will also work with you there are 1125 products. And Raw file is ready upc, description, Sku etc. It is copy paste work. - The task will involve exclusively the creation of the templates, not data importing or formatting. - Please specify your experience with Amazon's flat file system when responding. Ideal skills: - Proficient in creating flat file templates for Amazon - Prior experience with Amazon's flat file system - Excellent attention to detail
I'm in need of a skilled individual who can assist me in creating flat file templates for Amazon. I need a highly experienced Amazon listing expert. I need it in 24 hours. I will also work with you there are 1125 products. And Raw file is ready upc, description, Sku etc. It is copy paste work. - The task will involve exclusively the creation of the templates, not data importing or formatting. - Please specify your experience with Amazon's flat file system when responding. Ideal skills: - Proficient in creating flat file templates for Amazon - Prior experience with Amazon's flat file system - Excellent attention to detail
I need a professional to help me with my PES file resizing and correction for a cotton fabric project. Key Tasks: - Resize the design to fit within the 4x4 to 8x8 inches range - Digitize the design for optimal stitch density - Ensure the color scheme is correct and suitable for the final product (cotton fabric) You should have: - Proficiency in embroidery software, specifically with PES files - Experience in resizing and correcting embroidery designs - Understanding of different materials' requirements, especially cotton - Attention to detail - Portfolio of similar projects Please provide me with an overview of your experience and some examples of past work.
As a burgeoning home decor export business, I'm seeking a skilled graphic designer, versatile enough to bring a breath of fresh creative ideas to houseware items. Primarily, your task will involve creating engaging and market-friendly designs for mugs, plates, kitchen canisters, barware, and more. While I am open to design styles, your work should be flexible enough to cater to a variety of aesthetics. Your responsibilities would also include: - Developing and presenting concept ideas for the artwork - Producing final designs in line with our specifications - Revising the designs based on feedback The ideal candidate has: - Proficiency in graphic design software - Experience in designing printable artwork for physical products - Open-mindedness to experiment with different s...
I'm looking for a professional who can help with Excel work, primarily focusing on formula creation and formatting tables. Key Requirements: - I need assistance in creating formulas that can automate calculations and processes in Excel. - I'm looking for a clean and simple format for my tables, in line with a minimalist style. Ideal Freelancer: - Proficient in Excel, with a deep understanding of formula creation. - Experienced in table formatting and design, with a flair for minimalism. - Able to deliver high-quality, error-free work in a timely manner.
I have an Illustrator file that needs some text changes. All the new text content is ready, so the task mainly involves swapping out the existing text with the updated content. Ideal skills and experience for this project: - Proficiency in Adobe Illustrator - Strong attention to detail - Ability to follow instructions accurately Attached is a sample. Required modifications. 1. Change bar code. 2. Tidy up the text. 3. Duplicate the file and update some text. 4. Resend me with the right dimensions.
Hi Ishaq A., My Printer says that The logo file in one of the rewind bag artwork files for Mulberry Tree brand is too small. Can you please fix the logo and change to the two coloured versions used in the artwork
I'm looking for a skilled Power BI developer who can create detailed financial reports and dashboards, primarily based on data from Excel spreadsheets. Key Responsibilities: - Develop compelling, visually appealing reports and dashboards that are easy to interpret and navigate. - Tailor the reports and dashboards specifically to financial analysis, ensuring they provide the insights necessary for informed decision-making. Ideal Candidate: - Proven experience creating financial analysis reports and dashboards in Power BI. - Proficiency in integrating data from Excel spreadsheets. - Strong attention to detail and the ability to translate complex financial information into clear, concise visual elements. This project requires a high level of expertise in Power BI, fin...
I have a 58-second audio file with speech that has been marred by background noise. I'm seeking a professional audio engineer who can clean up the file and remove the static, ensuring the final audio quality is as pristine as possible, with minimal to no background noise remaining. SECOND HALF OF AUDIO NEED TO CLARIFY VOICES- YOUNG BOY TALKING TO HIS FATHER WHO HAS PLANTED EVIDENCE FOR HIS OWN CRIME. NEED TO HEAR IT AS SOON AS POSSIBLE This task requires someone well-versed in audio editing who can preserve the original content while significantly reducing the presence of background noise AND PERHAPS LOWER THE OVERLAPPED FAKE POLICE YELLING ON TOP.... Experience with radio or similar audio content is a plus. ANYONE WHO CAN DO IT FAST.
...Python file that was running fine last night for data analysis purposes. However, after trying to upload the '' file to GitHub, I encountered an error due to the file size being too large for GitHub. I need to get the Python file running again, but with the '' file stored on an external service to work around the file size limitations of GitHub. Key requirements include: - Identifying and resolving the issue causing the Python file not to run - Storing the '' file on an external service and adjusting the Python code to access it from there Ideal Skills and Experience: - Proficiency in Python - Experience with data analysis and handling large datasets - Familiarity with version control, specifically u...
I'm seeking a seasoned back-end engineer with expertise in Node.js and MongoDB. Your primary responsibility will be developing APIs that integrate seamlessly with external services. Key tasks include: - API development: You should have a proven track record of creating robust, efficient APIs. - Integrating with third-party services: The APIs ...scalability is crucial, even if it is not explicitly stated as such by the client. Ideal skills and experience for this job include: - Proven track record of API development in Node.js - Strong understanding of MongoDB - Experience in integrating various third-party services - Prior work on projects with high performance and scalability requirements If you believe you have the necessary skills to excel in this role, I encourage you t...
We are seeking experienced lead generation professionals to assist in identifying companies raising equity capital for a growing company over the next 3-6 months. Ideal candidates will have a strong background in financial services and...well-researched leads in specific industries. 2. Retainer: £1000 per month. PROCESS 1. Lead Research: Identify and research potential leads. 2. Email Outreach: Send emails to prospects. 3. Response Handling: Forward prospect responses to the business developer. 4. Scheduling: The business developer will schedule and conduct the sales calls. 5. Data Management: Upload researched data to our CRM in Excel format to ensure no duplications. If you are a driven lead generation professional with the required experience and skills, we would love to...
As we delve further into the world of quilt design, our team needs a proficient quilting professional who is well-acquainted with HZZE quilting software. This task involves converting our simple vector design into a .DAT file suitable for our HZZE machine. The design has been created in Adobe Illustrator and isn’t intricate, it requires implementing straight stitching only. Your skills and experience in working with similar software and accomplishing related tasks would be pivotal to the success of this project. We look forward to seeing the design come to life.
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 working with Java/Spring/JavaFX for the programm...
I'm looking for a skilled professional to create a 3D print file in STL format derived from an image I have. The project revolves around crafting a monochrome 3D model of a specific object within the provided image. Your tasks will involve: - Analyzing the image and focusing on the designated object. - Creating a 3D model of the object. - Generating an STL file for 3D printing in monochrome. Ideal candidates will have experience with 3D modeling, CAD software, and a keen eye for detail to accurately capture the object within the image. Please ensure your proficiency with STL file creation and monochrome 3D printing. Efficiency, precision, and ability to follow instructions closely are paramount for this task. Reach out if you demonstrate these skills. I am eager...
Hi, can you do a data crawl for sensitive vocabulary phrases? We need some sensitive words - such as words related to politics, war, military, violence, crime, pornography and so on. Purpose: for database cleansing We made this dirty thesaurus precisely to take care of dropping these bad words in the normal content, so a dirty thesaurus is needed We need the following national languages Russian French Portugal Project Details: 1: Need to crawl sensitive vocabulary words locally Or can you provide the appropriate dataset of sensitive words
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
