Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Jul 2007
    Location
    United States
    Posts
    220
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Copy/Paste AutoFiltered Range (2003)

    I'd like to copy and paste a range that has been AutoFiltered based on selected criteria in another worksheet. When I try, it copies the hidden records as well. How do I copy and paste only the unhidden cells in another worksheet based on the AutoFilter criteria I have selected?

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

    Re: Copy/Paste AutoFiltered Range (2003)

    What do you mean by "AutoFiltered based on selected criteria in another worksheet"? With AutoFilter, you specify the criteria by clicking on the dropdown arrows in the field names, not in a separate range.

    Anyway, the default behavior for Excel is to copy only the filtered (visible) data, so I don't understand why you get all data.
    You can try this:
    - Select the filtered table.
    - Select Edit | Go To...
    - Click Special...
    - Select Visible Cells.
    - Click OK.
    - Try to copy and paste now.

Posting Permissions

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