Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Check Activesheet for chart sheet or work sheet | Charts and Charting in Excel | |||
GETTING SELECTED DATA FROM A WORK SHEET TO OTHER WORK SHEET | Excel Discussion (Misc queries) | |||
Populating work sheet combox with another work sheet values | Excel Discussion (Misc queries) | |||
Is there away to keep "auto save" from jumping to the first work sheet in the work book? | New Users to Excel | |||
Spin button in a work sheet - how do I make it work? | Excel Worksheet Functions |