Jave access excel spread sheet run macrocông việc

cần nhân viên giới thiệu sản phẩm và bán hàng online hoặc trực tiếp, mặt hàng chính là Camera quan sát và hệ thống báo động, Access Control, hưởng lợi trên doanh số bán ra và số khách hàng giới thiệu được

Hiện trạng: Tôi có hơn 1000 file XML, nếu import bằng tay vào Access thì mất rất nhiều thời gian. Cho nên tôi muốn có 1 đoạn code hoặc 1 soft càng tốt có thể làm việc này 1 cách tự động.

- Th?i gian tho?i mái, lúc nào làm c?ng ???c.rn- Công vi?c ??n gi?n, không ?òi h?i nhi?u k? n?ng.rn- Có th? làm vi?c luôn.rn

Mình có thể biết cách thức làm việc như thế nào, mình có thể làm mọi thứ, chỉ cần nghiên cứu tí là sẽ làm được ngay

Đây là bài tập của tôi, nếu bạn cần, có thể liên hệ tôi để làm lại cho đúng yêu câu của bạn Trans to English: This is my exercise, if you need, you can contact me to right to do according to your request

I am seeking a freelancer with a strong background in Microsoft Excel's intermediate computations, especially proficient in VLOOKUP and IF statements. My project involves: - Identifying and correcting errors within my existing formulas. - Optimizing the efficiency of VLOOKUP and IF statements. The ideal candidate should have extensive experience dealing with and rectifying Excel formula errors. The ability to optimize efficiency of calculations to streamline our data processing is paramount. Providing examples of similar projects tackled in the past would be beneficial. I am looking forward to working with a precise and detail-oriented professional who can help me resolve these issues promptly.

I need to scrape data from a website. I'm stuck with an error. I used improtxml to scrape data ...data from a class in a website I know. However, the fact that this website has classes has a problem: . While on page 1 there will be that text data, but on many pages, that text data is not there and it is accidentally pushed up to insert the class data below into the previous class data. To make it easier to imagine, there will be 4 rows. I will need to get a fix for each row into the google sheet. However, there are pages where I insert the link and there will be no row 3 or row 2 and then row number 4 will be inserted into row number 3, making the data incorrect. I need improxml to automatically check the syntax, if it is correct, it will be filled in and if it is wrong, the bo...

...within the game. The project must be compatible with Windows 10. Candidates should be proficient in at least one of the following programming languages: C++, Python, or Pascal. Payment will be made upon successful demonstration of the emulator working within the game. Note: This project does not involve breaking any game's security measures or installing unsigned drivers. Important Information: Macro usage in the game is permitted and is not considered illegal. Before bidding on the project, please confirm that you have reviewed the code provided in the attachment. The project requires more in-depth and lower-level coding knowledge than the example provided in the attachment. It necessitates knowledge of ring0 level coding." By submitting a proposal for this project,...

I'm currently facing an issue where my neighbour has erected fences, shed, and posts outside their curtilage which impede access to my property. Despite my previous attempts to address this issue with Cheshire West and Chester's planning department, they acknowledged the breach, but opted for nonintervention. I am seeking professional legal assistance from a freelancer with a strong background in property law and proven track record in handling similar cases. Key Responsibilities: - Understand the case circumstances - Develop and execute an effective legal strategy - Communicate with the neighbour and relevant authorities Ideal Qualification: - Law degree with specialisation in property law - Demonstrated experience in dispute resolution - Excellent interpersonal ...

I'm seeking a professional to help me with a personal E-commerce data analysis project. I have access to a range of data sources including E-commerce platform data, sales data, and payment data. The primary goal is to create a comprehensive report that delves into the sales and payment analysis of my E-commerce business. Key objectives for this project: - Identify sales trends: I'm looking to understand the various sales trends that have emerged from the data over the period of time it covers. - Analyze payment methods: I want to categorically understand how my customers are paying for their purchases, and if the payment methods are changing over time. - Discover customer preferences: The project also aims to uncover key customer preferences and behaviors. Your role will...

