Save this Search
     

All JobsVBA

 5,485 results  
Sort by:
  • Posted Date
Fixed Price: Less than $500   |  Posted: 3h, 10m ago  |  Closed  |   16 Proposals
Need someone to write a quick VBA to close the text box on the attached spreadsheet. Once the button in the red box is clicked, I need the box to disappear (along with the text and button inside of it) and the cursor to move to A31 Thanks
Category: Data Analysis       
Skills: Microsoft Excel, VBA, Visual Basic       

****
 [?]
Sign in to view client's details.
| Client
|    United States
Fixed Price: $20 - $50   |  Posted: 6h, 57m ago  |  Closed  |   4 Proposals
Hi, We are in need of a json to csv converter. The tool can be either something that can be ran from the cmd line with two parameters(input file and output file). If you are skilled enough to make it as an Excel VBA function that would be perfect. It should work the same as the json to csv on this link   [obscured]  -csv.com/ Also i am attaching a json response in the txt file. Keep in mind that i need this to be universal and not just to work with this structure, the elements here will change so it has to be able to work exactly as the tool on the link above. Will hire the first feelancer who can do this quickly and with high quality. Dont bid if you are not 100% sure that you can either make it as cmd line tool that can be called or as a VBA function. For those there who are vba sawy there is something already made on   [obscured]  /Home/excelquirks/json/excel-json-conversion They just need to make it as a friendly function. Thanks
Category: Other - Data Science       
Skills: Microsoft Excel, Javascript, PHP, VBA, JSON       

z****_88
 [?]
Sign in to view client's details.
| z****_88
|    Serbia
Fixed Price: $500 - $1,000   |  Posted: 21h, 35m ago  |  Ends: 14d, 2h  |   1 Proposal
We would like to have the ability to offset the sketch for about 72 inches in autodesk inventor 2014 1. Create Part 2. Create Sketch 3. Offset sketch 72" / 78" 4. Draw playground boundary line/spline/polyline around the sketch 8. Ability to show both structure and playground boundries in 2D sketch only 9. Extrude playground boundary line 1/2" - (optional ilogic command ??) - my "Ferrari" 10. Apply surfacing material (optional ilogic command ??) - my "Ferrari" The following is a video done in vectorworks 2010, we would like to have the same feature in Autodesk inventor 2014 P.S In order to view the video open it Internet Explorer, which would allow you to download it.
Category: Other IT & Programming       
Skills: Autodesk Inventor, VBA, Visual Basic, API, vb script       

p****eng
 [?]
Sign in to view client's details.
| p****eng
|    Canada
Hourly Rate: About $12 / hr   |  Duration: 1-2 weeks  |  Posted: 23h, 45m ago  |  Closed  |   1 Proposal
For piecemeal work. C# / VBA / Excel / Macros / Add In work. The project involves a offshore development team around the world and an onshore business analysis team in the UK.
Category: Software Application       
Skills: Microsoft Excel, .NET Framework, VBA, C#       

a****008
 [?]
Sign in to view client's details.
| a****008
|    United Kingdom
Hourly Rate: Not Sure   |  Duration: 4-6 months  |  Posted: Jul 10, 2014  |  Ends: 28d, 21h  |   0 Proposals
**On-site only - please do not reply if you cannot come to Ewing, NJ to work.** We are looking for an Access/SQL Server developer contractor to help us complete some new development projects. SQL Server DBA experience is a plus. This contractor must work onsite so you must live within a driveable distance to Ewing, NJ, right off 95 Exit 4. Hours are flexible during the day but we prefer someone full-time for 3 to 6 months. Please let us know if you are interested to come in for an interview. We are a growing, high tech company with interesting work. Company (free) lunches on Wed, suburban location right off the highway and parking right outside our building. We hope you will consider this exciting opportunity. Thank you!
Category: Database Development       
Preferred Location: United States

u****012
 [?]
