Excel vba lookup value in another workbook jobs

I am engrossed in studying a company's customer, product, and trucks data for my PhD research. Contemporary businesses encounter a significant challenge wherein their delivery trucks often travel from one region to another with insufficient loads (Half of the trucks are empty), resulting in inefficient use of resources. My research aims to minimize the number of empty or partially filled trucks traveling to those areas, particularly in the last-mile delivery process. Below is a list of stores. I kindly request you to extract the dataset from one of the listed companies. The list of stores is prioritized in order. 1- IKEA (IKEA store that located in Saudi Arabia) 2- Home Centre 3- Home Box

...generating data visualizations. The selected expert will be expected to work with data from both Excel spreadsheets and SQL databases, so experience with these sources is crucial. I will be looking for an advanced level of expertise, as the job will involve complex data modeling and designing sophisticated, interactive visual reports. A strong understanding of data analysis and visualization techniques is essential. Key responsibilities and qualifications include: - Creating interactive dashboards - Generating data visualizations - Working with data from Excel spreadsheets and SQL databases - Demonstrable advanced level of Power BI experience - Advanced knowledge of data modeling - Proficient in designing sophisticated, interactive visual reports - Strong underst...

Who we are Lezzat is an Amazon marketing agency based in Reading, UK and Athens, Greece. We are bunch of Amazon sellers ourselves that got frustrated with the process of selling on Amazon, decided to provide our services so others will not face the same problems. Our team constitutes of marketing specialists, designers, photographers & consultants that are here to alleviate the complexities of selling on Amazon. Some of the world’s most popular consumer brands and innovative start-ups are our clients. About the role We are looking for a focused, driven Amazon Account Manager. The ideal candidate stays on top of Amazon’s marketing trends, has experience with Amazon listings (including flat file expertise), product research and Amazon software tools. You will be requi...

I have a 1-page Excel spreadsheet with 9 text columns that need to be merged. I'm looking for someone who can start this job immediately and has experience in Excel data manipulation and formatting. Please only bid if you can do this job immediately and I will award and give you the file.

Hi, Um getting an error at my website: Warning: Creating default object from empty value in /home/chezluis/public_html/wp-content/plugins/canteen-essential/inc/framework/ReduxCore/inc/ Need desapear this from homepage...

I'm looking for a freelancer who can create an elegant company card for me. I've a company logo that needs to be incorporated into the design. This is a straightforward project, but I do value attention to detail, creativity and of course, the ability to create a design that's elegant. Ideal skills and experience for the job: - Proficient in graphic design and print design - Prior experience in creating business cards - Strong sense of aesthetics and attention to detail. Name UK Phone Number Other Phone Number Email Address Company Website UK Address Other Address

I'm seeking an expert in Excel analytics. This project involves working with existing but undisclosed business data to help me understand and optimize the business's performance through indicators like KPIs. The freelancer's task encompasses: - The creation of robust dashboards that effectively communicate KPI outcomes. - The execution of classification analysis to differentiate key data points. - Clustering the data into discernable patterns to aid business decision making. Ideal skills for this job include Excel proficiency, data analytics experience, and an understanding of key business metrics such as KPIs, dashboards, classification, and clustering. A background in business data analysis and the ability to assign meaning to raw data is desi...

Hello Christian, Thank you for discussing the interior design project for your living room. Considering the floor plans, photos, and moldboard design you've shared, I propose delivering approximately 8 realistic rendering images within 7-10 days for 700 EUR. The payment will be divided into two milestones: one for the preview and another for the final rendering images. Best regards, Mohsen

I'm in the process of designing an e-commerce website in Figma and I'm seeking a frontend developer who can transform this design into a fully functional and responsive website. Key Functionalities: - Shopping Cart: A seamless and user-friendly shopping cart integration is crucial for this project. The cart should allow for addition of items, editing of quantities, and a smooth checkout experience. - User Registration and Login: The website should have a user registration and login system. This will help in personalizing user experiences, managing orders, and providing security to customers. - Product Search and Filter: A crucial feature for an e-commerce site. It should enable customers to easily find products they are interested in, through categori...

