Save this Search
     

All JobsVBA

 (7,170 results)  
Sort by:
  • Posted Date
Hourly Rate: $10 - $15 / hr   |  Duration: Not Sure  |  Posted: 1h, 25m ago  |  Ends: 14d, 22h  |   2 Proposals
Hi I have a working Macro (attached). It helps me take a master csv of orders and make smaller csvs for different courier softwares. I have a few tweaks to make to it, so looking for somebody well versed in VBA code to help. Job will probably be a couple of hours only, but this could be every month. Regards Gurpreet
Category: Other IT & Programming       
Skills: Microsoft Excel, PHP, VBA, Excel VBA       

g****tic
 [?]
Sign in to view client's details.
| g****tic
|    United Kingdom
Fixed Price: $20 - $100   |  Posted: 3h, 33m ago  |  Ends: 14d, 20h  |   8 Proposals
I am looking to automate my monthly income statements from standard excel download provided by banks and credit cards to my own customized format. Here's how it works. Every month I download monthly statements in excel files into a folder. The macro should read these files and spit out in my customized format which is really simple. If this can work in google sheets, its even better.
Category: Other IT & Programming       
Skills: Microsoft Excel, Excel VBA, google sheet       

p****ar1
 [?]
Sign in to view client's details.
| p****ar1
|    United States
Fixed Price: Less than $500   |  Posted: 3h, 49m ago  |  Closed  |   6 Proposals
I need someone to go to ceoemail.com, click on US Companies, get CEO email addresses from website, copy and paste them into an Excel spreadsheet. There will be approximately 800 email addresses.
Category: Database Development       
Skills: MySQL Administration, PHP, VBA       

h****sha
 [?]
Sign in to view client's details.
| h****sha
|    United States
Hourly Rate: Less than $10 / hr   |  Duration: Not Sure  |  Posted: 4h, 58m ago  |  Ends: 14d, 19h  |   2 Proposals
Job Title: Programmer Virtual Assistant Position Type: Part Time with ability to transition into Full Time Time Zone: Preferred to have time Assistant in our time for the morning and/or afternoon to discuss projects, error debugging, changes or answer questions. Some tasks and projects can be completed on the Programmer Virtual Assistant's own time schedule. Must be available on call for immediate support during business hours in case of emergencies. Daily Reporting: Just a simple bullet-point email at the end of each day Projected work Availability: 20 hours per week - full time depending on work productivity and speed of learning with minimal errors. Skills: General: - Eye for detail - Excellent English reading and writing - Ability to clearly follow instructions - High level of organization and ability to prioritize - Self-management and initiative Technical: - Must be advanced in VBA Macros and Excel scripting - Must know Database - Must know Data Feeds - Must know C# - Know...
Category: Other IT & Programming       
Skills: Microsoft Excel, C#, XSL, Excel VBA, Data Feeds       

s****eet
 [?]
Sign in to view client's details.
| s****eet
|    United States
Fixed Price: Not Sure   |  Posted: 6h, 25m ago  |  Ends: 14d, 17h  |   13 Proposals
Would like to use excel to populate personalized labels. Scope: Ability to populate and personalize multiple word documents, and print from one file Right now we export a CSV, edit, and then have the data, and then manually edit labels on a word doc. We'd like to edit within the CSV file, export that file, and import to auto populate hundreds of sheets. The way I imagine it, is we can use excel to edit text fields within a template: So cells: A1, A2, A3, A4 <> populate <> Sheet 1, text fields a, b, c, d B1, B2, B3, B4 <> populate <> Sheet 2, text fields a, b, c, d Each cell row is one customer, each sheet # is the label that correlates to that customer Solution can be hosted on cloud, or preferably exist on our HDs
Category: Other IT & Programming       
Skills: MySQL Administration, HTML, PHP, Adobe PDF, Excel VBA       

f****dog
 [?]
