![]() |
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? |
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