Passing data between spreadsheets

K

Kat

Is it possible to share data between spreadsheets? In
other words, when data is entered into one row, that
record is then transferred to another excel spreadsheet..
If so, how?
 
D

Doug Glancy

Kat,

Enter this formula in the cell in Sheet2 where you want the data from Sheet1
to appear:

=Sheet1!A1

No programming required. This is a very basic Excel function.

hth,

Doug
 
Top