Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I move the data in one cell on a page to another page/cell
What command do I use to move the containts of one cell on a page to a
different page and cell??? |
#2
|
|||
|
|||
On the receiving page and cell, type = then navigate to the sheet and cell
where you wish to extract the data and press Enter. Assuming you were in cell B1 of Sheet2,and you wanted it to copy the value from Sheet1 cell A10, then Excel would insert the formula =Sheet1!A10 You can just type the formula yourself, but it is probably easier to let Excel do it for you first time. Note, if your sheet name contains spaces, then the formula need single quotes around the sheet name. ='My new sheet'!A10 Regards Roger Govier Excell Beginner Help wrote: What command do I use to move the containts of one cell on a page to a different page and cell??? |
#3
|
|||
|
|||
If you actually want to remove from original cell and put someplace else, Cut
& Paste is a good a way as any. Regards |:) "Excell Beginner Help" wrote: What command do I use to move the containts of one cell on a page to a different page and cell??? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Printing data validation scenarios | Excel Worksheet Functions | |||
Varying page Excel report | Excel Discussion (Misc queries) | |||
Possible Lookup Table | Excel Worksheet Functions | |||
Data Validation Cell - Move to UserForm | Excel Worksheet Functions | |||
GET.CELL | Excel Worksheet Functions |