+ Reply to Thread
Results 1 to 3 of 3

Conditional Copy of Multiple Ranges

  1. #1
    Registered User
    Join Date
    11-09-2010
    Location
    Denver, Colorado
    MS-Off Ver
    Excel 2007
    Posts
    2

    Conditional Copy of Multiple Ranges

    I have multiple named ranges within a single worksheet. How can I copy the value from one row of a range to another based off a comparison of two values in a different range? For example:

    Range 1 = A2:A5
    Range 2 = C2:C5

    I want to compare the values of A2 to A3. If they are the same then copy the value of C2 to C3. Then compare A3 to A4 and so on through the extent of both ranges.

    Any help would be greatly appreciated.

    Thanks.
    Attached Files Attached Files
    Last edited by astefanacci; 11-09-2010 at 05:19 PM. Reason: Added requested Dummy Sheet

  2. #2
    Forum Contributor
    Join Date
    05-29-2009
    Location
    Kalgoorlie Australia
    MS-Off Ver
    Excel 2007/10
    Posts
    251

    Re: Conditional Copy of Multiple Ranges

    Hello Ast'
    Please attach a dummy sheet, ideally with an example of what you expect as a result.
    Regards
    Peter

  3. #3
    Registered User
    Join Date
    11-09-2010
    Location
    Denver, Colorado
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: Conditional Copy of Multiple Ranges

    Peter,

    Thank you for the response. I have updated my post with an attached file outlining what I am hoping to solve.

    Thanks.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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