Save this Search
     

All JobsExcel VBA

 (53 results)  
Sort by:
  • Posted Date
Results for 'Excel VBA'
Hourly Rate: Not Sure   |  Duration: Not Sure  |  Posted: Jul 29, 2015  |  Ends: 13d, 23h  |   9 Proposals
Using hyperlinks in column A, pull two specific data points from each webpage. The approximate number of webpages would be 350-500. The webpages are identical format, just with different data points. Ideally, the Macro would establish a loop so that after pulling the two data points from the first row, automatically move on to the next row to perform the same task. It is not necessary for the webpage to remain open. Separately, using property addresses in two columns (address, state) pull in information provided by the API information provided by   [obscured]   They provided an API ID where the the API information desired is identified and associated with the account. Able to provide API ID once needed. It is possible no results are available as the information is not enough to search - this is expected. Examples of the two requests are included in the excel workbook attached. One tab has the data for the Macro Loop and the other has the property information for the Zillow...
Category: Data Entry       

s****ga6
 [?]
Sign in to view client's details.
| s****ga6
|    United States
Hourly Rate: $10 - $15 / hr   |  Duration: Not Sure  |  Posted: Jul 28, 2015  |  Ends: 11h, 3m  |   2 Proposals
Hello, I need help creating the scenario's outlined in the attached document. The project must be completed in two days, July 30th 6:00 pm PST. Scenario #3, I will outline in a document but would like to have an excel pivot table associated with it to show the spend. The dollar value is Canadian and I will be available to answer questions, at anytime through email. Please let me know if this is something you feel you can do this quickly? Thank - You.
Category: Marketing Strategy       
Preferred Location: North America

L****ess
 [?]
Sign in to view client's details.
| L****ess
|    Canada
Hourly Rate: Not Sure   |  Duration: Not Sure  |  Posted: Jul 28, 2015  |  Ends: 13d, 5h  |   4 Proposals
Hi, I have a spreadsheet with about 200 data fields, that I would like to auto populate a Power Point, Word or InDesign. If you have that skill set please let me knoe. Thanks, Ryan
Category: Presentations       

r****nsf
 [?]
Sign in to view client's details.
| r****nsf
|    United States
Fixed Price: Less than $500   |  Posted: Jul 28, 2015  |  Ends: 1d, 4h  |   31 Proposals
Will email attachment (actual excel sheet) This is a very, very simple VBA code. Basically, I just need the excel workbook attached to fill in column T for me. Requirements: Macro executed via clicking on the button. Column T on worksheet "SourceData" gets automatically filled after pressing the button. See explanation below: I need "SourceData" column T to autofill based on "ReceiptAmt" column S and "BatchDate" column B. It looks up the corresponding information from "Download" and, when matching, fills in the Column T of "SourceData" with the "Ref1" number from "Download". Details: IF "ReceiptAmt" (SourceData sheet column S) = "Amt1" (Download sheet column G), AND "BatchDate" (SourceData sheet column B) = "EinreichungsDatum" (Download sheet column E), THEN Fill current row, Column T cell on "SourceData" worksheet with the data in Column I "R...
Category: Other IT & Programming       
Skills: VBA, Excel VBA       

t****sup
 [?]
Sign in to view client's details.
| t****sup
|    Germany
Fixed Price: $500 - $1,000   |  Posted: Jul 28, 2015  |  Ends: 13d, 3h  |   21 Proposals
Hello I need a programmer who can help build a dynamic project timeline based on Excel. I'd need someone who's built functions or products through Excel. VBA or VBS coding. This would need to be built so that we can make updates internally without further support. The way we'd like the logic to work: - Starting with a basic timeline - Allowing for add-on options to be added to the timeline (by clicking on a radio button, for example) - This will make the timeline shrink or expand by adding new rows/columns, and updates dates in other cells Happy to talk more. If you have examples of this sort of work, that would help. Thanks
Category: Other IT & Programming       
Skills: Microsoft Excel, VBA, VBScript, Excel VBA       

j****ptw
 [?]
Sign in to view client's details.
| j****ptw
|    United States
Fixed Price: Less than $500   |  Posted: Jul 28, 2015  |  Ends: 12d, 23h  |   25 Proposals
I have a couple of simple excel sheets, one for recording sales and one for recording invoices due by the business completed by a member of staff. I would like the spreadsheets to automatically report activity by emailing me once an evening to report the monetary value of sales in the month to date, work in progress, income due (who from and amounts) in the next 14 & 30 days and expenditure due (who to and amounts) in the next 14 & 30 days. Maybe a couple of other items but nothing complicated.
Category: Other IT & Programming       
Skills: Microsoft Excel, Excel VBA       

