Sorting in Excel VBA

Assuming for now two sheets in the workbook.... DATA with the raw data and OUTPUT to write the new table into:

Please Login or Register  to view this content.

Dear Jerry,
Thanks for your reply and i hope you are doing well

well sorry again i think it is my fault didn't explain it detailed

please find that attached sample 2 file

here is the result i want to get

From Data tab to Output tab

all the cells that are next to Red cells (Arabic) are sorted in column (A) at Output tab
and all cells that are next to Green cells (English) are sorted in column (B) at output tab

the same thing to all cells next to (Term Arabic) and (Term English) are sorted in column (C) and (D)

note that there will not be any colors in the file, i'm just explaining



so i just want the template code for that and i will edit it at two places

1- the cells to be found then copy the cell next to it
2- the destination that will copy to at second tab

i hope you get what i mean and sorry again for disturbing you really

you are my savior

cheers

Ethen

Like so, then:

Please Login or Register  to view this content.

Note: I'm not going to keep bouncing between sites, so you will need to responsibility for getting solutions you've received on one site posted to all the other sites where you have posted the same question. You need to do this, or not crosspost on multiple sites, else you risk wasting people's time as they try to solve a problem on Site A you've already gotten solved on Site B. I know you would never want to do that.

When you post a question on any forum, if you derive a solution on your own or elsewhere, you should be sure to not only close the other threads, but also be sure to post the your final solution in the alternate thread. Thanks.