Excel vba vlookup in another workbook jobs

Dough one Sources is looking candidates for Senior Business Analyst – VBA, Advance Excel. Job Role: Senior Business Analyst Job Location: Remote Experience: 4 + Years as Business Analyst – VBA , Advance Excel 3+ years of experience is required in creating dashboards in Manufacturing, Banking, Retail Industry. Working Hour: 3 hour per day (per day) Salary: 150 – 300 INR Per Hour Job Responsibilities : • Understanding Company requirements. • Understanding, consolidating and analyzing data from spreadsheets. • Creating dashboards, reports and charts in Analytics tools. • Working on financial and other types of modeling projects. • Having knowledge Dashboard Creation, Mainframe automation through VBA...

Hello, I need convert a PDF invoice to Excel to import to our invoices software

I'm looking for an experienced Power BI developer to create bespoke reports and dashboards, which will be integrated into Microsoft Teams. Tasks: - Handling data from Excel spreadsheets and converting it into insightful reports and dashboards. Skills and Experience: - Strong command of Power BI for report and dashboard creation. - Proven experience with Excel spreadsheets. - Good knowledge of integrating Power BI into Microsoft Teams. The goal is to make complex data easy to understand, facilitating better decision-making within our team. Your work will directly impact our day-to-day operations and strategies.

Create a presentation for an annual report in either a Microsoft product (Powerpoint, Word) or Google (Docs, Slides). The presentation will be based on data provided - a draft is attached but it is not yet final. Attached is a style of presentation that I am comfortable with, but another style could also be perfectly suitable. The ability to start on this immediately (after I provide the final draft) and finish it quickly is important.

I need a professional translator to convert an English document into another language. The specifics of the target language are for you to decide, based on your expertise and the nature of the content. Ideal Skills and Experience: - Proven experience in professional translation - Proficiency in both English and the target language - Familiarity with the subject matter is a plus - Excellent attention to detail and accuracy Please provide a brief overview of your translation experience and let me know the target language you propose for this task.

I am in need of a specialized WordPress developer with experience in Excel operations and data showcasing. Key tasks: - Create a WordPress page that extracts numeric and text data from an Excel sheet. - Implement highlights and color-coded information on the webpage for better readability and understanding. - The data on the Excel sheet will be updated on a monthly basis, hence the website should be able to fetch the data automatically upon any modifications. Ideal skills: - Proficiency in WordPress and Excel integration - Experience in creating visually appealing data showcases or infographics - Strong understanding of data extraction and display technologies The aim is to have a user-friendly webpage that accurately represe...

I'm in search of an Excel expert who can assist me with complex tasks in Excel. Specifically, help is needed in two key areas: - Formulas & Functions: While basic arithmetic operations are simple for me, I need assistance with text and date functions. - VBA Macros: I'm looking for someone who can develop advanced user forms and interfaces. This requires a high level of VBA expertise. The ideal candidate would have a strong background in Excel, with a focus on formulas, functions, and VBA. Previous experience working on advanced macros and a deep understanding of text and date functions will be a huge plus. The ability to communicate effectively and understand my specific needs is essential.

I'm looking for a skilled and creative designer to help me conceptualize and design an appealing food truck that serves crepes. I would like to use the same design "design idea" with the name of La bonne crepe de Maman. You have as well my company logo and the dimensions of the trailer. I would like to h...and creative designer to help me conceptualize and design an appealing food truck that serves crepes. I would like to use the same design "design idea" with the name of La bonne crepe de Maman. You have as well my company logo and the dimensions of the trailer. I would like to have a scan code for Instagram etc.. like the picture of the trailer and another Scan code on the top of the side window with the title Order by Phone. It needs to be in...

I'm in search of a versatile freelancer with skills in Word, Excel, programming, and graphic design. Your expertise in these areas will help me in different domains. Your main tasks will include: - Formatting documents in Word, ensuring a professional and consistent layout. - Creating Excel spreadsheets and conducting data analysis. Proficiency in Excel will be crucial to help me interpret and visualize data effectively. - Developing software or web applications. I am working with Java/Spring/JavaFX and am open to creative development ideas and solutions. - Designing logos and visuals. Your ability to create engaging and unique visuals will be a big asset to my projects. I am currently using Word 2010 and will be workin...

