+ Reply to Thread
Results 1 to 3 of 3

Copy set number of cells a set number of times within same worksheet

  1. #1
    Registered User
    Join Date
    09-05-2007
    Posts
    6

    Copy set number of cells a set number of times within same worksheet

    Hopefully I can describe what I'm trying to accomplish. I've tried several different macros that I have found on this forum but to no avail. The problem is I have info in cells A1 through A5. I would like to copy and past these cells into A6 through A10 and then A11 through 15 (you get the idea) and just keep on doing this a set number of times. Any help would be greatly appreciated.

  2. #2
    Forum Expert
    Join Date
    08-02-2013
    Location
    Québec
    MS-Off Ver
    Excel 2003, 2007, 2013
    Posts
    1,412

    Re: Copy set number of cells a set number of times within same worksheet

    Hello,
    Like this maybe :

    Please Login or Register  to view this content.
    GC Excel

    If this post helps, then click the star icon (*) in the bottom left-hand corner of my post to Add reputation.

  3. #3
    Registered User
    Join Date
    09-05-2007
    Posts
    6

    Re: Copy set number of cells a set number of times within same worksheet

    That worked great GC Excel. Thanks so much. 5 lines of code was all it took. I really need to get more savy on this.

+ 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] How to get the number of times exactly 4 consecutive cells have a number greater than 6?
    By llane5150 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-29-2013, 11:23 PM
  2. [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
  3. Copy Current Worksheet X number of times, as specified in dropdown box
    By Lord_Griffth in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-05-2012, 12:00 PM
  4. Copy Current Worksheet X number of times
    By colinwiens in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-08-2009, 03:43 AM
  5. Count number of times a specific number is displayed in cells
    By subs in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-27-2005, 11:05 AM

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