+ Reply to Thread
Results 1 to 2 of 2

Macro to copy/paste same table continually in same worksheet

Hybrid View

  1. #1
    Registered User
    Join Date
    10-30-2013
    Location
    Los Angeles
    MS-Off Ver
    Excel 2010
    Posts
    4

    Macro to copy/paste same table continually in same worksheet

    Hi All!

    I need a macro that will copy and paste an unedited version of a table in the same worksheet two rows after the previous table. For example, the first table is from A2:J27. After a user completes the table I want them to run a macro called NewTable that will copy the original table and paste an unedited table starting at A30. Once this table is complete run NewTable macro again to place another unedited table starting at A58.

    Thanks for any help you can provide.

  2. #2
    Registered User
    Join Date
    10-30-2013
    Location
    Los Angeles
    MS-Off Ver
    Excel 2010
    Posts
    4

    Re: Macro to copy/paste same table continually in same worksheet

    I was able to come with with the following macro but it is not removing the highlighting from the original table. Any ideas?

    Sub NewTable()
    '
    ' NewTable Macro
    ' To create a new table two rows after the last table
    '
    
    '
        Range("A2:J27").Copy Destination:=Range("A" & Rows.Count).End(xlUp).Offset(2)
        With Selection.Interior
            .Pattern = xlNone
            .TintAndShade = 0
            .PatternTintAndShade = 0
        End With
    End Sub
    Attached Files Attached Files

+ 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 paste table into new worksheet macro
    By Mr ZN in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-31-2013, 02:41 AM
  2. [SOLVED] Copy and paste from one worksheet to another worksheet macro problem
    By Kerbazee in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-19-2013, 04:15 AM
  3. Macro to copy a table and paste in another table (based on certain conditions)
    By acsishere in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 05-22-2013, 01:14 PM
  4. Copy, Find and paste between pivot table and worksheet
    By afgi in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-20-2010, 01:47 PM
  5. Macro to cut & paste continually adding data?
    By Rick-O-Shay in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 01-01-2010, 02:45 PM

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