How do I move the data in one cell on a page to another page/cell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

What command do I use to move the containts of one cell on a page to a
different page and cell???
 
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
 
If you actually want to remove from original cell and put someplace else, Cut
& Paste is a good a way as any.

Regards |:>)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Columns moving up and down on their own in a worksheet. What Goes? 2
Pressing TAB cursor moves a page to the right and not only 1 cell 1
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Excel Typed text appears in wrong cell 0
The whole page moves with the up/down arrows, not the cells 1
help Fill formulas, highlight cells to specified destination 1
Printing with cell borders 1
in excel my down arrow scrolls the page down instead moving to th. 2

Back
Top