I'm seeking an expert in Excel who can help me with a few diverse tasks, such as data entry, creating formulas and functions, and conducting data analysis. The dataset I'll be working with is medium-sized, ranging from 100 to 1000 rows. The primary goal of this project is to organize and structure the data. Ideal skills for this project include: - Proficiency in Excel, including using formulas, functions, and pivot tables. - Excellent attention to detail for accurate data entry. - Experience with data analysis and the ability to draw meaningful insights from the data. - Strong organizational skills to structure the data effectively. Ultimately, I'm looking for someone who can help me streamline my data management processes and turn this data into comprehensib...

I'm looking for a skilled Excel professional to help me create a custom inventory dashboard. Key Requirements: - The dashboard should focus on inventory management, specifically, visualizing product stock levels. - The data should be arranged in an intuitive manner that allows for quick and easy inventory tracking. Ideal Skills & Experience: - Strong proficiency in Excel, particularly in creating visually appealing and user-friendly dashboards. - Experience in inventory management, with an understanding of product stock levels and their relevance. - Attention to detail as accuracy in data representation is crucial for this project. - Good communication skills and a proactive attitude to ensure the project's success. Please note that due to the nature of this...

I'm looking for a skilled individual to assist me in adding unlimited plays to a magnetic swipe arcade game card. Key Requirements: - The card used is a magnetic swipe card, so prior experience with this type of card technology is essential. - I don't have access to the card's management system, so the solution needs to be standalone. - The primary purpose for this task is for research and testing purposes. The task itself is relatively straightforward - I need you to bypass any limitations set on the card to allow for unlimited plays. This project is time-sensitive, so I'm looking for someone who can deliver efficiently and communicate effectively throughout the process.

I am blending Google Sheet data with Google Ads and Analytics data but getting an error message. Need someone to help via screenshare. Thanks!

I'm in need of a proficient Excel expert who has a solid understanding of Excel macros and compatibility issues with Excel for Mac 2018 or later. The project involves assessing and modifying an existing Excel macro to ensure that it functions seamlessly on Mac platforms. Key tasks include: - Assessing the existing Excel macro and its functionality - Modifying the macro to be fully compatible with Excel for Mac 2018 or later - Implementing the desired modifications related to data transfer, header and footer creation, as well as digital stamp inclusion The ideal freelancer for this project should have: - Proficiency in Excel macro development and modification - Prior experience with Excel for Mac comp...

I need a virtual assistant for a daily one-hour task to input visitor information into a Google Sheet. Key Requirements: - Attention to Detail: It's important that all information is entered accurately and completely. - Manually need to collect data from various source Ideal Candidate: If you are a detail-oriented individual with prior data entry experience and can commit to a daily one-hour task, I'd like to hear from you.

I'm in need of an Excel expert who is well-versed in Excel and has experience in creating detailed and visually appealing dashboards for project management purposes. The primary goal of this dashboard is to help me track the effort and progress of my project. The information that I'd like to track includes: - Time spent on tasks - Percentage of completion - Deliverable status The excel is small and has only 15 rows its more like visualization task so that all data can be projected in one place as a dashboard.

I'm looking for a skilled Excel professional to clean a text-based dataset for me. The dataset is not massive, but it's quite messy. The data cleaning task is relatively straightforward and basic. You'll have to perform operations such as removing duplicates and adjusting formats. Ideal Skills and Experience: - Proficiency in Excel: You should be comfortable working with large datasets in Excel, including applying formulas and functions. - Data Cleaning Expertise: Prior experience in cleaning text data is a major plus. - Attention to Detail: The devil is in the details; I need someone who won't overlook small nuances in the data set. Once the data is cleaned, I'll need you to carry out some basic analysis on it. This will involve running s...

