dashboard

  1. J

    Guidance: Data table setup for Dashboard (Pivot Charts) Output

    Hi, Looking for guidance to create a Dashboard for quanties of stock, cashflow and other KPIs. I have table of data where: Column A = Date (ordered, earliest to latest) Column B = "In" or "Out" (if it's stock received or stock dispatched) Column C = Product code (e.g. 1, 2, 3, 4, 5) Column D =...
  2. U

    Filter Data on one sheet with dropdown list from another sheet

    I have an excel file with 3 Sheets - Dashboard, Funnel and DDL The Dashboard is used to display the summed up data from the funnel sheet The Funnel is used for user entry DDL - is my sheet uses for drop down lists What i would like to do is on the Dashboard sheet, add a drop down (which i have...
  3. P

    VlookUp

    I have a table with multiple columns. I am wanting to search one of those columns to find if there is a value > 0. If so, I want it to return back to a main table dashboard that value in one column and in the second column, it will return the number in the column it was searching. It would...
  4. B

    Match multiple criteria returns a specific result

    I am trying to build a vacation scheduler for a staff of approx. 100 staff and most of it works fine but I can't figure out one last piece. What I have is a dashboard, a staff list, a vacation list and then a DOR (day of rest) list. The dashboard has each employees name in B9:B100 Dates are...
  5. N

    Excel worksheet in Teams

    Hi all, My workplace has recently moved across to O365 and use Teams. Within our Sharepoint file structure/Teams, we have a workbook that is manually updated each week. In the workbook, I have a sheet, called 'Dashboard'. On it there are a series of view only charts. Does anyone know how I can...
  6. B

    Pull a specific data range from spreadsheet and offset when the month changes??

    Good afternoon all, I want to select 3 columns of data from my spreadsheet which will be displayed in a chart on my dashboard, for example Column headers are Jun 19/Jul 19/Aug 19, when I get in to the month of September I want the selection to move along one column and then select Jul 19/Aug...
  7. J

    Pivot table auto refresh, live dashboard update

    Hi, I have a data table turned into a pivot table. I want to use this pivot table to drive a dashboard (i.e. slicers, timelines other interaction) A user needs to be able to change variables which updates data table which in turn updates pivot table and dashboardE.g. a variable that affects a...
  8. S

    Google Datastudio alternative when using Excel

    Dear all I'm currently using Google Sheets to manage my stock portfolio. The system is to enter day which is tweaked and analyzed in many ways. To visualize data, current status and that I'm (hopefully) on track I use Google Datastudio. Actually I would like to move from Google Sheets to Excel...
  9. P

    Dashboard for data on multiple worksheets

    I have a file with multiple worksheets. Each worksheet has the same format, and each column shares a lot of the same data. Each worksheet is for a project that my team and I work on. What I would like to do is create a Dashboard for each team member which would show the tasks they are assigned...
  10. tlc53

    VBA Save PDF file of each sheet from Dashboard

    Hi, In my Dashboard sheet I have totals that feed through from each of the client sheets. Next to these totals, in column G, I have check boxes. I would like a saving macro to run if the check box is ticked. So; Sheet1 (Dashboard) Check box ticked - save pdf file of Sheet4 (Cordis) Check box...
  11. A

    How to save an excel Dashboard as an interactive web page

    Dear Excel experts, I made a nice dashboard in excel with graphs (from pivot tables) with slicers. I want to save this excel dashboard as a webpage, while maintaining the functionalities (using the slicer to select things, on which the graph automatically adjusts itself). Saving as a webpage...
  12. K

    Custom Print Pages VBA

    Hi All, I am trying to write VBA code for a CommandButton. I want the button to print in pdf a Dashboard from a tab in my worksheet called "Dashboard". It has 21 pages at the moment but I want to print it as one document and different pages need different scaling/margin settings. Is it...
  13. P

    Lookup value from another table

    I have a Workbook with tabs and each tab contains a table. Each table is the same format (Column A is ColA, Column B is ColB, etc). One of my tabs is a dashboard, where I want to retrieve values from each tab: Dashboard tab Column H will look into table Data-A and return the value of Column H...
  14. B

    Formule not refreshing

    Hey all, i use the following code to pull data from another workbook; =IF(INDEX('P:\000 Dashboard Production\Tabellen nieuw\[Bezetting 2019.xlsx]Planning'!$A$6:A69;ROW())=0;"";INDEX('P:\000 Dashboard Production\Tabellen nieuw\[Bezetting 2019.xlsx]Planning'!$A$6:A69;ROW())) The data in this...
  15. A

    Dynamically paste hyperlink to another sheet

    Hello, I have a macro that currently pastes text and charts to a Dashboard sheet from several other pre-formatted sheets. The pre-formatted sheets are copied and renamed by another macro, when the user wants to create a new sheet of one of the 5 template types we have in this tool. I would like...
  16. P

    VBA to expand pivot table

    Hi, I have 24 pivots in sheet1 and in sheet2 I have a dashboard which will have the numbers from the Pivot output. I have used GETPIVOTDATA to fetch the data from Pivot to my dashboard Table. I have 5 slicers connected to all the 24 pivots. I have years as data in one of the pivot as columns...
  17. R

    Copy Worksheet as Data with Charts

    Hi all, I have been reading a lot of content here over the years and would like to congratulate the helpful community for the fantastically helpful work all of you have provided here. How, I am posting here for the first time, as I can't find a solution to my problem using the search function...
  18. A

    VBA to filter by criteria

    Hey guys, I am trying to write a VBA way of filtering between two dates and by one criteria. For exmaple, I have a data on a sheet called "Sales Data" and date fields that are set in two different cells and a name in a third cell on "Dashboard". I want to be able to filter "Sales Data"...
  19. I

    How to pull data for quarterly and annually information?

    Hi friends I am struggling to build a dashboard which shows quarterly and annual results side by side. I have my detailed sales information in another sheet like this: Column A Column B to Column AZ # of Referrals Month wise data (i.e. the # of referrals...
  20. D

    Shapes linked to single cells not updating

    Hi, I've been looking all over the place for a solution to this but have yet to find one the fixes my problem permanently. I'm new to the forum so please let me know if something is incorrect with my post. I've created a dashboard on excel that mainly consists of tables and graphs; but I also...

Some videos you may like

This Week's Hot Topics

Top