Excel vba vlookup in another workbookpráce
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 ca...
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.
We're back again with another video - this one for Recruiter. All files here: Let me know if you have any questions.
... I'm in need of a highly skilled PHP programmer to enhance a Moodle-based learning platform. I'm looking to integrate it with Zucchetti, an employee registry system, to facilitate seamless Single Sign-On (SSO) and data synchronization between the two systems. Key Requirements: - **Integration with Zucchetti**: The ultimate goal is to integrate Moodle with Zucchetti. This means that the successful freelancer will need to have a solid understanding of how to connect these two systems seamlessly. - **SSO Implementation**: Single Sign-On will be a key feature to implement. This will allow users to access both platforms using a single set of login credentials. - **Data Synchronization**: The two systems should be able to communicate with one another, ensuring that da...
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 da...
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 s...
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.
...seeking a talented JavaScript Developer with expertise in ElectronJS, ReactJS, OpenCV/TensorFlow, and ExcelJS to join our team. The ideal candidate will be responsible for 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. Thi...
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'm in need of a Telegram Bot and corresponding Web application for the wellness industry. Key Features for the Telegram Bot: - **User Registration**: The ability for users to sign up and create their own accounts. - **Daily Health Tips**: A feature that provides users with helpful health tips on a daily basis. - **Fitness Tracking**: The bot should enable users to keep track of their fitness progress. Key Features for the Web Application: - **Wellness Resources**: A comprehensive library of wellness resources for users to access. - **Appointment Scheduling**: An integrated system for users to book wellness appointments. - **Community Forum**: A platform for users to share experiences, ask questions, and support one another. - **Fitness Challenge**: A section dedicate...
saya among dan saya bisa mengoperasikan excel dan saya siap bekrjasama.
...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 Counselling, our experienced faculty, and the hands-on practical training the students receive. - Aim for a balance of engaging visuals, compelling narrative, and informative content that appeals to individuals considering a career shift into counselling psychology. - We'll need the final video to be high-quality and suitable for promotional purposes across various online platforms. The ideal candidate for this job will have: - Proven experience in ...
...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...
...view it. Size: I need this exported in 4 different sizes. See below: 1920x1080 (Website homepage) (Will NOT need music or sound) 1080x1080 (IG) (Will need music) 1350x1080 (IG) (Will need music) 1080x1920 (IG) (Will need music) Length: The video should be 20 - 25 seconds long. Ensure it is no longer than this. Mediums: You will be required to use both video, 3D assets, and photos throughout this video. Creative references: The homepage video is what I am looking to replicate. This is how it should look and this is what the video’s main purpose is. Similarly to this video, it should highlight a number of different campaigns. Here is a reference for how you could bring in the photo assets - as they are still
I have an image that requires a hydro pole to be removed from the background. I don't want it replaced with another photo or specific element, but would like it to naturally blend in with the existing elements surrounding where the pole currently stands. Skills and Experience required: - Strong photo-editing skills - Experience in background adjustments - Ability to make the edit appear natural and seamless The end goal is to enhance the image's quality and focus by removing this distraction.
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.
Right now it's just one image - but I might add another tomorrow, and we'll add to the bonus rather than start a new project!
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.
K zobrazení podrobností se zaregistrujte nebo přihlaste.
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.
...Led Zeppelin'. The work would start June/July 2024, although looking to source an illustrator and get costing for the project now. Written in rhyming verse it follows a young Jimmy Page as he finds and learns the guitar, joins his first band, Art School, Session Work, The Yardbirds, and finally onto forming and leading one of the most successful bands in history - Led Zeppelin. The book will be illustrated for kids aged 5 to 10 with an attention to detail that parents will love. Guitars, Amps, Drums, Costumes, Albums, Stadiums and more. The ideal illustrator would be: - Proficient in cartoon style illustrations based on real people. - Experienced in creating multiple illustrations for a whole book. - A fan of Led Zeppelin. Having a knowledge of the...
I need an experienced video editor/content creator to produce three short video adds I want to use to announce an upcoming Alumni Reunion/Networking event on various social media platforms. The videos should be less than 1 minute in length, three different videos. You can use any music that you see fit but you need to have a good eye for visuals and a knack for storytelling. Key Responsibilities: - Creating engaging, 3 short videos for Facebook, TikTok, and YouTube - Ensuring the videos are less than 1 minute in length - Using royalty-free music effectively - Showcasing strong editing and storytelling skills -The videos must relay these key information 1. Name of the event is 'Poly Networking Event' 2. The event will be held on July 20, 2024. 3...
I'm in need of a skilled developer who can create an AI portal that 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 automatio...
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
I'm building a chrome extension for ghost browser (chromium based) that needs 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":...
This is for freelancers located in the U.S. ONLY. I need an Adobe Acrobat Pro expert to “Embed Videos” and “Create Links” inside a PDF document using Adobe Acrobat Pro. Just to be clear, not hyperlinks to other files outside the PDF document, not hyperlinks to websites, webpages or web located videos. When complete, and the PDF document is forwarded to another individual, they need to be able to "click on" an icon in the document and have the video play. We are a forensic investigation company and often have legal cases where these types of efforts are needed. Unfortunately, the documents cannot be sent to you. You will be working remotely on a computer in our office. The tasks pay $50 per hour with a one hour minimum. ...
Looking for an A frame design, same image on both side, something to promote an indoor archery range/shop and grab attention from people driving past. With an arrow pointing to the left on one side and to the right on another. Needs to have; 1) Arrow Point to left on one side and to the right on another 2) Logo 3) 20 Stephenson Road, Seaford, Address 4) Eye Catching Design 5) Mentions Indoor Archery Range/Shop
Looking for an expert in data visualization who can show off their skills by creating some stunning and insightful graphs based on my company's stock data. Here's what I need: - Create a scatter plot of the highest stock price (in the column labeled "High") against time. Write several sentences explaining the process/steps. -Create a scatter plot of the lowest stock price (in the column labeled "Low") against time. Write several sentences explaining the process/steps. -Create a histogram of the adjusted daily closing stock price (in the column labeled "Adj Close"). Make sure the histogram is meaningful by adjusting the bin size so you can see the shape of the histogram. Write several sentences explaining the process/steps...
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
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.
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 ...
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 require a skilled photo editor who specializes in faces for an intricate job. The task includes: - Replacing a face with another face - I have already selected and provided the replacement. - High attention to detail in the replacement is essential, ensuring that the replaced face maintains distinctive textures, precise skin tone, and features. Ideal candidates will have substantial experience in photo retouching and color correction, ability to handle background removal with finesse, and must demonstrate proficiency in maintaining high levels of detail in their work. Portfolio showing past face replacement edits is highly desirable.
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
I need a diligent freelancer to copy and paste text for me. Key Project Details: - Copy and Paste: The task involves copying text from one source and pasting it into another. - Source of Content: The text will be sourced from various online platforms. - Timeframe: I need this task completed urgently. Ideal Freelancer: - Attention to Detail: It is crucial that the text is copied accurately. - Speed: Given the urgent nature of the project, a quick turnaround is essential. Please provide your experience with similar projects and your availability.
...consultant to work on an annual SEO project for a well-known small appliance brand in the United States, which is part of an international group. The website is an e-commerce site. This profile will work integrated into the SEO team for AMERICA that the client has formed, along with other management and technical members so that teamwork will be an essential condition. The project is a global project where each region has its strategy, but all must go hand in hand. The consultant will become part of our network of freelancers, with the possibility of participating in other projects for which a profile like theirs is sought. What do we offer? - The possibility of joining a multicultural team and working in the dynamic e-commerce sector for a company with a ...
I require an experienced and proficient VBA developer to create a code that automates data entry tasks in Microsoft Excel. The main objective is to significantly increase productivity and ensure accuracy by automating repetitive data entry procedures. Ideal skills would include: - Vast knowledge of VBA and Excel - Prior experience in developing automation scripts - Exceptional attention to detail - Ability to work within strict deadlines
I'm in need of a seasoned Excel expert who's proficient at conducting optimization analysis to solve a real-world problem. Key Requirements: - Profound understanding of optimization analysis - Ability to work efficiently and quickly - Experience with diverse Excel functions Please note that the specific goal of the optimization analysis requires maximizing profits, minimizing costs, or optimizing resource allocation. Your expertise in this area will be crucial to our success.
I need an expert to convert tables from a PDF file into an Excel spreadsheet. The job involves transferring text and numbers from a multi-page PDF table to an Excel document. I have attached the PDF. The analysis should start from page 7. Here's what the project entails: - Converting data from a PDF table that includes both text and numbers - Handling tables that span across multiple pages in the PDF - Transferring the data to Excel without any need for specific formatting or layout changes - Provide the developed script used to obtain the records from the tables. As a freelancer, you should have: - Proficiency in PDF to Excel data conversion - Ability to work with complex table structures - Attention to detail to ensure accurate transfer of...
**Contest: Excel Specialist Wanted for Comprehensive Property Portfolio Management Tool!** Are you an Excel virtuoso with a passion for crafting intricate and comprehensive spreadsheets? We're embarking on a quest to develop the of a cutting-edge Property Portfolio & Financial position Management Tool for our discerning clients. If you possess the expertise to meticulously organize data, create advanced formulas, and design visually captivating presentations, this contest is tailored for you! Join us in revolutionizing property portfolio management with a document that sets the standard for clarity, accuracy, and usability. I would like to be able to edit if required in the future therefore 2 copies will be required. 1 being password and field protecte...
The company is seeking help from a professional who is fluent in Arabic to translate a text. They are looking for someone who can accurately and effectively convey the meaning of the original text in Arabic. This indicates that the user may have a document, message, or piece of information that needs to be translated from another language into Arabic. By reaching out for assistance, the user is demonstrating a need for clear and precise communication in Arabic, and is seeking a translator who can accurately convey the intended message in the target language.
I'm seeking a developer to create a comprehensive members' social media software. Thi...media software. This software should be responsive and functional across both web and mobile platforms. Key Functionalities: -Instant messaging: Members should be able to privately communicate with one another. -Photo and video sharing: A core function should include the sharing and commenting of multimedia content. -Blogging and forums: Members must have the ability to write posts and create threads for discussions. The platform should optimally support a user base of 1,000 to 5,000 members. Applicants should have a robust background in social media software development and be experienced in implementing the functionalities listed above. An understanding of scalability...
...uploads the product and puts the price along with photos. Right now the website allows the client to publish the product in a category (Example: Cards) and within this there are some associated subcategories (Example: Pokemon), we need to add another level of subcategory (Example: Pikachu SV4 2024). The scheme would look like this (Example: Cards->Pokemon->Pikachu SV4 2024). The main category already allows the creation of subcategories, it is necessary to simply create a second level of subcategories and the client cannot publish in subcategory level 2 only in level 3. The following is necessary: 1st. Create a second subcategory level linked to another subcategory. 2nd. In that second level of subcategory, at the top there appears an i...
...develop a program that scrapes text content off of multiple websites and then cross-references this data against another site. Key Requirements: - The software should effectively pull out text content from all provided sites. - The text content should be in a plain text format, ready for easy analysis and interpretation, preferably in an excel spreadsheet or comma delimited list. - The cross-referencing component is crucial, as the software will need to compare the data scraped with that of another website. Qualifications: - Background in Data Scraping and Software Development. - Previous experience with cross-referencing data. - Proficiency in handling different data formats. In essence, I'm looking for someone who can c...
I am looking for someone skilled in Microsoft Excel and Power Automate. This task involves creating an automation system that sends emails to our internal team members based on given triggers. The automation should trigger when: - An event's start date is approaching - An event's deadline is nearing The email content should serve as a reminder of the approaching start dates. It's pivotal that the chosen freelancer can work with accurate detail to ensure that no deadlines are missed. A deep understanding of Excel, or similar spreadsheet software, automation, and email systems is required for this task. Experience working with scheduling and deadline tracking will be an advantage.
...expert in Excel to help me with a statistical analysis of my sales data. The key tasks for this project are: - Conducting statistical analysis: I need you to run a detailed statistical analysis on my sales data. This will involve using advanced Excel functions to analyze variables such as sales trends, forecasts, and correlations. The ideal candidate for this project should have: - Proficiency in Excel: The chosen freelancer should have a deep understanding of Excel and be skilled in using advanced functions. - Statistical Analysis Expertise: Experience in statistical analysis is crucial, as you will be required to interpret the data and provide insights. - Attention to Detail: The work involves handling a large amount of data,...
