Vba Jobs

268 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}})
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
Fixed-Price - Intermediate ($$) - Est. Budget: $200 - Posted
We're looking for someone who can help us develop the financial plan for our start-up. We're both creative individuals and we're not great with numbers and statistics, however we understand the importance of the finance aspect of a business. With that said we need help with figuring out cost of goods, break even point, expenses, payroll, and pricing. **We currently have no data and we are unsure where to start. With that said we are looking for someone who will be willing to help us put together all the pieces of the puzzle.
Skills: Excel VBA Accounting Cost accounting Financial Accounting
Hourly - Expert ($$$) - Est. Time: Less than 1 month, Less than 10 hrs/week - Posted
Looking for someone to help edit/redo financial projections for an investors deck that include IRR, ROI, NPV, budgeting, financial modeling and forecasting. I have most of it done, just need help adding to it and finishing it. The company is vertically integrated legal marijuana company that is raising money from sophisticated investors.
Skills: VBA Accounting Budgeting & Forecasting Business Coaching
Fixed-Price - Intermediate ($$) - Est. Budget: $30 - Posted
All I need is to extract to Excel (Date, Price, Open, High, Low, Vol. and Change %) from: http://www.investing.com/indices/us-30-historical-data Code must be in Excel - VBA. Start date must be taken from a specific cell. End date must be the last of the current year.
Skills: Excel VBA VBA Web scraping