I'm looking for a skilled developer to assist with syncing an Excel file to my phpMyAdmin database. Key Requirements: - Real-Time Syncing: The sync should take place continuously in real-time. Any updates made to the Excel file should be reflected in my phpMyAdmin database instantly. Skills and Experience: - Proficient in Excel and phpMyAdmin - Experience in data syncing and database management - Familiarity with real-time data syncing No specific data validation or transformation is needed during the import process. The goal is to ensure that any changes made in the Excel file are accurately reflected in the existing database.

I'm looking for someone who can design a sophisticated budget template for me in Excel. This template should: - Track both income and expenses - Project weekly outcomes - Compare actual amounts to budgeted amounts - Include more than 20 budget categories - Incorporate graphs and charts for visual representation. Skills necessary for this project will include advanced Excel knowledge and experience with financial modeling. The ideal candidate will have previously worked with complex budget templates and be comfortable creating a user-friendly interface. You should know how to devise a system that simplifies input and keeps data organized and easy to understand. Your ability to turn raw numbers into straightforward graphs and charts will be particularly valuable...

I need a professional to convert the information in the attached document into an organized, well-formatted Excel sheet. The project will require you to: - Copy all the text content of the document into corresponding cells in the Excel sheet. - Transcribe all tables and charts in the document accurately into the Excel. - Maintain the original formatting of the data in the document. The Excel document should: - Include all columns and rows from the original document. - Not require any additional formulas or functions.

I am in need of a comprehensive Excel sheet that does calculation. Data entry is not too complex; it includes dates, dropdowns and formulas. Requirements: - Design an Excel sheet that calculates basic arithmetic operations, performs statistical analysis, and handles financial calculations. - The form should be user-friendly and able to accommodate the moderate complexity of data entry. - I need an expert who can create a clear and concise interface for the user, making data entry and subsequent calculations easy and efficient. It would be great if the freelancer has experience with: - Excel design for calculation purposes - Data entry form design - Experience in basic arithmetic operations, statistical analysis, and financial calculations.

Please Sign Up or Login to see details.

... HTTPS Domain Configuration: - Configure an HTTPS domain for both frontend and backend services. - Use Certbot or another tool to obtain and manage SSL/TLS certificates. - Redirect HTTP requests to HTTPS. 4. Documentation: - Provide detailed documentation for CI/CD setup, logging configuration, and HTTPS setup. - Include instructions for maintaining and updating the configurations. Requirements: - Experience with GCP: Expertise in managing and configuring GCP services. - CI/CD Expertise: Proven experience with GitHub Actions for CI/CD pipelines. - Logging and Monitoring: Knowledge of setting up logging and monitoring for web applications. - HTTPS Configuration: Experience in configuring SSL/TLS certificates and managing HTTPS domains. - Documentation Skills: Abili...

Let's do it. let's do it. let's do it

I'm looking for a skilled developer to assist with syncing an Excel file to my phpMyAdmin database. Key Requirements: - Real-Time Syncing: The sync should take place continuously in real-time. Any updates made to the Excel file should be reflected in my phpMyAdmin database instantly. Skills and Experience: - Proficient in Excel and phpMyAdmin - Experience in data syncing and database management - Familiarity with real-time data syncing No specific data validation or transformation is needed during the import process. The goal is to ensure that any changes made in the Excel file are accurately reflected in the existing database.

