+ Reply to Thread
Results 1 to 7 of 7

Copy first 4 rows of filtered range

  1. #1
    Valued Forum Contributor Charles's Avatar
    Join Date
    02-10-2004
    Location
    Biloxi
    MS-Off Ver
    Windows 7, Excel 2003,2007 & Mac2011
    Posts
    845

    Copy first 4 rows of filtered range

    Hi all,

    I need assistance with a code that would just copy the first 4 rows of a filtered range.

    Thanks
    Charles

    There are other ways to do this, this is but 1 !
    Be Sure you thank those who helped.
    IF YOU'RE SATISFIED BY ANY MEMBERS RESPONSE TO YOUR ISSUE PLEASE USE THE STAR ICON AT THE BOTTOM LEFT OF THE POST UNDER THEIR NAME.

  2. #2
    Valued Forum Contributor
    Join Date
    06-16-2006
    Location
    Sydney, Australia
    MS-Off Ver
    2013 64bit
    Posts
    1,394

    Re: Copy first 4 rows of filtered range

    Copy them where? Please post a sample sheet so that someone can help you

  3. #3
    Valued Forum Contributor Charles's Avatar
    Join Date
    02-10-2004
    Location
    Biloxi
    MS-Off Ver
    Windows 7, Excel 2003,2007 & Mac2011
    Posts
    845

    Re: Copy first 4 rows of filtered range

    Mallycat,

    My question was generic. Sorry for that.
    Attached is a copy of the filtered data.
    I'm looking to copy only the first 4 rows of column "E"
    And then paste to the sheet result (Transposed).
    I know this can be done manually, but am trying to do it by code.
    I know the code to copy the first row to the last row, but in this case I only need the first 4 rows
    of the filtered data.
    Attached Files Attached Files

  4. #4
    Forum Expert
    Join Date
    12-15-2009
    Location
    Chicago, IL
    MS-Off Ver
    Microsoft Office 365
    Posts
    3,177

    Re: Copy first 4 rows of filtered range

    Try

    Please Login or Register  to view this content.

  5. #5
    Valued Forum Contributor Charles's Avatar
    Join Date
    02-10-2004
    Location
    Biloxi
    MS-Off Ver
    Windows 7, Excel 2003,2007 & Mac2011
    Posts
    845

    Re: Copy first 4 rows of filtered range

    JieJenn,

    Thanks for the code. For some reason I the way you did the code would not work. Dummy me I did try to do it that way.
    My first thought was to "Just" copy the first rows at the same time ( not as you provided) of column E and paste to result. But I could not figure out to just copy the needed rows.
    Any way thanks for it.

  6. #6
    Forum Expert
    Join Date
    11-29-2010
    Location
    Ukraine
    MS-Off Ver
    Excel 2019
    Posts
    4,168

    Re: Copy first 4 rows of filtered range

    hi Charles, option with autofilter, please check attachment
    Attached Files Attached Files

  7. #7
    Valued Forum Contributor Charles's Avatar
    Join Date
    02-10-2004
    Location
    Biloxi
    MS-Off Ver
    Windows 7, Excel 2003,2007 & Mac2011
    Posts
    845

    Re: Copy first 4 rows of filtered range

    watersev,

    Thanks for the code.

+ 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