Copy cell to specific locations based on certain conditions

Hi Gurus:

So I am trying to copy cell to specific locations based on certain conditions(see attachment for illustation).
I am wondering if anyone can write me a code for this task.


Many many thanks,

Chris

You know the drill. :-)

Please Login or Register  to view this content.

Works Great! I appreciate it Steven!!
Enjoy the weekend!

Chris

Hi Steve:


So I am trying to the following(similer to this solved one but it inclueds 2 sheets) but I cannot post new thread since yesterday.
Please take a look of the sample file for better illustration.

-Compare the value of Cell B2 in sheet1 with all of the values of column D in sheet2.
-If a match is found at row i, do following:
--add ";" in front of the content of cell Ei and Fi respectively, if any,then copy them to cell C2 in sheet1.
--add ";" in front of the content of cell Qi and Ri respectively, if any, then copy them to cell Ui in sheet1.
--copy cell Ji from sheet2 to cell O2 of sheet1,if any.
--copy cell Ki from sheet2 to cell L2 of sheet1 ,if any.
--copy cell Li from sheet2 to cell M2 of sheet1, if any.
--copy cell Ni from sheet2 to cell N2 of sheet1, if any.
--copy cell Oi from sheet2 to cell D2 of sheet1, if any.
-Repeat the above precedure for cell B3,B4,B5.......of sheet 1 until all of the cell in column B is compared.


Many Many Thanks,
Chris

Backup your data.
Double check my code.

Please Login or Register  to view this content.

100% accurate code! works great!

I really really appreciate it Steven!

Chris

P.S. It seems that chess and programming are closely tied lol

They are indeed!