from 1 work sheet to another
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? |
from 1 work sheet to another
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. "Bill Berthiaume" wrote: 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? |
All times are GMT +1. The time now is 07:32 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com