+ Reply to Thread
Results 1 to 4 of 4

Macro to copy between 2 cells

  1. #1
    Forum Contributor
    Join Date
    07-24-2013
    Location
    HongKong
    MS-Off Ver
    Excel 2010
    Posts
    237

    Macro to copy between 2 cells

    I want to write a macro in relative mode. It starts from cell C1 and look downwards until it finds an "Start", then further looks download to find another "Start".
    If there is an "A" between these 2 "Start", all the cells between them will be copied an "A".
    If no "A" is found, goes forward to find another "Start" and repeat the same action.
    The macro stops until it finds an "Stop".
    ScreenHunter_028.jpg ScreenHunter_029.jpg

    Thanks you.
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: Macro to copy between 2 cells

    Maybe:

    Please Login or Register  to view this content.

  3. #3
    Forum Contributor
    Join Date
    07-24-2013
    Location
    HongKong
    MS-Off Ver
    Excel 2010
    Posts
    237

    Re: Macro to copy between 2 cells

    Quote Originally Posted by JOHN H. DAVIS View Post
    Maybe:

    Please Login or Register  to view this content.

    It perfectly meets my requirement.
    Thank you John.

  4. #4
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: Macro to copy between 2 cells

    You're welcome. Glad to help out and thanks for the feedback and the reps.

+ 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: 2
    Last Post: 01-08-2016, 11:44 PM
  2. Macro to copy and paste cells up till the last active row of cells
    By blueaurora in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-07-2015, 05:08 AM
  3. Macro to copy paste specific cells into empty cells below them
    By qlo_0lp in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-23-2014, 04:49 PM
  4. Replies: 3
    Last Post: 07-16-2014, 03:24 PM
  5. [SOLVED] Macro to copy cells into another column if cells contain a certain condition
    By lsm33000 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-11-2014, 02:27 PM
  6. [SOLVED] How to make Macro to lock certain cells connected to another cells value, then copy daily
    By RamiSaydi in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-29-2014, 12:41 PM
  7. Macro which finds and copy's cells based on values in other cells.
    By ScabbyDog in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-24-2012, 05:11 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1