+ Reply to Thread
Results 1 to 2 of 2

Displaying Sub Categories in Report

Hybrid View

  1. #1
    Registered User
    Join Date
    08-11-2016
    Location
    San Diego, California
    MS-Off Ver
    Microsoft Office Standard 2010
    Posts
    1

    Displaying Sub Categories in Report

    I have an excel spreadsheet with many columns (categories). For one of these categories I need to include a bunch of sub categories that need to be filled out as well but don't want to over-crowd the spreadsheet and would like to somehow consolidate the information.

    For example i have columns : Facility, unit description, candidate profile, contact info, etc

    Specifically for 'Unit Description' I have the following additional sub categories that need to be filled out 'unit name, unit location, director/manager, beds, AVG daily Census, etc...

    How can I show these sub categories related to Unit description but in a clean, efficient way?

    Please help!
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    10-09-2012
    Location
    Dallas, Texas
    MS-Off Ver
    MO 2010 & 2013
    Posts
    3,049

    Re: Displaying Sub Categories in Report

    I think I can help but I cannot identify exactly what you are trying to do.
    What are you trying to bucket, and into what buckets?

    Generally, in a sample workbook you want to 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.

    Also, remember to desensitize the data.
    Please ensure you mark your thread as Solved once it is. Click here to see how.
    If a post helps, please don't forget to add to our reputation by clicking the star icon in the bottom left-hand corner of a post.

+ 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. [SOLVED] need help displaying desired rows based on Yes and No question for multiple categories
    By DixieDoll11 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-07-2014, 01:48 PM
  2. Displaying an image conditional on an Access Report
    By ctsmith84 in forum Access Programming / VBA / Macros
    Replies: 1
    Last Post: 12-09-2011, 01:55 PM
  3. Displaying Current Day Inventory In Report
    By evanmorris in forum Excel General
    Replies: 5
    Last Post: 12-12-2010, 12:35 PM
  4. Replies: 2
    Last Post: 10-28-2010, 03:49 PM
  5. Problem in displaying total amount in report
    By Nancy123 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-13-2010, 12:06 PM
  6. Displaying a field in a report
    By simjambra in forum Access Tables & Databases
    Replies: 1
    Last Post: 08-10-2009, 02:47 PM
  7. Report by two categories.
    By Shams in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-06-2005, 05:00 PM

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