You've landed at the right place. oDesk is now Upwork. Learn about the new platform.

Vba Jobs

97 were found based on your criteria

show all
show all
only
only
only
show all
only
only
only
only
only
show all
only
only
only
Fixed-Price - Est. Budget: $ 50 Posted
I am needing assistance in creating a macro the list all filters in a selected cell. Sum of AMOUNT Column Labels 2014 Row Labels Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec 1000 52 9 56 13 46 19 44 39 42 24 18 20 1500 54 33 53 44 27 10 34 28 4 13 40 22 Grand Total 106 42 109 57 73 29 78 67 46 37 58 42 For instance the results would look like this for the cell with the value 34 Field Value Type Year 2015 Column Month July Column State CO Slicer Account 1250 Row Dept Clothing Filter The results would show the row, column, slicer and the filters criteria Thanks I can i
Skills: Excel VBA
Fixed-Price - Est. Budget: $ 150 Posted
Hi there, I am stuck on a project for which I need specialist advise. I am trying to set up a simple queuing system whereby a number of machines running Excel 2007 have access to a SQLite database hosted on an NFS drive. The goal of the system is for each machine to query the queue table to check whether there are any records in the queue that need to be processed. If the query returns a record then the status of that record is updated such that other machines do not pick it up for processing. Once processing is complete, we then start the process again. I have all constituent parts working fairly well but am running into 'database locked' errors. This is is spite of handling such errors by having the machine ignore such error, wait one second and try again. I have attached to this post a working example of the code which works fine for one machine but breaks down as soon as another is introduced. I am prepared to pay $150 dollars to get the answer to this problem..even if it takes...
Fixed-Price - Est. Budget: $ 100 Posted
We are currently looking for a developer. The first plan is to create some excel models and if the applicant provides good solid work we plan to merge various strategies and create a desktop platform. Developers requirements; 1) Proficient in Excel 2) Understand how to pull data from Yahoo and Interactive Brokers and use in Excel 3) Have the ability to develop desktop application in c++ and create charting program. We will provide all the formulas and strategies and we require you to complete the development side.
Hourly - Est. Time: 1 to 3 months, Less than 10 hrs/week - Posted
Looking for someone who is very skillful with Excel Macros and VBA. I have a few projects that I need completed. We will start with the easiest projects and work our way up to the most complex. The easy ones are just moving columns and adding formulas. The more complex macros will be working with manipulation of large data sets and working between multiple workbooks.
Skills: Excel VBA
Fixed-Price - Est. Budget: $ 300 Posted
I have a need for some ad Hoc programming for various queries and forms in an Access DB project that I have taken as far as my current skill level will allow me to go. I have a financial report I am creating which I need help completing the code on the query. I also have another document that isn't functioning quit right, and would like some help debugging.
Skills: VBA
Fixed-Price - Est. Budget: $ 500 Posted
Design and write program to replace old poorly implemented process of managing assets, transactions and the reporting of these transactions. Old asset management.system utilizes legacy Lotus123 spreadsheets and copy and pasting between sheets for report generation.
Fixed-Price - Est. Budget: $ 250 Posted
Require someone that is very proficient joining multiple spreadsheets into a relational database or workbook and then rendering in Power Pivot and BI for our 2013 users and Pivot table with graphs for 2010. This is a complex asset visibility and supply data analysis with a 24-48 hour turnaround. Will pay bonus for going above and beyond.
Fixed-Price - Est. Budget: $ 100 Posted
I currently plot support and resistance zones manually on a chart like the attached image. Then I manually enter these figures into MS Excel to determine if today's price is within the Support and resistance zones. WHAT I NEED I need to calculate these support and resistance levels within MS Excel programmatically or using some sort of algorithm. I currently download daily data that includes open, high, low, and close values for each currency pair or stock symbol. So this granular data can be used to calculate what is required.
Hourly - Est. Time: Less than 1 week, 10-30 hrs/week - Posted
Hi i require someone to help with creating a formula in excel to make a a value or a line of text out of a cell and place this in another cell for example MAC NC35 STUDIO SCULPT FOUNDATION SPF 15 - 40ML I would want to take the 40ML and place this into another cell I have a few other jobs related to this i would also need assistance with