Results 1 to 6 of 6

Copy a column's cell value into a new sheet where it skips every 4 rows

Threaded View

  1. #1
    Registered User
    Join Date
    03-22-2017
    Location
    Arizona
    MS-Off Ver
    Office 365 32-bit
    Posts
    14

    Copy a column's cell value into a new sheet where it skips every 4 rows

    I am using the MACRO below and it is working but I need to do this for 50 rows and eventually up to 4 or 500. Is there an easier macro to accomplish this without having to reference each row? I am copying the Tracking Number (Column A) in the Data Tab to column B in the Audit Data tab.

    Sub Macro1()
    '
    ' Macro1 Macro
    ' Copy tracking # from Data tab
    '
    ' Keyboard Shortcut: Ctrl+t
    '
        Application.CutCopyMode = False
        ActiveCell.FormulaR1C1 = "=Data!RC[-1]"
        Range("B7").Select
        ActiveCell.FormulaR1C1 = "=Data!R[-4]C[-1]"
        Range("B12").Select
        ActiveCell.FormulaR1C1 = "=Data!R[-8]C[-1]"
        Range("B17").Select
        ActiveCell.FormulaR1C1 = "=Data!R[-12]C[-1]"
        Range("B22").Select
        ActiveCell.FormulaR1C1 = "=Data!R[-16]C[-1]"
        Range("B27").Select
        ActiveCell.FormulaR1C1 = "=Data!R[-20]C[-1]"
        
    End Sub
    Attached Files Attached Files
    Last edited by Glenn Kennedy; 10-19-2023 at 03:51 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Formula that skips rows when Copy Pasted
    By yourik in forum Excel General
    Replies: 3
    Last Post: 08-30-2018, 02:35 AM
  2. Increment Cell Address every other Column (Currently skips)
    By jtnb in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-03-2017, 03:53 PM
  3. Replies: 9
    Last Post: 05-27-2015, 06:28 AM
  4. copy a formula that skips rows
    By mo2982 in forum Excel General
    Replies: 2
    Last Post: 06-09-2014, 10:41 AM
  5. Copy rows into new sheet based on cell/column data
    By StagemanGraham in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-13-2012, 08:11 PM
  6. Copy rows from master sheet to other sheets if certain cell in column is blank
    By nadiaraciti in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-29-2011, 02:05 AM
  7. How to copy formulas when it skips rows?
    By ladyjammie in forum Excel General
    Replies: 3
    Last Post: 01-29-2008, 07:06 PM

Tags for this Thread

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