Sign in to view client's details.
| f****dog
|    United States
Fixed Price: Not Sure   |  Posted: 7h, 3m ago  |  Ends: 14d, 16h  |   8 Proposals
I have calibration charts of various size water tanks with fill depths ranging from 0.25" up to the tank maximum height. For each fill depth there is a corresponding volume in gallons listed for that depth. Currently I must look up the depths and volumes for a specific tank and manually insert the unknown value into the spreadsheet I'm working on. I would like to be able to have the unknown depth or volume be automatically pulled from a table and inserted into the spreadsheet if I specify the tank size and the other known value. The current calibration charts are enclosed. The dipstick (depth in inches) and volume (gallons) is shown on the page for each tank. The various tank sizes are shown on each worksheet and are labeled with the tank diameter in feet followed by the total volume in 1,000 gallons. For example, a 10-20 tank is a 10' diameter tank with a total volume of 20,000 gallons. I would like to know if what I want is doable and the cost to create this data table. P...
Category: Data Engineering       
Skills: Spreadsheets, Excel VBA       

k****fee
 [?]
Sign in to view client's details.
| k****fee
|    United States
Hourly Rate: Not Sure   |  Duration: Not Sure  |  Posted: 7h, 15m ago  |  Closed  |   10 Proposals
We need an Excel VBA Macro that will allow for charts to be extracted and saved as individual workbooks. The macro will need to navigate through an Excel workbook, extract the chart objects, place them into their own individual workbooks (not as images), prompt the user to enter the title for the chart (which will then become the file name as well), break the link to the old workbook, extract the data from the chart and create a table that reflects that data.
Category: Data Analysis       
Skills: Excel VBA       

s****er1
 [?]
Sign in to view client's details.
| s****er1
|    United States
Fixed Price: $50 or less   |  Posted: 7h, 22m ago  |  Ends: 14d, 16h  |   15 Proposals
Excel Spreadsheet that needs modification Print modification to specific row that needs to be done by a button Should be a quick job
Category: Other IT & Programming       
Skills: Microsoft Excel, Visual Basic, Excel VBA       

A****ove
 [?]
Sign in to view client's details.
| A****ove
|    Canada
Hourly Rate: Not Sure   |  Duration: Not Sure  |  Posted: 7h, 31m ago  |  Ends: 14d, 16h  |   2 Proposals
This job will be using Microsoft Excel to create a software mockup so I can see the functionality of what I want to create. I have maps and a flow that I'd like you to create on an interactive Excel spreadsheet. The spreadsheet will eventually be used to have multiple people collaborate on the sheet, showing real-time updates as people input data. Candidate should be an expert in Excel spreadsheet creation, and have the ability to create a visually pleasing spreadsheet interface based on what I would like to see and the data put in. Candidate should be able to work quickly and be very good at communication via email and/or Skype.
Category: Other IT & Programming       
Skills: Excel VBA       

j****is2
 [?]
Sign in to view client's details.
| j****is2
|    United States
Fixed Price: Less than $500   |  Posted: 8h, 2m ago  |  Closed  |   12 Proposals
I want to create an excel s/sheet with historical sports results for the English Aviva Premiership Rugby Union competition. All the data can be found here:   [obscured]  /wiki/2007?08_English_Premiership_(rugby_union)   [obscured]  /wiki/2008?09_English_Premiership_(rugby_union)   [obscured]  /wiki/2009?10_English_Premiership_(rugby_union)   [obscured]  /wiki/2010?11_English_Premiership_(rugby_union)   [obscured]  /wiki/2011?12_English_Premiership_(rugby_union)   [obscured]  /wiki/2012?13_English_Premiership_(rugby_union)   [obscured]  /wiki/2013?14_English_Premiership_(rugby_union)   [obscured]  /wiki/2014?15_English_Premiership_(rugby_union) Note: The 2015 season is still in progress so not complete set of results. For each season I want to get the following data into a separate cell in the s/sheet: a) Fixture date and kick off time in the following format yyyy-dd-mm hh:mm:ss. Example: 2010-06-27 17:...
Category: Data Analysis       