...specific set of tasks on a local W10/11computer. The tasks I need accomplished are: - Connect to the remote QNX computer via SSH (Secure Shell)( login/ password in config file.) -send some command (must be configurable - Run certain commands via batch file on windows 10/11 computer. (Configurable) - Run local bat comands on Windows computer (configurable) - Send key combinations on Windows computer (configurable) Managing errors if they occurs. Keep CMD open for manually entering other commands ( in feature can be automated as another project or add-on) Prior experience with batch file creation and QNX systems is necessary. Proficiency in SSH connections is also essential for this project. The ideal freelancer would be meticulous and able to effectively org...

I'm in need of an Excel expert to enhance my files. The tasks include: - Removing duplicate rows - Fixing formatting issues - Merging two sheets into one Additionally, I would like to incorporate a corporate branding style in the file, utilizing appropriate colors and logos. Ideal Freelancer: - Proficient in Excel with experience in data cleaning - Skilled in formatting and merging multiple sheets - Familiar with incorporating corporate branding within Excel

I need a detail-oriented and efficient freelancer to assist me with a data entry project. The specifics are as follows: - The project requires entering a combination of numeric and text data. - The goal is to have the data organized in a clear and coherent manner. The format of the data is likely to be in spreadsheets, although it may vary. Proficiency in Excel and Google Sheets will be essential for this task. Previous experience in data entry with formulas will be considered a plus. The ideal candidate will be able to deliver high-quality work in a timely manner.

I'm in need of a skilled developer to create a text-based GPT (Generative Pre-trained Transformer) specifically for analyzing excel outputs and give answer according to user pre-defined questions.

I'm in need of an experienced professional to translate a legal document from English to another language. The document is a legal agreement and I need it to be accurately translated with all legal terms preserved. The ideal candidate should have the following qualifications: - Proficient in both English and the target language (Spanish, French, or German) - Previous experience with legal document translation - Understanding of legal terminology - Attention to detail, ensuring the translated document maintains the original intent and context. - Timely delivery is important. Please only apply if you meet these requirements.

...have a Journal App built in PHP/JavaScript/Laravel which allows to enter Journal entries, country, some photos and one video of limited size, different costs etc (see ). The job is to implementing the feature of Travel Route Map Creation using Leaflet and OpenStreetMap (both free, opensource). There is a tutorial here Users will be able to search a place in map, create lines of different colors from one place to another, add/tie blog posts, links and pictures with the map, dates, notes and then only map creator can download the map as Image/PDF. Leaflet free plugin is there for this. Each created map should have unique link. Creator of map can embed the map in his blog, allow/disallow

Active Directory Expert to create a Python script and test data to capture all meta data linked to and which describes the confined parameters of an AD account, AD RMS (Rights management Services) group policy GPO etc. and export to a MS Excel File. More information attached.

I'm looking for a dedicated virtual assistant to assist me with simple data entry tasks. The data will be provided in handwritten notes. Ideal Skills and Experience: - Proficiency in data entry - Ability to handle simple copy-pasting tasks - Experience with handwritten notes data entry is a plus - Attention to detail and accuracy - Excellent time management skills - Familiarity with tools like Excel or Google Sheets for organizing the data Please note that while the tasks are straightforward, attention to detail is crucial. I'm looking for someone who can deliver accurate and timely results.

...ANY CHANCE YOU CAN HELP ME PLEASE ? Thank you Kindly in Advance There is hope you can give your “best” price; unemployed, and have cancer with bills backing up, $10 possible? Please note $10 is the max total that I can handle for this (doing hourly reduces % fee). Will leave a Glowing paragraph of feedback 5 stars : - ) My funds are low but will pay quick and leave 5 stars. Please give your best possible for your bid ? (something reasonable?) Please note there is hope we can mutually complete this task; we can leave each other nice comments and 5 stars for each? Look at feedback on my profile, feedback I left for many others. Here is the project: SINCERELY WOULD BE NICE TO MEET YOU PLEASE ANY THOUGHTS ? Please note project is due in two hours as this pr...

