+ Reply to Thread
Results 1 to 3 of 3

Vba Filter and copy rows to sheet2 every 3rd row

  1. #1
    Forum Contributor
    Join Date
    03-30-2014
    Location
    https://t.me/pump_upp
    MS-Off Ver
    Excel 2013
    Posts
    274

    Vba Filter and copy rows to sheet2 every 3rd row

    Jindon helped me with filtering on 2 cols using max criteria
    However how to do this with every 3rd row
    Example data file uploaded with explanation and sample data
    Jindons code is as follows
    Please Login or Register  to view this content.
    All help will be appreciated here
    Graham
    Attached Files Attached Files
    Last edited by Grahamfeeley; 03-31-2021 at 02:07 AM.

  2. #2
    Forum Guru Bo_Ry's Avatar
    Join Date
    09-10-2018
    Location
    Thailand
    MS-Off Ver
    MS 365
    Posts
    7,211

    Re: Vba Filter and copy rows to sheet2 every 3rd row

    Please try

    Please Login or Register  to view this content.
    Attached Files Attached Files

  3. #3
    Forum Contributor
    Join Date
    03-30-2014
    Location
    https://t.me/pump_upp
    MS-Off Ver
    Excel 2013
    Posts
    274

    Re: Vba Filter and copy rows to sheet2 every 3rd row

    Thank you Bo-Ry, you showed me how to do this perfectly, and it did'nt come to me how to execute this
    it gives an error in copying to sheet2, but that does not matter as i can execute this myself
    The fact is it works perfectly and I thank you very much
    Graham

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Copy rows from sheet1 to sheet2
    By Jonor in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-17-2015, 11:33 AM
  2. Copy Rows to Sheet2 Based on 2 Criteria
    By tyrelzich in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-13-2014, 05:58 PM
  3. How to Copy Rows from sheet1 to sheet2
    By seaottersut in forum Excel General
    Replies: 5
    Last Post: 03-14-2013, 04:04 PM
  4. [SOLVED] Copy Selected Rows from Sheet1 to Sheet2
    By abjac in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 08-08-2012, 05:34 AM
  5. [SOLVED] macro to copy the formulas in Sheet2 to as many rows as rows available in Sheet1
    By flakedew in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 06-21-2012, 04:52 AM
  6. Copy data from sheet1.last row and combine them in sheet2 different rows
    By faffol in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 05-17-2012, 03:43 AM
  7. Copy Rows that have NonBlank in Column C to Sheet2
    By CRIMEDOG in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-25-2011, 10:25 AM

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