Save this Search
     

All JobsVBA

 (61 results)  
Sort by:
  • Posted Date
Results for 'VBA'
Fixed Price: Not Sure   |  Posted: Jul 30, 2015  |  Ends: 9d, 8h  |   44 Proposals
We need a developer to make the attached changes to an existing Access 2007/2010 database application.
Category: Database Development       

z****ter
 [?]
Sign in to view client's details.
| z****ter
|    United States
Hourly Rate: Not Sure   |  Duration: Not Sure  |  Posted: Jul 29, 2015  |  Ends: 8d, 8h  |   11 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
Fixed Price: Less than $500   |  Posted: Jul 28, 2015  |  Ends: 7d, 15h  |   13 Proposals
Just need guidance on connecting a Microsoft Access Database to a MySQL database hosted on digitalocean via the ODBC over SSH utility. I do not need VBA code and only need guidance on establishing a connection from Microsoft Access on my Windows 7 machine to the MySQL database hosted on digitalocean servers.
Category: Database Administration       

r****itc
 [?]
Sign in to view client's details.
| r****itc
|    United States
Hourly Rate: Not Sure   |  Duration: Not Sure  |  Posted: Jul 28, 2015  |  Ends: 7d, 14h  |   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: $30 - $50   |  Posted: Jul 28, 2015  |  Ends: 7d, 13h  |   8 Proposals
i have a website which i prepared using vba.net with c# . all the functionality part(90%) is finished. now i want to change the design of the site which has home, about, contact and another page with login functionality. 1) home page need to change the look( not specific but need to look professional) 2) about page need to change the look( not specific but need to look professional) 3) Contact page need to change the look( not specific but need to look professional) 4) OI page is now it is looking like this   [obscured]  /4ej4d7h61/site_1.png   [obscured]  /tcanqomv3/site_2.png   [obscured]  /w3bdibkq1/site_3.png i want to change that as below look   [obscured]  /q586f1mm5/newlook_1.png   [obscured]  /uvyac0pb7/newlook_2.png 5) login and register pages to modify( not specific but need to look professional) need to change the design(finalize) and prepare for hosting.
Category: Software Application       
Skills: ASP.NET, C#       

v****ame
 [?]
Sign in to view client's details.
| v****ame
Fixed Price: $500 - $1,000   |  Posted: Jul 28, 2015  |  Ends: 7d, 12h  |   29 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: 7d, 8h  |   27 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
Fixed Price: Less than $500   |  Posted: Jul 28, 2015  |  Ends: 7d, 7h  |   1 Proposal
Hi, Looking for a expertise to make a plug-in MT4 to ODIN Client (Multiclient)... Whenever signal generated from MT4 must place an order in ODIN client (CTCL) on demand we will provide the sample ID for testing & developments.
Category: Other IT & Programming       
Skills: MySQL Administration, .NET Framework, PHP, VBA, C++       

g****der
 [?]
Sign in to view client's details.
| g****der
|    India
Hourly Rate: $20 - $30 / hr   |  Duration: 1-2 weeks  |  Posted: Jul 27, 2015  |  Ends: 17d, 14h  |   19 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: 6d, 12h  |   31 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
Hourly Rate: Not Sure   |  Duration: Not Sure  |  Posted: Jul 27, 2015  |  Ends: 6d, 12h  |   0 Proposals
General ledger and accounts receivable accounting program needed to integrate with a lease management system, (MS Access 2003 front end and MYSQL backend). Current accounts receivable integration is with Peachtree / Sage Accounting, thru daily automated load of exported information , which would be replaced. Would like to find someone that has worked with and has code for a MS Access accounting package or one using VBA or VBA.NET, but alternatives will be considered.
Category: Software Application       

b****n11
 [?]
Sign in to view client's details.
| b****n11
Fixed Price: Not Sure   |  Posted: Jul 27, 2015  |  Ends: 5d, 22h  |   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: 5d, 11h  |   6 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: 5d, 1h  |   13 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: Less than $500   |  Posted: Jul 25, 2015  |  Ends: 4d, 2h  |   2 Proposals
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: 3d, 14h  |   10 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: 3d, 13h  |   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
Fixed Price: Less than $500   |  Posted: Jul 24, 2015  |  Ends: 3d, 10h  |   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: 3d, 9h  |   36 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: 2d, 22h  |   9 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
Hourly Rate: $15 - $20 / hr   |  Duration: 4-6 months  |  Posted: Jul 23, 2015  |  Ends: 2d, 17h  |   30 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: 2d, 17h  |   14 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
Fixed Price: Less than $500   |  Posted: Jul 23, 2015  |  Ends: 2d, 13h  |   16 Proposals
There is a website with a linked database (ASPX) that I would like to be able to pull into excel automatically without having to copy and paste every single page of the database. I would like it to be able to be updated regularly, with an excel script to scrub for duplicate entries. This is a public website with public information, I just want easy access to it in Excel. Please contact me for more information on this project.
Category: Data Engineering       
Skills: .NET Framework, Excel VBA       

j****oss
 [?]
Sign in to view client's details.
| j****oss
|    United States
Hourly Rate: $10 - $15 / hr   |  Duration: Not Sure  |  Posted: Jul 23, 2015  |  Ends: 2d, 12h  |   4 Proposals
Hello, I'm having a problem printing legal sized excel documents - they print smaller than they should.
Category: Technical Support       
Skills: PHP, VBA, Mac OSX Administration       

n****ter
 [?]
Sign in to view client's details.
| n****ter
|    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