Vba Jobs

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

show all
  • Hourly ({{ jobTypeController.getFacetCount("0")|number:0}})
  • Fixed Price ({{ jobTypeController.getFacetCount("1")|number:0}})
Hourly - Entry Level ($) - Est. Time: 3 to 6 months, 10-30 hrs/week - Posted
Project # Part-1 This is the first part of a long project that will use VBA to investigate several capital budgeting methods Initial Assignment: The Assignment will involve generating projects with various characteristics, ranking the projects using several methods, buying projects using available money, and continuing this process for five capital budgeting periods (years). ... This project needs to be done in Excel using VBA. A VBA macro button needs to be placed on the initial sheet clearly visible when in the home (A1) location.
Skills: Excel VBA Financial analysis
Hourly - Entry Level ($) - Est. Time: 1 to 3 months, Less than 10 hrs/week - Posted
I am looking someone who is very good at VBA scripts. Good communication skills, understand requirement efficiently, meet the commitment, delivery requirement timely.
Skills: VBA
Hourly - Intermediate ($$) - Est. Time: Less than 1 month, 10-30 hrs/week - Posted
Hello Upworkers, I have two projects which require Microsoft Outlook and Office Add-ins. The detailed requirements are listed below: Add-in 1: Query Xero Practice Manager (XPM) via Outlook and Office 2013/16 I use an application called Xero Practice Manager (API’s accessible here https://developer.xero.com/documentation/practice-manager/overview-practice-manager-api/ and here https://www.workflowmax.com/api/client-methods) and need an Add-in to do the following with MS Outlook and MS Office: 1. Create, edit and save an email/word template. The templates must be centrally saved to a Box.com account 2. The body of the template will contain variable data fields 3. The variable data fields will be pre-populated by querying XPM (via API) based on the Client ID and return the following a. First Name b. Surname c. Address d. Business Name e. City, Postcode and about 6 other fields within the body of the template. These will be simple API calls to XPM 4. A very good example of how this works can be found in a product called Suite Files. Please scroll to the 14th minute in this YouTube video for 5-6 minutes as it explains the requirement very well https://www.youtube.com/watch?v=rxkCVqV9JzM Add-in 2: Box.com Folder Tree within Outlook 2013/16 I use Box.com and require an Outlook Add-in which provides me with the Box.com Folder Tree within Outlook 2013/16. The objective here is that I do not want to access files from Windows Explorer, I want full access to files from within a folder tree in Outlook. Below are some of the specifics that I require: 1. Must have ability to drag and drop email files from the Inbox to a folder within the add-in 2. Must have ability to drag and drop attachment files from Inbox to a folder within the add-in 3. Must have ability to browse folder tree and drag attachments into the body of an email or optionally create a secure Box link to the file 4. Must have full search capability within the folder tree in Outlook 5. Must have ability to create, modify and delete files/folders based on permission type (this is based on the user’s Box account) 6. All search filters from the Box API must also be included i.e. name, folder, doc type, date range, metadata etc 7. The view in the folder tree should also allow a file preview (email preview from within the add-in) 8. There must also be an option which allows to you to see recent files and create favourite to folders for quick access 9. When searching the email files within the folder tree, need filters to searh on ‘From’, ‘Subject’, ‘Body’ fields 10. Need to ability to attach documents from the Box.com folder tree to an email N.B. do not want to attach links, it must be documents 11. Need ability to ‘file email right after it is sent to a Box folder’ i.e. save on send. This should be an option which you can enable and disable 12. From within the Box.com folder tree, you should have the ability to right click on a file which gives you options to: a. ‘Attach to new email’ – this would then open a new email screen b. Rename File c. Download and Open d. Edit Document in App 13. Need ability to drag and drop files from Windows Explorer to the Box tree within Outlook 14. All these features are available in the Box API viewable here https://docs.box.com/docs 15. A very good example of how this works can be found in a product called Suite Files. Please scroll to the 6th minute in this YouTube video for 5-6 minutes as it explains the requirement very well https://www.youtube.com/watch?v=rxkCVqV9JzM Within your proposal, please allow for some possible changes during the software development cycle. Please also specify your anticipated effort to deliver both these projects. Look forward to hearing from you
Skills: VBA .NET Framework C# C++
Fixed-Price - Intermediate ($$) - Est. Budget: $50 - Posted
We have .csv files exported from Wistia (a video hosting service). These files contain video viewing data such as # of plays, hours watched, % viewed, etc. We would like to get more granular information based on these data by breaking down each stat according to user, type of video, etc. Please find the attached Excel file to see Wistia data (see "Wistia raw export" worksheet) and the type of information we'd like to extract from it (see "Information needed" worksheet). We would then like to have a way of visualizing such information easily, for example if we want to see how many hours user X spends viewing video type Y. Excel should be adequate for our purpose, but we are open to suggestions.
Skills: Excel VBA Microsoft Excel Microsoft Excel PowerPivot
Hourly - Entry Level ($) - Est. Time: More than 6 months, Less than 10 hrs/week - Posted
Hello, We are looking for .NET Developer with excellent coding knowledge Create and deliver data-driven reports Design, code, document and test software applications. Object Oriented Programming design in ASP.NET MVC 4.5 HTML 5 and CSS 3 Entity Framework 5 AJAX Calificaciones Extensive experience in Object Oriented Programming design in ASP.NET MVC
Skills: VBA ASP.NET C# CSS
Hourly - Entry Level ($) - Est. Time: 1 to 3 months, 30+ hrs/week - Posted
We already started with a company database covering our full company processes. After spending a lot of time we got stuck with cetrain problems and issue so the database is quick and efficient. The concept is clear for us and we need somebody who is an expert and can complete the work asap.
Skills: VBA Database design
Fixed-Price - Intermediate ($$) - Est. Budget: $800 - Posted
Hello, We currently have a programme/piece of software that we use to generate our survey forms. We have the installation software for the programme but that is all... We are looking to improve the software system that we currently use by making some much need enhancements, we previously had a freelancer working on this who we have lost full communication with, so we have had to start from scratch again... We require a developer to " Re-write" the full package to suit out new format of outputs The system consists of a front end "Data Input" sheet which populates several tabs with an excel sheet and exports out a excel file in our client survey sheet - developed using Microsoft Visual Studio. I have attached a sample of our current output which need enhancements and the front end "Data Input" sheet. At this stage hopefully this explains what we are after the full details of the changes will be agreed once we decide what option from the above is best. This will be a fixed price contact paid on completion. Thanks Gary
Skills: Excel VBA VBA
Hourly - Intermediate ($$) - Est. Time: Less than 1 week, 10-30 hrs/week - Posted
I am looking for an excel expert to built and workbook that will automate and generate reports based on raw data and keywords. I will provide an example with a mockup report to help visualizing the needs. I have a workbook with multiple tabs: * Raw Data * List with SKUs * List with terms (Brands) * List with terms (Keywords) This data is added manually, and using this we need to generate several reports. (Please look at the attached file) Using the data from the exiting tabs we generate the following reports. Report #1: Sku report AUTOMATION I this report we use the "Raw Data" tab and the "List with SKUs" tab data. The idea of this report is to display all the data available for each SKU. To do this, we check the search terms form "Raw Data" column A. And this is compared with the list of SKU. If there is a match the data is added to the report. Each SKU should report the total for all the possible matches. SKUs with out matches within the "Raw Data" tab don't need to be reported. _______________ Report #2: For each of the brands and keywords tabs, need new to create a new tab called with the "brand" or "keyword" and report all the search terms that contain the "brand" or "keyword" If you look at the example attached will be easier to understand what need to be done. The tab with the RAW data and SKU could contain 100k+ rows on a real report. If you are interested in the task i will be able to provide further details and answer all your questions.
Skills: VBA Automation Microsoft Excel
Fixed-Price - Intermediate ($$) - Est. Budget: $20 - Posted
Looking for a expert in google sheets or microsoft excel to configure a few sheets and generate some reports We have a file that contains customer data with unique serial number / stock code of the product purchased. And another file that contains the product serial number and the Distributor of that serial number We want to generate reports of the customer data of each distributor from this 2 files. The system should automatically generate reports as we add more data to both files. More details can be discussed privately
Skills: Excel VBA Google Docs Microsoft Excel Microsoft Excel PowerPivot