+ Reply to Thread
Results 1 to 2 of 2

Copy and paste cells from range

  1. #1
    Registered User
    Join Date
    12-16-2013
    Location
    Reading, England
    MS-Off Ver
    Excel 2007
    Posts
    34

    Copy and paste cells from range

    I need the command button on worksheet SLA Order to copy only the cells with data in them from the green cells above the button and paste them into worksheet SLA

    See attached sample worksheet

    The current code on the command button is below.
    I need it to only look at the range in green and ignore the cells with data below
    Please Login or Register  to view this content.
    Further explination of Sheet if needed:
    Goto Home and put type test into cell B4 and and hit New Order Command button. This has just created a new worksheet called 'test SLA Order'
    (SLA Order is my template sheet)
    Goto test SLA ORDER and fill in the first couple of rows from the drop down boxes and enter a quantity in the next cell.
    So what I need is for the command button on this worksheet to copy only the cells with anything in them from the green cells above and paste them into the
    worksheet Totals.
    When a new order is created there may be a different number of cells filled in on the newly created worksheet %%% SLA Order and again I need the command button on this worksheet to copy only the cells with anything in them from the green cells above and paste them into the
    worksheet Totals directly below the previously pasted cells.
    Attached Files Attached Files
    Last edited by rikk1965; 02-04-2014 at 07:51 AM.

  2. #2
    Valued Forum Contributor natefarm's Avatar
    Join Date
    04-22-2010
    Location
    Wichita, Kansas
    MS-Off Ver
    2016
    Posts
    1,020

    Re: Copy and paste cells from range

    I think with the following adjustment it should work:
    Please Login or Register  to view this content.
    You may want to add something to acknowledge that the code is complete and prevent duplicate button clicks, such as selecting the Totals sheet when finished.
    Acts 4:12
    Salvation is found in no one else, for there is no other name under heaven given to mankind by which we must be saved.

+ 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. Replies: 1
    Last Post: 10-23-2012, 08:41 PM
  2. Copy, Paste Cells in a range
    By rawdog2222 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-08-2012, 12:13 PM
  3. 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
  4. Sub to Copy and Paste a Range of Cells
    By FrankB2050 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-07-2010, 09:39 AM
  5. Select a range of cells and then copy them, and paste into other cells
    By Dynelor in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-24-2007, 04:03 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