Sign in to view client's details.
| u****012
|    United States
Fixed Price: Less than $500   |  Posted: Jul 09, 2014  |  Closed  |   6 Proposals
Various VBA code required. Adding/deleting rows. Refer to attached worksheet for all comments and functionality. Yellow fill is to be shown on the screen to users. But not visible on the page when printed. If data overflows onto the next page, the page title and the "Project Details" data is to be copied on every page after the first i.e. as a sort of "Header". Please note the different area calculations for rectangle vs. circular i.e. L (mm) x W (mm) vs PI x r^2. refer to Sheet 3.3 C32 and D32. Please be aware of the hidden rows. All other functionality is described in the comments.
Category: Software Application       
Skills: Microsoft Excel, VBA       

a****r83
 [?]
Sign in to view client's details.
| a****r83
|    Australia
Fixed Price: Not Sure   |  Posted: Jul 09, 2014  |  Closed  |   39 Proposals
I need to divide some cells in Excel. Many contacts (people) now have more than one phone number assigned to them. These phone numbers need to be in an individual cell yet still assigned to the same person. This is so that we may use telephone auto dial service to contact them. Similar situation exists for some of the emails. Thanks you, Aldo
Category: Software Application       
Skills: .NET Framework, PHP, VBA       

a****958
 [?]
Sign in to view client's details.
| a****958
|    United States
Fixed Price: Not Sure   |  Posted: Jul 09, 2014  |  Ends: 13d, 1h  |   14 Proposals
- Advanced Excel Expertise - Knowledge of VBA and macros - Prior data scraping ulitity development experience is a plus - Ability to not only grab data but to organize it as well Job Description: We're looking for a professional data scraper to develop an Anywho/Yellow pages data scraper in Excel (must be automated, cleanly coded). Looking for a program to help generate lists 10,000-100,000 in size. Must be able to organize all the data into its respective categories. Your qualifications: - A work style that is extremely detail oriented - A complete Elance profile - References or an established reputation on Elance preferred - Meeting the skills required
Category: Data Engineering       
Skills: Microsoft Excel, Data scraping, Web scraping       

B****ent
 [?]
Sign in to view client's details.
| B****ent
|    United States
Fixed Price: Less than $500   |  Posted: Jul 09, 2014  |  Ends: 12d, 23h  |   6 Proposals
Dear Elance, We need to create a simple kids game in both Android and IOS. Need to start this immediately. Please apply with your previous work samples. You should be available in Skype and whatsapp to communicate easily. We will provide all the graphics needed. Our budget is $120 for each app. The winner will get regular projects. Regards, VBA
Category: Mobile Applications       
Skills: Android, iPhone, iPad, 2D Animation       

v****ies
 [?]
Sign in to view client's details.
| v****ies
|    India
Fixed Price: $20 - $30   |  Posted: Jul 09, 2014  |  Closed  |   17 Proposals
I would need to have write me and excel macro, that would work through a directory of excel files, open each of the excel files and with each file, extract 3 values out of that file from a specific tab. The extracted values should be put on to a new excel sheet. For each file in new row. Each value in its own cell - so for first file, cells A1,B1, C1 will be filled. Please make sure to disable screen updating and calculation during the process. The path can be fixed into the VBA code. Please get this done within 24 hrs after approval
Category: Data Engineering       
Skills: Microsoft Excel, VBA       

m****mbb
 [?]
Sign in to view client's details.
| m****mbb
|    Brazil
Fixed Price: $100 - $150   |  Posted: Jul 08, 2014  |  Ends: 12d, 10h  |   12 Proposals
Good evening, I have created a 6 page Word (2010) using legacy form feilds that populate hundreds of other areas of the document. This document also has macros that go out and gets (opens other word docs, copies and pastes) additional text (inside tables). Unfotunatly something has gone wrong and after some macros are executed and an attempt to print is made word crashes. Once reopened it will continually crash unless selecting a form feild.
Category: Data Entry       
Skills: VBA, Microsoft Word, Macro       

J****gel
 [?]
Sign in to view client's details.
| J****gel
|    Canada
Fixed Price: Less than $500   |  Posted: Jul 08, 2014  |  Closed  |   10 Proposals
We would like have 1 program to do the following. 1- Uninstall a program we have installed. 2 - Install windows VSTOR, .NET 4.5 and a custom program. 3 - Apply the License Key to the software.
Category: Software Application       
Skills: C, .NET Framework, PHP, VBA       