I'm looking for a talented logo designer w...Requirements: - The Name R.T.J. should be inserted on the grill - The word TRANSPORT should be put on the front bumper bar, both carved in one example and straighter cross in another example. - the logo should convey an icon of the front of a truck (see attachment) with the name inside sections. - The logo should be created with some blues, some gold font colours - the logo should be given to me in a few different colour samples I'm on a tight deadline for this project and need it to be completed as soon as possible. Ideal Skills and Experience: - Proven experience in logo design, especially for brands - Understanding of the psychology behind color choices in branding - Ability to deliver h...

I'm in need of a professional who is highly skilled in Excel for a project involving 4-color conditional formatting. The project will focus predominantly on numerical data. Here are the essentials: - Proficiency in Excel is crucial - Deep understanding of 4 color conditional formatting, specifically with numerical data - Experience with setting color-coding based on specific values I'm looking for an expert who can swiftly and accurately apply this formatting to a substantial amount of data. Thanks for considering bidding on this project.

...thrive in a fast-paced environment where your success is directly tied to your effort? Are you passionate about connecting businesses with the power of a stellar website? If so, we want YOU on our team! We're a High Converting Website Design Agency looking for a driven, commission-only sales superstar to join our ranks. In this role, you'll be responsible for: Prospecting and Cold Calling: You'll identify potential clients who need a website refresh or a brand new online presence. Be prepared to make a positive first impression and build rapport over the phone. Understanding Client Needs: You'll have a knack for uncovering a client's vision and translating that into actionable website goals. Selling Solutions: You'll present our web design p...

I HAVE A WORD DOCUMENT THAT FEEDS VIA AN EXCEL SHEET VIA A COMPLEX VBA .. I need the following to addede: Split of Clients for Buys, Sells, Buy/Sell Spreads, Brokerage, Management Costs Currently, the Excel only allows the input of trades for one client, however, we’d like to have this broken up to at least 3 clients (I remarked client and partner in the meeting, however, we have some clients who have an account each, plus a joint-account).

...FOR NOW ALSO WORK WEEKENDS AS WE HAVE SEVERAL EMERGENCIES TO FINISH URGENTLY. We will start with 5-10 small task in and then go to some smaller .NET tasks all with 1 day sprints for you to become familiar with the software and then our main goal will be to integrate another B2B API for our MVNO. Initially we need part of the hours to be worked in the first weeks from 8:00PM- 2:00am UTC -3 (Brazil Time) later you can work on your time zone. If you are awarded the task we expect you to accept IMMEDIATELY and if the project is not accepted immediatly we will award it to another developer. To qualify you must be full stack and work PROFICIENTLY with gitlab and code in ., .NET ASP, WEB API + MS SQL. We also have woocommerce and have developed and wi...

I'm looking to enhance two key areas of my website and I need your expertise. - Supplier Product Upload and Search Functionality: Firstly, I would like...suppliers can upload products (one product with different supplier prices by different suppliers), and how it is displayed to customers. - MLS Feed Integration: Secondly, I'm looking to connect my website to receive an MLS feed from another website. This would require you to setup the connection and ensure the data is accurately synced. Ideal Skills: - Proficiency in web development with a focus on ecommerce features - Experience with implementing search functionality improvements - Knowledge of MLS feed integration would be a bonus. - Laravel If you're confident in your ability to deliver on thes...

...design should bring to life my brand’s unique identity and vision. Here are some key points about the project: The business is in Alice Springs so logo with outback and aboriginal feeling Please see the attached file for one logo i really like - Purpose: The logo should encapsulate our brand identity and visually enhance our website. In addition to the website, the logo may be used for different functionalities, which underscores the need for a versatile and scalable design. - Skills and Experience: Prior experience in logo design is essential. Please include examples of your past work in your application to demonstrate your competence and creativity. Experience in creating logos for websites and multiple platforms would be desirable. - Co...

