+ Reply to Thread
Results 1 to 5 of 5

Revenue Excelsheet with corresponding Macro, HOW?!

  1. #1
    Registered User
    Join Date
    11-25-2017
    Location
    Köln, Deutschland
    MS-Off Ver
    2016
    Posts
    3

    Question Revenue Excelsheet with corresponding Macro, HOW?!

    Hi everyone,

    this is my first post, so please don't be to hard on me for not explaining well...

    I have to create an Excelsheet for work in which I have to document the Revenue and Roomnights produced by different Countries. The idea is, that I have one sheet to put in the data starting in 2013 for each month and then having a second sheet where I only see specific data. As far as I have understood it, you can use a dropdown menu to choose the different dates. However, I am not sure how to connect the dropdown menu to the list so that the output data actually changes with the month I choose on the menu.

    Hope somebody can help me

  2. #2
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex, UK
    MS-Off Ver
    365
    Posts
    7,468

    Re: Revenue Excelsheet with corresponding Macro, HOW?!

    Could we see a workbook with some sample data?
    Would be helpful if you could also manually create your expected outcome.
    We can then assist with formulas etc. to produce that automatically.

    BSB

  3. #3
    Registered User
    Join Date
    11-25-2017
    Location
    Köln, Deutschland
    MS-Off Ver
    2016
    Posts
    3

    Re: Revenue Excelsheet with corresponding Macro, HOW?!

    How do I upload an excel sheet?

    I do have a similar one but I don't understand what the person who created the sheet did...

  4. #4
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex, UK
    MS-Off Ver
    365
    Posts
    7,468

    Re: Revenue Excelsheet with corresponding Macro, HOW?!

    Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

    BSB

  5. #5
    Registered User
    Join Date
    11-25-2017
    Location
    Köln, Deutschland
    MS-Off Ver
    2016
    Posts
    3

    Re: Revenue Excelsheet with corresponding Macro, HOW?!

    For some reason the upload always fails...

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 7
    Last Post: 11-18-2015, 02:33 AM
  2. Revenue Calculation based on Variable revenue Percentage
    By suhabthan in forum Excel General
    Replies: 0
    Last Post: 06-19-2014, 12:48 PM
  3. Compare two columns in different excelsheet using vbscript macro
    By Swetha_Moni in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-03-2012, 09:53 AM
  4. [SOLVED] Difference between total revenue - last days revenue
    By vinodt in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 10-08-2012, 02:35 PM
  5. Replies: 1
    Last Post: 12-16-2009, 07:09 AM
  6. [SOLVED] How to use a macro from another excelsheet
    By Jeroen in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-24-2006, 10:25 AM
  7. How can I automatic insert tekst from excelsheet using macro
    By Paul Tikken in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-21-2006, 06:25 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1