...ANY CHANCE YOU CAN HELP ME PLEASE ? Thank you Kindly in Advance There is hope you can give your “best” price; unemployed, and have cancer with bills backing up, $10 possible? Please note $10 is the max total that I can handle for this (doing hourly reduces % fee). Will leave a Glowing paragraph of feedback 5 stars : - ) My funds are low but will pay quick and leave 5 stars. Please give your best possible for your bid ? (something reasonable?) Please note there is hope we can mutually complete this task; we can leave each other nice comments and 5 stars for each? Look at feedback on my profile, feedback I left for many others. Here is the project: SINCERELY WOULD BE NICE TO MEET YOU PLEASE ANY THOUGHTS ? Please note project is due in two hours as this pr...

Hi, I noticed your profile and would like to offer you my project. We can discuss any details over chat. This is another website.

What we have -------------------------- 1: Excel or CSV file. containing addresses to post letters 2: Letter Quality ( Paper weight, Sizes, Cost per letter etc configuration in JSON array) What we need -------------------- - Standalone PHP Script where we will be able to select an item from provided JSON. - Through DHL API we will validate the provided addresses(in the form of exel or csv) if each individual address is valid - or we should be able to select the areas of over choice over google map is shown in the provided video - this funcationaly is also provided over DHL api I think. and there demographic filters can also be applied which are provided be DHL api also shown in the video Please apply only if you the the required experience. these link...

I'm in need of a professional who can convert both scanned documents and photos into simple data in Excel format (language is not in English workable when one can use translate and understand the few terms that are there). The ideal candidate will have the following skills and experience: - Proficient with MS office - Expert in handling MS Excel - Ability to follow a specific Excel template provided - Attention to detail to ensure accurate data entry ***The task is very simple and just requires attention to detail. I need mainly 4 Data Rows: 1. Date 2. Payor/Payee 3. Amount 4. Short Description of Transaction (if given in the doc) Please message me to talk about the project and the realistic bid price per Job. Your respo...

We are an Ecommerce company dealing with variety products and we are looking for a Social Media Ads Manager to join our team. The tasks i...and we are looking for a Social Media Ads Manager to join our team. The tasks includes but not limited to: Creating the ads on different Social Media Platforms Create reports in Excel, and Google Sheets on a daily and monthly basis Turning off the ads which are not delivering the acceptable ROI Creating a new ad for the stopped campain The Ads Manager must be solely free for this project and not committed to any other task, job or study work hours: 6 days a week, 10 hours a day The agent must be fluent in both Arabic and English Must also have good communications skills Can work on Excel Have sufficient experience in ...

I'm looking for a skilled AI Developer to program module that speaks with AI (Gemini or GPT) as batch analysis of Excel files. Key Responsibilities: - Conducting pattern recognition and insights in the data Ideal Skills: - Strong AI development experience - Proficiency in Excel and data analysis - Ability to automate analysis processes

I'm looking for an expert machine software engineer who can proficiently integrate software wit...- The successful freelancer will be required to integrate software with an industrial control system and Programmable Logic Controllers (PLCs). Ideal skills and experience: - The ideal candidate will have considerable experience in machine software engineering, with a focus on software and hardware integration. - In-depth understanding and hands-on experience with industrial control systems and PLCs are crucial for this task. - Experience with programmable logic controllers (PLC) is particularly critical. We are looking to build a load bank with Canbus or another form of communication protocol that can be controlled from a single location. Software will have to be ...

I am in the process of starting a new enterprise and require a skilled web developer to create an airconditioner comparison website. This platform will serve as a space where different airconditioner models and brands can be compared. Key components of the website: - Airconditioner Comparison: The primary function of the website is to allow users to compare various airconditioner models and brands. This should be user-friendly, informative, and visually appealing. - Showroom Visit Assistance: Another crucial feature of the website is to offer personalized assistance to users who are interested in visiting authorised showrooms. This might include providing them with details about the showrooms, scheduling appointments, and offering recommendations based on their needs...

I am seeking an experienced Power BI expert who can assist with generating intermediate reports. This role involves: - Working with Excel datasets. - Developing seamless processes to generate user-friendly reports. - Troubleshooting any issues that may arise during report generation. The ideal freelancer should have: - Excellent understanding of Power BI. - Experience in report generation. - Adept knowledge in handling Excel datasets. - An analytical mindset with attention to detail. Proficiency in Excel and experience with intermediate report generation will be highly advantageous.

