Excel vba vlookup in another workbookJobb
We're launching a promotional campaign for a spoon and require experienced actors who are comfortable with,...comfortable with, and can execute, absurd humor. The objective of this joke advert is to: • Create an engaging, funny, and memorable way to promote our product: the spoon I'm replicating the old style infomercials of the 90s so acting needs to be a bit wooden and feel cheep The ideal candidate should have: The ability to use a phone (on its side in a tripod or propped up somehow) and film themselves firstly struggling to use a spoon and another take using a spoon perfectly like its the easiest thing they have ever done. also deliver some lines. I'll be looking to use the footage from the phone, so make it the best quality you can. making sur...
I need to move my WordPress site, which is 8GB in size due to images and database, from one cPanel to another server. Key requirements: - The migration should be seamless and preserve all data, content, and functionality. - The site should be fully operational on the new server post-migration. Ideal Skills: - Expertise in WordPress site migration. - Proficiency in handling large-size migrations. - Strong understanding of cPanel and server configurations. Please provide prior experience with similar projects.
...seeking a skilled cPanel expert who can assist me in moving one cpanel account in one reseller hosting account to a new provider. I'd like to ensure a seamless transition with minimal downtime. Thee problem is the account size is very large, currently 160GB, but I'm not sure exactly as the disk space doesn;t always reset immediately. I've created backup files which are 160GB, but there may even be unnecessary backup files inside that! Plus uploading the files to the receiving cpanel have failed - possibly due to the large size. Key Tasks: - Move entire reseller hosting account to a new provider - Ensure all websites and data are effectively migrated - Verify and ensure all services are fully operational post-migration Ideal Skills: - Proficiency in...
...de aproximadamente diez días. - El pago será de 0.015€/correo electrónico encontrado. Research/Data Collection: Email Search for Technology Companies - I am looking for a freelancer who can assist me in gathering email addresses from a list of companies. - The purpose of this project is to collect data for research purposes. - The ideal freelancer should have experience in data collection and be proficient in conducting online research. - The project requires gathering a substantial number of email addresses from a sample of 4800 companies aprox. - Attention to detail and accuracy are crucial in this project to ensure the validity of the collected email addresses. - The freelancer should be able to efficiently navigate various onlin...
We have a list of around 4,795 energy consultants. This list contains the name of the consultant, the company name they work for, contact information including general email address, telephone number, website, and address. However, we need you to find out the personal corporate email address of each consultant, and insert it into Column K in the Excel sheet. Check the attached file. Time : 48 Hours Budget 50$ Lowest Bidder will win Milestone Payment : no advance milestone payment. After Completed work get payment. Thanks
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.
...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 plus. Your previous succ...
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, ...
I have a Microsoft Excel assignment that needs expert handling. My needs include: - Data analysis: I want to make sense of my data, and uncover any hidden trends or correlations. - Formula creation: I require the creation of Excel formulas to automate data processing tasks. - Graphs and charts: I need insightful visuals to represent my data. This will aid me in understanding and communicating it more effectively. While it's unfortunate I could not provide more detailed information, it's vital that the freelancer can work with a certain degree of ambiguity. Expertise in Excel-based data analysis, formula creation, and chart and graph creation are essential. An ability to uncover data insights, no matter how small the dataset, will be high...
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 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.
Vänligen Vänligen Registrera dig eller Logga in för att se mer information.
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
