Results 1 to 3 of 3

VBA COPY and Paste filtered Results to last Row onto next empty row another workbook

Threaded View

uk3arabi VBA COPY and Paste filtered... 03-09-2023, 03:14 AM
maniacb Re: VBA COPY and Paste... 03-14-2023, 01:16 PM
uk3arabi Re: VBA COPY and Paste... 03-15-2023, 06:38 AM
  1. #1
    Registered User
    Join Date
    03-24-2020
    Location
    London
    MS-Off Ver
    Excel 2013
    Posts
    4

    VBA COPY and Paste filtered Results to last Row onto next empty row another workbook

    I need some help with the below code, what i'm trying to do is copy A10-E10 as long to the last row of data, paste the copied data to another workbook last column but i cant get the paste to work, i dont know where to add that part to the code, and add the destination.
    Sub Copy_Data_to_last_row()
    
    
        Dim xScreenUpdating As Boolean
        
        Dim xPastewindows As Windows
        
        
        Dim xRg As Range
    
        '
        Windows("Exceptions report.xlsx").Activate
        
        Range("A10:E10").Select
        Range(Selection, Selection.End(xlToRight)).Select
        Range("A10:E10").Select
        Range(Selection, Selection.End(xlDown)).Select
        Range(Selection, Selection.End(xlDown)).Select
        Range(Selection, Selection.End(xlUp)).Select
        Selection.Copy
    
    
        Application.ScreenUpdating = False
        
        xRg.Copy
        
        xpaste.Cells(Rows.Count, 1).End(xlUp).Offset(1, 0).PasteSpecial xlPasteValues
        
        Application.CutCopyMode = False
        
        Application.ScreenUpdating = xScreenUpdating
    
    End Sub
    Last edited by davesexcel; 03-09-2023 at 10:06 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Macro to Copy and paste filtered data to new workbook
    By walsha23 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-27-2018, 01:44 PM
  2. Unable to copy and paste the Filtered data to new workbook
    By Rajkumar_h in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-15-2017, 12:14 PM
  3. Copy filtered Range, Remove Filter, Find 1st Empty Cell from the bottom, Paste VBA
    By intervals in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-29-2016, 10:48 PM
  4. Filtered Data Loop, Copy and Paste into New Workbook, delete first column and save
    By newbiegirl3113 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-20-2016, 03:44 AM
  5. Copy range from one workbook, paste to next empty cell in another workbook
    By glock9mm in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-23-2013, 12:16 AM
  6. [SOLVED] Copy/Paste Filtered Data To New Sheet In New Workbook.
    By ScotyB in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 05-13-2012, 09:10 PM
  7. Copy filtered data & paste formatted in a new workbook
    By BorisMKD in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-17-2008, 06:54 AM

Tags for this Thread

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