| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
data from one workbook automatically entered into another workboo.
Can you enter data in worksheet 1 book 1 and have it automatically entered
into another workbook? If yes what is the formula? Thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
data from one workbook automatically entered into another workboo.
In workbook2 in a sheet in A1 enter
=[workbook1.xls]Sheet1!A1 Or in workbook2 type an = sign in a cell then switch to workbook1, select a sheet and cell and hit ENTER key. Gord Dibben MS Excel MVP On Tue, 9 Sep 2008 11:27:10 -0700, cfrt wrote: Can you enter data in worksheet 1 book 1 and have it automatically entered into another workbook? If yes what is the formula? Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Data Range updating automatically as new data is entered | Charts and Charting in Excel | |||
| How do I get data automatically entered into a cell? | Excel Worksheet Functions | |||
| In Excel-shade the cell automatically when data is entered | Excel Discussion (Misc queries) | |||
| How do I lock a cell automatically after it has data entered. | Excel Discussion (Misc queries) | |||
| How do I automatically shade cells depending on data entered? | Excel Worksheet Functions | |||
Linear Mode
