+ Reply to Thread
Results 1 to 4 of 4

Copy and Paste Cell "X" Times

  1. #1
    Registered User
    Join Date
    02-12-2014
    Location
    Dallas, Texas
    MS-Off Ver
    Excel 2013
    Posts
    24

    Copy and Paste Cell "X" Times

    Hi forum,

    I have hit a wall creating this macro...

    I need a macro that will read the number in cell T1, then copy the value in cell G3 (either "Y" or "N"), and paste it below G3, T1 amount of times.

    For example,

    T1 = 5
    G3 = "Y"

    Macro will copy the "Y" in G3 and paste it 5 times, filling range G4:G8.

    This will mean range G3:G8 all show "Y".

    Seems like this should be fairly simple but I have struggled to develop a clean solution. Any help is appreciated.

    Thanks.

  2. #2
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,649

    Re: Copy and Paste Cell "X" Times

    Try this.....
    Please Login or Register  to view this content.
    Regards
    sktneer


    Treat people the way you want to be treated. Talk to people the way you want to be talked to.
    Respect is earned NOT given.

  3. #3
    Registered User
    Join Date
    02-12-2014
    Location
    Dallas, Texas
    MS-Off Ver
    Excel 2013
    Posts
    24

    Re: Copy and Paste Cell "X" Times

    Thank you sktneer; works great.

  4. #4
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,649

    Re: Copy and Paste Cell "X" Times

    You're welcome. Thanks for the feedback.

+ 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. Separate cell which have "Comma" into different row & multiple each row "n" times
    By Arun ebl in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-09-2013, 11:22 PM
  2. [SOLVED] Copy multiple rows that contain a certain "name" in column "A" then paste it into new work
    By rschlot2 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-18-2013, 02:25 PM
  3. [SOLVED] Copy Merged Cell and Paste to Right "X" times
    By jdohio5 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 04-26-2013, 05:29 PM
  4. Excel 2007 : Paste every "x" cells, for "y" times
    By Mimil in forum Excel General
    Replies: 2
    Last Post: 01-22-2011, 09:44 AM
  5. Replies: 1
    Last Post: 01-30-2006, 06:10 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