s****y77
 [?]
Sign in to view client's details.
| s****y77
|    Australia
Hourly Rate: Not Sure   |  Duration: Not Sure  |  Posted: Jul 08, 2014  |  Ends: 12d, 8h  |   38 Proposals
We are needing a highly skilled microsoft excel VBA expert You will be given logical rules which need to be automated Database automation. Create scripts based on logical rules.
Category: Software Application       
Skills: .NET Framework, VBA, Visual Basic       

p****ain
 [?]
Sign in to view client's details.
| p****ain
|    United States
Fixed Price: Less than $500   |  Posted: Jul 08, 2014  |  Closed  |   12 Proposals
I need to format an excel spreadsheet with VBA code. Please see the linked VBA tutorial:   [obscured]  /documents/excel/1174-excel-split-data-into-multiple-worksheets-based-on-column.html There are 1510 unique records with less than 200 shared identifiers (CustomerId). There are 31 columns. I will need them sorted by CustomerID and separated into individual sheets. I'd like this completed today.
Category: Data Entry       
Skills: Data Entry, Microsoft Excel, Computer Skills       

****
 [?]
Sign in to view client's details.
| Client
Hourly Rate: Not Sure   |  Duration: Not Sure  |  Posted: Jul 08, 2014  |  Closed  |   5 Proposals
We need help with a vba connection between excel and powerpoint. We have a project where we need to create a batch of powerpoint presentations from an excel document. In total we need to create around 50 powerpoint presentations that are based on data in the excel sheet. The script needs to work in the following way. 1. There is a list of all reports (variables). The script chooses the first report and updates an advanced filter. Now the graph only contains the data which should be included in the first report. 2. Open a powerpoint template 3. The graphs exist in the powerpoint template and is linked to the excel file. The graphs in the file now gets updated. 4. Remove links to the excel document 5. The powerpoint file is saved as. 6. Loop starts over with the second report The status is that we have solved step 1,2,5 and 6. But we cant solve number 3 and 4. When we run our script and update the graphs in excel nothing happens in powerpoint. So we need a vba that updates the graphs...
Category: Other IT & Programming       
Skills: Microsoft Excel, Microsoft PowerPoint, VBA       

g****nen
 [?]
Sign in to view client's details.
| g****nen
|    Sweden
Hourly Rate: $20 - $30 / hr   |  Duration: 7-9 months  |  Posted: Jul 08, 2014  |  Ends: 11d, 21h  |   18 Proposals
ooking for someone with strong english skills and MS Access report building. Job is usually 8-10 hours a week. The application is mostly built but needs small bug fixes, additional reports and forms. Should be comfortable in SQL Server T-SQL and also MS Access VBA. Job is 90% MS Access VBA and MS Access reports and 10% sql server. Will have to work USA CST hours and have strong english skills. Enter ^%^%123 on the first line to signify you read this. Add me on Skype: jratt0. YOU WILL START TOMORROW WHEN ACCEPTED. Please answer the following when applying: 1. If your SQL Server cannot be reached by client computers, what might be the problem? 2. If you have a table of customer sales with these fields CustomerName Date SaleAmount how would you write a querry that shows 1 line per customer and a range of their highest sale to their lowest sale amount? 3. If you moved your SQL sever and MS Access database to another computer, how do you make sure the tables from SQL server still...
Category: Technical Support       

J****att
 [?]
Sign in to view client's details.
| J****att
|    United States
Hourly Rate: Not Sure   |  Duration: 1-2 weeks  |  Posted: Jul 08, 2014  |  Ends: 11d, 20h  |   30 Proposals
We use a protected workbook to share with partner organisations so they can calculate details for projects remotely. They keep encountering a debug message that then allows them to see in to the back end of the spreadsheet. We would like this to stop happening.
Category: Technical Support       
Skills: Microsoft Excel, VBA       

T****ith
 [?]
Sign in to view client's details.
| T****ith
|    United Kingdom
Fixed Price: Less than $500   |  Posted: Jul 08, 2014  |  Ends: 11d, 19h  |   11 Proposals
1. Write a VB Script to extract a mobile number from a text file/data source. 2. Implement this script to work in an email parser programme. 3. Email Parser Programme "ResponseMailerPro" is attached to carry out task.
Category: Other IT & Programming       
Skills: VB.NET, VBA, Computer Skills       

