+ Reply to Thread
Results 1 to 10 of 10

Filtering With Multiple Sub-items (Many Rows) Per Single Item (One Row)

  1. #1
    Registered User
    Join Date
    03-06-2018
    Location
    USA
    MS-Off Ver
    Always up to date.
    Posts
    18

    Filtering With Multiple Sub-items (Many Rows) Per Single Item (One Row)

    Sorry for the complicated title; I'm not quite sure how to describe my problem. See attached file for the structure.

    I've slowly built up a template that is used to track music writing credits per episode of a show. I am at the point where I need to start filtering individual writers to check their history, but the setup makes this difficult. I'm aware of one solution, which is to copy down the episode number and title every time we add a new row/credit for an episode. This introduces its own problems, though: I have a couple of conditional formatting rules that don't play nice with repeating episode info. I am also trying to make the template as easy to use as possible, as it is shared among several people. So it would be preferable to not have to copy info every time a new row/entry is inserted, if possible.

    So the main question is, is there a way I can filter out individual writers with my current structure?

    A secondary question might be whether there is a better structure I should be following that still maintains clarity and visual feedback, which I've tried to build into this template. (There is person by person conditional formatting as well that didn't properly translate to Excel.)

    (Side note: the actual spreadsheet is a Google Sheets document, but I've exported this simplified example to Excel and would be grateful for any solution, even one that only works in Excel.)
    Attached Files Attached Files
    Last edited by etudes; 03-07-2018 at 06:00 PM.

  2. #2
    Valued Forum Contributor
    Join Date
    02-04-2009
    Location
    Texas
    MS-Off Ver
    Excel 2016
    Posts
    657

    Re: Filtering With Multiple Sub-items (Many Rows) Per Single Item (One Row)

    The easiest thing I can think of - Leave the episode title line blank Column F...
    Start the Music info one line down
    Then when you filter for writers - Check the writer's name and Blanks

    Otherwise you could build some summary page...
    Attached Files Attached Files

  3. #3
    Forum Expert
    Join Date
    08-16-2015
    Location
    Antwerpen, Belgium
    MS-Off Ver
    2007-2016
    Posts
    2,380

    Re: Filtering With Multiple Sub-items (Many Rows) Per Single Item (One Row)

    i see writers in column I
    i dont see why you could not filter on column I


    Kind regards
    Leo

  4. #4
    Registered User
    Join Date
    03-06-2018
    Location
    USA
    MS-Off Ver
    Always up to date.
    Posts
    18

    Re: Filtering With Multiple Sub-items (Many Rows) Per Single Item (One Row)

    Quote Originally Posted by CRIMEDOG View Post
    The easiest thing I can think of - Leave the episode title line blank Column F...
    Start the Music info one line down
    Then when you filter for writers - Check the writer's name and Blanks

    Otherwise you could build some summary page...
    Ahh that's clever, I didn't realize that could work that way. That still does include a large amount of unneeded data in the filter on the actual sheet I'm working with (which has dozens of other episodes being added); but it's definitely a solution I can live with. I'm not sure how a summary page would work, but I might do some research on that as well. Many thanks!

    Quote Originally Posted by LeoTaxi View Post
    i see writers in column I
    i dont see why you could not filter on column I


    Kind regards
    Leo
    Sorry, I should have been clearer. With my setup, filtering on column I doesn't tell me which episode each cue is from unless it's on the first row of the episode.
    Last edited by etudes; 03-07-2018 at 08:12 PM.

  5. #5
    Forum Expert
    Join Date
    08-16-2015
    Location
    Antwerpen, Belgium
    MS-Off Ver
    2007-2016
    Posts
    2,380

    Re: Filtering With Multiple Sub-items (Many Rows) Per Single Item (One Row)

    this macro shows userform
    select writer in listbox on userform and see

    Please Login or Register  to view this content.
    Kind regards
    Leo
    Attached Files Attached Files

  6. #6
    Registered User
    Join Date
    03-06-2018
    Location
    USA
    MS-Off Ver
    Always up to date.
    Posts
    18

    Re: Filtering With Multiple Sub-items (Many Rows) Per Single Item (One Row)

    I'm not quite sure what you're referring to, sorry. I tried viewing the macros in the workbook and running the one in there, but it returns an error, even if I have one of the writers selected. Am I missing something? (I'm unfamiliar with macros).

  7. #7
    Forum Expert
    Join Date
    08-16-2015
    Location
    Antwerpen, Belgium
    MS-Off Ver
    2007-2016
    Posts
    2,380

    Re: Filtering With Multiple Sub-items (Many Rows) Per Single Item (One Row)

    In Sheet 1
    goto Macro's
    choose Filter_On_Writer
    userform pops up

    Choose writer

    Kind regards
    Leo

  8. #8
    Registered User
    Join Date
    03-06-2018
    Location
    USA
    MS-Off Ver
    Always up to date.
    Posts
    18

    Re: Filtering With Multiple Sub-items (Many Rows) Per Single Item (One Row)

    I'm afraid there's no userform that pops up when I do it. I get an error instead (see attached photo).
    Attached Images Attached Images

  9. #9
    Forum Expert
    Join Date
    08-16-2015
    Location
    Antwerpen, Belgium
    MS-Off Ver
    2007-2016
    Posts
    2,380

    Re: Filtering With Multiple Sub-items (Many Rows) Per Single Item (One Row)

    seems you missing the librarie

    in this another method

    Kind regards
    Leo
    Attached Files Attached Files

  10. #10
    Registered User
    Join Date
    03-06-2018
    Location
    USA
    MS-Off Ver
    Always up to date.
    Posts
    18

    Re: Filtering With Multiple Sub-items (Many Rows) Per Single Item (One Row)

    Thanks Leo, that's a very useful solution. Macros feel a bit beyond me right now, so creating an equivalent in Google Sheets would be tough, but it's something I plan to look into. Thanks much!

+ 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] Merging col items in a single cell for each row item
    By Rajkumar_h in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-14-2017, 07:27 AM
  2. Macro to convert lists in a row to multiple rows with single items
    By gilbro in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-14-2016, 10:55 AM
  3. Excel Macro filtering only 1st item out of multiple items from the source data
    By zipperzipped1204 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-29-2015, 02:37 PM
  4. Retrieving multiple rows of data from one single item
    By kikilala in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-03-2014, 08:39 AM
  5. Macro for selecting a single item while filtering the data in Pivot Table
    By Syed964 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-13-2013, 01:28 PM
  6. Replies: 0
    Last Post: 11-13-2012, 12:53 PM
  7. Combining single rows into multiple lined items
    By bread in forum Excel General
    Replies: 1
    Last Post: 08-31-2009, 12:27 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