I find myself in need of a skilled freelancer to restore my suspended Google Business account. My account was suspended due to exceeding the storage limit, and I have been unable to fix this issue myself. The professional perfect for this job should excel in: - Google Business account restoration - Dealing with suspension issues, specifically exceeding storage limit - Providing tips and guidelines on how to avoid future suspensions due to storage issues The task includes confirming the suspension reason, working towards resolving it, and ensuring resumption of the account. Knowledge on dealing with Google's support system would be highly advantageous. Looking forward to working with you.

Build an AI based tool that has auto voice dubbing and auto voice separation for my videos and Auto dubbing for over foreign 80 languages with close captioning text and an AI-based tool that automatically animates, lights and composes CG characters into a live-action MP4 video scene in AI and Machine learning. Build AI based tool for auto dubbing, close captioning text, Create Professional custom 3D Character animates, lights, and composes CG Robot and Alien and creates custom Voices for the video 3D Robot & Alien characters. You will need to help me create any needed AI access and License accounts. I am seeking a proficient developer to create an AI-based tool that automatically animates, lights and composes CG characters into a live-action scene using AI and Machine ...

I need a freelancer to help me type text from digital files to an Excel spreadsheet. - The data you will be typing is textual in nature, with the content coming from digital files. The final output should be an organized and error-free Excel spreadsheet. - Attention to detail is crucial. The ideal candidate for this job will have experience with data entry, exceptional typing speed and accuracy, and a track record of working efficiently with digital text and Excel. Please be sure to include any relevant experience and your estimated timeframe for completing this task.

I'm looking for proficient writers who can deliver 6-10 articles revolving around technology, health, fitness, and news. Each article should be between 500-800 words. Ideal candidates should have: I need human written articles, if any one going to use AI to fool me, please dont apply...its only for serious writers. No spinning also. I have less budget, i can pay 300 Rupees for a 1000...technology, health, fitness, and news. Each article should be between 500-800 words. Ideal candidates should have: I need human written articles, if any one going to use AI to fool me, please dont apply...its only for serious writers. No spinning also. I have less budget, i can pay 300 Rupees for a 1000 word well written article Let's collaborate to create content that educates, influences, an...

...registration, excel upload, and assigning packages. Key Requirements: - Develop a user registration system: The module should collect the following user information: Name, Email address, Phone number, password, course, batch. - Implement an excel upload feature: Users should be able to upload excel files select of course and batch - Enable package assignment: The module should allow for the assignment of packages to users. while user registration or excel upload Ideal Skills and Experience: - Proficient in PHP: As the app is built on this platform, a strong expertise in PHP is essential. - Experience in user registration systems: The successful candidate should have experience in creating user registration modules. - Excel...

I'm in need of a Unity game developer to help me create a mobile game that focuses on asynchronous multiplayer gameplay. Key Points: - The game will need to be developed using Unity and Photon Unity Networking (PUN) to facilitate the asynchronous multiplayer experience. - The gameplay should be optimized for mobile devices, ensuring a smooth and enjoyable experience for players. - The focus of the game will be on asynchronous multiplayer, meaning that players will be able to engage with one another without being required to be online simultaneously. This will require robust synchronization mechanisms and a well-thought-out game design. Ideal Skillset: - Proficiency in Unity and PUN is a must for this project. - Strong experience in mobile game development...

I have bank statements from Bank A that I need converted into an Excel spreadsheet. The specific transactions you'll be dealing with are both deposits and withdrawals. Here's what I need: - A thorough and meticulous translation of each individual transaction: both deposits and withdrawals. - Once this data is entered into the spreadsheet, I need you to sort it by transaction type. This role requires expertise in Excel and a keen eye for detail is essential, as the integrity of the data will be paramount. Knowledge about financial transactions, specifically deposits and withdrawals, will be useful. A background in bookkeeping or accounting will also be a plus.

