How to set variable in "for each cell in range" procedure

[GIS2013]

Hi. My question is somehow related to another question I posted earlier today (see link). By the way, how do I add a link without this huge string? I've tried the icon above but it doesn't seem to work.

So here is the link: "http://www.excelforum.com/excel-formulas-and-functions/953870-how-to-identifying-specific-strings-in-a-column.html?p=3400160#post3400160"

The difference this time I need VBA code, for better flexibility:

Please Login or Register  to view this content.

I need matching pairs in column A like hai_a and a_hai (matching: if they have the same string in the opposite sides of =) to be written down in column B. As the file attached shows. But my code is not too good since I'll need to replace each time for examle "hai" with "bvr" (shown in the file) and so on. I'm trying to use a variable instead, inside the loop, so it'll look for - using my code - pairs..

[larai]

Not sure what you're trying to accomplish.

Could you please fill out column B in your attachment with the values you want returned?

Example:
Col A-----Col B
a_hai-----a_hai
hai_a-----hai_a
bvr_x-----?


Are you comparing A2 & A3 (every 2 rows)?

[GIS2013]

Sure, please see desired pairs in column C. I'd should add that the list is longer than you see in the sample, so it's rather tedious task to match all these pairs.

[larai]

I don't understand what you're trying to accomplish.

I see that you start off with nc_sc, which does not have the reversed value in the adjacent row. tx_az & az_tx specifically don't relate to either row 10 or 11, so how did you determine where to place these values? Shouldn't it appear in C6 & C7?

[GIS2013]

hi larai. Look at column A (titled "current"). you can see nc_sc, right? well I need a macro which would look for the "opposite" of nc_sc in column A which is sc_nc, right? and then after a matching has been found, both nc_sc and its opposite sc_nc will be placed one above the other in column c (titled "goal"). hope it's more clear now. I'll check replies (if any) later. thanks!

[6StringJazzer]

By the way, how do I add a link without this huge string? I've tried the icon above but it doesn't seem to work..

What icon did you try?

There are two ways to include a link. One is to simply put the full URL in your post. If you scroll down while editing your post, you will see a checkbox marked "Automatically parse links in text" that is checked by default. If you leave it checked, then your URL will be turned into a link when your post is published. If it is long, then the displayed text will be truncated. I do not know why the URL you included was not turned into a link.

You can create an HTML hotlink by selecting the text for the link, clicking the "World Link" icon (middle of the middle row of icons) and then pasting the URL into the box. Your selected text will then become a link to that URL.

[GIS2013]

All right Jeff.

I've made some progress, and able to match pairs using VBA (newer version attached). But I Still need your help to order these results. I need all of them to populate column I rather than be written diagonally. Thanks

***Update*** in column G1 should be written: this is how column G should be look like" (rather than column A).

[larai]

I still don't understand what you're trying to do, exactly. Previously you wanted to fill column B with matching pairs, but I could not understand what order you want the pairs in.

What is in column A in your example versus Column G?

The layout is also completely different. Please provide a "before" worksheet and an "after" worksheet.

thanks

[GIS2013]

@larai see my PM.