copying data to new row

  1. A

    Problems Copying a column pattern

    Hey everyone. I'm having an issue using the pull/copy (dragging by the corner) for a pattern that skips columns from another sheet. Example (This is my formula for the first 5 rows, but I need to copy them down keeping the pattern going until 340) NPC'!$B$7 NPC'!$E$7 NPC'!$H$7 NPC'!$K$7...
  2. A

    Macro to copy last row of data into multiple rows below

    Hi All! I have a macro that copies the last row of data on Sheet1 into the row below it: Sub CopyRow() Dim LR As Long With Sheets("Sheet1") LR = .Range("A" & Rows.Count).End(xlUp).Row .Rows(LR).Copy Destination:=Sheets("Sheet1").Range("A" &...
  3. L

    Selecting A Range of Columns and then Copying It To Next Unused Row (A question on efficiency)

    Just wondering, Do you guys every get tired of helping out people here? I surely hope not. Because I have another question for you. Thanks again! Right now I have found all my answers through search and / or asking directly in this forum. This is so much better than the office help file, or...

Some videos you may like

This Week's Hot Topics