I'm looking for an experienced Excel expert to create a customized spreadsheet for my construction project. The primary usage of the sheet will be for material and labor cost estimation, and I need it to include visualizations in the form of charts for budget allocation. Key Tasks: - Set up the sheet with the right formulas and functions to ensure accurate calculations for material and labor costs. - Design the sheet to be user-friendly, yet professional in appearance. The ideal candidate should have: - Proficient knowledge and experience in using Excel for construction projects. - Prior experience in creating similar spreadsheets with formulas and visualizations. - An understanding of the construction industry and the specific needs of t...

I have a complex Excel file with more than 10 worksheets that I need help with. The project involves three main tasks: data entry, formulas and calculations, and data analysis. Key Responsibilities: - Data Entry: - Ensure accurate entry of information across various tabs - Formulas and Calculations: - Implement necessary formulas and calculations to make sure that the data is accurately processed - Data Analysis: - Utilize Excel functions for data analysis Skills and Experience Required: - Proficient in Excel, including strong skills in data entry and formula creation - Experience in data analysis and visualization would be a plus - Attention to detail and accuracy are crucial as the data is spread across multiple tabs This is an urge...

I'm in need of an experienced and creative architect to work on the floor plan for my new villa. Ideal Skills and Experience: - Ability to understand and translate the client's vision into a functional and aesthetically pleasing floor plan. - Strong communication skills and willingness to make revisions as necessary to meet the client's needs. Floor Plan for Home Villa I need Floor Plan design for 2.5 story Villa including elevations, sections, windows and doors schedules Lot area is 520 SQM with required 270-280 SQM foot print North is 26 LM East is 20 LM South is 26 LM West is 20 LM Set Back from north is Minimum 4 LM Set back from east is Minimum 3 LM Set back from west and south is 2 LM GF requirements Mens’ Setting area 5.5 x 7 M ex...

I'd like to replace a friend's face in a certain picture with another person's face, while keeping the final image as realistic as possible. Key task details: - Swap faces from two different photos - Ensure the final image is as true-to-life as possible - Maintain the overall harmony in terms of lighting and angles after the swap Prior experience in detailed photo editing and manipulation is required for this project as the change needs to be seamless for realistic aesthetics. I'm particularly keen on seeing past work where you've successfully handled similar tasks. Show me that you understand the finer nuances of making facial swaps appear utterly genuine!

Hi there! I'm seeking an expert in Python and VBA who can develop a real-time data statistical analysis tool for use on Windows. The tool must be able to process financial data. Though the format of my data wasn't specified, please be ready to handle a diverse range of formats, including but not limited to CSV files, SQL databases, and Excel files. Skills and Experience: - Mastery of Python and VBA - Experience with statistical data analysis - Familiarity with financial data - Proficiency in handling diverse data formats. - Skill in working on Windows OS. Ultimately, I require a reliable system for my ongoing financial data analysis needs. Your track record of similar successful tasks will be a plus.

I'm seeking an expert in Python and VBA who can develop a real-time data statistical analysis tool for use on Windows. The tool must be able to process financial data. Though the format of my data wasn't specified, please be ready to handle a diverse range of formats, including but not limited to CSV files, SQL databases, and Excel files. Skills and Experience: - Mastery of Python and VBA - Experience with statistical data analysis - Familiarity with financial data - Proficiency in handling diverse data formats. - Skill in working on Windows OS. Ultimately, I require a reliable system for my ongoing financial data analysis needs. Your track record of similar successful tasks will be a plus.

I am looking for someone who knows how to do theme customisation on Shopify. I want that when a customer clicks on the Buy Now button of my Shopify store, that customer is taken to the checkout page of another Shopify store. My budget is ₹1000 for this task.

