+ Reply to Thread
Results 1 to 3 of 3

Copy entire row from one sheet to another base on answer

Hybrid View

  1. #1
    Registered User
    Join Date
    10-30-2008
    Location
    maryland
    Posts
    2

    Question Copy entire row from one sheet to another base on answer

    I try to copy a row from sheet1 to sheet2 base on answer on 'Y' or 'N' .
    it does nt work so far. I appreciate suggestion on other way to do this or modification of these code. I am urgent need.
    thanks.

    Sub COPY_TRUE()

    Worksheets("Sheet1").Row().Copy _
    Destination:=Worksheets("Sheet2").Row(7)

    End Sub

    Sub COPY_FALSE()

    Worksheets("Sheet1").Row().Copy _
    Destination:=Worksheets("Sheet3").Row(7)

    End Sub

  2. #2
    Registered User
    Join Date
    10-30-2008
    Location
    maryland
    Posts
    2

    Update code Please suggest!

    Dim myrow As Integer
    myrow = ActiveWindow.RangeSelection.Row
    Rows(myrow).Select 'This copies the selected row
    Selection.Copy
    ActiveSheet.Paste Destination:=Worksheets("Sheet3").Cells(3, 1)
    Application.CutCopyMode = False
    Range("7:7").Select
    Selection.Copy
    ActiveSheet.Paste Destination:=Worksheets("Sheet3").Cells(1, 1)
    Application.CutCopyMode = False

  3. #3
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689
    Welcome to the forum.

    Please take a few minutes to read the Forum Rules, and then edit both your posts to wrap the code with Code Tags.
    Entia non sunt multiplicanda sine necessitate

+ Reply to Thread

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