+ Reply to Thread
Results 1 to 2 of 2

Data Inputting = Dashboarding

  1. #1
    Registered User
    Join Date
    11-28-2018
    Location
    Coventry, England
    MS-Off Ver
    Office 2013 + 365
    Posts
    1

    Data Inputting = Dashboarding

    I have a huge weekly data set called a 'activity sheet' that is inputted with numbers by several people per AM and PM shift

    The front end is spread over 52 tabs so 52 weeks worth of activity data

    I need to collate all this data into one master file which consists of breaking down per day per week per month per quarter and being able to build a dashboard from that data.

    Struggling with the Data Table piece - is there anyone willing to collaborate with me on this and help further? I feel there are simpler ways to do this but not entirely sure.

    Thanks

  2. #2
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    365
    Posts
    7,908

    Re: Data Inputting = Dashboarding

    You may get a better response if you post a sample workbook with enough non-sensitive, but representative data to demonstrate what you are trying to do. If needs be, manually compute what the expected result should look like.

    Also when you say "several people" per shift, do you mean that they are all trying to access this workbook at the same time? Do you have all 52 weeks in the same workbook, or do you have 52 separate workbooks?
    One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.

    A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.

+ 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. Inputting data
    By mszypa50 in forum Excel General
    Replies: 13
    Last Post: 08-14-2015, 05:27 PM
  2. Replies: 0
    Last Post: 07-26-2013, 01:27 PM
  3. Inputting Data
    By 2nice in forum Excel General
    Replies: 5
    Last Post: 09-30-2010, 05:43 PM
  4. inputting data
    By Shanor in forum Excel General
    Replies: 0
    Last Post: 06-15-2006, 05:55 AM
  5. Update a chart immediately after inputting data into data source
    By MELMEL in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 12-01-2005, 05:40 PM
  6. DASHBOARDING chart type
    By jcaranibar in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 11-02-2005, 06:20 PM
  7. [SOLVED] DASHBOARDING chart type
    By jcaranibar in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 11-02-2005, 06:17 PM

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