I'm seeking a skilled personal assistant to help with my data tasks, focusing on Excel entry and processing. Key Tasks: - Excel Data Entry: You'll be responsible for entering more than 500 data points. - Data Processing: You will also assist in processing these data entries. Your Skills: - Proficient in Excel: You should be able to work with pivot tables and VLOOKUP functions. - Data Entry Expertise: Demonstrable experience in managing large data quantities is a must. - Organized & Detail-Oriented: The ability to maintain accuracy and precision while handling this large volume of data is crucial. This is a great opportunity for someone who's eager to showcase their Excel skills in a practical, real-world setting.

I'm in need of a web-based job card system that will allow the creation and editing of digital job cards. There is also a requirement for quotes, parts / inventory, archived jobs, and customer management. Both employees and managers will need access to the system, with an admin login section for authorization of completed job cards. We would like the system to export completed jobs to CSV file for automated invoice generation in Quickbooks Online. We will also require the system to import the customer database from Quickbooks in CSV format. Key Functionalities: - Creation and Editing of Jobs - Ability to use system on-site / remotely through the use of iOS or Android web browsing. Some - Ability to select a simple job status from a drop-down combo box eg. In-progress, waiti...

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.

Develop macro-enabled Excel file to handle CSV

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...

I'm running a website with an Apache2 server backend and a React frontend. The problem is, the frontend is loading with HTTPS while the backend is using HTTP, despite having a proper SSL configuration in the etc/sites-available confi file. I'm currently using a reverse proxy server to redirect HTTPS traffic to my backend server and I'm using a secur...communicate between the reverse proxy server and the backend server. Key tasks include: - Troubleshoot configuration issues to identify the cause of the HTTP/HTTPS discrepancy - Ensure that the SSL configuration on the Apache2 server is indeed correct - Verify that the reverse proxy server is properly configured to redirect HTTPS traffic to the backend server No access can be shared - work will be done via Screensharin...

I need a freelancer who can conduct a comprehensive background check for pre-employment purposes. The task involves: - Conducting a thorough check on the candidate's criminal records - Verifying the candidate's employment history - Confirming the candidate's educational qualifications The ideal freelancer for this project should be well-versed with background checks, have access to reliable databases and be able to compile the information accurately and efficiently. Please note that the privacy and confidentiality of the candidate's information is of utmost importance.

...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(hundreds to thousands), each html file contain multiple tables(vary from 15-35, depend on each html file). Python to extract specific table and vertically stack them together to create an Excel file.(first column add html filename.) inside html file is encoded in chinese, so must use chinese to view it. table name/string partially e.g. "現金流量表" or "被投資公司名稱" or "資金貸與他人"or "轉投資大陸地區" or other name(later can be change). extract table based on table names/string. the table may not be there(depend on the html). If so just skip or single row ...

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

My objective is to create short duration (5-10 minutes) documentary-style videos showcasing interesting video footage of your local models for our platform. We are hiring freelance video photographers like you, to shoot easy fashion style video shows with local female models you recru...you invite to model for you, and we pay you from US$500 per shoot project, more once you become familiar with shooting for us. ModelsUpClose are video entertainment producers,  hiring video photographers from across the world in fashion style General Exhibition video shows since 1997.   It is essential we agree on your proposed model before starting a project. We have a Job Specification sheet to ensure your success and can discuss storylines and themes to suit you and your models...

My WordPress website, , is currently down and displaying a 'White screen of death'. Although I have not added or updated any themes or plugins recently, I'm unable to access the WordPress admin dashboard. I'm in urgent need of a skilled developer to troubleshoot and restore my site. Key tasks include: - Diagnosing the 'White screen of death' issue and resolving it to bring the website back online. - Investigating the root cause of this error and ensuring it does not reoccur in the future. - Restoring access to the WordPress admin dashboard so that further updates can be made, if necessary. Ideal skills for this job: - Proven experience in troubleshooting WordPress issues, particularly 'White screen of death'. - Strong background in we...

Need someone to go through one of my company bank statements for the last 8 months and prepare both years financial statements (profit/loss and balance sheet).

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

Hi I'm about to advertising a learning course. I will be delivering the co...moodle to post course materials, and interact with the course participants. A draft of the course information is attached. I'm looking for a freelancer who can support me with my Moodle platform. I have never used moodle before, so I need help with installation and setup, and ensuring that our required functionality is possible. I am working with an assistant and we both need to be able to access the participant forums to respond to queries, and to upload and receive materials. Please provide a succinct proposal, and an expectation of how long this would take. I am after a very simple solution at this stage, as the moodle element is only for communicating with participants, and not for th...

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. -...

I have a 5-10 minutes MP3 file that needs to be transcribed urgently. I need the transcription to be accurate and in a sheet format. Ideal Skills and Experience: - Proven experience in audio transcription - Ability to deliver high-quality work under tight deadlines - Proficiency with sheet formatting - Strong attention to detail This is an urgent project, so I am looking for someone who can start right away and deliver the transcription quickly. If you have the required skills and can meet this deadline, please bid on this project.

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.

As a client, I'm in need of a few highly skilled red teamers to demonstrate that administrative level access can be gain on hardened targets. Key Requirements: - The primary goal of this project is to discover any potential weaknesses in the security of the network environment and gaps in the cybersecurity infrastructure's configuration. - We need to show the SOC how their security products can be bypassed. Ideal Skills and Experience: - Proven experience in red teaming. - Solid understanding of common security vulnerabilities and how they can be exploited. - Strong problem-solving skills and the ability to think like a cyber attacker. - Proficiency in using various pentesting tools and frameworks (metasploit, cobalt strike, sliver). This is a critical project and...

I need an employee time tracking system on Google Sheets. The system should automatically calculate total hours worked, allow for marking ...Features: - Automatic Calculation: The system should calculate the total hours worked by every employee within the specified date range. - Attendance Tracking: There should be an option to mark employees as present or absent. - Project Details: Each row should contain fields for the project number and name. - Multi-employee Handling: The system should accommodate multiple employees' data in a combined sheet. Skills and Experience: - Proficient in Google Sheets - Experienced in creating automated time tracking systems - Familiarity with employee attendance tracking - Ability to create a user-friendly interface that can handle data for mult...

As an individual requiring assistance with a coloring task, I'm looking for a freelancer with proven expertise in both digital and traditional coloring. A proficient colorist is required to add life to my photographs, invoking emotions and enhancing their overall aesthetic. Key requirements: 1. Skilled in both digital and traditional coloring processes 2. Access to appropriate tools or software for digital coloring 3. An eye for detail and color - to reproduce colors accurately in digital and traditional formats 4. The ability to handle digital photos, specifically. 5. Ability to meet agreed deadlines Experience in similar projects will be a huge plus. Looking forward to seeing your amazing work.

...auto-investing trading on world wide's financial market. Fixed Rate Job Paid based on success delivery per country. $10/country. Make about 5-10 API/country for installing python, setting SQL for our applications and Google Sheet. For each country may need API for such as : 1. Historical Data 2. Financial Scrapped Source 3. Financial Summary Scrapped Source 4. Interest rate 5. Some More Required Skill & Experience : 1. Php & SQL 2. Familiar with python installing & setting up environments 3. Experienced in Linux Debian & LNMP server by SSH 4. You need to know on how to run python scripts on debian by ssh, and setup cron task on debian, and debugging etc Personality's Criteria : 1. No toxic working environment 2. Agile, Responsive, and Fast Del...

