Vba excel extract sheet namePekerjaan
I'm seeking a freelancer to correct the date format in my Excel sheet that is currently not displaying correctly. Key Requirements: - The Excel sheet must display dates in the format DD/MM/YYYY. Additional Details: - The corrected date format is only required on specific sheets within the same workbook, not all sheets. Ideal Skills & Experience: - Proficiency in Excel and its date formatting functions - Experience with correcting date format issues in Excel - Attention to detail to ensure all specified sheets are updated correctly.
I need a freelancer to search List of Medical centers & Hospitals in Australia. Currently we have a list of centers & hospitals but need to search & add about 3000 more which are not included there (Including the contact details). We need a complete file with accurate detils & milestone will not be released until the work is checked. All centers should be added as per the state. Please quote with the time period & the exact fees you will charge for this. Ongoing work for successful candidate.
...live support needed via teams. The request has to be fulfilled this week. I'm in need of a professional who can assist me with creating workflow automations and integrating with Microsoft applications. We will organise a teams sessions and go through the desired customizations , all the work is done via remote access. I have a Microsoft environment comprising of SharePoint, Outlook, Teams, Word, Excel, and PowerPoint. Some tasks need to be automated such as document approval , collaborations and other SharePoint settings. Ideally, you should be highly proficient in Power Automate (Microsoft's workflow automation tool) and have strong experience in integrating various Microsoft applications. A background in SharePoint, Outlook, Teams, and the Office suite is a big pl...
I have a basic school project that requires inputting provided data into Microsoft Excel. Here are the specifics: - You will be provided with a simple dataset. - The main objective of the project is to input data from this dataset accurately based on the given instructions. The ideal freelancer for this project would be someone who is: - Proficient in Microsoft Excel. - Detail-oriented to ensure accurate data input. - Able to follow provided instructions carefully.
**Project Objective:** We are looking to automate the management of absences within our company using VBA Excel. The goal is to simplify and optimize absence tracking, reporting, and data analysis to save time and improve accuracy. **Project Description:** The project involves developing an automated solution in Microsoft Excel that includes: 1. **Absence Data Entry:** - Interactive forms for entering absences (sickness, vacations, authorized absences, etc.) - Data validation to ensure accuracy and consistency. 2. **Automatic Absence Calculation:** - Automatic calculation of absence days per employee. - Tracking different types of absences and their quotas (paid leave, sick days, etc.). 3. **Report Generation:** - Creation of weekly, monthly, and ann...
I'm looking for a freelancer who could post a job on LinkedIn. . WORK WILL BE POST JOB ENTER DATA SHEET i WILL PROVIDE. Ideal Skills and Experience: - Proficient in LinkedIn usage - Ability to attract and write engaging job posts - Knowledge of the entry-level sales job market You will be using your own LinkedIn account to accomplish this task.
I need help with a data entry task that involves copying and pasting data from PDF documents into an Excel spreadsheet. Key points: - The task involves strictly copy and paste work, no data cleaning or formatting is required. - The primary source of data is PDF documents, so proficiency in extracting data from PDFs is a plus. - The data should be accurately transferred into an Excel spreadsheet. Ideal Freelancer: - Proficient in PDF data extraction and Excel. - Attention to detail is crucial. - Previous data entry experience is preferred.
I'm in need of a Power BI expert to create a comprehensive dashboard for our recruitment department. The dashboard will pull data from our existing Excel spreadsheets and update daily. Key Features Required: - Job Status: This will give us a clear overview of the number of open positions, positions in the interview stage, and positions that have been filled. - Recruitment Pipeline: Visual representation of where in the recruitment process our candidates are, from application to hire. - Applicant Information: A detailed breakdown of our applicants, their demographics, and the source from which they applied. - Application Source: Analysis of the effectiveness of our recruitment sources. - Time to Hire: Ideally, a calculation of the time it takes to move a candidate from applicat...
I am in need of a diligent professional who can assist in extracting text data from PDF files and accurately inputting the information into an Excel spreadsheet. The job calls for attention to detail and excellent data entry skills. Essential Skills and Experience: - Proficiency in Data Entry - Expertise in Excel Your responsibilities will include: - Accurately converting text data from PDF files into Excel - Ensuring data integrity through careful data entry - Delivering the project on time Ideal candidates would have prior experience in handling similar tasks. Your accuracy and commitment to the task at hand will be pivotal to the outcome of this project. Looking forward to receiving your bids.
...have an additional summary page. Key Requirements: - I require the spreadsheet to have automatic calculations. For example, I'd like the sheet to automatically sum up the tasks, highlight overdue tasks and calculate completion percentages. - Data sorting and filtering functionalities are a must. I want to be able to sort my tasks by due date, priority or completion status. - Conditional formatting is also needed. I'd like the cells to change color based on task status (e.g., incomplete, complete, overdue). Platform and Updating: - I prefer the use of Google Sheets for this project. - I plan to update the spreadsheet manually. This means that the sheet should be user-friendly and easy to navigate, with clear headings and sections that I can easily edit and add t...
We are seeking an experienced NLP Engineer to develop a robust resume parsing solution for our website. The ideal candidate will have a strong background in Natural Language Processing (NLP) and machine learning techniques to accurately extract and structure information from resumes. Responsibilities: Develop and implement NLP algorithms to parse and extract relevant data from resumes. Ensure high accuracy in extracting information such as personal details, education, work experience, skills, and more. Integrate the parsing solution with our website to provide seamless user experience. Continuously improve the parsing accuracy through machine learning and feedback loops. Collaborate with our development team to ensure smooth integration and functionality. Requirements: Pro...
I am in need of a tool that can effectively extract information from Telegram groups and channels for lead generation purposes. Key Requirements: - Extracting phone numbers: The most crucial information I need are phone numbers for potential leads. Purpose: - The extracted phone numbers will be used for WhatsApp marketing. Ideal Skills: - Proficient in data extraction from Telegram - Experience in lead generation - Knowledge of WhatsApp marketing Looking forward to receiving bids from experienced freelancers who can fulfill these requirements.
I am in need of a skilled Excel professional who can create a comprehensive Excel dashboard focused on data analysis. The dashboard will integrate with various Excel files to provide real-time data updates. Key Requirements: - Create an Excel dashboard that primarily focuses on data analysis - Integrate the dashboard with multiple Excel files - Ensure that the data updates are in real-time Ideal Skills: - Proficiency in Excel - Experience in creating complex and dynamic dashboards - Knowledge of data analysis techniques - Familiarity with real-time data integration This project is ideal for an Excel expert who can not only design a visually appealing dashboard but also ensure that it is highly functional for data analysis purposes.
We seek an Excel expert with experience in developing Bill of Materials (BOM) and Inventory management solutions tailored for small home businesses. The focus is on simplicity and functionality without the need for a commercial product presentation. **Key Features Needed:** - A user-friendly Excel workbook that manages electronic components, their stock levels, and inventory updates post-sales efficiently. - BOM creation from inventory items with an ability to incorporate "other costs" into each assembly. - Stock purchase entries should automatically update inventory quantities and costs. - Detailed sales tracking with automatic inventory quantity adjustments. - Low stock level notifications via highlighted rows in the spreadsheet. - The system should allow ea...
Hi, I need to extract data from some sites and compare them in a unique database. In few words i need a scraping code in python that extract data from some sites and the data have to saved in a mysql database.
...Amazon Selling Partner API. The key tasks for this project will revolve around API integration and product data retrieval. Key Requirements: - Proficiency in .Net Core - Proven experience with API integration - Strong background in product data retrieval - Familiarity with Amazon Selling Partner API would be advantageous The ideal candidate should be able to guide the most effective ways to extract product data from Amazon's API and implement this process seamlessly. I need help of expert on hourly bases with my team. The person who we will hire they need to seat with my team and give solution where we have facing problem. The main problems we are facing are 1. Variant Listing 2. Problem of images YOU NO NEED TO DO ANY TYPE OF CODE, JUST DO DISCUSSION WITH OUR TEAM IN S...
...point of contact for our company. The ideal candidate will be responsible for greeting and assisting visitors in a professional manner and should be well-versed in the following areas: - **Greeting and Assisting Visitors**: - You'll be the face of the company, so a friendly and professional demeanor is essential. - **Managing Visitor Records**: - We prefer maintaining a manual sign-in sheet or Visitor's Dairy , so previous experience in this area or willingness to learn is crucial. - **Dress Code**: - Our company maintains a formal business attire policy, so the right candidate should be comfortable adhering to this. The ideal freelancer for this role should have: - Excellent verbal communication skills - Previous experience in a receptionist role is ...
I'm seeking an individual who is well-versed with Excel for data entry tasks. This primarily involves typing and organizing data. Here's what you'll be doing: - Typing out data and organizing it in Excel spreadsheets - Ensuring accuracy and efficiency in data entry Applications should include: - Examples of past work, particularly those related to data entry and Excel Ideal freelancers for this job are those who: - Have prior experience in data entry - Are proficient in using Excel - Possess strong attention to detail, ensuring accuracy in their work.
...developing and maintaining desktop applications using ElectronJS, building and managing user interfaces with ReactJS, and implementing OpenCV and TensorFlow. Additionally, the role requires the ability to read and manipulate Excel files using ExcelJS. The candidate should be proficient in JavaScript and have a strong understanding of its ecosystem. They should possess extensive experience with ElectronJS for building cross-platform desktop applications. Familiarity with OpenCV and TensorFlow is essential, as is experience with ExcelJS or similar libraries for handling Excel files. This project aims to develop a desktop application using that allows users to create custom OMR (Optical Mark Recognition) sheets with questions and multiple-choice options. The applicatio...
I am looking to automate certain repetitive tasks that are currently performed in Excel using Power Automate. - Main Objective: The chief goal of this project is to automate data comparison tasks. This will greatly improve productivity and minimize errors that may come with manual comparison. - Ideal Experience: The ideal freelancer for this task should have extensive experience in Excel and Power Automate and should have successfully completed similar jobs in the past. A strong understanding of data comparison techniques and working with excel spreadsheets will be highly beneficial. - Skill Set: Key skills required include Excel, Power Automate, and a good understanding of data processing and workflow automation.
I'm in need of a skilled individual who can scrape data from various websites for the purpose of lead generation. The data should be delivered in Excel or CSV format. Key Requirements: - Proficient in web scraping - Experience with lead generation - Ability to deliver data in Excel/CSV Ideal Skills: - Proficiency in Python/R for web scraping - Previous experience in similar projects - Strong understanding of lead generation techniques If you have experience in web scraping and lead generation, I'd love to hear from you.
I am looking for a skilled freelancer to assist with a project that involves reading text from PDF files and answering questions based on the content. This task must be completed without using any external libraries. The ideal candidate should have strong programming skills and experience with text processing and file handling. Project Details: Objective: Extract text from provided PDF files and answer specific questions based on the content. Requirements: No use of external libraries for PDF reading and text extraction. Write custom code to parse and process the PDF files. Develop a method to accurately answer questions using the extracted text. Deliverables: Custom code/script for reading text from PDF files. A function or method to process the text and generate answers to the ...
I'm seeking a video creator to produce a 1-3 minute promotional video for our esteemed "Postgraduate Diploma in Counselling Psychology" program. The video will target career changers specifically. Key requirements and details: - The video should effectively highlight the program's three main selling points: its course recognition by Singapore Association of Counselli...platforms. The ideal candidate for this job will have: - Proven experience in creating promotional videos, ideally for educational programs or courses - A solid understanding of the psychology of career changers and how to appeal to this specific audience - Excellent storytelling and video editing skills to bring our program's unique strengths to life If this project sounds like something you'...
...of a Python expert who can develop a content spinning tool for me. The tool should be capable of automatically generating unique variations of basic text, like blog posts and articles. Key Requirements: - I'm looking for a tool that can automatically generate spun content from existing text, without any manual input needed. - File upload option - If I upload an Excel sheet, the tool spin content in that sheet and export excel sheet with spin content. - It needs to be able to handle the text complexity level of blog posts and articles, 50-500 words - THe purpose of this tool is to rewrite content to make content ZeropGPT free Ideal Skills: - Proficiency in Python programming. - Prior experience in developing content spinning tools. - Knowledge ...
...an Excel table. The icons are for various amenities that will be listed on a real estate website. Responsibilities: • Search for icons on that match the list of amenities provided. The premium version of Flaticon may be used. • Ensure each icon matches the style and aesthetic suitable for a modern real estate website (in the style as attached files). • Document each icon in an Excel table with two columns: Title and Classname. List of Amenities: • See attached file. Requirements: • Experience with and familiarity with downloading and organizing icons. • Proficiency in Excel. • Attention to detail to ensure the icons are correctly matched to the amenity titles. • Ability to deliver the task within a specified timeframe....
I'm in need of a skilled data scientist who can create a web scraping tool specifically for Shopify websites. I need to extract Product details, Pricing information, and Customer Reviews from a wide range of Shopify websites including those in the Clothing and fashion, Electronics, and Home and decor etc. Key requirements: - The tool should efficiently scrape the specified data points from the mentioned categories of Shopify websites. - The extracted data should be well-structured and easily exportable for further analysis. - The tool should be able to scrape a large number of websites in a relatively short period of time. Ideal Skills: - Proficiency in web scraping and data extraction - Experience with data structuring and analysis - Good knowledge of Shopify websites and...
I'm in need of meticulous and organized professional who can effectively manage data entry, document organization, and scheduling tasks. The scope of the project includes: - Streamlining data entry processes - Organizing and managing key documents, specifically financial statements - Handling a dynamic schedule effectively The ideal candidate should be proficient with Microsoft Excel and Google Suite (Docs, Sheets, Calendar). Your expertise will help us improve our administrative operations efficiently and effectively.
I have an Excel file that needs to be formatted with some basic arithmetic formulas. Key Requirements: - I need the data in the cells to be formatted to phone number style. - Basic arithmetic formulas are required for this project. The level of statistical analysis you'd need to provide is basic, such as mean, median, or mode. Ideal Skills/Experience: - Proficiency in Excel and formulas is a must. - Experience with basic statistical analysis is preferred. Please get in touch with your credentials and prior work samples. Thank you.
I am in need of an experienced business plan writer to help me craft a detailed business plan with the primary aim of attracting angel investors. The pla...promoting and selling bridal jewelry, including online and offline marketing tactics, partnerships with bridal boutiques or wedding planners, participation in bridal shows, and use of social media platforms. Financial Projections: Provide detailed financial forecasts over a minimum of 3 years , including revenue projections, startup costs, operating expenses,cash flow, profit & loss, balance sheet and business valuation . Risk Management: Identify potential risks and challenges facing the business, such as fluctuations in demand, supply chain disruptions, competition, and economic downturns. Develop strategies to mitigat...
Silakan Daftar atau Login tuntuk melihat rincian.
I need a detailed spreadsheet of information taken from public meetings. The content I'm seeking to compile involves: - Date of the meeting - Detailed descriptions of action items that were voted on, including the specific amounts. In this assignment, precision, attention to detail, and understanding of meeting notes is crucial. Mastery of Excel and experience handling similar tasks is required. Familiarity with action items and the voting process in public meetings will be a plus.
I'm in need of a VBA script that can generate textual reports from Excel spreadsheets. Key Requirements: - The VBA script should focus on generating textual reports, without the need for incorporating charts or graphs. - The data source for the report generation will be Excel spreadsheets. Ideal Skills and Experience: - Proficiency in VBA coding and automation. - Strong understanding of Excel and its data manipulation capabilities. - Prior experience in report generation through VBA is highly preferable.
I need a tool that can scrape text content and tables from LinkedIn quickly and efficiently into an Excel format. The tool needs to be able to: - Extract text content and tables from LinkedIn - Export the scraped information into Excel format - Operate quickly and efficiently to meet a tight deadline The ideal candidate should have: - Experience in web scraping, particularly with LinkedIn - Proficiency in Excel - Ability to develop a tool that can operate quickly and effectively Given the urgency of this project, I need someone who can start ASAP and deliver the tool in a timely manner. Experience with rapid tool development would be a huge plus.
... 1. Name of the event is 'Poly Networking Event' 2. The event will be held on July 20, 2024. 3. The event will host guest speakers from IT & Engineering professionals from fortune 500 companies such as Adobe, NASA, Micron, Raytheon, Carrier, and many more. 4. There will be fun activities, dinner, drinks, memorabilia giveaway. Ideal Candidate: - Proficient in video editing software (e.g., Adobe Premiere Pro, Final Cut Pro) - Experienced in creating content for various social media platforms, particularly Facebook, TikTok, and YouTube - Highly creative with a strong visual aesthetic - Knowledge of copyright laws and usage of royalty-free music - Strong communication skills to understand and execute my vision If this sounds like a ...
...is capable of efficiently extracting table data from PDF documents. The extracted data should be organized and saved into a customized Excel template. Additionally, the system should be designed to assign different user IDs with varying levels of access control. Key Requirements: - Develop an AI portal with the capability to extract table data from PDFs. - Organize and save the extracted data in Excel using customized templates based on the source PDF. - Implement a user management system that assigns different access controls to various user IDs. Ideal Skills and Experience: - Proficient in AI development and data extraction techniques. - Expertise in Excel automation and customization. - Strong background in user management and access control systems. - P...
At , we are developing a Wordpress site to sell sheet music for the flute. We are using WooPayments for payments. At least I think we are. Our first customer is shown here: On another site, we have integrated to receive the money. However, their report shows no transactions from MasterpieceMusic.org. This job requires someone to find out what happened to that payment and to ensure that future sales get credited to out Eway account. At the top of your application, answer the following question: How would you find the cause of this problem? Don't waste your time telling me how good you are; your feedback and reviews from previous clients will tell me that. It's likely that there will be many applications
Project Overview: I have an existing UI/UX design for a Point of Sale (POS) system that needs to be adjusted and extended to match the specifications outlined in my requirements sheet. This project involves updating the current design to enhance usability, functionality, and aesthetics based on detailed requirements. Key Responsibilities: Review the existing UI/UX design of the POS system. Analyze the requirements sheet to understand the specified enhancements and extensions. Update and extend the current design to align with the specified UI/UX requirements. Ensure the new design improves user experience, accessibility, and functionality. Collaborate with me to iterate on design changes and incorporate feedback. Deliver high-quality design assets and documentation. Requir...
I need a professional who can gather detailed information on more than 500 LinkedIn employees for recruitment purposes. This is a time-consuming task, so it's important to be patient and detail-oriented. A successful candidate would have: - Excellent understanding of LinkedIn and how to extract information from it - Experience in recruitment or research, with a proven track record - Patience and attention to detail This is a critical project for our recruitment efforts, so I need someone who can deliver accurate and comprehensive information.
...to extract an a few values from another ghost plugin that injects some data into every new tab that opens. You can create new identities with ghost browser and give them a name. When the new tab opens in the new identity one of ghost browsers plugins injects an array of data. into the page and can be viewed in the console. I'd like to extract the ID, Name and Color values that it injects and store them in my chrome plugin but haven't been able to successfully access. Building the plugin I'm ok with but need help accessing these values. Here is the array that gets injected into each tab: { "active": {}, "bypassed": false, "info": [], "identityInfo": { "color": "BC789C", ...
...explaining the process by which you calculated these statistics. Calculate the mean, median, mode, and standard deviation of the stock volume. Put in table format for easy review. Write a sentence explaining the process by which you calculated these statistics. Ideal freelancers for this project would be those experienced in statistical analysis and data visualization. Skills in using tools like Excel. If this sounds like your kind of project, get in touch and showcase your skills. The information to use is attached...
I need someone to help with offline data entry. The task involves entering less than 1000 entries into an Excel spreadsheet. Accuracy is key as the data will be used for business analysis. Ideal Skills and Experience: - Proficiency in offline data entry - Advanced Excel skills - Ability to maintain high level of accuracy - Previous experience with similar tasks is a plus
Fixed cost & developers from Uttar Pradesh only . I'm looking for a skilled freelancer who can help me develop a real-time temperature display system using NodeMCU ESP8266. Key Project Requirements: - Integration with 3 or more Bluetooth BLE sensors - Real-time temperature display on an LCD screen - Parsing advertisement data from nearby paired BLE sensors - Data sheet will be supplied for reference Ideal Skills/Experiences: - Proficient in programming with NodeMCU ESP8266 - Experienced in working with Bluetooth Low Energy (BLE) technology - Familiarity with parsing advertisement data - Knowledge of connecting and operating LCD displays This is a fixed cost project with a budget under $100. Please provide your quote for the project, along with your relevant experience...
I'm looking for someone with strong data gathering skills who can create a comprehensive Excel spreadsheet. The spreadsheet must contain a list of all Australian suburbs along with their corresponding Local Government Areas (LGA). The essential points to be kept in mind are: • The list should be sorted by council areas for easy navigation. • Only the name of the suburbs and their corresponding council areas are required. No additional components such as population or region data are necessary. This project might require advanced web searching capabilities and attention to detail to ensure accuracy of the compiled list. Experience in data extraction is highly desirable.
...varied and comprehensive, including but not limited to customer demographics, product descriptions, and pricing information. This is exclusively a RESEARCH project, and will take some time. Because of this I WILL ONLY PAY HOURLY. If you require a fixed price/contract, do not bid, I will not give you the job. Key Responsibilities: - Thoroughly examine the provided businesses in the spreadsheet - Extract and analyze various attributes, such as customer demographics, product descriptions, and pricing information - Summarize and present the information in a clear, concise manner - Provide suggestions on the potential opportunities or challenges based on the data This project requires an individual who is meticulous, analytical, and has a strong understanding of business operations....
I need someone who can create a database in MS Excel for Invoices Log (tracking for already processed invoices) with the following features. 1- A list of all invoices (Master List). 2- A list of all Contracts. 3- A list of all Purchase Orders. 4- A list of Approvers who is approving the invoices. 5- A list of Accounts. 5- All of these list should be linked with each other. There should be a Dashboard (Main Page) with link to the pages (Add Invoice, Search Invoice, Search Approver, Search Contract, Search PO, Search Account and Reports pages) on the top, and below the page list there should be the statistical data of the database. For Add New Invoice page, I should be able to add an invoice details, and if it's related to a contract or purchase order, I should be able to add ...
I'm in need of someone skilled in Microsoft Excel for a couple of tasks. - **Formatting:** Firstly, I require assistance in formatting the spreadsheet. This will include ensuring that the data is clear and easy to read. I would like the spreadsheet to look professional. - **Formula checking:** While the formulas used are not too complex, I still want them to be checked thoroughly for accuracy and consistency. This will mainly involve basic arithmetic operations. I'd appreciate it if you have a background in financial analysis. It would be helpful to have a good eye for detail as well.
I'm in need of a skilled VB.Net developer to assist with an urgent task. I have a JSON file that needs to be deserialized in order to extract its text content. This data migration task is quite simple - the JSON structure is not complex with only a few nested elements. This project is of utmost urgency, and therefore, needs to be completed as soon as possible. I'm looking for someone who has experience with: - VB.Net - JSON deserialization - Data migration Your task will be to create a script in VB.Net that can efficiently read the JSON file and extract the text content. This script will be a crucial part of our data migration process. If you have the necessary skills and can take on this urgent project, please get in touch. Your prompt completion of this task ...
I need some one to clean a file that has names and addresses The field with the name has business names and first and last name combined. I need them separate. Also some time there are two name or a last name and then the first name of a husband and the first name of the wife I need all that in separate fields See attached sample
