Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Worksheet Functions / September 2007

Tip: Looking for answers? Try searching our database.

from 1 work sheet to another

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Bill Berthiaume - 21 Sep 2007 14:34 GMT
i just started using excel so i don't hae a clue what to do. how do i get
data from one work sheet to another worksheet automaticly so when i enter the
data on sheet 1 it gets entered into sheet 2 automaticly?
Balan - 21 Sep 2007 15:04 GMT
Hi Bill
Go to Sheet 2 and type  =
then go to sheet 1 to the cell where you  are going to type the values and
press Enter.  A link between these two cells will be established.  When you
go to Sheet 2 and see the cell where you established a link you will see the
figure 0 as you are yet to fill data in the relevant cell in sheet 1.  As and
when you type some figure in that cell in sheet 1, it will automatically
appear in sheet 2.

If you want the data in more than 1 cell [in the same column or range or in
other cells], you can copy the link in sheet 2 to the relevant cells  ( by
copying the contents of the cell in sheet 2 where you had established the
link to other cells in sheet 2).  As and when you enter values in
corresponding cells in sheet1, they will autmatically appear in corresponding
cells in sheet2.  If you go to the cells in sheet 2 and see by taking the
cursor to the cell that the addresses of the corresponding cell in sheet 1
has been copied into the cell.

Hope this meets your requirement.

Best Wishes.

> i just started using excel so i don't hae a clue what to do. how do i get
> data from one work sheet to another worksheet automaticly so when i enter the
> data on sheet 1 it gets entered into sheet 2 automaticly?
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.