Results 1 to 3 of 3
  1. #1
    4 Star Lounger
    Join Date
    Aug 2003
    Location
    Stroud, United Kingdom
    Posts
    548
    Thanks
    0
    Thanked 0 Times in 0 Posts

    filtering (XP / 2000)

    Hi, I remember i did something a while ago and cannot remember now how i did it, it was like a copy and paste, but may have been an advanced filter to another range.

    I have a load of data in range1, with headings 1 to 5 say, and i wanted to copy it to another range, but this range, say range2 only has certain headings from the first one, say 3 headings. How is this done so that only the relevant data from range 1 is copied to range 2?

    if that makes sense?
    Thanks,

    pmatz

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

    Re: filtering (XP / 2000)

    You can do this with Data | Filter | Advanced Filter. Your Range 1 is the List Range. You also need a Criteria Range; this consists of one or more column headings and optional criteria under the column headings, for example:

    <table border=1><td>SalesDate</td><td>SalesAmount</td><td>>12/12/2003</td><td><5000</td></table>
    If you don't want to filter values, use only the column headers. And you need a "Copy To" range; this consists of the column headers you want; everything below them must be empty.

    Click somewhere in Range 1.
    Select Data | Filter | Advanced Filter.
    The List Range will be filled in automatically.
    Click in Criteria range and type or select the criteria.
    Tick the "Copy to another location" check box.
    Click in "Copy to" and select the column haders of the output range.
    If you like, tick the "Unique records only" check box.
    Click OK.

  3. #3
    4 Star Lounger
    Join Date
    Aug 2003
    Location
    Stroud, United Kingdom
    Posts
    548
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: filtering (XP / 2000)

    Thanks, I wont 4get that again! I was trying to put the 'modified' headers in the criteria range [img]/forums/images/smilies/sad.gif[/img]
    Thanks,

    pmatz

Posting Permissions

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