i need a formula for relocate the cells

i wanna copy the cells from A, B and C columns along the E and F columns

when i have more data along A, B and C columns and when i pull down the cells from their right-down corner , its giving wrong cells in E and F coumns

pls have a look to my attached file

thanks a lot for ur help from now on.

Originally Posted by Special-K

Copy results!A3:C11 to a blank sheet

Use this code to convert the output to columns 5 and 6

Please Login or Register  to view this content.

hello special k ,
is this macro code ?
if yes , there is sth wrong in macro code, when i press alt + F8 , Run button is not appearing

ah pardon, ur excel is english. so it didnt work, cant u send me this code with one *xlsm file please ?

Originally Posted by AlKey

Please see attached file with formulas.

alkey, why ur formula checking only until 11th row ?
i need this formula minumum until 1000th row.
can u edit ur formula pls?

i changed them to 1000 and everything disappeared
can u send me edited code with file please ?

SUPER SUPER
thanks a lot for ur all supprt ALKEY!!!
i became so happy to meet u!!!
thank u!!!

oke my friend
see ya.