Results 1 to 6 of 6

Database help. From database list to nice looking list

Threaded View

  1. #1
    Registered User
    Join Date
    11-14-2016
    Location
    DK
    MS-Off Ver
    Excel 2000+
    Posts
    3

    Database help. From database list to nice looking list

    I have a database in Sheet1 that looks something like this:

    100 Category, 01 Subcategory, A Item name, Data, Data, Data ...
    100 Category, 01 Subcategory, B Item name, Data, Data, Data ...
    100 Category, 01 Subcategory, C Item name, Data, Data, Data ...
    100 Category, 01 Subcategory, D Item name, Data, Data, Data ...
    100 Category, 02 Subcategory, A Item name, Data, Data, Data ...
    100 Category, 02 Subcategory, B Item name, Data, Data, Data ...
    100 Category, 03 Subcategory, A Item name, Data, Data, Data ...
    100 Category, 03 Subcategory, B Item name, Data, Data, Data ...
    100 Category, 03 Subcategory, C Item name, Data, Data, Data ...
    200 Category, 01 Subcategory, A Item name, Data, Data, Data ...
    200 Category, 01 Subcategory, B Item name, Data, Data, Data ...
    200 Category, 01 Subcategory, C Item name, Data, Data, Data ...
    200 Category, 01 Subcategory, D Item name, Data, Data, Data ...
    200 Category, 02 Subcategory, A Item name, Data, Data, Data ...
    200 Category, 02 Subcategory, B Item name, Data, Data, Data ...
    200 Category, 03 Subcategory, A Item name, Data, Data, Data ...
    200 Category, 03 Subcategory, B Item name, Data, Data, Data ...
    200 Category, 03 Subcategory, C Item name, Data, Data, Data ...

    Commas represent cells. Category, subcategory and items of course have real names.


    How do I make a "print out" in Sheet2 that looks like this?:

    100 Category
    100.01 Subcategory
    100.01.A Item name, Data, Data, Data ...
    100.01.B Item name, Data, Data, Data ...
    100.01.C Item name, Data, Data, Data ...
    100.01.D Item name, Data, Data, Data ...
    100.02 Subcategory
    100.02.A Item name, Data, Data, Data ...
    100.02.B Item name, Data, Data, Data ...
    100.03 Subcategory
    100.03.A Item name, Data, Data, Data ...
    100.03.B Item name, Data, Data, Data ...
    100.03.C Item name, Data, Data, Data ...
    200 Category
    200.01 Subcategory
    200.01.A Item name, Data, Data, Data ...
    200.01.B Item name, Data, Data, Data ...
    200.01.C Item name, Data, Data, Data ...
    200.01.D Item name, Data, Data, Data ...
    200.02 Subcategory
    200.02.A Item name, Data, Data, Data ...
    200.02.B Item name, Data, Data, Data ...
    200.03 Subcategory
    200.03.A Item name, Data, Data, Data ...
    200.03.B Item name, Data, Data, Data ...
    200.03.C Item name, Data, Data, Data ...

    Whether items are listed as "100.01.A Item name" or simply ".A Item name" is not important.
    The main thing is that I want a nice looking list with titles and subtitles. Preferably with special text formatting applying to the titles and subtitles.

    ..
    Last edited by Trille; 11-15-2016 at 05:22 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Clean a database using a list
    By Ayadin in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 06-12-2016, 02:47 PM
  2. [SOLVED] Drop down list, form database
    By pccamara in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 02-25-2015, 07:04 AM
  3. Unique list from database
    By way2suresh in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-08-2013, 08:59 AM
  4. changing a database list
    By thedragon in forum Excel General
    Replies: 3
    Last Post: 10-30-2011, 08:50 PM
  5. VBA Deleting in database from list box
    By Jennifer in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-10-2006, 04:15 PM
  6. [SOLVED] database list
    By gtsch in forum Excel General
    Replies: 6
    Last Post: 12-14-2005, 02:20 PM
  7. how do i list an access database list in excel
    By Markp in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-15-2005, 04:01 AM

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