+ Reply to Thread
Results 1 to 2 of 2

Command button and VBA - copy and paste

  1. #1
    Registered User
    Join Date
    06-04-2016
    Location
    Manila, Philippines
    MS-Off Ver
    2016
    Posts
    8

    Smile Command button and VBA - copy and paste

    I would like to make a command button that when clicked,

    will copy the Sheet "Edit" Range A1:B7 and paste it in the Sheet "Summary" Range A1:A7.
    Copy Sheet "Edit" Range A9:A19 and paste it in the Sheet "Summary" Range A8:A18
    Copy Sheet "Edit" Range B10:B19 and paste it in the Sheet "Summary" Range A20:A29
    Copy Sheet "Edit" Range A21:A22 and paste it in the Sheet "Summary" Range A30:A31
    so on and so forth.

    It is like, it would generate a template from the details I have.

    1.JPG

    and make it look like this

    2.JPG
    3.JPG

    Thank you

  2. #2
    Registered User
    Join Date
    11-01-2012
    Location
    Cairo, Egypt
    MS-Off Ver
    MS Office 2013
    Posts
    76

    Re: Command button and VBA - copy and paste

    Please Login or Register  to view this content.
    Change The source (colored red) and destination (colored green) as required

+ 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 selected row and paste it to another sheet command button vba
    By KK1234 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-22-2014, 03:22 AM
  2. [SOLVED] selective copy and paste via command button vba
    By KK1234 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 03-28-2014, 12:07 PM
  3. Copy and Paste as Values using Command Button
    By macky1730 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-04-2013, 02:18 AM
  4. [SOLVED] Simple Copy and Paste Command Button
    By j_gideon in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 09-25-2013, 02:38 PM
  5. [SOLVED] Problems with copy and paste working with a command button.
    By Spreadlover in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 07-14-2013, 05:58 AM
  6. Command button to add rows, copy and paste formulas, and format.
    By seankuus in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-05-2013, 08:37 PM
  7. copy and paste data from one worksheet cell to another using command button
    By jasonruiz in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-13-2011, 04:34 AM

Tags for this Thread

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