+ Reply to Thread
Results 1 to 1 of 1

✰✰✰ How To Automatically Update a Dashboard Based on Multiple Sheets ✰✰✰

Hybrid View

  1. #1
    Registered User
    Join Date
    10-26-2012
    Location
    Romania
    MS-Off Ver
    Excel 2013
    Posts
    1

    Cool ✰✰✰ How To Automatically Update a Dashboard Based on Multiple Sheets ✰✰✰

    Hello everyone,

    For the past few days i am trying to solve a problem for the PPC company that i work. Basically, i am trying to create a Excel dashboard that can sort PPC data, based on other sheets. I have attached the doc to this post, maybe you guys can come with something up.

    Here are the things that i am trying to achieve with this dashboard:

    - in the dashboard sheet, i want to be able to sort data, based on the "Accounts" sheet;
    - in the "Optimization Criteria" field, from the Dashboard sheet, i have added 4 criteria to sort the data:
    1. Account - is a validation box that allows me to select through different accounts;
    2. Campaign Type - is a validation box that allows me to select through different campaign types;
    3. Optimization Type - ------------------------||----------------------------- optimization types;
    4. Campaign Issues - ------------------------||----------------------------- campaign issues;

    - below the "Optimization Criteria" there is a table. The point for this table, is that whenever i select a account in "the account validation box", i want the data from the "Accounts" sheet, to be automatically added to table.

    If, for example i want to sort the account data by campaign type, i would like to see in the table, only the columns for that specific sort i made.
    And so on.

    Tomorrow is my birthday and if i can get this problem solved, it will be the best gift ever.

    Thank you.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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