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.
Bookmarks