C****der
 [?]
Sign in to view client's details.
| C****der
|    United Kingdom
Fixed Price: Less than $500   |  Posted: Jul 07, 2014  |  Ends: 11d, 4h  |   36 Proposals
I have a Microsoft Excel spreadsheet that needs integration of functions, and possibly VBA language as well. Manually inputted data will need to flow through multiple sheets and macros might be the best option. This is a fairly simple job, and for an expert, shouldn't take a lot of time.
Category: Data Engineering       
Skills: Microsoft Excel, VBA, Spreadsheets       

A****erg
 [?]
Sign in to view client's details.
| A****erg
Fixed Price: Less than $500   |  Posted: Jul 07, 2014  |  Closed  |   8 Proposals
From a spreadsheet containing a list with the following fields: Customer Number, Customer Name, Warehouse, Summary Market (i.e. web, stockist, trade, mail order etc.), Country, Latitude, Longitude, Kg shipped At the press of a button, open the default browser and display a google map showing markers for each customer, of differing colour according to the allocated warehouse. This should be zoomable etc. as per any google map. Clicking on a marker should display an info-box with customer nr, name, summary market and kg shipped. If a data filter is applied to the list prior to button click, then map only the relevant records - this will allow us to map only one country or one or more summary market etc. as required. Also map the warehouse locations (lat / longs will be supplied in separate cells on the worksheet) with different marker symbols, the factory location (this is fixed), and map a weighted average customer location for the selected records. Source code must be open for u...
Category: Other IT & Programming       
Skills: Microsoft Excel, Javascript, VBA, Google Maps       

L****ant
 [?]
Sign in to view client's details.
| L****ant
|    United Kingdom
Fixed Price: Not Sure   |  Posted: Jul 07, 2014  |  Closed  |   17 Proposals
I have a large spreadsheet and I need to calculate distances between postal/zip codes. I am able to calculate using Lon/Lat, I need the distance to be calculated in miles and then give me a total cost for fuel as if I were driving in a car. I have attached the workbook which has the spreadsheet for postcodes, longitude, latitude and the name of the town the postcode refers to.On the customer details page you will see a cell for postcode this will be the customers post code which will be a variable and the cell below will show the distance in miles. My post code will be a fixed variable hope this makes sense
Category: Database Development       
Skills: Microsoft Excel, VBA, Google Maps       

t****l18
 [?]
Sign in to view client's details.
| t****l18
|    United Kingdom
Fixed Price: $1,000 - $1,500   |  Posted: Jul 07, 2014  |  Ends: 2d, 18h  |   7 Proposals
6-8 weeks project focused on developing a 'Pricing Decision Model' in Excel/VBA. Candidate is required to work from Gurgaon Office (on Sohna road). Background in data analytics along with creating user friendly dashboards a big plus. Expected start from July 14th. Thanks
Category: Data Analysis       
Skills: Microsoft Excel, VBA, Data Cleansing       
Preferred Location: India

Q****arq
 [?]
Sign in to view client's details.
| Q****arq
|    India
Fixed Price: Less than $500   |  Posted: Jul 07, 2014  |  Closed  |   22 Proposals
VBA code required for 3 types of buttons: 1. to add/insert rows with data validation and formulas, 2. to remove/delete the added rows 3. to reset entire worksheet to defaults refer to attached scope of works and worksheet that requires the vba code. if this can be done to a high enough quality, repeat work will be made available.
Category: Software Application       
Skills: VBA, excel macros       

a****r83
 [?]
Sign in to view client's details.
| a****r83
|    Australia
Hourly Rate: $30 - $40 / hr   |  Duration: 1-2 weeks  |  Posted: Jul 06, 2014  |  Ends: 35d, 23h  |   5 Proposals
looking for experienced vba for excel training instractor to teach a course at our clients office in raanana on August 10-14 morning hours.
Category: Software Application       
Skills: VBA       
Preferred Location: Israel

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