Vba Jobs

264 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 - 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: $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 - Expert ($$$) - Est. Budget: $300 - Posted
Looking for an excel guru to modify and existing spreadsheet. We would like to have a button within the spreadsheet that when pressed emails certain one of two worksheets within the workbook to an email address in one of the fields. The subject of the email and message would also be included in excel fields. Let me know if you can help with this.
Skills: Excel VBA Microsoft Excel
Fixed-Price - Expert ($$$) - Est. Budget: $20 - Posted
I need to write a macro in Excel (2016 for Mac) that can submit by email as a pdf a portion of a spreadsheet (outlook for Mac) I'm creating a process to submit a form for approval and all sales staff work on Mac. I have the Excel sheet and I need to send the part of the sheet (B7:J57) as a pdf to 2 or 3 email addresses. I'm attaching the file I need you to work on. The sheet is named "Calculator". The simpler the code, the better. Thanks,
Skills: Excel VBA
Hourly - Expert ($$$) - Est. Time: Less than 1 week, Less than 10 hrs/week - Posted
I use an online share brokerage firm that produces live share data for the FTSE 350, NYSE and NASDAQ stock exchanges in real time. Unfortunately, this live data does not extend to the share graphs they produce which has a 15 minute delay. The data I am specifically after that needs a line graph for each entry is the "top risers" for these exchanges which consists of the top 20 stocks for each exchange. As previously stated, this data reflects the live share price but the graphs they produce do not. Here is an example : http://www.hl.co.uk/shares/stock-market-summary/ftse-350/risers This information is best stored in an excel document that can be manually refreshed when needed. The type of graph format is a line graph format similar to what the above site has. Any questions let me know
Skills: Excel VBA Microsoft Excel Microsoft Excel PowerPivot