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. #1
    Registered User
    Join Date
    06-26-2018
    Location
    us
    MS-Off Ver
    10
    Posts
    12

    Post Copy table to the first unused row on another sheet

    Hi everyone,

    I have zero experience with macros/vba and would like some help.

    Details:

    Sheet1 (Today's Queue) contains a table (Today) with an assortment of data that is pulled every morning, and then deleted at the end of the day. The data from this table feeds into graphs for daily emails. This data always contains the same amount of columns (A-G), but differs in the amount of rows each day.

    Sheet2 (Queue History) contains the combined data from every morning pull, and is never deleted.

    The goal is to have a macro that:
    1) copies all the data from the Sheet1 "Today" table,
    2) paste that data as values to the first unused row on the bottom of Sheet2 (this way no data from Sheet2 is deleted or overwritten), and
    3) clear data from columns A - F in Sheet1 (Today's Queue).

    Please note that some rows contain blank cells.

    I have attached a sample workbook for your reference.

    Thanks!
    Attached Files Attached Files

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