Save this Search
     

All JobsExcel VBA

 30 results  
Sort by:
  • Posted Date
Fixed Price: Not Sure   |  Posted: 5h, 9m ago  |  Ends: 14d, 18h  |   12 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: 5h, 32m ago  |  Ends: 14d, 18h  |   3 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
Hourly Rate: Not Sure   |  Duration: Not Sure  |  Posted: 22h, 38m ago  |  Ends: 14d, 1h  |   27 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
Hourly Rate: Not Sure   |  Duration: Not Sure  |  Posted: Jul 08, 2014  |  Ends: 15h, 53m  |   4 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: Not Sure   |  Duration: 1-2 weeks  |  Posted: Jul 08, 2014  |  Ends: 13d, 13h  |   27 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 07, 2014  |  Ends: 12d, 21h  |   31 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: $1,000 - $1,500   |  Posted: Jul 07, 2014  |  Ends: 4d, 11h  |   5 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
Hourly Rate: $30 - $40 / hr   |  Duration: 1-2 weeks  |  Posted: Jul 06, 2014  |  Ends: 37d, 16h  |   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
Fixed Price: $500 - $1,000   |  Posted: Jul 06, 2014  |  Ends: 11d, 14h  |   10 Proposals
Development of database in MS Access for usage of Inventory optimisation Linear programming for optimisation of Load and Route
Category: Database Development       
Preferred Location: India

l****das
 [?]
Sign in to view client's details.
| l****das
|    India
Fixed Price: Not Sure   |  Posted: Jul 06, 2014  |  Ends: 11d, 11h  |   7 Proposals
The project consists of implementing: - an Excel / VBA / ActiveX based API to the Interactive Brokers Trader Workstation (IB TWS) - simple, transparent and commented VBA code - which can be based on the IB TWS ActiveX example The application will need to - connect to / disconnect from the TWS at given times - reconnect to the TWS if the connection is lost - check availability of market data and handle situations in which market data is not available - retrieve market data, order data and account data from the IB TWS - encompass basic trading functionality (orders / conditional orders, triggered by proprietary trading signals) - log market, order and account data The application shall retrieve the following data from the IB TWS - Market data (per instrument): open, bid, ask, last and close for instrument types indices (2), stocks (1) and currencies (2). Open data for indices / stocks should be official exchange open price data. Bid and ask data where applicable. - Account data / pos...
Category: Software Application       

l****a01
 [?]
Sign in to view client's details.
| l****a01
|    Switzerland
Fixed Price: Less than $500   |  Posted: Jul 04, 2014  |  Ends: 10d, 0h  |   16 Proposals
I want this   [obscured]  /excel/rowliner.htm But to work on Microsoft Excel 2013 for Windows in 64 bit version. It must work on split and frozen panes Not be affected or alter any other excel function, including Undo
Category: Software Application       
Skills: Microsoft Excel, .NET Framework, VBA       

t****hew
 [?]
Sign in to view client's details.
| t****hew
|    Australia
Fixed Price: $1,000 - $5,000   |  Posted: Jul 04, 2014  |  Ends: 9d, 21h  |   25 Proposals
I need help with dividend calculating for ETF components and dates. Excel VBA a plus. Organized and efficiency needed.
Category: Investment Analysis       
Skills: Microsoft Excel       

O****ces
 [?]
Sign in to view client's details.
| O****ces
|    United States
Fixed Price: Not Sure   |  Posted: Jul 04, 2014  |  Ends: 24d, 13h  |   10 Proposals
Hi, I need a programm to compare buy and sell prices from different shops. I guess Excel VBA will be the best, but I'm open to your suggestions. The Programm shall check Prices in this Shop   [obscured]  / and then take the EAN number which is below the title on every Page and put it in the Trade in search at Amazon (   [obscured]  /gp/search/s/?url=rh%3Dn%3A771391031 ). At the end it should create a list, where it shows which books give the most profit. I know, both sites are in German. Of course I can help if you need a translation.
Category: Other IT & Programming       

m****ler
 [?]
Sign in to view client's details.
| m****ler
|    Germany
Hourly Rate: $10 - $15 / hr   |  Duration: 1-2 weeks  |  Posted: Jul 03, 2014  |  Ends: 8d, 22h  |   14 Proposals
We are looking for a simple VBA or Macro for data analysis. The objective is to create a Macro for calculating portfolio standard deviation, consisting of 60-120 stocks at a time for 10 years worth of data and funds. For illustration, watch the video up to 7 minutes mark.   [obscured]  /watch?v=FZyAXP4syD8
Category: Data Science       
Skills: Microsoft Excel, VBA       

A****fan
 [?]
Sign in to view client's details.
| A****fan
|    Australia
Hourly Rate: $20 - $30 / hr   |  Duration: 1-2 weeks  |  Posted: Jul 03, 2014  |  Ends: 8d, 14h  |   47 Proposals
I need a very strong excel expert to finish a project that requires some macro writing. I need to be able to enter various data that will populate a summary page. The spreadsheet needs to be graphed once it is populated.
Category: Software Application       
Skills: Microsoft Excel, .NET Framework, PHP, VBA       

t****333
 [?]
Sign in to view client's details.
| t****333
|    United States
Hourly Rate: Not Sure   |  Duration: Not Sure  |  Posted: Jul 03, 2014  |  Ends: 8d, 9h  |   32 Proposals
We have a simple excel spreadsheet which takes some stress values and then using VBA creates some calculations. We want to convert the Excel sheet into a stand-alone executable file (.exe) using VB.net and Delphi. We are seeking a full-time developer and this is our trial project to assess their suitability for the role.
Category: Other IT & Programming       
Skills: .NET Framework, VB.NET, Delphi, COM       