I'm in need of an experienced audio technician, preferably with a background in voice manipulation and sound editing. As per the requirements of my project, I'm attempting to alter my voice recording to emulate that of another person, whom I have vocal samples from. Qualifying candidates should be adept at manipulating aspects such as pitch, tone, and accent to make my voice a convincing replica of the target voice. Key skills and experience: - Proficiency in sound editing - Prior experience with voice alteration tasks Please include the following information in your application: - Examples of past work, preferably including voice alteration projects. Despite the technical requirements being unspecified, proficient knowledge and use of approp...

I'm seeking an experienced developer to create an online script that can automate the conversion of CSV files. Script must be browser based and linux based. No preference on programming language. Source file will need to be uploaded to CSV converter, and script will sort data and rename columns based of pre-existing requirements. Once conversion is finished, download link generated to download updated CSV.

I'm seeking a seasoned Excel VBA developer to create a script that will regularly manipulate data within my Excel sheets. I have vba code run each 5 hours to export my excel sheets as pdf photos, but the problem here is my pdf photo sometimes not shown correctly, and sometimes its shows correctly. here is my vba code: For i = 1 To 57 '54 ' = False sheetxx(i).Select (Now + TimeValue("0:00:05")) ' "({1068})", True 'DoEvents pdffilename = fname2 & "" & sheetxx(i).Name & ".pdf" jpegfilename = fname2 & "" & sheetxx(i).Name & ".jpg" Shell ("D:khalid savescreenshot " & jpegfilename) ' (Now + ...

I need assistance with a simple Excel data entry task. This job purely consists of data entry and doesn't require any form of data analysis. The data I need entered includes names and addresses. Ideal Skills: - Proficiency in Excel - Attention to detail - Experience with data entry

I need a professional with excellent data entry skills to assist in cleaning and refining my existing data sets. The data is currently in Excel format, and I want it to be more organized and polished. Skills and Experience: - Proven data entry skills - Proficiency in Excel - Experience with data cleaning and refinement - Attention to detail Tasks to be completed: - Review the current data sets - Remove any inaccuracies or errors - Reorganize the data if needed - Ensure all data follows a consistent format The ideal candidate is someone with a keen eye for detail and the ability to handle large amounts of data efficiently. I expect prompt delivery and utmost accuracy in the task. If that's you, place your bid now!

I need a Python script that will help automate various tasks. Key tasks for this automation include: - File Management: the script should enable the organized handling of Word documents and Excel spreadsheets. - Data Entry: automation for data entry tasks. - Email Sending: automation for sending emails. The ideal candidate for this job should have: - Strong experience with Python scripting and automation. - Understanding of file management concepts and libraries in Python. - Ability to implement automated data entry and email sending functionalities. Looking forward to finding a professional who can deliver efficient, clean code for this project.

I'm in need of an experienced Siemens PLC programmer to work on a project involving a S7-1500 model. The goal is to program various tasks related to servo systems. We have two servos linked with each other and have to move relative to one another. We have a 3d model of the assembly and should be simulated before delploying Key Requirements: - Expertise in Siemens PLC programming, specifically with the S7-1500 model. - Proficiency in programming servo tasks such as motion control, positioning, and synchronization. - Ability to work with existing hardware and servo motors setup. You should be able to understand and execute tasks related to motion control, positioning, and synchronization. Your experience with servo programming will be important, as the pr...

$50 MAX On Submit ... for an Elementor form, I need the label and value to be emailed on Submit. Currently it only sends the prices.

I'm looking for a proficient web developer with social media management skills to assist in promoting my brand online. The ideal candidate should have a strong understanding of Facebook, Instagram, Twitter, TikTok, and YouTube, and be able to create and share a variety of content on these platforms. Key Responsibilities: - Manage and maintain a consistent presence on Facebook, Instagram, Twitter, TikTok, and YouTube - Create and curate content to be posted across these platforms - Use social media to generate leads The posted content should be a mix of: - Educational: Informative posts that will engage our audience and provide value to them - Promotional: Posts that promote our brand and drive traffic to our website - Entertaining: Engaging content to keep our audienc...

Hi Roman, If you remember, last year you did a project for me to show the list of participants of an event to me. I want to improve on that code and add some functionality and features to it. W...show the list of participants of an event to me. I want to improve on that code and add some functionality and features to it. Would you be available? We can chat about the details, but basically, this is what I want: I have an Excel file with different sheets. For example, Founders, Advisors, Announcements, and Media. I want a code similar to the previous code (of course, more complicated) to read this Excel file and show the content of each sheet in a different format (as the amount of type of information is different). I will share an example of the Excel fil...

I have an extention that was working on Google Chrome and suddenly stopped working, most likely due to a Google Chrome update. It is programmed in JavaScript. Please help me fix and develop it, or create another extension similar to it in characteristics and features. Here is the link to download the extension: I will send you a link to download the extension so you can download it, try it, and let me know if it is fixed. Thank you

I'm looking for a detailed guide on how to get tweets using the RTweet library in R. Key points include: - Explaining the setup process of the Twitter Developer Account since I'm facing issues with access - A detailed, step-by-step guide on how to leverage the RTweet library for tweet lookup and analysis - Troubleshooting guidance for known issues Ideal skills: - Proficient in R programming language - Strong understanding of the RTweet library - Experience with Twitter Developer account setup - Ability to explain complex concepts in a simple manner - Troubleshooting experience with the Twitter API

As we're working with Salesforce Enterprise edition, I'm in need of a seasoned Salesforce developer who can step in and assist with various aspects of my current project. This project involves a high level of complexity, including advanced customisations and integrations with other systems. Key Tasks: - Customisation of objects and fields: This will require a deep understanding of how our organisation operates and what data is critical to our processes. You will need to not only create custom objects and fields, but also ensure they are integrated seamlessly into our existing Salesforce platform. - Workflow automation: Our goal is to streamline as many of our business processes as possible. Your role will be to identify areas that can be automated and implement th...

I'm seeking a talented developer with a solid understanding of Excel VBA and Python to develop a system that generates and runs Python code via a manual button within Excel. The Python code generated should have the capability to work with financial data specifically. Linguistic proficiency in Excel VBA and Python is required; knowledge in XLwings or a similar tool would be a significant advantage.

Development a human anatomy VR application for oculus platform. When player in the app, they can choose a male or female anatomy. Then, choose the system function. Subsequently, anatomy of the system function will appear. Then player can click expand to isolate the parts with info panel to show name of organ. Then, player can close and choose other system or choose to see system of another gender. Arabic text of organ name and system name is to be provided prior or during development. Final delivery in apk.

The website is designed primarily to serve as an informative platform about our services and broadcasting experience in the Free To Air sector. Information that needs to be conveyed on the website: 1. Detailed overview of the services we offer, outlining how we excel in the market. 2. Showcase our extensive experience in the field, driving confidence in our capabilities. The site will be mainly aimed towards potential clients and Free To Air broadcasters who are looking for reliable broadcast service providers. Ideal freelancers for this job should have proficiency in web design with experience developing informational websites for service-based businesses. Understanding of the broadcasting or related sector would be an advantageous, but not ...

I need a skilled Wordpress expert to address a migration issue I'm facing with ...server running PHP 7.2.4 where the site worked to a server running PHP 8.2. The front end of the site works but now access to the back end gives the error "There has been a critical error on this website. Learn more about troubleshooting WordPress." I need someone to correct the code so that it works correctly. I believe that the issue may be connected to WPBakery To excel in this project, you should be highly experienced in Wordpress, with a deep understanding of PHP, theme and plugin compatibility issues. Your ability to troubleshoot and resolve migration issues will be crucial. I'm looking for a professional who can efficiently tackle this issue and ensure a...

I'm seeking a skilled and versatile bookkeeper to manage my accounts in QuickBooks. Key Responsibilities Include: - Daily entry of transactions - Financial statement preparation - Tax planning and filing Ideal Qualifications: - Proficiency in QuickBooks - Experience in managing both accounts payable and receivable - Strong understanding of tax planning - Excellent attention to detail - Previous experience working with a diverse range of transactions I value clear communication and a proactive approach to managing my finances. The role may be expanded in the future if the right candidate demonstrates a keen eye for financial strategy.

I'm in need of a skilled Unity developer who can bring to life a 3D visualization of moving points. The purpose of this visualization is educational, aimed at explaining the concept of trajectory. Key requirements: - The visualization will involve moving points in 3D, following a trajectory that's dictated by data in an Excel file. - The movement of these points should be adjustable by the user in terms of speed. The ideal freelancer for this job would have: - Proficiency in Unity, with a strong background in 3D animations. - Experience in creating educational visualizations. - The ability to integrate data from an Excel file into the Unity project. Please note that while the visualization is primarily educationa...

Job Title: Business and Marketing Assistant Type: Part-Time, Remote Hours: 10 hours/week (2 hrs a day / 5 days a week) Salary: £400/month (with potential for growth) About Us: We are a wedding photography start-up based in London, England. We are aiming to revolutionise the wedding industry and expand into other areas like architecture and interior photography. We value creativity, innovation, and quality. Role: We need an organised, creative, and knowledgeable person to help us grow. You'll work on marketing, operations, and other tasks, helping us implement and test new ideas. Your role will grow as our business does. Responsibilities: Develop and execute marketing strategies. Manage daily operations. Contribute ideas and feedback. Implement and test new...

I'm seeking a skilled professional who can help create attention-grabbing LinkedIn messages tailored for investors. The core objective is to pitch my business effectively. The messages must strongly communicate my company's value proposition. Ideal freelancer for this task should have: - Experience in crafting e-pitches, particularly on LinkedIn. - Deep understanding of investor language and interests. - Ability to create concise, engaging content. - Proven success in similar projects. In your proposal, please provide examples of previous work specifically related to investor-targeted LinkedIn messaging.

We are a market research survey firm and looking to conduct a study focusing on customer preferences and feedback for MoneyGram money service provider. Ideal Candidate: - Have you used or would you consider using a service to transfer money to another person. - Familiarity with the remittance service providers of MoneyGram, Wise, Revolt etc

I'm in need of a robust AI system to create professional headshots, ideally suited for business profiles. - The essential function is generating high-quality JPEG images suitable for a diverse range of business profiles. - Another vital feature is the ability to customize the backgrounds extensively. The AI system should offer multiple selectable backgrounds to cater to a wide variety of preferences. - Ideal developer skills would include prior experience with AI image-based projects and understanding advanced graphic designs. This project presents a great opportunity for anyone who excels in AI imaging and aims to help businesses create unique personal branding.

I'm looking for a sophisticated freelancer who can generate educational marketing contents for my TikTok, Youtube Shorts, and Instagram Reels audience. The main topic is center...resonate with our brand's voice and style - Create 2 reels/shorts per day on various platforms - Increase Views, Subscribers, Likes, Comments - Increase Followers & Influencers -Understand demographics we are targeting Ideal Skills: - Proficiency in TikTok, YouTube Shorts, and Instagram Reels content creation - Prior experience in developing engaging & viral video content - Ability to present educational information in an appealing, marketing style - Understanding of content optimization and best practices for each platform I'll highly value a proof of conc...

...corresponding business card. The company is called IMBERA. The company offers services in client advisory for building owners, interim management, consulting, project management, and budgeting. The logo should appear professional, as my clients will be municipal administrations, cantonal administrations, and foundations. It should have recognition value like my abbreviation (see attached image), but it doesn't have to. I am a civil engineer and prefer a clean structure. This should also be reflected in the logo. Looking forward to your ideas! Gerne möchte ich ein Logo für meine Firma erstellen lassen. Auch entsprechend eine Visitenkarte. Die Firma heisst IMBERA. Die Firma bietet Dienstleistungen in Bauherrenberatung, Springereinsätze,...

the workbook consists of the below sections: - Section 1 - Vocational Education & Training - Section 2 - Core & Employability Skills - Section 3 - Learning Design - Section 4 - Learning Delivery - Section 5 - Assessment - Section 6 - Administration - Section 7 - Work Health & Safety each section contains between 15 to 26 questions, i will provide martial to help with finding the answers. the workbook is a training and assessment work book