****
 [?]
Sign in to view client's details.
| Client
|    United Kingdom
Fixed Price: $500 - $1,000   |  Posted: 8h, 8m ago  |  Ends: 1d, 15h  |   7 Proposals
MS Access, VBA/Macro based new CRM solution. Looking forward to an easy to use CRM Solution with intuitive, plug and play / modular architecture for listed CRM modules, like, track client interaction, log various methods used in client interaction, add/edit new clients, users, companies Customization mass emailing, template driven, plugin for MS Access based CRM system; Outlook Integration and VBA/Macro coding expert Database Migration expert required to complete the migration of MS Access 2013 database to SQL Server 2008 R2. May need to analyze and re-code few objects of the MS Access solution that do not directly migrate to SQL Server.
Category: Database Development       
Skills: Microsoft Access Administration, CRM       

z****eem
 [?]
Sign in to view client's details.
| z****eem
|    United Kingdom
Fixed Price: $20 - $100   |  Posted: 10h, 46m ago  |  Ends: 6d, 13h  |   18 Proposals
Hey, I'm wanting to create a vba script to get some data by an API and input it into a sheet. PLEASE SEE THE ATTACHED DOCUMENT FOR DETAILS! It should only take 1-2 hours to code this, so should be easy. Thanks
Category: Other IT & Programming       
Skills: Microsoft Excel, VBA, Excel VBA       

R****D90
 [?]
Sign in to view client's details.
| R****D90
|    United Kingdom
Fixed Price: $30 - $50   |  Posted: 11h, 9m ago  |  Ends: 6d, 12h  |   3 Proposals
I have an Excel workbook that works well on the PC but needs to be tweaked to work on the Mac. Basic issue is that the Retrieve button doesn't work. Save button code may need to be checked too. Please take a look and quote me a price. I need this as soon as possible.
Category: Software Application       
Skills: mac excel vba, mac os       

S****ugJ
 [?]
Sign in to view client's details.
| S****ugJ
|    United States
Fixed Price: Not Sure   |  Posted: 12h, 31m ago  |  Ends: 2d, 11h  |   12 Proposals
I have a 9 page step by step instruction of an Excel worksheet. I need an expert to program it from this attachment and then add automatic iteration such that the worksheet can perform the same calculations until a convergence occurs. No need to know engineering, just excel programming with good grasp of technical charts and professional looking output on a 8.5" x 11" paper. Only algebraic equations are involved. Please attach sample of your work showing iteration or automatic search feature. Two week turnaround using Excel 2010 or 2013 is preferred. Please no pre-bid queries.
Category: Software Application       
Skills: Microsoft Excel, Excel VBA       

L****000
 [?]
Sign in to view client's details.
| L****000
|    United States
Hourly Rate: Not Sure   |  Duration: 3-4 weeks  |  Posted: 13h, 11m ago  |  Ends: 14d, 10h  |   12 Proposals
We need to create a purchasing data base that contains current and past bought products, that can be easily turned into a price list for site specific requirements. Certain parts have numorous suppliers and numerous prices. The price list sent to each factory (about 72 factories in total) will show the delivered cost of the parts to that factory only, so a complete price list (made up of all prices to all factories) is not workable. The database/spreadsheet must be easy to add to as more and more factories and parts are required.
Category: Database Development       
Preferred Location: United Kingdom

M****ngs
 [?]