...assist in tracking, restocking, and managing our inventory efficiently. - Customer Management: Maintaining customer details for smoother transitions and personalized customer experiences is crucial. - Sales Reporting: We require comprehensive sales reports to review our business's progress and areas for improvement. Users: The software should easily accommodate 1-5 users at once, with unique access capabilities for each user. Ideal Candidates: I'm seeking professionals with experience designing and developing business-centric software. Experience with .NET, Java, or other relevant programming languages would be beneficial. Knowledge of Windows-based software development and expertise in back-end databases are essential. Applicants who understand the needs of small-t...

...enhanced by AI to provide deeper insights. - Comparison Tools powered by AI to highlight key differences. - Exportable Reports with AI-generated summaries. 6. **Security and Integrity** - AI-driven Proctoring for real-time monitoring. - Plagiarism Detection with AI. - Environment Lockdown managed by AI. 7. **Integration and API** - ATS Integration with AI-powered matching. - API Access with AI-driven functionalities. 8. **Support and Documentation** - Help Center with AI-powered search and suggestions. - Customer Support augmented with AI chatbots. - Tutorials and Training with AI recommendations. 9. **Additional Features** - Gamification with AI-generated challenges. - Mobile Support with AI enhancements. - Customization with AI-driven ...

I will need to go through your flow and also have the appropriate access to troubleshoot the issue

...real-time, ensuring they're operating effectively and do not pose a risk of failure due to overcharging or undercharging. Key Features: - The hydrometer should have a standard accuracy of ±0.01. This level of precision is essential to correctly assess the battery health and predict any potential issues. - The data collected from the hydrometer needs to be available through a web interface. This online access will allow me to monitor multiple batteries from a central location, offering more convenience and control. Ideal Skills and Experience: - Experience in designing and developing electronic hydrometers or similar IoT devices. - Proficiency in interfacing such devices with microcontrollers. - Data should be passed to serial port of controller - Understanding of ba...

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'm looking for a skilled professional who can assist me with updating product information on two PDFs. Additionally, I need a one-page "specials" sheet created with a professional and corporate style. This sheet should be in line with our company's branding guidelines. Key Tasks: - Update product information in two PDFs - Design a one-page "specials" sheet - Ensure the design is professional and corporate, adhering to our branding guidelines Ideal skills and experience: - Proficient in Adobe Acrobat for PDF editing - Strong graphic design skills and experience in creating corporate designs - Ability to follow existing branding guidelines while designing new assets - Attention to detail to ensure all changes are implemented accurately ...

...aesthetic. - Materials: The bathroom will feature quartz countertops. A minimum 60-inch vanity with a double sink A toilet separated from the rest of the suite by a wall and door. A tiled shower with subway tiles for both the walls and floor, possibly with a built-in bench. A walk-in closet/dressing room. Full-size 32-inch doors. If possible, the walk-in closet and dressing area should have direct access to both the bathroom area and the bedroom. We have a total area of 8 ft x 16 ft (128 sq ft) if you remove the walls. Ideal candidates for this project should: - Be experienced in designing modern and contemporary spaces - Have a strong understanding of bathroom layouts and fixtures - Possess excellent communication skills to ensure our vision is accurately captured. We are bu...

I need a virtual assistant for a daily one-hour task to input visitor information into a Google Sheet. Key Requirements: - Attention to Detail: It's important that all information is entered accurately and completely. Ideal Candidate: If you are a detail-oriented individual with prior data entry experience and can commit to a daily one-hour task, I'd like to hear from you.

I'm looking to implement a user registration system for a paid tutorial video platform. Here's what I need: Script for user registration for gaining access for paid tutorial video Workflow Register new account / login fields: full name | email | password Once user creates his account, only he will access his account if he is using the same device where he first registered. Users need to register to gain access to a tutorial video. Once the registration is approve by the administrator, user will be able to login to watch video. Administrator will need dashboard for accounts administration: Registered users: Fields: full name | email | password | [Botton to active or disactive accounts. User IP/Geo Location/Device ID

For App Promo Video for Project Access, Kaybe Virtual Assistant.

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...