I have a project with Excel vba vlookup that needs modified. The tables are large and the vlookup is very slow. When I read documentation, the suggestion is to use a double vlookup, which I am not able to get the syntax right,. This is the line that is working, but slow: LookupResult = [login to view URL](LookupValue, LookupRange
Hello there I have this project for today til 4 am gmt+2 (that is in 2 hours) and budget $15USD and words count 300. We ..."The Carlyle Group" distributed private equity funds in 2017-2018 in other companies/groups for containers in maritime. If not on containers then in maritime generally. Write specific names and amounts of funds. Happy biding :)
Hi! I need a Delphi Project (Any version. Most recent better) with a form in which I can type a text like "19 CRIMES" and then shows an image of that specific text (THE WINE BOTTLE) using any seach engine (best if google).
I would like to hire an Excel Expert to correct a faulty Excel VBA Sub. I want to 1) Transpose a column to a row, 2) Multiply that row times a conforming matrix, and 3)Transpose the result to a column. Attached is an Excel spreadsheet with some data and some defined ranges. It contains a macro triggered by the only button on the spreadsheet. There are
The idea is creating a list of companies and the primary key is the registration number with the ability to amend the list or create a new list. and then to import excel files contain a large list of companies and in case one of the companies were inputted in the before it showed show as red flag. (More like a vlookup table) So, we will have two interfaces
Test API using a document that has input and outputs Short term project for only a few hours..will send soap and API documentation and will need to provide me guidance and training.
I need several pieces designed to be 3D printed. An in-depth knowledge of CAD is needed. I am looking for someone to work with long term because I will need many pieces designed. Additionally, someone who has access to Skype is preferred due to the complexity of trying to explain some of these parts components over message. I just need the files not the actual 3D print.
to implement a software system that will perform the same basic operations of GitLab, plus more functions that you believe will bring great benefits to users. Gui must be very nice.
Here is everything you need to understand in the video: [login to view URL] Please see attachment which contains all the files you'll need to get started Here is a link to access all the files: [login to view URL] Let me know if you have questions, Thanks, Jai
I need some changes to an existing website. Specific payments methods for specific shipping methods
I need a versitile marketing team of people with experience and dedication to delivering results. Preffered Skills: Facebook Advertising Instagram Advertising Influencer Marketing
The programmer has to create an action hook. For the Wp User Frontend Plugin. [login to view URL] When a user chooses the taxonomy series only one user can choose the term Robin Hood other users can not choose Robin Hood. The action hook has to take the id of the user and put in termmeta. It has to be in termmeta to
Urgent - VBA Mac Not Windows - I need a VBA macro to run on MAC to search a folder and all its subfolders for a combination of files like excel and word files and copy all files found to a new folder. Your code MUST run on MAC.
Hello i have this theme [login to view URL] and i want to make some edits because the ads in my website loads delayed. 1. Define all JS & Jquery usages in this theme. 2. Remove un-nessary JS and jquery. [login to view URL] lazy loading for js and any delayed code makes js load defered. [login to view URL] theme font ( cairo ). 5. Every (H2) have to be #1e73be. every H2 Have background #f9f9f9...
Verilog simulation of two action-reaction processes
I need a list of however many you can find but they need to follow these guidelines: - USA Supplier OR have really quick shipping in the same amount of time it would take to ship from USA - Pricing needs to be good, I need to make a good profit back I want to find suppliers for these specifics: * General Electronics - powerbanks, tablets, laptops, mp3 players, headphones,etc. *jewelry - Murano ...
...data from PDF into excel and then format the extracted data. I want a tool that I can use to convert data from downloaded PDF files into excel format. These are race form guides and need the tool to extract data for each runner and arrange that data as per sample excel sheet. The extracted data should all be in single excel sheet, with data in
I need a programmer. I had an excel file of renters for a residential & commercial building. I prepare this file monthly. It consists from columns with Flat numbers, it’s kind (residential or commercial), renter name and rent And the era paid for rent at its time it is in Hijri calendar from...to... You can get and update all information from last month
I have a bunch of differential equations and parameters which describes the cardiac action potential. I need a standalone program with user-friendly GUI. The user will enter the parameters (ion concentrations etc.) on the GUI and click start. The program will start to calculate the differential equations and plot the results dynamically. I prefer Java
I have just created a Shopify store and I am looking for social media marketing teams or experts that can promote my store on multiple media platforms. Specific/ Niche targeting is required
We sell police equipment on our website. We would like to add the ability to make a personalized website experience for customers from each police department. It should work like this - each police department will have a unique URL that goes to a page on our website (landing page?) and then each officer will have a login (created by us when we are told by the department the name of each office...
I'm looking for someone who can create VBA Word 2016 templates for a law firm, based on our needs as they come about. We have current small access db, that some of our templates pull from, that can be used when needed.
Primary responsibilities will be: · Creating/managing rotating web banners · Optimizing for mobile display · Optimizing site for load time (decreasing load-time) Tertiary responsibilities will be: · Optimize pages for SEO · Optimize pages for User Experience · Google Analytics tracking Requirements: Strong grammar and communication skills Interest...
I have a list of roughly 5,000 gas stations and billboards. I need them plotted on a map (I've already done this), and then to determine how many of the gas stations and billboards are on these two US coast-to-coast driving routes. The Oregon Trail (Historic US-20) [login to view URL] The Loneliest Road (Historic US-50) [login to view URL] The gas stations should either right on the road o...
See [login to view URL]
Hi, I need access to all tweets in each separate location made between August 2017-2018 that has one specific keyword. I basically need the ability to create a list (dates and specific tweet content) which I can than random sample x amount of tweets to analyze for research. Locations: Bangladesh, US, UK, Myanmar
I'm using a PC with MS Word Mailings/Mail merge. Microsoft Office 365; Version 1811 (Build 11029.20079 Cilck-to-Run); MS Word for Office 365 (16.0.11029.20045) 32-bit I've already completed the Xcel spreadsheet with all my names/addresses for the 240 Christmas cards I want to mail at the post office Monday, December 10th. I have all the names in one column, the street addresses in the ...
##Advanced VBA skills and high experience automating excel will be needed to understand the code written so far, debug and complete the work according to spec## A VBA programmer has done most of the work according to the attached Statement of Work, however due to personal issues he has not been available in weeks to complete the work. This has been
Webcam Chats need an additional function added. There ARE images of pretty women on this site ! If YOU are offended by pretty woman, don't apply, seek help instead... Need somebody fluent in Flash AS2.0 and PHP. Need a function added to current audio/video chat. Auto responses and ridiculous quotes will be ignored. Payment when work is complete.
Excel Macro VBA - assistance with VLookup in VBA Hello The purpose of the macro is to process each row, and when there is a certain condition, correct the entry in the cell. I am using (attempting to use) VLookup to access the values in the 2nd sheet and correct the values in the first sheet of the workbook. Receiving the following error when running
...currently in need of an article contributor that can create and post articles on multiple different business sites such as Forbes, Wall St Journal, New York Times, Mashable, [login to view URL], LA Times and you can also use an article I wrote about our public figure which is actually an interview, or you can build off of that interview to gather more data
build a macro which will copy data from one excel workbook to another. for each row in one excel file the macro should create two lines in the other excel workbook. in the column A of the new file CA should be written in the first line and SL in the second one. also in column E should be filled with text "y" as many as rows