ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   spreadsheet corrections or additions (https://www.excelbanter.com/new-users-excel/159268-spreadsheet-corrections-additions.html)

cajun1

spreadsheet corrections or additions
 
have a main spreadsheet to pull data from.that way an update to cells there
would flow changes to the other spreadsheets.Can that be done other than to
manually
copy and paste?

kassie

spreadsheet corrections or additions
 
Not exactly clear what you are trying to achieve. For starters, you could
link the files with formulae. Say you have BookOne.xls and BookTwo.xls, and
you want to link a cell in BookTwo.xls to a cell in BookOne.xls. Lets say
BookOne.xls is the main sheet.

In cell A6 in BookTwo.xls, you want the same result as in BookOne.xls, cell
B15. In BookTwo.xls enter =BookOne!.B15 Can you work with that?

--
Hth

Kassie Kasselman
Change xxx to hotmail


"cajun1" wrote:

have a main spreadsheet to pull data from.that way an update to cells there
would flow changes to the other spreadsheets.Can that be done other than to
manually
copy and paste?



All times are GMT +1. The time now is 04:26 PM.

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