+ Reply to Thread
Results 1 to 4 of 4

Macro to copy a section of a worksheet and then loop and copy multiple times

  1. #1
    Registered User
    Join Date
    10-24-2017
    Location
    Omaha, NE
    MS-Off Ver
    Excel 2010
    Posts
    25

    Macro to copy a section of a worksheet and then loop and copy multiple times

    I am new to macros and trying to understand how to create a loop. In the attached file I am trying to create a macro that copies cells a1:a65 in tab Statement Account Template to cell a1 of tab Monthly Statements. Where I am struggling is how then to copy a1:a65 in tab Monthly Statements down the page multiple times based on the number of names in the list at cell a2 on tab Billing Data Tab. Any guidance would be appreciated.
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    10-06-2008
    Location
    Canada
    MS-Off Ver
    2007 / 2013
    Posts
    5,054

    Re: Macro to copy a section of a worksheet and then loop and copy multiple times

    Please Login or Register  to view this content.
    b

  3. #3
    Registered User
    Join Date
    10-24-2017
    Location
    Omaha, NE
    MS-Off Ver
    Excel 2010
    Posts
    25

    Re: Macro to copy a section of a worksheet and then loop and copy multiple times

    Thank you! This works perfectly.

  4. #4
    Forum Expert
    Join Date
    10-06-2008
    Location
    Canada
    MS-Off Ver
    2007 / 2013
    Posts
    5,054

    Re: Macro to copy a section of a worksheet and then loop and copy multiple times

    Thanks for letting us know.
    Good Luck.

+ 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. [SOLVED] Copy and Transpose multiple times in a new worksheet
    By dosydos in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-23-2018, 02:59 PM
  2. [SOLVED] Copy Worksheet Multiple Times to New Workbook, In Order
    By cchase22 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-09-2015, 04:39 PM
  3. [SOLVED] Macro to copy one row for n times in another worksheet.
    By khalidness in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-11-2014, 10:24 AM
  4. [SOLVED] Copy and Paste Multiple times and loop
    By Dnass in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-05-2013, 08:44 PM
  5. Replies: 0
    Last Post: 06-25-2013, 09:46 AM
  6. I need a macro that will let me loop a section of the vba code x number of times
    By tuckejam in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-28-2013, 02:44 PM
  7. [SOLVED] VBA loop to copy a worksheet a number of times, assign name each time based on loop number
    By TBG in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-29-2012, 10:54 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