Results 1 to 8 of 8

Copy table to the first unused row on another sheet

Threaded View

jlive24 Copy table to the first... 06-28-2018, 01:14 PM
Mumps1 Re: Copy table to the first... 06-28-2018, 02:01 PM
jlive24 Re: Copy table to the first... 06-29-2018, 11:11 AM
Mumps1 Re: Copy table to the first... 06-29-2018, 11:30 AM
jlive24 Re: Copy table to the first... 07-06-2018, 12:34 PM
Mumps1 Re: Copy table to the first... 07-06-2018, 01:22 PM
jlive24 Re: Copy table to the first... 07-09-2018, 02:23 PM
Mumps1 Re: Copy table to the first... 07-09-2018, 02:25 PM
  1. #2
    Forum Expert Mumps1's Avatar
    Join Date
    10-10-2012
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2010, 365
    Posts
    8,026

    Re: Copy table to the first unused row on another sheet

    Try:
    Sub CopyRange()
        Application.ScreenUpdating = False
        Sheets("Today's Queue").UsedRange.Offset(1, 0).Copy
        Sheets("Queue History").Cells(Rows.Count, "A").End(xlUp).Offset(1, 0).PasteSpecial xlPasteValues
        Sheets("Today's Queue").UsedRange.Offset(1, 0).ClearContents
        Application.CutCopyMode = False
        Application.ScreenUpdating = True
    End Sub
    Last edited by Mumps1; 06-28-2018 at 02:04 PM.
    You can say "THANK YOU" for help received by clicking the Star symbol at the bottom left of the helper's post.
    Practice makes perfect. I'm very far from perfect so I'm still practising.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Way to filter out Unused space and Copy/paste onto another worksheet
    By bdouglas1011 in forum Excel General
    Replies: 6
    Last Post: 09-29-2014, 11:41 AM
  2. [SOLVED] copy sheet based on table, rename, and hyperlink table to new sheet
    By DrZeuss in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-30-2014, 01:18 PM
  3. Replies: 0
    Last Post: 05-08-2014, 11:59 AM
  4. Copy data then remove unused rows
    By pingwin77 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-01-2012, 05:02 PM
  5. [SOLVED] Copy cell data from one w/sheet to another with unused cells left blank
    By steve@stanley in forum Excel General
    Replies: 2
    Last Post: 07-06-2012, 10:05 AM
  6. Unused cells at end of sheet?
    By gsxith3 in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 04-15-2009, 09:26 PM
  7. [SOLVED] Is there a way to cut off unused cells on a sheet
    By newbie in forum Excel General
    Replies: 2
    Last Post: 08-03-2005, 02:05 PM

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