ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Passing data between spreadsheets (https://www.excelbanter.com/excel-programming/281491-passing-data-between-spreadsheets.html)

Kat[_5_]

Passing data between spreadsheets
 
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?

Doug Glancy[_5_]

Passing data between spreadsheets
 
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


"Kat" wrote in message
...
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?





All times are GMT +1. The time now is 06:33 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com