+ Reply to Thread
Results 1 to 8 of 8

Showing filtered results on separate sheets

  1. #1
    Registered User
    Join Date
    05-20-2010
    Location
    Australia
    MS-Off Ver
    Excel 2000
    Posts
    5

    Showing filtered results on separate sheets

    I have a sheet of data which I want to filter out and show the results on a separate sheet.

    For instance sheet 1 column A has a pulldown list of categories (wall, floor, ceiling). the row has data relating to that category (paint colour, paint finish, supplier)

    I want Sheet 2 to show all the rows of data from sheet 1 that have "wall" in sheet1 column a, sheet 3 would then show floor, sheet 4 would show ceiling.

    I want it to update automatically. so that if i change a category from column A on sheet 1, all the other sheets alter the information acordingly.

    Is this possible?

  2. #2
    Forum Expert pike's Avatar
    Join Date
    12-11-2005
    Location
    Alstonville, Australia
    MS-Off Ver
    2016
    Posts
    5,327

    Re: Showing filtered results on separate sheets

    hey mhodges
    this may help
    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    05-20-2010
    Location
    Australia
    MS-Off Ver
    Excel 2000
    Posts
    5

    Re: Showing filtered results on separate sheets

    What's the best way to use this code?

    Thanks (not to smart with codes)

  4. #4
    Forum Expert pike's Avatar
    Join Date
    12-11-2005
    Location
    Alstonville, Australia
    MS-Off Ver
    2016
    Posts
    5,327

    Re: Showing filtered results on separate sheets

    hey mhodges
    probably best to attach a sample example

  5. #5
    Registered User
    Join Date
    05-20-2010
    Location
    Australia
    MS-Off Ver
    Excel 2000
    Posts
    5

    Re: Showing filtered results on separate sheets

    Hi, I've attached an example. Imagine it with 100 rows and I want to see the 30 rows that are category "wall" on the tab wall, floor on tab floor etc. and to just update as I change the category.

    Thanks heaps for your input. Appreciate it.
    Attached Files Attached Files

  6. #6
    Forum Expert pike's Avatar
    Join Date
    12-11-2005
    Location
    Alstonville, Australia
    MS-Off Ver
    2016
    Posts
    5,327

    Re: Showing filtered results on separate sheets

    mhodges
    I apologise about the delay but try....
    Please Login or Register  to view this content.
    Last edited by pike; 06-02-2010 at 08:56 AM. Reason: .Cells(Rows.Count, "A").End(xlUp).Offset(1, 0)

  7. #7
    Registered User
    Join Date
    05-20-2010
    Location
    Australia
    MS-Off Ver
    Excel 2000
    Posts
    5

    Re: Showing filtered results on separate sheets

    Thanks Pike,

    Can you attach that to the example for me and repost it. I'm afraid it doesn't make too much sense to me! But it certainly looks impressive!

    That would be super...

    Cheers.

  8. #8
    Forum Expert pike's Avatar
    Join Date
    12-11-2005
    Location
    Alstonville, Australia
    MS-Off Ver
    2016
    Posts
    5,327

    Re: Showing filtered results on separate sheets

    Hi mhodges,

    try this attachment..
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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