...a dedicated server. Experience with dedicated servers is crucial. - Identify Specific Requirements: I'm unsure of any dependencies or specific requirements the application might have, so the ideal candidate will need to assess this and make necessary recommendations. Ideal Skills & Experience: - Proficiency in ASP.NET 3.5: Extensive experience with ASP.NET 3.5 and above is essential. - Server Migration: Proven track record of smoothly migrating applications from one server to another. - Dedicated Server Management: Understanding of managing applications on dedicated servers. - Problem-Solving Skills: Ability to identify and resolve any specific requirements or dependencies. Please provide an overview of your relevant experience with ASP.NET migrations and manag...

I'm in need of a structural engineer or a person with a relevant background in load-bearing support. The project involves the use of I beam sections, particularly an ISMB-300 beam acting as a column and another ISMB-300 beam acting as a beam. Specific Details: - The ISMB-300 beam will connect to the web of an ISMB-500 column. - The ISMB-300 beam will connect to the flange of the ISMB-500 column. - The connection will be executed by 3 - 20mm diameter bolts. - The I beam sections will be put to use in an industrial environment. - The load anticipated for these I beam sections is a medium load, ranging from 5 to 15 tons. Ideal candidates for this project should have a strong understanding of load-bearing support structures, and experience in designi...

I'm in search of an expert in MS Excel to help me with an advanced task involving formula creation. This project requires knowledge of macros and pivot tables. Your primary responsibilities will include: - Developing and implementing complex formulas in Excel - Ensuring the data is correct and displayed properly - Creating macros and pivot tables - Providing any insights that can help improve the overall process The ideal candidate should have: - Proven experience in advanced Excel tasks - In-depth understanding of macros and pivot tables - Ability to communicate effectively and provide clear progress updates - Attention to detail and accuracy in data analysis and formula creation

Hi Ahmed! I have another art creation I'm hoping you'll be interested in doing. Same as always it will need to be all black with a transparent background, high-resolution and 5 inches in height. Let me know if you need more information. - Fida Arnous

I want someone who can create a database in Excel/Access for Invoices Log (tracking for already processed invoices) with the following features. 1- A list of all invoices (Master List) with the field names I will provide. 2- A list of all Contracts with the field names I will provide. 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. The database should have a main page, with link to the above mentioned list pages plus Add Invoice, Search Invoice, Search Approver, Search Contract, Search PO, Search Account and Reports pages. For Add New Invoice page, I should be able to add an invoice details in it, and if it's related to a contract or purchase or...

In this project, I'm looking for a talented photographer or digital artist who can expertly alter a family photograph. The goal is to morph the appearance of 'Pa' in a particular photo where he wasn’t looking his best, and replace it with his image from another photo. The tasks include: - Maintaining the authenticity of the original photo - Changing 'Pa's face and body input from another photo while retaining the natural look - The great grandson on 'Pa’s lap must remain unaffected by this alteration It’s crucial that you have extensive experience in: - Digital morphing and - Photo retouching With these skills, you'll be able to achieve the desired result. Understanding and sensitivity to famil...

I am in need of an experienced video editor to help me replace a face in 4-6 scenes of my video with another face. The ideal candidate will have a good eye for detail and the ability to make the replacement look as natural as possible. Key Requirements: - Replace face in 4-6 scenes - Make sure the replacement looks natural - Deliver high-quality video editing work Skills & Experience: - Proven experience in advanced video editing - Familiarity with face replacement techniques - Ability to seamlessly integrate new face into scenes - Strong attention to detail Please provide examples of similar work you've done in the past. I'm looking to hire someone who can deliver high-quality work within a reasonable timeframe.

I’m in need of an experienced Excel software engineer who specializes in automation. The project revolves around automating data entry tasks in Excel. We are an accounting firm and I am looking to automate my compliance practices. Tasks include 1) rolling forward previous year excel work papers 2) taking information from. Client data sheets (excel) and importing into new excel workpaper workbook 3) data analytics based on metrics 4) hyperlink to source data Ideal candidates should have: - Proven experience with Excel macro programming and automation - Ability to work with numeric and legal data - Strong attention to detail to ensure data accuracy This will be a valuable addition to our workflow. Looking forw...