Sign in to view client's details.
| M****ngs
|    United Kingdom
Fixed Price: Less than $500   |  Posted: Apr 19, 2015  |  Ends: 13d, 20h  |   8 Proposals
I need an excel written that will data mine/scrape information from a website and then plug the information into a corresponding table. I have a chart created that pulls data from the table, and I would like the script to then save all the chart images into a single file. The data being pulled is Option Interest data (stock market related) from max-pain.com. Because I will want to pull data for multiple tickers/symbols (i.e. $AAPL, $AMZN, $TWTR, etc . . .), the script will need to mine the data from multiple pages as each ticker has it's own independent page. To see the data being scraped, here's the Option Interest Data at the website:   [obscured]  /q/op?s=AAPL&straddle=true&date=1429833600 I've attached the spreadsheet with the strikes and option interest data as well as the corresponding chart that is created from the data. Basically I am wanting a script that will pull this data from the website, update the data table so that the chart will reflect the...
Category: Data Analysis       

r****ndh
 [?]
Sign in to view client's details.
| r****ndh
|    United States
Fixed Price: Not Sure   |  Posted: Apr 19, 2015  |  Ends: 13d, 19h  |   12 Proposals
I am looking for someone to code a program that will search a list of sites and then scrape data into excel. I most likely will want someone use vba in excel but would be open to alternatives. The list of sites is as follows: Peoplewise.com BeenVerified.com InstantCheckmate.com USPeopleRecords.com Intelius.com ZabaSearch.com Phonebook.com DateCheck.com LookUpAnyone.com ISearch.com Spoke.com PublicRecords.com PublicRecords360.com PeopleFinders.com PeopleFinder.com PrivateEye.com USAPeopleSearch.com PeekYou.com PeopleSmart.com Spokeo.com USSearch.com Verispy.com CriminalRecords.com Persopo.com LookUp.com CheckPeople.com AnyWho.com PeopleData.com Backgroundalert.com I will want to be able to enter identifiers and then have program search sites and scrape results into excel. I will want the link to the results as well to be scraped. The sites do not have uniform search criteria. However, most common are first name, middle name, last name, city, state, age.
Category: Other IT & Programming       
Skills: Excel VBA       

T****HLF
 [?]
Sign in to view client's details.
| T****HLF
|    United States
Fixed Price: $20 - $25   |  Posted: Apr 19, 2015  |  Ends: 13d, 17h  |   13 Proposals
Hi, I have an excel file in which column A, Column B contains part numbers.. A100,S4500, H4963.. soo on 1983 approx unique numbers on column A... Column B is grouping number, for example column A - row 1, row 2, row 3, row 4... n could be s4800 then column A row 5, 6, 8... could be S4801 etc.. I want to search for each number on column A on J: or folder, If file name matches or contains value from column A, that location should be hyperlinked to column F. Someone with expert skills should get it done in under 1 hour. I expect lttle bit of tweaking. End product should be a windows form Input: I'll upload excel file - Solftware then search for values in column A for file at location which I'll specify in the software. Please bid if you are interested..
Category: Software Application       

s****asv
 [?]
Sign in to view client's details.
| s****asv
|    Canada
Hourly Rate: Not Sure   |  Duration: Not Sure  |  Posted: Apr 19, 2015  |  Closed  |   1 Proposal
I need to showcase powerbi features to a group of people, and I would like someone to help me customize interesting functionality within powerbi. Perhaps having something happen onclick or mouseover events? Your suggestions are welcome. Irrelevant proposals will be ignored.
Category: Business Intelligence       
Skills: Microsoft Excel, Business intelligence       

a****man
 [?]
