Results 1 to 5 of 5

Copy and Paste cells from Range with data

Threaded View

  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 with data

    Please see attached sheet
    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.
    But with each new customer a new worksheet is created from SLA Order with a new name based on what is in cell B4 on worksheet Home when button on that sheet is activated.
    So each new SLA Order worksheet will have a different number of cells filled in depending on customer order. The command button must copy only these cells and paste them into worksheet SLA directly below any previous cells pasted there.

    Can anyone give me a hand with this

    Cheers
    Attached Files Attached Files
    Last edited by rikk1965; 02-04-2014 at 05:45 AM.

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: 01-16-2013, 05:36 AM
  2. Replies: 3
    Last Post: 11-20-2012, 02:25 PM
  3. Copy, Paste Cells in a range
    By rawdog2222 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-08-2012, 12:13 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. 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

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