+ Reply to Thread
Results 1 to 7 of 7

VBA Macro to copy a range of cells and paste to a new location

  1. 06-20-2014, 07:33 AM #1
    JuneTwentyFourteen
    JuneTwentyFourteen is offline
    Registered User
    Join Date
    06-19-2014
    Location
    UK
    MS-Off Ver
    Excel 2010
    Posts
    18

    VBA Macro to copy a range of cells and paste to a new location

    Good Afternoon,

    I am trying to create a macro that copies and pastes an entire row of information to a selected range on another upon a prompt from a user.

    For example, on the attached sheet, I would like a user to click on B4 and have Cells C4,D4,E4,F4 paste automatically to Cells C11,D11,E11,F,11.

    If the user then wants to transfer the info pertaining to strawberries into row 11, they would simply click on row B7.

    Is this possible?

    Any help would be appreciated.

    Regards

    Colin
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 06-20-2014, 07:41 AM #2
    TMS
    TMS is offline
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,464

    Re: VBA Macro to copy a range of cells and paste to a new location 

    Please Login or Register  to view this content.

    See attached.

    Regards, TMS
    Attached Files Attached Files
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke

    Reply With QuoteRegister To Reply
  3. 06-20-2014, 07:46 AM #3
    alansidman
    alansidman is online now
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2405 Win 11 Home 64 Bit
    Posts
    23,895

    Re: VBA Macro to copy a range of cells and paste to a new location

    Alternative solution, put a button on the spreadsheet that when clicked asks which row to transfer. See attached.
    Attached Files Attached Files
    Last edited by alansidman; 06-20-2014 at 07:49 AM.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
    Reply With QuoteRegister To Reply
  4. 06-20-2014, 09:08 AM #4
    JuneTwentyFourteen
    JuneTwentyFourteen is offline
    Registered User
    Join Date
    06-19-2014
    Location
    UK
    MS-Off Ver
    Excel 2010
    Posts
    18

    Re: VBA Macro to copy a range of cells and paste to a new location

    Thanks guys, both great replies, you've provided me with a couple of solutions there.

    Thanks very much again.

    Colin
    Reply With QuoteRegister To Reply
  5. 06-20-2014, 09:24 AM #5
    alansidman
    alansidman is online now
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2405 Win 11 Home 64 Bit
    Posts
    23,895

    Re: VBA Macro to copy a range of cells and paste to a new location

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks for the feedback and the rep.
    Reply With QuoteRegister To Reply
  6. 06-20-2014, 09:26 AM #6
    JuneTwentyFourteen
    JuneTwentyFourteen is offline
    Registered User
    Join Date
    06-19-2014
    Location
    UK
    MS-Off Ver
    Excel 2010
    Posts
    18

    Re: VBA Macro to copy a range of cells and paste to a new location

    Done and Done
    Reply With QuoteRegister To Reply
  7. 06-20-2014, 10:38 AM #7
    TMS
    TMS is offline
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,464

    Re: VBA Macro to copy a range of cells and paste to a new location

    You're welcome. Thanks for the rep.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. macro to copy range hidden paste in a specific location
    By graiggoriz in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-26-2014, 11:27 AM
  2. Macro to copy a range of cells to another location based on odd or even number in a cell
    By Thupp in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-18-2013, 05:00 PM
  3. Copy a set of cells and paste it to a user-specified location
    By abhinav10 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-10-2012, 05:51 PM
  4. Change range of cells within VBA macro and copy and paste to fixed cell range
    By Mannyny in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 07-20-2012, 11:51 AM
  5. [SOLVED] Macro to copy range of cells and paste into 1 sheet
    By Dean in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-19-2006, 08:55 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1