moving cells

P

PeterJames85

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
 
G

Gord Dibben

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
 
Top