Sign in to view client's details.
| a****man
|    United States
Fixed Price: Less than $500   |  Posted: Apr 19, 2015  |  Closed  |   10 Proposals
I want to create an excel s/sheet with historical sports results for the Australian National Rugby League competition. All the data can be found here:   [obscured]  /wiki/2007_NRL_season_results   [obscured]  /wiki/2008_NRL_season_results   [obscured]  /wiki/2009_NRL_season_results   [obscured]  /wiki/2010_NRL_season_results   [obscured]  /wiki/2011_NRL_season_results   [obscured]  /wiki/2012_NRL_season_results   [obscured]  /wiki/2013_NRL_season_results   [obscured]  /wiki/2014_NRL_season_results   [obscured]  /wiki/2015_NRL_season_results Note: The 2015 season is up-to-date as of Round 7 For each season I want to get the following data into a separate cell in the s/sheet: a) Fixture date and kick off time in the following format yyyy-dd-mm hh:mm:ss. Example: 2010-06-27 17:45:00 b) HomeTeam e.g. Melbourne Storm c) AwayTeam e.g. Paramatta Eeels d) HomeScore e.g. 10 e) AwayScore e.g. 20 f) Sta...
Category: Data Analysis       

****
 [?]
Sign in to view client's details.
| Client
|    United Kingdom
Fixed Price: Less than $500   |  Posted: Apr 19, 2015  |  Closed  |   5 Proposals
I am looking for someone who will write short and simple VBA code that will modify xls file. The macro should: - open all available files one by one from Folder X - they are in csv format - modify the data in the file (you can compare the before and the after file) - save the new files as xlsx in Folder Y Once the change has been completed - all files from Folder X can be deleted (if VBA allows such operation) - but this is not "must have". Operations that need to be performed in the file: - remove the header of the file, so that there is plain data that we then import to database - add/create first column with SN: - same value for all rows - modify the data column - add Generated kWh column - there is a formula there. Any questions? please let me know.
Category: Data Analysis       
Skills: VBA, Excel VBA       

b****per
 [?]
Sign in to view client's details.
| b****per
|    Poland
Fixed Price: $20 - $30   |  Posted: Apr 19, 2015  |  Closed  |   11 Proposals
Hello, I have an Excel file that needs it's macro updated. There is a current insert rows macro that copies the formula from above and inserts a row. When you go back to this location and execute the macro again, the formula isn't dynamic. Instructions tab has more details. Thanks
Category: Other IT & Programming       
Skills: Microsoft Excel, VBA, Excel VBA       

R****d11
 [?]
Sign in to view client's details.
| R****d11
|    United States
Fixed Price: Not Sure   |  Posted: Apr 19, 2015  |  Ends: 13d, 8h  |   14 Proposals
- Create a programme, macro or plug-in that could be used in to pull selected financial data (end-of-day stock prices, earnings per share, book value etc) into an excel spreadsheet to be integrated into a financial model. - The programme should be able to handle around 1,000 stock quotes from exchanges globally (US, HK, Europe, Singapore, Australia etc). - At the click of a button, the financial data should be able to be refreshed automatically. Type of application development required: Modification to Current Application Integration requirements: Requires Integration Purpose or functionality of application: Excel Platform(s) desired for application: Windows Graphical User Interface requirements: No Application to run over network: Yes
Category: Business Intelligence       
Skills: Microsoft Excel, Excel VBA       

c****ong
 [?]
Sign in to view client's details.
| c****ong
|    Singapore
Fixed Price: Less than $500   |  Posted: Apr 19, 2015  |  Closed  |   13 Proposals
Need a excel template, to automate a set of steps for an excel sheet. Data, and doc with the steps mentioned will be provided, you have to make an excel which will perform all those steps and only some of the input data should be entered.
Category: Data Analysis       
Skills: Excel VBA       

k****a13
 [?]
Sign in to view client's details.
| k****a13
|    India
Fixed Price: $500 - $1,000   |  Posted: Apr 18, 2015  |  Ends: 13d, 0h  |   37 Proposals
We are a manufacturer of cylinders and are looking for someone who can simplify the code our current system in Excel. My new versions of excel does not include the old and perfectly fine calendar, that I can find, that we need to identify ship dates. I will need another solution. I created the current version and it is not in the most organized order. I can/will help with any process flows. Would also consider upgrading to access database to allow for multiply users. I have attached our current version but have removed many of the customers and history due to the size of the file.
Category: Database Development       

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