+ Reply to Thread
Results 1 to 3 of 3

copy/insert button

  1. #1
    Registered User
    Join Date
    10-11-2013
    Location
    Denmark
    MS-Off Ver
    Excel 2010
    Posts
    22

    copy/insert button

    Hello all

    I´m completely new to the more advanced uses of excel. My problem is:

    I want to make a button that can copy specific cells and insert them in a ordered table in a new sheet. The situation is visualised in the attached image.
    It must be so that one can enter new data and when pushing the button the old data must not be overwritten.

    idea.JPG

    Hope you can help.Thanks and best regards.

  2. #2
    Forum Contributor
    Join Date
    04-25-2013
    Location
    Stockholm, Sweden
    MS-Off Ver
    Excel 2010
    Posts
    150

    Re: copy/insert button

    Hi,

    You could use something like this:

    Please Login or Register  to view this content.
    It's best if you upload a sample workbook rather than a picture.

  3. #3
    Registered User
    Join Date
    10-11-2013
    Location
    Denmark
    MS-Off Ver
    Excel 2010
    Posts
    22

    Re: copy/insert button

    I will try uploading spreadsheets next time

    But how should the code be implemented? should i just create a button and copy/paste the code ofc. with changes to sheet nr. and range?

    best regards?

+ 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. command button to copy cells from one worksheet and insert to another
    By recain in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-03-2013, 11:26 PM
  2. [SOLVED] Macro to copy row, insert below, invert amt, and insert blank row between each new tx
    By raquel1227 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 03-07-2013, 12:56 PM
  3. Comand button to insert new row and copy formulas only
    By ir_eddie in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-06-2012, 06:14 AM
  4. Automatic copy and insert row to other sheet after input and click button
    By antoni in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-17-2009, 11:50 PM
  5. Copy to clipboard button on / paste special button.
    By jasonmcbride in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 12-19-2008, 11:53 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