Save this Search
     

All JobsVBAPosted: Within 7 days

 (37 results)  
Sort by:
  • Posted Date
Posted: Within 7 days
Fixed Price: Not Sure   |  Posted: 15h, 34m ago  |  Ends: 14d, 8h  |   22 Proposals
Hello - I have an Excel File that I use to map out our server folders and associated sub folders. I then have an associate manually create folders and subfolders from it. I would like someone to write VB code in Excel so that I can run the VB and a Windows Folder will be created on my desktop with all associated subfolders etc, from the Excel File. Timing is ASAP. Thank you.
Category: Database Administration       

U****ons
 [?]
Sign in to view client's details.
| U****ons
|    United States
Hourly Rate: Not Sure   |  Duration: Not Sure  |  Posted: 16h, 45m ago  |  Ends: 14d, 7h  |   8 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: 18h, 5m ago  |  Ends: 14d, 5h  |   10 Proposals
Hi, I have a long spreadsheet, instead of scrolling up and down all the time, I would like to create hyperlinks in Google sheet. Let's say that I have: 1.1 Croesus Framework License 2.1 Croesus Advisor License 2.2 Croesus Advisor Production Environment Mirror Site 2.3 Croesus Advisor UAT/Pre-prod Environment From cell 1 to 4 I want to be able to click on Croesus Framework License, and that it brings me all the way down to the related section of the document (in the same spreadsheet). I tried this in excel, however it will link me to the cell but at the bottom of the screen. I want it to show at the top of the screen.... and it doesnt work in Google spreadsheet. Thanks for your help
Category: Other IT & Programming       
Skills: Microsoft Excel, Excel VBA, google sheet       

E****ult
 [?]
Sign in to view client's details.
| E****ult
|    Canada
Hourly Rate: $10 - $15 / hr   |  Duration: Not Sure  |  Posted: Jul 28, 2015  |  Ends: 18h, 30m  |   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
Fixed Price: Less than $500   |  Posted: Jul 28, 2015  |  Ends: 13d, 13h  |   11 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: 13d, 12h  |   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, 11h  |   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: $20 - $25   |  Posted: Jul 28, 2015  |  Ends: 13d, 11h  |   20 Proposals
The red area is as it is in the Excel file. You must add rows based on item type = rule (rows 3 ? 18) and match and mix color and sizes (see rows 21 -83) Col A -? default value SKU (Col B) ? product ID (highest ID in file + 1) (Col C)? mix and match of colors and sizes (note watch format) Col E -? Product code from an row with type Product (Col A) + number Col V & W default valu Y COL DK -? Product code from an row with type Product (Col A) COL DL -? female COL DM -? adault COL DN -? gets the color Color=Aqua from Col C (only Aqua)) COL DO -? gets the size [S]Size=2[S]Color=Aqua Col C (only 2) COL DR -? same as Col DR COL DS -? gets 5441 COL DT -? gets Y This is just an example file in the final file there are 50000+ rows
Category: Product Management       
Skills: Microsoft Excel, VBA, Excel VBA       

M****ort
 [?]
Sign in to view client's details.
| M****ort
|    Netherlands
Fixed Price: $30 - $50   |  Posted: Jul 28, 2015  |  Ends: 13d, 11h  |   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: 13d, 10h  |   20 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: 13d, 6h  |   24 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: 13d, 5h  |   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: 23d, 12h  |   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, 10h  |   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, 21h  |   21 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, 9h  |   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, 23h  |   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, 12h  |   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, 10h  |   9 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: 2d, 3h  |   24 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: 10d, 0h  |   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, 12h  |   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, 11h  |   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, 8h  |   32 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
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