c****wds
 [?]
Sign in to view client's details.
| c****wds
|    United Kingdom
Hourly Rate: $20 - $30 / hr   |  Duration: 1-2 weeks  |  Posted: Jul 27, 2015  |  Ends: 23d, 4h  |   17 Proposals
Looking for assistance with finishing a detailed excel model for an education technology company. There is a model in existence that needs to be cleaned up and modified. Valuation experience is a plus.
Category: Project Management       
Skills: Microsoft Excel, PHP, WordPress, Excel VBA       

u****ani
 [?]
Sign in to view client's details.
| u****ani *
|    United States
Fixed Price: Not Sure   |  Posted: Jul 27, 2015  |  Ends: 12d, 3h  |   29 Proposals
I need to be able to generate a Word document various configuration data in a data file such as Access, Excel, or whatever works best. We are using: * Microsoft Office 2013 Pro 32-bit * Windows 7 Pro 64-bit Here is what I am doing: * Once a month, I meet with a NEW CUSTOMER and perform an interview. * I need to flag various statuses for this CUSTOMER in a data file of some type (e.g., Excel). * I need to click a button and a new Word document be created that contains various information based on the data file. * Some text will be verbatim what is in the data file while some will be text generated based on an On/Off, True/False type value in the data file. * I would like to save the data file for each customer. In the future, I should be able to completely regenerate their report by using the program and the data file. Below is some example data and an example output. This is not all of the data just an EXAMPLE of the type of functionality I need. DATA HasCar yes HasTruck no CarQt...
Category: Software Application       

d****r01
 [?]
Sign in to view client's details.
| d****r01
|    United States
Fixed Price: Not Sure   |  Posted: Jul 27, 2015  |  Ends: 11d, 13h  |   22 Proposals
The project involves software upgrade works to an existing Microsoft Excel tool to streamline inputs, calculations and generate an output report or summary. There is a prescribed standard defining the requirements of the excel tool. The current tool does not include VBA code to simplify certain inputs and this will be required. A summary page/report will need to be generated for each assessment.
Category: Data Engineering       
Skills: Microsoft Excel, VBA       

S****Ltd
 [?]
Sign in to view client's details.
| S****Ltd
|    New Zealand
Hourly Rate: Not Sure   |  Duration: Not Sure  |  Posted: Jul 26, 2015  |  Ends: 11d, 2h  |   5 Proposals
Looking for someone to help with a google sheets integration. Need google sheets to look at the server once a day see if there are new files. If they have a certain prefix AND have a certain text in column XX, then load row into google sheet XXX on a new row. If file has another prefix AND has specific text in column XX, then load row into google sheet XXX. Etc.
Category: Other IT & Programming       
Skills: FTP, VLookup Tables, Excel VBA, google sheets       

j****oix
 [?]
