Results 1 to 7 of 7

Paste to a new sheet, empty row

Threaded View

  1. #1
    Registered User
    Join Date
    10-11-2013
    Location
    here,there
    MS-Off Ver
    Excel 2010
    Posts
    7

    Paste to a new sheet, empty row

    Hi all,

    I have spend last 3 days trying to figure out how to do the following:

    I want to copy data (one row) from SheetA to a SheetB to first next empty row, so it will continue making a list, and then delete the data from that row.

    This is what i curently have - i just want to add something that will look at "Data Colection" cheet, see which one is the first empty row and copy the data to it. (Everything works fine, i just need that extra piece of code)

     Range("B4:K4").Select
        Selection.Copy
        Sheets("Data Colection").Select
        Range("A2").Select
        Selection.PasteSpecial , Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
            :=False, Transpose:=False
        Sheets("DataEntry").Select
        Range("B4").Select
        Application.CutCopyMode = False
        Selection.ClearContents
        Range("C4").Select
        Selection.ClearContents
        Range("D4").Select
        Selection.ClearContents
        Range("G4").Select
        Selection.ClearContents
        Range("I4").Select
        Selection.ClearContents
        Range("J4").Select
        Selection.ClearContents
        Range("K4").Select
        Selection.ClearContents
    I am in the process of still learning the VBA code, so please be patient with me.

    Thank you!
    Last edited by alansidman; 10-12-2013 at 04:03 PM. Reason: code tags added

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Copy and Paste Row from Sheet(1) to First Empty Row in Sheet(2)
    By jgray in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-21-2013, 03:54 PM
  2. [SOLVED] Copy and paste row into next sheet, into next empty row??
    By Statesman in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 12-15-2012, 08:00 AM
  3. check if sheet empty then paste value
    By celticpucca in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-12-2011, 08:41 PM
  4. Copy Entire Row & Paste in First Empty Row On The Same Sheet
    By Emonk in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-23-2011, 11:41 AM
  5. Paste Selection in next new empty row on different sheet
    By cooper1308 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 07-15-2009, 03:18 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