Results 1 to 4 of 4

copy non adjacent cells and paste to another sheet.

Threaded View

  1. #1
    Forum Contributor
    Join Date
    03-08-2007
    Location
    St. Augustine, Fl
    MS-Off Ver
    Excel 2021 for Mac
    Posts
    392

    copy non adjacent cells and paste to another sheet.

    Dim copyRange As Range, cel As Range, pasteRange As Range
    
    Set copyRange = ThisWorkbook.Sheets("Invoice").Range("E3,E4,B7,E24")
    Set pasteRange = ThisWorkbook.Sheets("Register").Range("A5")
    For Each cel In copyRange
        cel.Copy
    ecolumn = Sheet2.Cells(1, Columns.Count).End(xlToLeft).Offset(0, 0).Row
    pasteRange.Cells(1, ecolumn).PasteSpecial xlPasteValues
       
     
    Next
        Application.CutCopyMode = False

    I am trying to copy non adjacent cell from Invoice sheet and past the in Register sheet in consecutive row starting in A5- D5. I have tried the VBA below however , it copies all the non adjacent cell in A5 one at a time. how do I get them to go A5, B5, C5, D5, then next transfer to the last row.
    Last edited by Wskip49; 12-07-2020 at 11:47 AM. Reason: used hashtags

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Copy and paste non-adjacent cells using UNION
    By Scott8400 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-19-2018, 11:15 AM
  2. Copy and paste specific cells depending on adjacent cells HELP NEEDED
    By clacheson1 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-20-2017, 04:06 PM
  3. Replies: 14
    Last Post: 10-29-2015, 07:29 PM
  4. VBA Macro to copy & paste non-adjacent cells from one sheet to another
    By clo2peter in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 03-20-2014, 03:06 PM
  5. [SOLVED] Copy and paste comment on the adjacent cells
    By lokwungkwung in forum Excel General
    Replies: 7
    Last Post: 08-26-2013, 11:46 AM
  6. [SOLVED] find value, copy value of adjacent cell and paste it on another sheet
    By Ajgor in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-25-2012, 04:21 PM
  7. Find Adjacent Data In One Sheet and Copy/Paste Into Other Sheet
    By jaylotheman in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-06-2011, 07:19 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