Macro to pull every Nth row of data

  • I have a workbook with over 20 worksheets with same columns and rows( each has its own name). There is also a master worksheet that is stacked sequentially in the same order. I need a macro to populate the range R39:AC39 in all the worksheets pulling data from the master worksheet. e.g
    Sheet 1 R39:AC39 will pull data from the master R39:AC39
    Sheet 2 R39:AC39 will pull data from the master R83:AC83
    Sheet 3 R39:AC39 will pull data from the master R127:AC127 & SO FORTH.


    Thanks!

  • Welcome to the forum!


    In a Module: