from 1 work sheet to another

[Guest]

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?

 

[Guest]

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.