Sign in to view client's details.
| j****oix
|    United States
Fixed Price: Not Sure   |  Posted: Jul 26, 2015  |  Ends: 10d, 15h  |   9 Proposals
hi i need text data to upload and split to excel Sr. No. KsrK86Dg5f58frsC find - and plit data from back 4 latters Employee Id ZEZH-8ta1Ul find next minmum 3 digit no and split before it Occurance No. 684720485383 find next text word and splite before it Loan File No FDR2845/13 find next $ or number Loan Amount $12,000.00 next space or after .00 split Rate of Interest 10.3% after % split Tenure 6 months find dollat $ and split Total Loan $12,620.40 find dollat $ and split EMI $2,103.40 find thext and split Other Loans no next space or start with caps latter Intials Dr next space Employee Name MICHAEL L ZIENTEK find line break or enter and split Add1 West 904 Riversidé Ave find { and split City1 sp0kane find to latter and split before State1 WA find number and split Zip1 99201 find text and split Country1 ÜSÁ find line break or enter and split Contact Mode Letter find next spave Marital Status Divorced find next spavce Ref Name CHARLES_WANTA find number and split Years of ...
Category: Software Application       

s****ons
 [?]
Sign in to view client's details.
| s****ons
|    India
Fixed Price: Not Sure   |  Posted: Jul 25, 2015  |  Ends: 10d, 5h  |   20 Proposals
I need someone that has experience analyzing text phrases within Excel. I don't mean only counting the number of times words show up. I need text analysis. I don't know the exact methodology so I am looking to partner with someone that has experience in this area
Category: Data Analysis       
Skills: Microsoft Excel, VBA, text analysis       

u****013
 [?]
Sign in to view client's details.
| u****013
|    United States
Hourly Rate: Not Sure   |  Duration: Not Sure  |  Posted: Jul 25, 2015  |  Ends: 10d, 3h  |   10 Proposals
Hi I am searching for highly skilled Excel/Vba expert. Send me working examples of excel code you have coded. Not Macros Required Statement of Work Itemized Hours must be able to complete the work within 48 hours once the offer has been accepted and agreed upon. Total Cost NOTE: escrow yes, NO payment will be provided beforehand and I will only release payment after ALL the components are working as they should be. One missing or defective component = non payment. I apologize for this but I need all components to be working 100 percent. thank you
Category: Other IT & Programming       
Skills: Microsoft Excel, Excel VBA       

h****es3
 [?]
Sign in to view client's details.
| h****es3
|    United States
Hourly Rate: Not Sure   |  Duration: Not Sure  |  Posted: Jul 25, 2015  |  Ends: 1d, 20h  |   25 Proposals
Good Day, I have a macros-driven fixed asset management excel workbook that needs a few modifications. These include adding Asset categories and columns and adding macros while maintaining the integrity of the current macros. Regards
Category: Data Engineering       
Skills: Microsoft Excel, VBA, Excel VBA       

C****112
 [?]
Sign in to view client's details.
| C****112 *
|    South Africa
Fixed Price: Less than $500   |  Posted: Jul 25, 2015  |  Ends: 9d, 17h  |   1 Proposal
I need someone to construct a robust currency valuation model using Bloomberg symbols to check if a currency is undervalued or overvalued. I need this to use various indicators and be a dynamic output The second part requires implementation of a paper explaining a carry yield FX strategy.
Category: Data Science       
Skills: Foreign Exchange Trading, Excel VBA       

q****art
 [?]
Sign in to view client's details.
| q****art
|    United States
Hourly Rate: $20 - $30 / hr   |  Duration: 1-2 weeks  |  Posted: Jul 24, 2015  |  Ends: 9d, 4h  |   9 Proposals
Looking for assistance with finishing a detailed excel model for an education technology company. There is a model in existence that needs to be cleaned up and modified. Valuation experience is a plus.
Category: Project Management       
Skills: Microsoft Excel, PHP, WordPress, Excel VBA       

u****ani
 [?]
Sign in to view client's details.
| u****ani *
|    United States
Hourly Rate: Not Sure   |  Duration: Not Sure  |  Posted: Jul 24, 2015  |  Ends: 9d, 4h  |   23 Proposals
We have an Amazon inventory flat file that needs to be formulated so that we can automate inventory processes. For this particular job, we have two different inventory files from two separate vendors. These files need to be added to the main inventory file as additional sheets, and have the correlating data auto-update the main inventory file. Case-searching/booleans will be necessary in the formula build.
Category: Data Analysis       
Skills: Microsoft Excel, VLookup Tables, Excel VBA       

D****904
 [?]
Sign in to view client's details.
| D****904
|    United States
Hourly Rate: Not Sure   |  Duration: 1-2 weeks  |  Posted: Jul 24, 2015  |  Ends: 9d, 1h  |   33 Proposals
Greetings, My Real-estate company is seeking to collect information from potential leads from a website. We have about 500+ contacts that need to be extracted from a website that's made available to the public. Information that will be need is name and address of the persons and also case numbers. This can be an ongoing job as new contacts will be needed on a daily bases for mailing campaigns.
Category: Data Engineering       

P****LLC
 [?]
Sign in to view client's details.
| P****LLC
|    United States
Fixed Price: Less than $500   |  Posted: Jul 24, 2015  |  Ends: 9d, 0h  |   11 Proposals
Hi So we are launching a new company with a pretty much forced matrix whereby there's only 5 tiers down. (depth fixed at 5 tiers) and width is pretty much unlimited (meaning you can always add new people under you). We will be using an affiliate marketing software to track commission generated and whose under you. The product itself is $400. You are buying the first $400 to join as a distributor. Assuming you are generating 2 downlines, you pretty much break even at first tier... 1st tier sales - 50% commissions x 2 downlines 2nd tier - 5% x 4 3rd tier - 5% x 8 4th tier - 5% x 16 5th tier - 5% x 32 The above is only for the first sale from your downlines. For subsequent sales through your downlines, it's all at 5% commission. We do want to take into account what we can earn in subsequent sale too. We want an excel sheet where we ca...
Category: Other - Data Science       
Skills: Microsoft Excel, Sales, Affiliate Marketing       

u****ize
 [?]
Sign in to view client's details.
| u****ize
|    Singapore
Hourly Rate: Not Sure   |  Duration: Not Sure  |  Posted: Jul 24, 2015  |  Ends: 8d, 23h  |   34 Proposals
Attached is a sample line from a larger file that needs to be parsed. These files usually have about 25,000 comma delimited info... What it is, is a file containing the weights of medicine/pill capsules that go through a pill sorting machine. Those capsules whose weights are accepted by the machine are signified by an "A" next to the number. Those that are out of range/rejected by the machine are signified by an "R" next to the number. In the example, the file starts with a date and time and then starts taking weights of the medicine/pill capsules...it continues and if the weight is accepted, it keeps to the left of the machine chute and if the weight is rejected it sends the capsule to the machine's right chute.... We need an excel script that will parse these files and displays a table of the weights that are acceptable (or A) and those that are rejected/out of range (or R). Then a summary of both. We need the numbers in a format that can easily be pri...
Category: Software Application       
Skills: Microsoft Excel, Scripting, Excel VBA       

D****pes
 [?]
Sign in to view client's details.
| D****pes
|    United States
Fixed Price: Less than $500   |  Posted: Jul 24, 2015  |  Ends: 8d, 13h  |   8 Proposals
I am having a hard time locating, sifting through, figuring out if I qualify, ensuring I haven't missed a deadline and applying for scholarships. It's been a hassle and I need someone's help. Here is what I am thinking: 1) I want an excel document that pulls scholarships from all over the Internet. 1b) my field of study is nursing but general scholarships are great as well :) 2) I want them to be sorted by due date but I also want included is the name of scholarship, essay question, how many words the essay has to be min or max, the website of scholarship, and anything else that seems pertaining. Those are what I am wanting. The reason for the excel sheet is so I don't have to continue looking aimlessly for scholarships that I don't qualify for etc. Is this something you can help me with? Do you have a better idea than what I have come up with or maybe you can build on my idea? Than please put in a bid and explain what makes you different and how you can make this a success for me. ...
Category: Other IT & Programming       
Skills: Microsoft Excel, Research, Internet Research       

c****010
 [?]
Sign in to view client's details.
| c****010
|    United States
Fixed Price: $1,000 or less   |  Posted: Jul 23, 2015  |  Ends: 8d, 9h  |   40 Proposals
I need a method to cross reference service records at my car dealership (~1200/mo) with a customer list (called the ACB) and generate a list of records that matches a particular set of rules i.e. Have had two visits within 12 months of their in-service date, repair orders (ROs) cannot be warranty paid, a second RO within 7 days counts as the same RO, the RO cannot be from a commercial vehicle, etc. All of this information is readily available, but I will need to alter some data to protect privacy during development. The service records are available as a .csv file on an FTP, but I can easily download this locally to my PC to use with the spreadsheet. The ACB is manually downloaded as a .xls file. Ideally I would like to: 1. Download the service records to my PC 2. Download the ACB to my PC 3. Open my "Retention Workbook" 4. Easily connect to/Point to/Import the service records and ACB into this worksheet 5. Run the cross reference 6. View an organized list of customer(s)+o...
Category: Data Analysis       
Skills: VBA, Excel VBA       

m****on2
 [?]
Sign in to view client's details.
| m****on2
|    United States
Hourly Rate: $15 - $20 / hr   |  Duration: 4-6 months  |  Posted: Jul 23, 2015  |  Ends: 8d, 8h  |   29 Proposals
I am looking to establish a working relationship with an excel expert for various tasks related to my company that I don't have the bandwidth to take care of myself. Need someone who is comfortable with all levels of excel work, from VBA app integration to more basic tasks.
Category: Data Entry       

E****nja
 [?]
Sign in to view client's details.
| E****nja
|    United States
Fixed Price: $75 or less   |  Posted: Jul 23, 2015  |  Ends: 8d, 8h  |   13 Proposals
I receive a weekly report, which is a list of fuel charges. I need to format and summarize the report. I have attached a workbook with 2 sheets in the workbook. Sheet 1 is the raw data and sheet 2 is the summary report I need created with VBA. I need to loop through each line of data and classify the charge. I want to copy certain columns of the raw data on sheet 1 to the summary table on sheet two starting on line 17. For each tail number in the list I need to add this tail number to the summary area in green on sheet 2 starting with column B, row 4. Then the next tail number would go in column C, row 4 and so on. Next, I need to determine if the cost is a fuel cost or an ad hoc cost. Each line can only be either fuel or an ad hoc cost and the line amount in column S of sheet 1, the raw data sheet, will be the cell transferred to either column H or column I of sheet 2. If column P of the raw data sheet states USG then this is a fuel charge and the amount listed in column S ne...
Category: Software Application       
Skills: Visual Basic       

c****254
 [?]
Sign in to view client's details.
| c****254
|    United States
Symbol Key
Payment method not yet verified
Payment verified
Purchased $1-$500
Purchased $500-$5,000
Purchased more than $5,000
You have already submitted a
proposal to this job