Vlookup excel macro xls jobs

Filter

My recent searches
Filter by:
Budget
to
to
to
Skills
Languages
    Job State
    9,814 vlookup excel macro xls jobs found, pricing in CAD

    We are looking for Bookkeeper/Accountant who can use Microsoft Excel functions, Vlookup, Tables, Pivot Tables. Tasks: Monthly Accounts Reconcile Inventory List Accounts Payable Bank Account Reconcile Cash Balancing Cash flow projections

    $5 / hr (Avg Bid)
    $5 / hr Avg Bid
    34 bids
    Fix VBA macro 6 days left
    VERIFIED

    Got a VBA macro that's pulling duplicates into excel. There are no duplicates on the original website. Some problem is causing it to repeat some data. Need you to fix this behavior so that the macro only gets the data as is.

    $30 (Avg Bid)
    $30 Avg Bid
    24 bids

    [login to view URL] Please check the link above, what I want to do, is partly done above. I need a macro, that will turn this: [login to view URL] into this template:

    $32 (Avg Bid)
    $32 Avg Bid
    4 bids

    [login to view URL] Please check the link above, what I want to do, is partly done above. I need a macro, that will turn this: [login to view URL] into this template:

    $19 / hr (Avg Bid)
    $19 / hr Avg Bid
    9 bids

    ...us to import the 2 above spreadsheets from local files on a PC. Sheet 1 has data on several tabs (could be 50 or more) this all needs to be consolidated on to one sheet. A VLOOKUP will be required to add 4 columns of data from Sheet 2 onto the relevant record in sheet 1. This will give us a full data set for the day. Stage 2: Data Manipulation Once we

    $227 (Avg Bid)
    $227 Avg Bid
    49 bids

    ...Qty on Tab 1 (the data on this tab has multiple repeating records) SKU, ,Item, Color, Size on Tab 2 (the data on this tab is a lookup table) I need a macro to run and do the following : 1. Do a vlookup to Tab 2 and populate the SKU alongside Item, Size, Color, Qty on Tab 1 2. Sum up all repeating records in a new spreadsheet by SKU # and put output

    $53 (Avg Bid)
    $53 Avg Bid
    37 bids
    Need excel help 5 days left
    VERIFIED

    Two MS workbooks. Need to use VLookup and in and capture data from one and populate in another

    $28 (Avg Bid)
    $28 Avg Bid
    44 bids

    I have some work, in an Excel spreadsheet. pivote table, vlookup, formulas good command in excel work

    $155 (Avg Bid)
    $155 Avg Bid
    29 bids
    I need an Excel Macro Expert 4 days left
    VERIFIED

    I am a telecom engineer. I need to get an Excel Macro developed for a large Excel sheet with a block of unique information consisting of 23 rows repeated 2100 times making the total number of rows to be about 48300. I need to add 3 rows of unique information to each block of 23 rows making it a total of 26 rows making the total number of rows 28x2100=54600

    $46 (Avg Bid)
    $46 Avg Bid
    23 bids

    Hi. I need someone to build an Excel VB Macro that, when run: 1. takes residential property query field data from Excel provided by the user (e.g. postcode, number of bedrooms etc) 2. runs a search in "[login to view URL]" based on that query and 3. copies the results from that web query back into the Excel sheet. For example, the query contains information

    $169 (Avg Bid)
    $169 Avg Bid
    25 bids

    1) Windows 10 pro, Excel 2016 2) User should be able to identify target folder for process to run on all excel sheets in the folder as a batch. 3) Source data is Excel sheet (no more than 4 columns, and max. 100 rows) 4) Output is csv (12 columns, and no more than 100 rows) 5) Some columns in source will be split into many columns in output

    $143 (Avg Bid)
    $143 Avg Bid
    18 bids
    Excel Macro 3 days left

    This is a small and quick piece of work. I need to insert a row into an excel table and then validate all the cells in the table when the user saves the excel workbook.

    $37 (Avg Bid)
    $37 Avg Bid
    28 bids

    Create a Macro in EXCEL: 1. Count the number of spelling mistakes in a cell eg: "The lanb is a world beest" Count = 2 2. List the all the spelling mistakes in a cell eg: "The lanb is a world beest" Mistakes= lanb,beest 3. Exclude the spelling mistakes based on the word count. eg: if we say letter count as 4 then if word "cat " is misspelled then it

    $41 (Avg Bid)
    $41 Avg Bid
    22 bids

    Looking for someone savvy with VBA (Excel) - essentially good with macros, and linking this to Word. In need of a workbook that can serve as: 1. an upload tool (for a list of questions) 2. a db sheet Q&A format, for the search tool to search for matching answers to the input questions 3. a functionality that will take the matching questions

    $259 (Avg Bid)
    $259 Avg Bid
    47 bids
    VBA excel macro 2 days left

    The original excel file has one sheet and output should have 3 additional sheets than the original: 1) extra sheet1 (just a selection of columns from original) - date filter 2) extra sheet2 (some pivots should be created in this sheet) 3) extra sheet3 (a new selection of column from original) - date filter 4) vba code should have comments and be explained

    $174 (Avg Bid)
    $174 Avg Bid
    29 bids

    I need a macro or bot created that will do the following function. 1. Login to Google voice account 2. Sent text message 3. Record any response to text message to file The macro/bot should support doing this for a list of multiple accounts pulled from a .csv file with the following fields. Google Voice Account Login, Google Voice Account Password

    $272 (Avg Bid)
    $272 Avg Bid
    11 bids

    I am looking for a small database with easy interface ( like a small app ) or excel with Macros file where i can put all my soccerplayers in. I am a Soccer Coach and i want to have a Database where i can put all playing times, assists, goals scored, exchanges and some other information in live time during the match... so it has to be a easy interface

    $217 (Avg Bid)
    $217 Avg Bid
    46 bids

    We require 3 different sets of Macro for 3 different excel files. Please contact us to further disucss

    $110 (Avg Bid)
    $110 Avg Bid
    35 bids

    Two sets of Data. Sheet1 and Sheet 2 For every 1 line on Sheet2, I need Sheet 1 copied Example: Sheet1: A B C Sheet2: 1 2 3 Sheet3: Fixed RT OT DT Output Sheet: Column 1 Column2 Column3 A 1 Fixed A 1 RT A 1 OT A 1 DT A ...

    $47 (Avg Bid)
    $47 Avg Bid
    12 bids

    I have some work, in an Excel spreadsheet. Pivot, vlookup, hlookup, concatenate, text to columns, conditional formatting, if else

    $28 (Avg Bid)
    $28 Avg Bid
    32 bids

    ...need to create an excel macro file, it is very easy and fast work. all the details are attached in the files attached include a sample excel file. i need this done very fast, preferably within next 1-2 hours if possible i am copying the list of details about macro function again, it is attached in the text file also:- the excel file details are as

    $28 (Avg Bid)
    $28 Avg Bid
    10 bids

    ...i need to create an excel macro file, it is very easy and fast work. all the details are attached in the files attached include a sample excel file. i need this done very fast, preferably within next 1-2 hours if possible i am copying the list of details about macro function again, it is attached in the text file also:- the excel file details are as

    $89 (Avg Bid)
    $89 Avg Bid
    7 bids

    Replace product_ID with different set of IDS from Sheet1

    $28 (Avg Bid)
    $28 Avg Bid
    76 bids

    I have different excel files reading from each other.. each file has statements on it... i want these statements to have have a unique identified, if the problems are the same i want them to have the same unqie identified.

    $34 (Avg Bid)
    $34 Avg Bid
    9 bids

    I have a table of data and i want 2 macros to create 2 reports. The macro will also do relevant formatting and also total all at the bottom of the report List of reports includes: (i) Report one sums by name (ii) report two sums by month.

    $24 (Avg Bid)
    $24 Avg Bid
    49 bids

    ...within next few minutes if possible i need all data in different columns of sheetA copied 43 times in sheetB, when i run the macro For example: sheet A: columnA columnB tex1 text1.1 text2 text2.1 then when i run macro, in sheetB i should get columnA columnB text1 text1.1 ... ... copied 43 times text2 text2.1 .. ... copied

    $17 (Avg Bid)
    $17 Avg Bid
    51 bids

    Hi everyone, I need a terrific instagram logo that jumps out. The name of ...I need a terrific instagram logo that jumps out. The name of the account is youevenvlookupbro but I want my logo to be as below. =vlookup(bro)? It is an instagram account all about beautiful spreadsheets in excel. I need the logo to be very bold without being obnoxious.

    $22 (Avg Bid)
    Featured
    $22 Avg Bid
    29 bids

    It would have 4 screens as screen flow with commonly used features in a typically app

    $227 (Avg Bid)
    $227 Avg Bid
    7 bids

    We need to complete an xls spreadsheet with April purchases. Each purchase is scanned in a pdf you may find enclosed to this doc. We have 69 sheets=69 line For each line you need to fill the spreadsheet with these information: A: DATE B, C, D, E: YY (year), MM (month) , DD (day); SS (serial) F: protocol = concatenation of B, C, D, E You may find this

    $31 (Avg Bid)
    $31 Avg Bid
    71 bids

    i have some [login to view URL] is very sample.i need macro excel expert [login to view URL] only macro excel expert bid me.

    $28 (Avg Bid)
    $28 Avg Bid
    10 bids

    Hello Freelancers, I want a macro or visual basic code to extract the data from PDF to Excel Automatically. I have PDF and sample. Dont get forget to mention you offer I think it is not more than an hour work. Happy bidding

    $7 / hr (Avg Bid)
    $7 / hr Avg Bid
    32 bids

    I need the script of macro to sort my spread sheet. I need something that I can use myself on a daily basis. The attached file should be sorted based on the name of the city - which is part of the string in the first column. Each city should be sorted out to a separate sheet (if possible). Please type the word "Root Beer" at the end of your proposal

    $35 (Avg Bid)
    $35 Avg Bid
    18 bids

    Excel macros play an important role to perform repetitive operations in excel. It takes lot of time, when handled manually. I have done quite good amount of work in excel macro handling. It includes, extracting information from text files, transferring info in to excel, E-commerce templates, Image handling, Shapes variation, Pivot Tables, Text to columns

    $29 / hr (Avg Bid)
    $29 / hr Avg Bid
    28 bids

    I need you to create a macro for vehicle that are changed. For example, if a customer wants to replace a white bumper with black then a parts list is generated. From that list of parts a quote is created. Basically, it's a option pricing. If you think there is better way to do it on access or any other way then please let me know. I would like to

    $582 (Avg Bid)
    $582 Avg Bid
    31 bids

    Steps: 1. get equation from column H 2. past equation in [login to view URL] 3. copy the output back into spreadsheet, in column N 4. repeat

    $24 (Avg Bid)
    $24 Avg Bid
    12 bids

    ...of data are organized. I have Excel sheets with structured data that should go into the template described above, however the format of data is different. Through smart use of VLOOKUP and matching column / row heading / names the data in the cells can be moved into the template. I need an expert in Excel / VLOOKUP that has an eye for detail to 'enter'

    $13 / hr (Avg Bid)
    NDA
    $13 / hr Avg Bid
    50 bids

    Search using Vlookup and provide the total number

    $25 (Avg Bid)
    $25 Avg Bid
    88 bids

    I have an Microsoft Word document and i want to add a dropdown list to one place on the document. It will contain 3 peoples names - Steven, Darren and Michael....If darren is selected (location A) on attached, then darrens email address needs to be placed in the footer (location B) and his photo shown on the document at location C. If michaels name is selected, his email address and photo needs to...

    $33 (Avg Bid)
    $33 Avg Bid
    14 bids

    Excel expert needed for a small job Iv added a new column to my excel file and my macro has producted an error [login to view URL] Before macro use to produce a sheet with last weeks bookings now i want to create a sheet with some of the columns hidden. Should be an easy job and my budget is 20 or max €30

    $30 (Avg Bid)
    $30 Avg Bid
    49 bids

    ...click script(click every 3 minutes) or keyboard script (Ctrl+Tab every 3 minutes) to keep a desktop active. The catch is that this will run in an office environment that has a macro blocker in place. Simply put, macros or hotkeys don't work (AHK/Jitbit/etc). The only way for it to register input is from physical keyboard keystrokes or mouse movement. I

    $146 (Avg Bid)
    $146 Avg Bid
    6 bids

    Hello there. I need help with VBA code in Outlook 2016 so that: When email from "no_reply@[login to view URL]" is received in mailbox, sub "OpenFile" is called. and msg is saved in "k:/files/" as "[login to view URL]". Date should be "year-month-day" and time" hour-min" thank you..

    $71 (Avg Bid)
    $71 Avg Bid
    3 bids

    ...doing measurings and I have many js files. I need to convert the values from .js file into xls sheet. I prupose to create webpage on any free domain (or situated on local disk) where I can upload js file and download only the extracted data (only the numbers) in xls. Every value will be in its own cell, all in one column "A". Filtred from the the lowest

    $46 (Avg Bid)
    $46 Avg Bid
    17 bids

    I am creating an excel workbook. This is for calculating the costs of table tops in an office furniture environment. I have three interdependent lookup lists. The first is the top thickness (16mm, 22mm, 32mm) from a list of thicknesses. The second is the finish range (A,B,C,D,E) from a list of ranges The third is the wood specie (this is a filtered

    $148 (Avg Bid)
    $148 Avg Bid
    22 bids

    i want check with each asin in sheet1 if any row find in sheet2 with that asin then pick sku from that row from sheet 2 if sheet1 and sheet2 prices of that asin not equal budget is 15-20$ Thanks

    $25 (Avg Bid)
    $25 Avg Bid
    42 bids

    We have an existing macro in excel (created by another freelancer many months ago), that needs some slight modifications done. The macro It was designed to work with multiple .txt source files, but now the source file is just one big single .txt file. The existing script loads values from a .csv finance file and uses that to make calculations in a main

    $41 (Avg Bid)
    $41 Avg Bid
    21 bids

    i have two sheets in excel,i want combine rows in one sheet if match with particular column value in excel

    $35 (Avg Bid)
    $35 Avg Bid
    56 bids

    I want a macro/VB to be build to convert XLSX/XLS file of a specific format to a csv format. some basic formula to be build as per the input and output file. This XLSX/XLS file data will keep changing, so whenever we run the macro, csv file should generate. It's a simple requirement.

    $53 (Avg Bid)
    $53 Avg Bid
    28 bids

    ...on Sheet ‘Reference Data’ • The times of the interactions should be within say 1 Hour of each other so the ‘Opened’ Columns on both sheets. I have tried doing this with VLookup (failed attempt on the hidden ‘Ignore’ Sheet in the workbook.) But this only returns the first value it finds and some of the clients have more than one and I’m rea...

    $49 (Avg Bid)
    $49 Avg Bid
    43 bids

    I create new project workbooks based on predefined templates from many existing workbooks. What I would like is a new project workbook with drop down menus that lets me choose sheets from different workbooks and copies all selections to the new project workbook.

    $122 (Avg Bid)
    $122 Avg Bid
    11 bids

    I have an excel file with 384 input columns and approximately 86000 data point. each row represents 1 second. I want you to write a macro that would take each column copies it and provides an adjacent column with 5, 10, 15, and 20 seconds delays. Simply the column gets copied, inserted next to the original one and the data is shifted down 5, 10, 15

    $240 (Avg Bid)
    $240 Avg Bid
    5 bids