+ Reply to Thread
Results 1 to 11 of 11

Filtering Data & Auto-filter

  1. 05-07-2010, 07:16 AM #1
    Henry c
    Henry c is offline
    Registered User
    Join Date
    11-11-2009
    Location
    Reading, England
    MS-Off Ver
    2010
    Posts
    69

    Filtering Data & Auto-filter

    Hi,

    I have a worksheet full of data and wish to display all the rows of a certain catagory on a seperate sheet.

    The problem is, there could be any number of rows in each catagory.

    I know by Auto-filtering the data I can just show the data relateing to a specific catagory, but is it possible to show this filtered data on a seperate worksheet?

    Thanks.
    Reply With QuoteRegister To Reply
  2. 05-07-2010, 07:25 AM #2
    pike
    pike is offline
    Forum Expert pike's Avatar
    Join Date
    12-11-2005
    Location
    Alstonville, Australia
    MS-Off Ver
    2016
    Posts
    5,330

    Re: Filtering Data & Auto-filter

    You can do it with "Advanced Filter"
    It has a "copy to another location" option
    If the solution helped please donate to RSPCA

    Site worth visiting: Rabbitohs
    Reply With QuoteRegister To Reply
  3. 05-07-2010, 07:33 AM #3
    Henry c
    Henry c is offline
    Registered User
    Join Date
    11-11-2009
    Location
    Reading, England
    MS-Off Ver
    2010
    Posts
    69

    Re: Filtering Data & Auto-filter

    This will only let me copy to the same sheet, or am i doing something wrong?
    Reply With QuoteRegister To Reply
  4. 05-07-2010, 08:01 AM #4
    pike
    pike is offline
    Forum Expert pike's Avatar
    Join Date
    12-11-2005
    Location
    Alstonville, Australia
    MS-Off Ver
    2016
    Posts
    5,330

    Re: Filtering Data & Auto-filter

    true forgot about that
    once you have filtered the data use like

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  5. 05-07-2010, 09:20 AM #5
    Henry c
    Henry c is offline
    Registered User
    Join Date
    11-11-2009
    Location
    Reading, England
    MS-Off Ver
    2010
    Posts
    69

    Re: Filtering Data & Auto-filter

    Thanks for this!
    Reply With QuoteRegister To Reply
  6. 05-07-2010, 08:02 PM #6
    pike
    pike is offline
    Forum Expert pike's Avatar
    Join Date
    12-11-2005
    Location
    Alstonville, Australia
    MS-Off Ver
    2016
    Posts
    5,330

    Re: Filtering Data & Auto-filter

    Have any problems attach a small workbook and we can refine the code/syntax
    Reply With QuoteRegister To Reply
  7. 05-07-2010, 08:42 PM #7
    martindwilson
    martindwilson is offline
    Forum Expert martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: Filtering Data & Auto-filter

    you don't have to do anything but filter/select visible cells and copy paste to a new sheet
    or use advanced filter
    say your data is on sheet1 and so is your criteria range
    select sheet2! then data/advanced filter
    then select sheet1! put range and criteria range select copy to another location
    it will then automatically switch back to sheet2! pick a cell click ok
    "Unless otherwise stated all my comments are directed at OP"

    Mojito connoisseur and now happily retired
    where does code go ?
    look here
    how to insert code

    how to enter array formula
    why use -- in sumproduct
    recommended reading
    wiki Mojito

    how to say no convincingly

    most important thing you need
    Martin Wilson: SPV
    and RSMBC
    Reply With QuoteRegister To Reply
  8. 05-07-2010, 09:01 PM #8
    pike
    pike is offline
    Forum Expert pike's Avatar
    Join Date
    12-11-2005
    Location
    Alstonville, Australia
    MS-Off Ver
    2016
    Posts
    5,330

    Re: Filtering Data & Auto-filter

    I knew Advance filter would do it just forgotten how
    Thanks Martin
    not enough wiki Mojito
    Reply With QuoteRegister To Reply
  9. 05-07-2010, 09:05 PM #9
    martindwilson
    martindwilson is offline
    Forum Expert martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: Filtering Data & Auto-filter

    ahh but its the Guiness talking tonight lol
    Reply With QuoteRegister To Reply
  10. 05-07-2010, 09:09 PM #10
    pike
    pike is offline
    Forum Expert pike's Avatar
    Join Date
    12-11-2005
    Location
    Alstonville, Australia
    MS-Off Ver
    2016
    Posts
    5,330

    Re: Filtering Data & Auto-filter

    One thing I miss about the UK is the Guiness on tap
    Reply With QuoteRegister To Reply
  11. 05-07-2010, 09:15 PM #11
    martindwilson
    martindwilson is offline
    Forum Expert martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: Filtering Data & Auto-filter

    extra cold mmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmm
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1