+ Reply to Thread
Results 1 to 7 of 7

Copy and Paste Series

  1. #1
    Valued Forum Contributor meabrams's Avatar
    Join Date
    10-03-2014
    Location
    USA
    MS-Off Ver
    2007, 2010, 2013, 2016
    Posts
    451

    Copy and Paste Series

    I need a macro that will look in Column A for Section and copy the Contains in Column B in to Column D filling it down til it finding the next instance of Section until it gets to the last used row in Column A

    Sample.xlsx

  2. #2
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,767

    Re: Copy and Paste Series

    How to install your new code
    1. Copy the Excel VBA code
    2. Select the workbook in which you want to store the Excel VBA code
    3. Press Alt+F11 to open the Visual Basic Editor
    4. Choose Insert > Module
    5. Edit > Paste the macro into the module that appeared
    6. Close the VBEditor
    7. Save your workbook (Excel 2007+ select a macro-enabled file format, like *.xlsm)

    Please Login or Register  to view this content.


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved


    If the suggestion helps you, then Click *below to Add Reputation

  3. #3
    Valued Forum Contributor meabrams's Avatar
    Join Date
    10-03-2014
    Location
    USA
    MS-Off Ver
    2007, 2010, 2013, 2016
    Posts
    451

    Re: Copy and Paste Series

    Close to what I need but I need it to key in on any time Section is in Column A

  4. #4
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,767

    Re: Copy and Paste Series

    Quote Originally Posted by meabrams View Post
    Close to what I need but I need it to key in on any time Section is in Column A
    Can you please make the above sentence more elaborate since I am unable to understand your requirement

  5. #5
    Valued Forum Contributor meabrams's Avatar
    Join Date
    10-03-2014
    Location
    USA
    MS-Off Ver
    2007, 2010, 2013, 2016
    Posts
    451

    Re: Copy and Paste Series

    Your macro is using the first instance of "Section" and running it all the way to the bottom of the used range. In the spreadsheet there is many different time where it has the word "Section" and that is where I need it to change to whatever is column B and fill that down til it gets to the next and so on untill it get to the very end of the used range

  6. #6
    Valued Forum Contributor meabrams's Avatar
    Join Date
    10-03-2014
    Location
    USA
    MS-Off Ver
    2007, 2010, 2013, 2016
    Posts
    451

    Re: Copy and Paste Series

    was wondering if this is possible... I still need a macro that is able to look for the word Section in Column A then copy/fill down the info that is in Column B into Column D until it gets to the next instance of the word Section then start the process again and do this for the entire used range in Column A

  7. #7
    Valued Forum Contributor meabrams's Avatar
    Join Date
    10-03-2014
    Location
    USA
    MS-Off Ver
    2007, 2010, 2013, 2016
    Posts
    451

    Re: Copy and Paste Series

    I finally figured out a way to to get your code to do what I needed! The issue I was having is that with the scanned in document sometimes it wouldn't put a blank area in column "C" I had to create/call a macro before hand that inserted a blank row above every instance of "Section" then remove it once completed with your macro.

    Please Login or Register  to view this content.

+ 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. [SOLVED] Copy a range, but skip 1st and every 6th row, paste value to end of series
    By rjnc in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 09-21-2015, 06:17 AM
  2. Replies: 3
    Last Post: 01-01-2015, 06:26 AM
  3. Replies: 2
    Last Post: 05-19-2014, 01:21 AM
  4. copy the Series from other cell series
    By tejasnaik in forum Excel General
    Replies: 0
    Last Post: 08-16-2012, 01:57 AM
  5. [SOLVED] Copy and paste cells dynamically to a range in a series of named Worksheets.
    By skyping in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 04-27-2012, 04:22 AM
  6. Replies: 1
    Last Post: 02-09-2012, 09:22 PM
  7. Replies: 1
    Last Post: 01-04-2005, 06:06 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