Results 1 to 13 of 13

Move Only Selected Data Frm 1 Sheet 2 other Existin Workbooks 1st Avaliable Empty ROW

Threaded View

  1. #1
    Registered User
    Join Date
    08-08-2011
    Location
    london,england
    MS-Off Ver
    Excel 2003
    Posts
    19

    Move Only Selected Data Frm 1 Sheet 2 other Existin Workbooks 1st Avaliable Empty ROW

    i need your help bro !

    Sub CopySelectedMultiple()
    Dim NextRow&, rng As Range
    With Sheets(“Sheet2″)
    For Each rng In Selection.Areas
    On Error Resume Next
    NextRow = .Cells.Find(What:=”*” _ , After:=.Range(“A1″), SearchOrder:=xlByRows, _
    SearchDirection:=xlPrevious).Row + 1
    If Err 0 Then NextRow = 1
    On Error Goto 0
    rng.Copy .Cells(NextRow, 1)
    Next rng
    End With
    End Sub
    can anyone modify it to Move the Selected Data to another Existing WorkBook “Database.xls” sheet1 which already exist in MY documents, if the Database.xls is active ? or not…
    Last edited by xcruc1at3r; 08-09-2011 at 07:05 PM.

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