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
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
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 want to build a website with the application android et iOS, where people can have an access to the nearest doctors in the Area or other areas/cities), with their profiles (Name, contact, address, map ..) a website that looks like this one: [login to view URL]
This is a new and innovative way for Dealers to get leads and sell more vehicles. No more generic leads sent over and over to all Dealers in the area. All leads will be high quality leads later in the buying process and ready to visit Dealers and buy.
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.
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
...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 or Python for this job, but it needs to be easy to modify and self-explained. - Differential equation solving (I will provide the equations.) - Dynamic graph
Need an individual who has strong skills in Adobe InDesign. Our organization has some proposals that need some edit work done as the original proposal was created through Adobe InDesign. We would like this individual to come in office (located in Roxbury, MA) for a few hours to tackle this task.
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.
##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
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
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
I am looking for an Excel VBA programmer. I need to develop a Warehouse Management System in Excel with the help of VBA programming. The task is to setup a Master-Data file (Excel) that should function as a database. I need you to create an excel for every team where they are able to store data in Master-Data and retreive information from the Master-File
I want someone to fix Rotating not working error on my Project. This will be 1~2 hours working. I will give you good feedback to you.
Hello, I want to streamline some tasks for my colleagues so I want them to be able to do three things using separate buttons on an Excel sheet. I can do the buttons and attach the macros but writing the macros seems to be beyond me. I need as follows: From one button: Save a template .xlm file as a new file in a specified location with the file
I am interested in having an automated calendar creator with vba code combined with multiple task calendars. Essentially someone should be able to copy multiple calendar task sheets into one excel workbook organize the columns in a standard format. The format being "Deal Name", "Task & Description", "Key Date", "Organizer", and "Commen...
I have got a VBA Macro for Ms Excel coded by a VBA Expert. I want some changes in it, need to delete something & add few new contents. It should be a simple project for an expert so lowest bids will win this project.
...you-------- -----------------PROJECT DESCRIPTION: I am interested in having an automated calendar creator with vba code combined with multiple task calendars. Essentially someone should be able to copy multiple calendar task sheets into one excel workbook organize the columns in a standard format. The format being "Deal Name", "Task & Description", "...
Advanced VBA needed in 24hrs
Hello, I have a small Excel VBA project to be completed. Data is not large but needs to just be automated to fill data to a template. Need a good knowledgeable person to help me out. I will send the files later. Need this to be done around this weekend so you need to be available then. Budget -10$. Any bids for excess value will not be considered. Thanks
Hi, if you are an expert with VBA, access and word, this project will be very easy for you. I have a * very small and basic* invoice database with client, invoice and billing tables set up and need some functionality, user interface and reporting added to it: Functionality Each "client" entry has multiple invoices and each invoice has multiple billing
Hello, you need to do. 1) Specify the characteristics of the lamp. 2) Visualization. 3) illumination Chart and map Calculation design of lamps for an area of 15.5 x32 meters. Height 8 meters DIALux!!! Thanks
The catalogue will be approximately 30 pages long. We currently have products information on product sheets. This will need some rearranging and logos applied. Will also need front and back cover designed and contents page. Need someone who has qualifications in graphic design and word etc.
We are looking for an experienced 3d designer to design a park play area. The play area design will include play equipment render, flooring render, maybe some shade render as well. Please see attached image to get an idea of the work involved.
I would like to build a tool that will allow us to better manage our user lists and service Providers. Function: I would like an excel to hold the following data: List of all teams List of all users in those teams List of all service providers contracted with those teams and the budgets Contact details at service providers Email text The above data
We habe a little Rental Management System in Excel. Now we need some VBA funktion to Create a Picking list. what is to do ? 1.) Every device has a button whit his special information in it. So we have to develop a function that will save this information. 2.) we have to put with checkbox selected devices to a picking list on a another sheet
I own a print advertising business. I am always looking for decision makers to purchase the advertisement over the phone and for me to pick the orders up or they can mail the check and e-mail me the advertising copy. Sell the space I get the check you get paid either $8.00 per. hour three days a week for four hours a day on first week and then we
I need someone in the Bangkok area (Sukhumvit) to help me with a data entry project.
I need someone in the Bangkok area (Sukhumvit) to help me with a data entry project.
I need someone to copy information from some websites. I need business name mobile number and most importantly ABN number. I'll send list of local post codes