c****404
 [?]
Sign in to view client's details.
| c****404
|    Ireland
Hourly Rate: Not Sure   |  Duration: Not Sure  |  Posted: Jul 03, 2014  |  Ends: 8d, 3h  |   3 Proposals
I love your ring chart and would love to see how it can be modified to allow for me to use it with showing phase progression of a project with its underlying stories.
Category: Project Management       
Skills: Microsoft Excel, VBA, Microsoft Project       

j****ing
 [?]
Sign in to view client's details.
| j****ing
|    United States
Fixed Price: $100 - $150   |  Posted: Jul 02, 2014  |  Ends: 7d, 17h  |   20 Proposals
Text and numbers from a pfd document copypasted to excel. Text and numbers from excel copypasted to webpage.
Category: Other IT & Programming       
Skills: Microsoft Excel, HTML, PHP, VBA       

O****ian
 [?]
Sign in to view client's details.
| O****ian
|    Finland
Hourly Rate: Not Sure   |  Duration: Not Sure  |  Posted: Jul 01, 2014  |  Ends: 6d, 21h  |   8 Proposals
i need to add pictures to my excel sheet and change macro for the COLUMN A sold change COLUMN A SOLD section. basically every time i need to check an item on column a. i right click the mouse a check box shows and i click it
Category: Technical Support       
Skills: Microsoft Excel, VBA       

c****nts
 [?]
Sign in to view client's details.
| c****nts
|    United States
Fixed Price: Not Sure   |  Posted: Jun 30, 2014  |  Ends: 5d, 18h  |   18 Proposals
We are looking for someone to implement a loan management program for a small company. The program would have to be linked to live bank account information, and calculate required cash flows and dates based on pre-defined formulas. This is certainly managable in a big excel spreadsheet but we would like to use a more "secure" / "sophisticated" option for it, to make sure none of the users make any mistakes. We are currently considering to use Microsoft Access + Excel / Java Overlay for this unless you have a better idea. We are looking to complete this in the next 2 months. Please get in touch for further information. Experience with loan management / financial sector would be beneficial.
Category: Database Development       
Preferred Location: United Kingdom

k****rit
 [?]
Sign in to view client's details.
| k****rit
|    United Kingdom
Fixed Price: $25 or less   |  Posted: Jun 29, 2014  |  Ends: 4d, 13h  |   41 Proposals
I am trying to take a cell in excel and remove some of its contents based on a certain criteria. For example, a cell that is "great office space available $10 per month." - what I would like to do is remove all the content from the cell which is to the right of the $ symbol (including the symbol). So the cell should now be "great office space available". Part 2: I have a long list in excel of sentences like this. I would like to loop through the entire list and replace all the cells with the above. The list also has spaces in between the cells, so I would like to condense the list so that there is no spaces in between cells. Additional: I want the macro to have relative referencing; I may move the contents and want to start the macro within different cells, sheets, or workbooks. Macro should start on the active cell. *I attached an example with 2 columns; before and after and highlighted what was removed on the left column. I need this ASAP.(ID: 58845690...
Category: Other IT & Programming       
Skills: Microsoft Excel, VBA       

i****ace
 [?]
Sign in to view client's details.
| i****ace
|    United States
Hourly Rate: $10 - $15 / hr   |  Duration: Not Sure  |  Posted: Jun 27, 2014  |  Ends: 2d, 17h  |   9 Proposals
the Access tools needs to do following: Import multiple excel worksheets into various tables Format data in specific format to use in a third party system Create export files to use in third party system Attached is how the import files will look like and third party tools import file format. Please refer to STQ Data file format from page 325. Please let me know if you can turn this around over the weekend.
Category: Other IT & Programming       
Skills: Access VBA       

m****_tx
 [?]
Sign in to view client's details.
| m****_tx
|    United States
Hourly Rate: Not Sure   |  Duration: Not Sure  |  Posted: Jun 27, 2014  |  Ends: 2d, 12h  |   20 Proposals
I have installed a Dynasonics DTFXE Ultralink Heat Meter on our 5MW Boiler to meter the amount of Heat our Kilns are using. Energy Link Software (MS Excel) came with the Meter. It is currently accumulating every couple of seconds and at the end of every day we are given a total usage in kWh. This tells us what we are using over a 24 Hour period. However, we ALSO need to be able to show what our peak Load is during this 24 Hour period so therefore we need to add 2 new sheets to the Excel File. One which tells us what the Meter is using every minute during the day and one which tells us what we are using every hour. With this information then we will be able to graph the data and show what we are using. See attached the Excel File which is described above which you can have a look at.
Category: Other IT & Programming       
Skills: MySQL Administration, HTML, PHP, VBA       

T****r88
 [?]
Sign in to view client's details.
| T****r88
|    Ireland
Fixed Price: Not Sure   |  Posted: Jun 26, 2014  |  Ends: 1d, 21h  |   13 Proposals
We have an excel file with a macro that will do several things. All actions are currently limited to local file locations/folder paths and we need these actions to be functional with https server locations. We have the following capabilities. Macro 1 - Importing photos into excel file: 1) local photos folder path is entered into cell 2) image name.jpg is entered into photo cells 3) the macro will find images and paste them into output sheet/table ----We need this functionality to work with a folder path this a mapped network drive/online location ie:   [obscured]  /accounts/name/etc. Macro 2 - Report Generator: 1) local report template folder. This folder has a word document template that has bookmarks 2) local output folder. this folder is where the generated word document is placed. the macro copies ranges/cells from the excel file and places them into the word document --- we need this functionality to also work with a folder path this a mapped network drive o...
Category: Other IT & Programming       
Skills: VBA, Visual Basic       

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