Passing data between spreadsheets

  • Thread starter Thread starter Kat
  • Start date Start date
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?
 
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
 
Back
Top