how to copy/select 1 column from one work sheet to another using formula.

[cbterror]

please help me, i just want to know on how to put/move/copy the data of whole column or row from one worksheet/book1 to another using formula only pleaseee


wefgggg.JPG

[Special-K]

Formulas cant put values in other cells. You need VBA for that.
However you can make a cell the result of other cells using formulas.

So in your case

in Sheet2!C5
=Sheet1!D5

and copy the formula down as far as C12

Note if a cell is blank youll get a 0.This can be hidden by formatting the output cell or changing the formula to

=IF(Sheet!D5="","",Sheet1!D5)