+ Reply to Thread
Results 1 to 7 of 7

copy range and paste next to each cell with data

  1. 08-10-2016, 12:58 AM #1
    maym
    maym is offline
    Forum Contributor
    Join Date
    10-12-2011
    Location
    Sydney
    MS-Off Ver
    Excel 2016 in 2024
    Posts
    857

    copy range and paste next to each cell with data

    Hi

    I am trying to copy a range and then paste in on my worksheet for each row that has data (the data is in Col A and is separated by 10 rows). So far I have the following but it is not working:

    Please Login or Register  to view this content.
    Does anyone know where I'm going wrong with this?
    Reply With QuoteRegister To Reply
  2. 08-10-2016, 01:16 AM #2
    bulina2k
    bulina2k is offline
    Valued Forum Contributor bulina2k's Avatar
    Join Date
    11-20-2012
    Location
    Urziceni, Ialomita, Romania
    MS-Off Ver
    2019 and 365
    Posts
    861

    Re: copy range and paste next to each cell with data

    Hi there!
    Is A65536 the last row on column A ?
    If so replace the For Each c In Range("A20:A65536").Cells with
    For Each c In Range("A20:A65528").Cells
    .. and don't forget to have fun!
    Bogdan.

    mark SOLVED and Add Reputation if my answer pleases you
    Reply With QuoteRegister To Reply
  3. 08-10-2016, 01:20 AM #3
    maym
    maym is offline
    Forum Contributor
    Join Date
    10-12-2011
    Location
    Sydney
    MS-Off Ver
    Excel 2016 in 2024
    Posts
    857

    Re: copy range and paste next to each cell with data

    Hi

    I tried that, thank you. But I now have "Invalid qualifier" error on:

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  4. 08-10-2016, 01:23 AM #4
    bulina2k
    bulina2k is offline
    Valued Forum Contributor bulina2k's Avatar
    Join Date
    11-20-2012
    Location
    Urziceni, Ialomita, Romania
    MS-Off Ver
    2019 and 365
    Posts
    861

    Re: copy range and paste next to each cell with data

    can you upload a sample file ?
    Reply With QuoteRegister To Reply
  5. 08-10-2016, 01:27 AM #5
    maym
    maym is offline
    Forum Contributor
    Join Date
    10-12-2011
    Location
    Sydney
    MS-Off Ver
    Excel 2016 in 2024
    Posts
    857

    Re: copy range and paste next to each cell with data

    sure, please see attached
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  6. 08-10-2016, 02:05 AM #6
    bulina2k
    bulina2k is offline
    Valued Forum Contributor bulina2k's Avatar
    Join Date
    11-20-2012
    Location
    Urziceni, Ialomita, Romania
    MS-Off Ver
    2019 and 365
    Posts
    861

    Re: copy range and paste next to each cell with data

    Try this way (avoiding loops makes it faster)

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  7. 08-10-2016, 02:13 AM #7
    maym
    maym is offline
    Forum Contributor
    Join Date
    10-12-2011
    Location
    Sydney
    MS-Off Ver
    Excel 2016 in 2024
    Posts
    857

    Re: copy range and paste next to each cell with data

    perfect, thanks so much!
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next 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/paste data using checkbox-clear when unchckd & multiple selections paste in next cell
    By Staceymcw in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 12-02-2015, 12:09 AM
  2. [SOLVED] Macro to copy and paste new data into the next blank cell WITHIN a range
    By MattRNR in forum Excel Programming / VBA / Macros
    Replies: 32
    Last Post: 10-22-2015, 12:45 AM
  3. Macro to Copy a Cell from a Range When Adjacent Cell = TRUE and Paste to Different Sheet
    By KatGirl in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-03-2014, 03:01 AM
  4. [SOLVED] Copy Data from one sheet and paste the consolidated data into another (Data Range Varies)
    By kittu55 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 09-13-2013, 10:02 PM
  5. Copy/Paste range of data excluding certain rows and copy to another workbook
    By HoerbigAdm in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-12-2012, 02:51 PM
  6. 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
  7. How to copy/paste range only if data in ANY cell of that range
    By bridie4 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-22-2011, 08:13 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1