Excel vba vlookup in another workbookεργασίες
...existing Excel VBA project that interfaces with AutoCAD 2020. I'm looking for an experienced VBA developer to update the current functionality. Key Requirements: - This project involves updating an existing Excel VBA tool that works with AutoCAD 2020. The tool is currently used to generate data in Excel extracted in AutoCAD drawings what can be easy changed and send back to the relevant Drawings. You will be required to maintain the current functionality while also enhancing its capabilities. - The existing tool is aimed at automating the process of generating Excel data from AutoCAD drawings based on. The updated version should be user-friendly, and should ideally also allow for some form of automation of repetitive ...
I need someone to consolidate data from multiple Excel sheets. The data in these sheets consists of both text and numeric values. The goal is to bring all this data together into a single sheet, while handling duplicates in a distinct manner. Key elements of the project include: - Merging text and numeric data from several Excel sheets into one - Handling duplicate entries by marking them without removing - Organizing the data by grouping it as per the provided sheets separately Ideal candidates should have: - Proficiency in Excel and experience working with data consolidation - Understanding of handling and marking duplicate entries if any - Ability to accurately organize and group data Your task will be to create a consolidated view of text an...
Hi Work-Nix Solutions, I would like to work with you again please on refining the great Excel-spreadsheet that you have helped me to build.
I'm currently looking for a skilled photo editor who can assi...currently looking for a skilled photo editor who can assist with a unique project. My requirements are explicit and I require a specific set of edits to be made. The task is simple: - Remove one individual from one photo - Add that same individual to another photo Additional Details: - I already have both the photos that need to be edited - Only one person needs to be maneuvered between the two photos Ideal Skills: - High proficiency in image editing softwares - Experience in manipulating images and blending them seamlessly - Background in portrait retouching animations This project would perfectly suit those with a keen eye for detail, and who adhere to image realism. If this sounds lik...
I'm in need of an Excel developer who can aid me in analyzing data, creating advanced formulas and functions, and programming macros. With your expertise, the primary goal is to develop an Excel file that will be used to generate various reports. Ideal Skills and Experiences: - Proficient in Excel data analysis and manipulation - Experienced in creating advanced formulas and functions - Able to implement macro programming - Adept in generating insightful reports from complex data Our goal is to provide you with an exportable dashboard in Excel, a tool that will efficiently display opportunity details per property and provide a dedicated area for your notes. Opportunities that meet the threshold should display the...
...vital in scheduling and placing ads, as well as assessing their performance using advanced reports. Key Features: - **Ad Placement and Scheduling:** - The primary function of the ads manager will be to place and schedule ads on my website without any hitches. This should be user-friendly and efficient. User Authentication: - **Social Media Login:** - I'd prefer user authentication to be through social media login, making it convenient for users to access the ads manager without the need for remembering yet another set of login details. Reporting and Analytics: - **Advanced Level:** - The reporting and analytics generated by this tool should be comprehensive and insightful. It should be able to track conversions and provide a detailed ROI analysis. Ideal Skil...
Παρακαλούμε Κάνε Εγγραφή ή Κάνε Είσοδο για να δεις λεπτομέρειες.
...years of experience in a full cycle implementation in SAP PP ECC as well as in support projects. • Minimum of 5 years designing and configuring PP modules knowledge of the key integration points between the other SAP modules (MM, PM and QM experience is an asset). • Ability to multitask and manage multiple deliverables and projects at the same time. • Understanding of accounting business processes. • Ability to understand business processes from a customer perspective. • Ability to work in a team environment, effectively interacting with others. • Excellent customer-oriented communication skills. • Must be results oriented, and demonstrate a “can-do” attitude – adaptability, flexibility and resourcefulness....
Looking for someone to help with few quick things. - Help me fetch repo from one aws account and push into another. - copying s3 data from one aws account to another. I believe it is only 10 mins job if someone knows it.
I am in need of a Senior Financial Analyst to assist with our company's financial modeling, forecasting, and data analysis and reporting. The ideal candidate must be familiar with various financial concepts, data analysis, and proficient in the use of Microsoft Excel, Tableau, and QuickBooks. Key Responsibilities: - Develop and maintain financial models for our operations and future forecasts - Analyze and interpret financial data - Prepare regular reports on financial performance - Utilize Microsoft Excel, Tableau, and QuickBooks for data management and analysis. The candidate must have significant experience in financial modeling and data analysis, preferably in a senior role. The ability to communicate complex financial information in...
I'm seeking an experienced architect to redraw the fire strategy plan for my small office building. The plan is as follows: 1. The building is 2 Leonard Circus designed b...experienced architect to redraw the fire strategy plan for my small office building. The plan is as follows: 1. The building is 2 Leonard Circus designed by stiff and Trevilian 2. The project is Fire strategy 3. The example is of another project of ours (Omega) 4. The first task is to digitise the outline of the plans by the architect (no need for details) 5. Add our plate taken from our dwg file 6. Add our symbols also taken from the dwg file 7. Colour in the same way that we colour at the end of the day the task is to produce fire strategy drawings in our plate and with our symbol...
I'm seeking an experienced architect to redraw the fire strategy plan for my small office building. The plan is as follows: 1. The building is 2 Leonard Circus designed b...experienced architect to redraw the fire strategy plan for my small office building. The plan is as follows: 1. The building is 2 Leonard Circus designed by stiff and Trevilian 2. The project is Fire strategy 3. The example is of another project of ours (Omega) 4. The first task is to digitise the outline of the plans by the architect (no need for details) 5. Add our plate taken from our dwg file 6. Add our symbols also taken from the dwg file 7. Colour in the same way that we colour at the end of the day the task is to produce fire strategy drawings in our plate and with our symbol...
I'm in search of an individual who is both tech-savvy and creative, capable of designing and editing an Excel-based yearly budget tracker for my department. This document must not only be functional, but visually appealing, making use of our company's branding and in a way that ensures user-friendliness. Key Requirements: - Creating a Comprehensive Tracker: I need a budget tracker that can calculate data and maintain it in a clear and organized manner, reflecting both incoming and outgoing finances. - Visual Appeal: This tracker should not be a typical, boring spreadsheet. It should feature vibrant colors and bold fonts, while still maintaining a clean and simplistic design. Additionally, it should incorporate our company's logo and color scheme ...
...am in need of a skilled expert to develop and set up a computer vision program to process a batch of SD video cards. This program will undertake a couple of key tasks: - Image Classification - Object Detection In terms of output, I require the processed videos to generate a Metadata file, which ideally is formatted into an Excel or CSV file. This data should include details such as date, time, classification, and direction. While I do have an Azure account for hosting and I am comfortable with it, I am also open to suggestions on which programming language would be the best fit for this project. The ideal freelancer for this task should possess the following skills and experience: - Proficiency in Python, C++, or Java - Familiarity with Microsoft Azur...
I'm in need of a tool that can effortlessly upload text information from an Excel document to a website form on a daily basis. The tool should also facilitate the mapping of Excel columns to the corresponding fields in the website form through a user-friendly interface. Key requirements include: - Daily automated upload of data from Excel to the website form - A straightforward, user-friendly interface for mapping Excel columns to website form fields - Accurate and efficient transfer of text information - A secure and reliable tool that ensures data integrity Ideal candidates for this project should have: - A strong background in web development with experience in form automation - Proficiency in Excel, including ...
...inputting it into an Excel spreadsheet. The key aspects of the project are: - **Data Extraction:** This involves comprehensively retrieving data from various websites. Some sites may have more complex structures, requiring the freelancer to navigate and extract data accurately. - **Excel Formatting:** The extracted data needs to be entered neatly into an Excel spreadsheet. - **Advanced Level Detail:** The data extracted should be detailed and comprehensive, including historical data and analytics where relevant. The ideal freelancer should have experience in web scraping and data entry, as well as a good understanding of Excel. They should be meticulous, capable of handling potentially complex website structures, and able to work with a high level...
I'm looking for a SEO specialist to help me to improve the traffic on my website. The focus is on local search engine optimization / onpage-seo. ## Note: - I need only an instruction excel - list. The language of the page is in german, but an online translation tool can be used. - No Plugin will be used, but other proven SEO - Tools are possible. Key Responsibilities: - On-page SEO analysis to identify the status of the page (one page, homepage) - You will send me your seo recommendations for onpage optimations - You will use a seo tool (we discuss which one is best) - I only need a written instructionfile what should be done at page, - start asap - Time: 2 hours a week for one month Ideal Candidate: - experience with on-page SEO for websites - Strong analytical ...
I'm in need of an experienced Arduino ESP32 developer who can create a software for me. This software should primarily support GPS and LTE communications for the purpose of tracking and navigation. The device is a and I can supply a testing device to you. The code has to open 2 simultaneous connections to the SIM7670G chip on the ESP32 at the same time. On port1, it has to read the GPS position every second and build up at Lat Long Array in memory. When this gets to 60 points, it triggers another 'thread' to create a polyine of these points and then sends this polyline to a server using TCPIP. Note that while the TCP Send is in progress which can take up to 10 seconds, the other thread is still catching the GPS points every second, so we
Hi Nadia A. The project is: Research and identify qualified 1,000 sign manufacturers /stores /sellers /suppliers (that sell signs) across Germany. Compile the leads data into a Excel format.
...digitized and transformed into an Excel spreadsheet. The document consists of approximately 238 pages, and I require the following: - Organization: Calls, texts, and data should be separated into distinct columns in the spreadsheet. - Data Layout: The information should be laid out in an ordered manner which we will discuss further. Additional requirements include: - Calculations: The Excel sheet should include specific calculations like total call duration and data used. - Data Fields: The "To/From", "City", and "Time" fields should be organized in distinct columns within the spreadsheet. Ideally, I'm looking for a freelancer with: - Proficiency in PDF to Excel conversion. - Strong organizational an...
I have a list of 2060 SKUs in an Excel sheet that I need corresponding images scraped from Website A. Each image should be saved with the SKU number as the filename (e.g., for SKU 32440). Key Requirements: - Scrape images from Website A for 2060 SKUs - Save each image as a high-resolution jpg with the SKU number as the filename Delivery: - I will provide you with the Excel sheet containing the list of SKUs via email. - You should deliver the images in a compressed file with 2060 images, each named according to the corresponding SKU. Ideal Skills and Experience: - Experience in web scraping, particularly image scraping - Proficient in Excel for managing SKU lists - Ability to deliver high-resolution images - Attention to detail to ensure...
I'm looking for another freelancer to help me with creation of a backend for my crypto solana token website. The freelancer has to have experience with solana blockchain and creation of solana tokens aswell as with nodejs Solana Token 10 billion pieces Token has to be multi-sig capable Presale with 10 levels of 72 hours each AirDrop the tokens
ITALIAN LANGUAGE MANDATORY. Starting from a list of 12500 Company names in excel, we need to fill in the other columns finding online: - website URL - Zip Code - VAT Number - Type of Industry (selecting it from the excel drop down menu)
i want to be data entry job use word, pdf , excel , PowerPoint , and any type of graphic design work . i have 3 years teaching experience with data collection , data entry , and graphics design . i have fully and wonderful experience in Microsoft office , excel, PowerPoint , photoshop , illustrator, CorelDRAW, filora
For this project, we need to consolidate customer data from multiple Excel files into one Excel sheet using macros. This will allow us to manage our data more efficiently. Key tasks include: - Creating a macro that can extract and merge customer data across several Excel files. - Managing the data in a way that it is grouped by Customer ID. Skills and Experience: - Extensive knowledge in Excel and proficiency in creating macros. - Prior work experience with data consolidation projects. - Exceptional attention to detail. - Ability to organize data effectively. - Knowledge of data management according to customer demographics.
My WordPress website is redirecting my phone number link to another URL. This is an urgent issue that needs to be resolved within the next 24 hours. Key Tasks: - Investigate the issue: Identify the root cause of the redirect and provide a detailed explanation of it. - Fix the redirection: Modify the link to correctly direct users to the intended phone number without any detours. - Testing: Ensure the link functions as intended across different devices and browsers. I have full access to the website's hosting and admin panel, making it easier for you to troubleshoot the problem. Ideal Skills and Experience: - Extensive experience with WordPress and website development. - Proficient in debugging and troubleshooting website issues. - Strong knowledge of URL redirection ...
...will be used in correlation with sales data from Excel Sheets. The goal of this task is to determine if the presented ad spend had a significant impact on total sales or sales in our stores. The data spans from May 2016 to May 2024. Key Requirements: - Compile ad spend data from Google Ads and Facebook Ads, and sales data from Excel Sheets. - Perform trend analysis on the data sets to determine if any discernable impact exists between the ad spend and sales. - The focus should be on whether ad spend, regardless of platform, led to a measurable and discernable difference in sales. Ideal Skills: - Strong data analysis and interpretation skills. - Proficiency in working with ad spend and sales data. - Experience with trend analysis and ...
...expansion chamber for dirt bike. I do know all my dimensions lenght and diameters. I want to be able to draw a line wich will be my centerline and then on this line i want customize every lenght and diameter of each section. Then had radius in sections. I would like to to be able to divide each sections in strip section to be then cut on my plasma. I have included a YouTube video to show what i am looking for . I want to have a reference line that i can curve on every axis along the length required in order to follow the curved and straight section needed. - On that line I want to have adjustable point to be able to adjust length and diameter for each my subsection. Because each pipe is build with many differents cones -Each section/cone needs
...Telegram bot bot_a, the code loops through accounts in the API list and pastes the user's message text to bot_b and bot_c. It then waits for responses from bot_b and bot_c, and processes the two responses together. The processing logic includes keyword checks, removal of special emoji, and extraction of numbers from buttons. Then, bot_a sends the processed text back to the user. I now need to add another bot, bot_d, such that when a user sends a message to bot_a, I will use the API list accounts to paste the user's message text to bot_b, bot_c, and bot_d, and wait for responses from all three. Then, I will merge and process the text from the three responses, and have bot_a send the processed text back to the user. Sometimes, bot_d may not respond. In suc...
Translation of two files, from English to Hebrew. File #1 contains 8 rows of text in Excel format, 119 English words. File #2 contains 85 rows of text in Excel format, 2,035 English words.
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...
...a project of enhancing the visual appeal of an existing Excel spreadsheet. This entails more than just a simple makeover, but applies a professional visual identity to the spreadsheet. The spreadsheet is a database to show service times and the parts required for that service. I need it to be easy to read and professional. You can use our logo. Key Responsibilities: - I would like customized fonts and formatting integrated throughout. This isn't limited to a specific area, so use your judgment to decide what gets modified. It's essential that the spreadsheet no longer resembles a generic 'Excel' one. - I want the spreadsheet to look and feel intuitive, maintaining the professional aesthetic. Preferred Skills: - Mastery of Excel and its vari...
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...
