| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Arrow Keys Moving Window Frame instead of Moving Between Cells | Excel Discussion (Misc queries) | |||
| Moving between cells | Excel Discussion (Misc queries) | |||
| Moving cells | Excel Worksheet Functions | |||
| moving cells | New Users to Excel | |||
| Sum of 6 moving cells | Excel Discussion (Misc queries) | |||
Linear Mode
