Results 1 to 2 of 2

Copy row when data entered in cell H

Threaded View

fabjay Copy row when data entered in... 10-13-2011, 01:26 PM
arlu1201 Re: Copy row when data... 10-15-2011, 11:53 AM
  1. #1
    Registered User
    Join Date
    10-12-2011
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    2

    Copy row when data entered in cell H

    If data entered in sheet 1, column H copy entire row column A, row 208. The result should be an Itemization of the rows with data entered.

    Private Sub Worksheet_Change(ByVal Target As Range)
      If Target.Column = 6 And Target.Cells.Count = 1 Then
        Target.EntireRow.Copy Destination:=Sheets(2).Cells(Rows.Count, 1).End(xlUp).Offset(1, 0)
        Target.EntireRow.Delete shift:=xlUp
      End If
    End Sub

    Can you help me edit the above code, please?
    Do not delete row.
    Copy within the same sheet –
    Copy to row 208 and below…..

    see attached
    Last edited by Leith Ross; 10-15-2011 at 04:01 PM. Reason: Added Code Tags

Thread Information

Users Browsing this Thread

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

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