ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How can I share information between multiple sheets in Excel? (https://www.excelbanter.com/excel-worksheet-functions/52677-how-can-i-share-information-between-multiple-sheets-excel.html)

lucasjackson

How can I share information between multiple sheets in Excel?
 
New question:

I know now how to use "=sheet1!a1" to copy cells from sheet 1 to sheet 2,3
etc.

Is there is a formula that will allow me to enter data
into sheet 2, and have it copy automatically into sheet 1 and 3, or into
sheet 3 going to sheet 1 and 2? So that I can enter the data into any sheet
and have it transfer to all sheets, rather than always from sheet 1 to sheets
2 and 3.



Dave Peterson

How can I share information between multiple sheets in Excel?
 
You have one response to your post in .misc

lucasjackson wrote:

New question:

I know now how to use "=sheet1!a1" to copy cells from sheet 1 to sheet 2,3
etc.

Is there is a formula that will allow me to enter data
into sheet 2, and have it copy automatically into sheet 1 and 3, or into
sheet 3 going to sheet 1 and 2? So that I can enter the data into any sheet
and have it transfer to all sheets, rather than always from sheet 1 to sheets
2 and 3.


--

Dave Peterson


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

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