Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Excell Beginner Help
 
Posts: n/a
Default 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   Report Post  
Roger Govier
 
Posts: n/a
Default

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   Report Post  
CyberTaz
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Printing data validation scenarios SJC Excel Worksheet Functions 14 July 24th 05 12:43 AM
Varying page Excel report judypudy Excel Discussion (Misc queries) 6 July 13th 05 08:39 PM
Possible Lookup Table Karen Excel Worksheet Functions 5 June 8th 05 09:43 PM
Data Validation Cell - Move to UserForm thom hoyle Excel Worksheet Functions 0 April 28th 05 12:23 AM
GET.CELL Biff Excel Worksheet Functions 2 November 24th 04 07:16 PM


All times are GMT +1. The time now is 05:32 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"