+ Reply to Thread
Results 1 to 3 of 3

Can you Copy Paste range and table to another sheet?

  1. #1
    Registered User
    Join Date
    07-15-2022
    Location
    Delta Canada
    MS-Off Ver
    365
    Posts
    73

    Can you Copy Paste range and table to another sheet?

    I need a very simple Copy- Paste of a small range and table to second sheet
    When I finish adding data to the main table , I need to back it up to the second sheet and leave one row between
    I tried posting this question yesterday, with the actual sheet, but I think it was just tooo confusing.

    The table is not always the same size... Sometimes the table will have 4 rows, sometimes it might have 40 rows.
    04.png

    The second sheet will just be a few of these tables with just one row space between them like this:
    05.png

    Thank you in advance.
    Chris
    Attached Files Attached Files
    Last edited by chrispikekerry; 11-16-2022 at 10:41 AM. Reason: Simplified pictures

  2. #2
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,616

    Re: Can you Copy Paste range and table to another sheet?

    Such a code in standard module shall do:

    Please Login or Register  to view this content.
    Attached Files Attached Files
    Best Regards,

    Kaper

  3. #3
    Registered User
    Join Date
    07-15-2022
    Location
    Delta Canada
    MS-Off Ver
    365
    Posts
    73

    Re: Can you Copy Paste range and table to another sheet?

    Works fantastically.... Thanks so much.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Copy and Paste from one sheet to next empty table row in another sheet
    By shre0047 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-06-2016, 01:19 AM
  2. Copy paste specific range to last non empty cell in Column A different sheet
    By realrookie in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-18-2016, 04:20 PM
  3. Copy range to next empty row in a table on another sheet with VBA
    By vicguz33 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-02-2015, 05:02 AM
  4. [SOLVED] copy range and paste values only to another sheet in next empty row
    By KK1234 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-22-2015, 05:08 AM
  5. Replies: 0
    Last Post: 03-20-2014, 11:51 AM
  6. [SOLVED] Macro to Copy Range and Paste in the Empty Row Same Sheet
    By kaurka in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 04-22-2013, 11:01 AM
  7. Replies: 1
    Last Post: 04-22-2013, 10:34 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