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

Vba Jobs

145 were found based on your criteria {{ paging.total | number:0 }} were found based on your criteria

show all
  • Hourly ({{ jobTypeController.getFacetCount("hourly") | number:0}})
  • Fixed Price ({{ jobTypeController.getFacetCount("fixed") | number:0}})
show all
only
only
only
show all
only
only
only
only
only
show all
only
only
only
Looking for the Team App?
Download the New Upwork Team App
Hourly - Entry Level ($) - Est. Time: 1 to 3 months, 10-30 hrs/week - Posted
We utilize microsoft access to control business functions and I am in need of a skilled programmer who can assist me in the detailing out the more tasks. Immediately I am building an inventory/Pick/Pack system which needs some Dsum work. I have several databases we use that run different aspects of the business and there is ongoing work needed on these. You must be very skilled in database programming. I understand that Access is not as sophisticated as others but it works for us and knowledge of how to get the most out of it is essential. To be successful you must communicate well in English and be able to understand what I am trying to achieve and develop the best solution for it. You should be able to suggest better ways of organizing and executing processes as you see fit. This would be an ongoing relationship as a IT programmer for our systems. They are admittedly "homemade" at this point so a greater level of sophistication is needed.
Skills: VBA database programming Microsoft Access Programming
Hourly - Intermediate ($$) - Est. Time: Less than 1 week, Less than 10 hrs/week - Posted
I have a suite of online courses. I have students that buy my courses outright and I have students that get into the courses for free through a free coupon. My free coupons unfortunately have proliferated quite a bit around the web, so I'm considering shutting them off (not allowing any new free students). I have a list of 12 excel sheets that are quite messy. They show my monthly revenue for ach month and they tie them to a student name. I need someone with excel skills to calculate just how much the value of a free student is. That is to say, IF a student joins one of my courses first, how much do they on average spend on my other courses. I run promotions bi-monthly and have a lot of cross enrollments. You'll need to go to each excel and see the names of the free students, then compare them across the other sheets to the names of the paid students. If there are matches then calculate the amount they purchase and add that into the total average. Attached is a sample monthly earnings report. *Please keep in mind: there are many students that use the same name but are different people. You will need to control for this possibility and to save the datas integrity remove any names that that appear to be duplicate (ie listed as enrolled in the same course twice, either paid or free)* We can talk in private message over more details to make sure we're on the same page.
Skills: Excel VBA Data Analytics Data Entry Data Modeling
Fixed-Price - Entry Level ($) - Est. Budget: $250 - Posted
I have a change log that and a change report. Currently, I update the change report manually. I would like the change report to be populated automatically from the change log. The format of both the change log and report are finished and I don't want to change them (if possible).
Skills: Excel VBA Microsoft Excel
Hourly - Entry Level ($) - Est. Time: More than 6 months, Less than 10 hrs/week - Posted
Statistical time series analysis of energy data with rapdiminer & r We are seeking an expert to build statistical models for time series data in the electric energy industry. We have timeseries data as ¼ h values representing the current energy load that a customer is consuming from the grid. We would like to do advanced statistical analysis of the energy data and represent the outcome oft he analysis in form of a report or web application. The first requirements would be: - Read a CSV timeseries file - Provide a report conatining the following information o Aggregated consumption per month o Aggregated maximum load per month with a timestamp representing the maximum energy load oft he individual month o Aggregations  Aggregated consumption per Month from Mo – Sa 09:00 – 20:00: Total Value and % value from overal consumption  Aggregated consumption from all other times: Total Value and % value from overal consumption o Monthly average of all daily minimum within one month
Skills: Excel VBA Business Analysis Data Analytics IBM SPSS
Fixed-Price - Entry Level ($) - Est. Budget: $35 - Posted
I have 2 spreadsheets that need VBA/macros created. The spreadsheet will have a submit button and when the user clicks submit it will take certain cells on the sheet to create the file name and save the file to a register.
Skills: Excel VBA Microsoft Excel
Hourly - Intermediate ($$) - Est. Time: Less than 1 week, Less than 10 hrs/week - Posted
We are working for a steel mill and can produce "any" size in the source plate (within our dimensional program): and I can't seem to find a excel script or program that quite simply finds the size of the optimal plate in the dimensional program when we get a request for plates that we have to cut down and produce combined. Commercial nesting programs all have the stock option: where they have limited options of source plates to choose from, hence I cant find any good commercial alternatives. Normally this is not a large problem, but if the specification is large andunfortunate in dimensions it would be very good to have a way of finding the optimal dimensions of the source plates. Basically: what the software should do is the following (very simple example): Settings (in a excel table that is editable): Thickness: Max Width Max Length 1 100 1000 2 200 2000 3 300 2500 I have a complete table for this http://dansteel.dk/data/files/Pllaengder%20-%202015-01-28.pdf So, I select a series of cells of the same thickness (length - width - thickness) and the program identifies the dimension and number of plates that creates the least amount of scrap (or the one that creates zero scrap). For instance: 9 pcs of 10 x 100 and 2 pcs of 5 x 50 plates would give a result of 1 plate of 100 x 1000. *The settings should have a cell padding option per thickness for all cutts that are inside of the plate. In the finished product i would like to input on the "parts" page: thickness width length pcs padding and then generate (grouped/based on thickness) the optimal sizes to produce, with the consideration that we need a minimum number of each source plate (based on the fact that we prefferably need to produce at least 3800 KG).
Skills: Excel VBA Microsoft Excel
Looking for the Team App?
Download the New Upwork Team App
Fixed Price Budget - ${{ job.amount.amount | number:0 }} to ${{ job.maxAmount.amount | number:0 }} Fixed-Price - Est. Budget: ${{ job.amount.amount | number:0 }} Open to Suggestion Hourly - Est. Time: {{ [job.duration, job.engagement].join(', ') }} - Posted
Skills: {{ skill.prettyName }}
Looking for the Team App?
Download the New Upwork Team App