+ Reply to Thread
Results 1 to 2 of 2

How to copy filtered records into new worksheet? Please Help?

  1. #1
    Registered User
    Join Date
    10-13-2006
    Posts
    60

    How to copy filtered records into new worksheet? Please Help?

    Hi,

    How to copy filtered records into new worksheet. if i copy the filtered record, hide records are also copied. Please Help!. Thanks in advance

  2. #2
    Forum Expert
    Join Date
    01-03-2006
    Location
    Waikato, New Zealand
    MS-Off Ver
    2010 @ work & 2007 @ home
    Posts
    2,243

    Re: How to copy filtered records into new worksheet? Please Help?

    hi,

    To only select visible cells you can select the relevant range, press [F5], "Special" & "Visible Cells only" before copying the records to the next sheet.
    A shortcut combination for selecting visible cells only is [alt + :].

    hth
    Rob
    Rob Brockett
    Kiwi in the UK
    Always learning & the best way to learn is to experience...

+ 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