moving cells
 

I want to move cells from one page to another by using a formula, or
basically without having to manually enter then numbers. I am sure
there is an easy way to do this i just cant figure it out

moving cells
 

Formula can not move cells.


" wrote:

I want to move cells from one page to another by using a formula, or
basically without having to manually enter then numbers. I am sure
there is an easy way to do this i just cant figure it out

moving cells
 

Peter

You cannot "move" data using formulas.

You can replicate the data on another worksheet by using a linking formula.

Sheet1 is source sheet.

In Sheet2 in a cell enter =Sheet1!A1

As you enter data in Sheet1 it shall be entered in Sheet2.


Gord Dibben MS Excel MVP

On 11 Apr 2007 15:26:02 -0700, wrote:

I want to move cells from one page to another by using a formula, or
basically without having to manually enter then numbers. I am sure
there is an easy way to do this i just cant figure it out