Results 1 to 7 of 7
  1. #1
    Star Lounger
    Join Date
    Jan 2004
    Location
    Westervoort, Netherlands
    Posts
    56
    Thanks
    2
    Thanked 0 Times in 0 Posts

    Advanced filter - result on other worksheet (2002 sp3)

    Hi,

    I have data in one sheet which have to be transferred to to different sheets. I want a link between the data so I was thinking about Advanced filter but it wont work on more then one worksheet.

    The data just has to be analysed and moved to one sheet or the other sheets based on a value in a specific column.

    Can anyone help me?

    Regards Marcel

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Advanced filter - result on other worksheet (2002 sp3)

    Advanced filter can work on different sheets.

    The sheet that gets the "Output" results (copy to) is the sheet that should have the advanced filter. The List range and criteria range may be on different sheets than the copy to.

    Steve

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Advanced filter - result on other worksheet (2002 sp3)

    As Steve points out, Advanced Filter can work with multiple sheets, but you have to start from the destination ("copy to") worksheet. But Advanced Filter doesn't create a link between the original data and the copied data.
    If you provide more detailed information, you might get more specific help.

  4. #4
    Silver Lounger
    Join Date
    Mar 2001
    Location
    Springfield, Ohio, USA
    Posts
    2,136
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Advanced filter - result on other worksheet (2002 sp3)

    I can't understand/do what you are saying. Can you rearrange the attached to be on different sheets?
    <font face="Comic Sans MS">Sam Barrett, CACI </font face=comic>
    <small>And the things that you have heard... commit these to faithful men who will be able to teach others also. 2 Timothy 2:2</small>

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Advanced filter - result on other worksheet (2002 sp3)

    See attached.

    Your criteria range was incorrect. It should have field name(s) in the first row, and criteria in the second row (or nothing in the first row, and a formula in the second row).

  6. #6
    Silver Lounger
    Join Date
    Mar 2001
    Location
    Springfield, Ohio, USA
    Posts
    2,136
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Advanced filter - result on other worksheet (2002 sp3)

    > Your criteria range was incorrect
    Yep. It's been too long

    I just didn't get the part about starting with the output page, but I've got it now. Thanks!

    So, it seems that since Marcel needs multiple output sheets, Advanced filter would not work, but as you say, we need more details.
    <font face="Comic Sans MS">Sam Barrett, CACI </font face=comic>
    <small>And the things that you have heard... commit these to faithful men who will be able to teach others also. 2 Timothy 2:2</small>

  7. #7
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Advanced filter - result on other worksheet (2002 sp3)

    It would work but would be cumbersome as you would have to create it for each sheet rather than creating 1 and just changing the sheet.

    It could be done with one filler on the sheet with the range and a "temporary output" on that sheet. The temporary output could be copied to a new sheet, run another advanced filter then do another copy etc.

    This scenario may also be done using autofilter and filter the items in place and then copy the visible records

    Steve

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •